OJS 3.1.1.4 db metrics stop update data

Software Support
21

You can’t just remove that entry, you’ll now need to reprocess your stats logs. You should move all of the days that did not generate stats into the stage/ folder and wait for the process to run again.

22

I remove files from UsageEventLogs folder, and reprocess statLog with activity:

  1. unchecklist and checklist again Acron Plugin
  2. Unchecklist and checklist again Usage Event
  3. Unchecklist and checklist again Usage Statistic
  4. Clear data cache
  5. clear template cache
  6. Clear Clear Scheduled Task Execution Logs

OJS re-create new file in /files/UsageStat/Stage folder new one file contain

125.161.90.65 - - "2020-04-20 02:49:14" https://owner.polgan.ac.id/index.php/owner/article/view/60 200 "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36"
66.249.71.158 bot - "2020-04-20 02:50:11" https://jurnal.polgan.ac.id/index.php/sinkron/article/download/10517/340/2751 200 "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
114.119.163.95 - - "2020-04-20 02:50:12" https://jurnal.polgan.ac.id/index.php/sinkron/article/download/10188/297/1834 200 "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; AspiegelBot)"
125.161.90.65 - - "2020-04-20 02:50:42" https://owner.polgan.ac.id/index.php/owner/article/download/60/28/247 200 "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36"
125.161.90.65 - - "2020-04-20 02:50:43" https://owner.polgan.ac.id/index.php/owner/article/download/60/28/247 200 "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:52:30" https://jurnal.polgan.ac.id/index.php/sinkron/index 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
40.77.167.152 bot - "2020-04-20 02:53:17" https://owner.polgan.ac.id/index.php/owner/article/download/33/14/129 200 "msnbot/2.0b (+http://search.msn.com/msnbot.htm)"
116.206.31.46 administrative 1 "2020-04-20 02:54:12" https://jurnal.polgan.ac.id/index.php/sinkron/index 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:54:36" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/10526 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:55:06" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/11 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:57:16" https://jurnal.polgan.ac.id/index.php/sinkron/index 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:57:54" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/10549 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:58:17" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/5 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
114.119.160.204 - - "2020-04-20 02:59:11" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/242 200 "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; AspiegelBot)"
116.206.31.46 administrative 1 "2020-04-20 02:59:16" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/54 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:59:40" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/54 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
116.206.31.46 administrative 1 "2020-04-20 02:59:51" https://jurnal.polgan.ac.id/index.php/sinkron/index 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
114.119.161.90 - - "2020-04-20 03:01:28" https://jurnal.polgan.ac.id/index.php/sinkron/index 200 "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; AspiegelBot)"
114.119.160.204 - - "2020-04-20 03:02:35" https://jurnal.polgan.ac.id/index.php/remik/article/download/10196/268/1626 200 "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; AspiegelBot)"
114.119.166.141 - - "2020-04-20 03:03:43" https://jurnal.polgan.ac.id/index.php/remik/article/download/10041/168/974 200 "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; AspiegelBot)"
40.77.167.152 bot - "2020-04-20 03:04:10" https://owner.polgan.ac.id/index.php/owner/article/view/84 200 "Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)"
116.206.31.46 administrative 1 "2020-04-20 03:04:35" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/116 200 "Mozilla/5.0 (Windows NT 6.1; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"
114.119.166.150 - - "2020-04-20 03:05:57" https://jurnal.polgan.ac.id/index.php/sinkron/index 200 "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; AspiegelBot)"
40.77.167.198 bot - "2020-04-20 03:06:00" https://jurnal.polgan.ac.id/index.php/sinkron/article/view/184 200 "Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)"
23

after 14 hours still didnt work

image

24

At this point the only thing I can think of is to think back to December 26 and try to remember what might have changed back then. If it worked before and then stopped working, what could have happened?

Also, i notice that in that list of hits you posted, they are all either bot hits or hits where you’re logged in as an administrator (the ones marked ad administrative). Those won’t count and will be ignored during processing.

Regards
Jason

25

How about the trigger to write DB metrics?

What the plugin to write DB metrcis? Maybe i try do trace from that

26

The plugin that actually does the writing to the database is the usageStatistics plugin. The scheduled task for that is run by the Acron plugin.

27

i remember now. what happen before.

i guest because of my hosting provider upgrade PHP Version to 7.2. but i dont remember what version before.

do you think because of PHP version?

28

I don’t think PHP 7.2 is the problem here, since we also use 7.2 on our production servers and stats process just fine.

Cheers,
Jason

29

i found this Error, is there any correlation with this?

[12-May-2020 01:57:51 Asia/Jakarta] PHP Fatal error:  Uncaught Error: Call to a member function getId() on null in /home/polgnac/public_html/jurnal/pages/article/ArticleHandler.inc.php:76
Stack trace:
#0 /home/polgnac/public_html/jurnal/lib/pkp/classes/core/PKPRouter.inc.php(369): ArticleHandler->initialize(Object(Request), Array)
#1 /home/polgnac/public_html/jurnal/lib/pkp/classes/core/PKPPageRouter.inc.php(239): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)
#2 /home/polgnac/public_html/jurnal/lib/pkp/classes/core/Dispatcher.inc.php(134): PKPPageRouter->route(Object(Request))
#3 /home/polgnac/public_html/jurnal/lib/pkp/classes/core/PKPApplication.inc.php(227): Dispatcher->dispatch(Object(Request))
#4 /home/polgnac/public_html/jurnal/index.php(67): PKPApplication->execute()
#5 {main}
  thrown in /home/polgnac/public_html/jurnal/pages/article/ArticleHandler.inc.php on line 76
30

Dear mr @jnugent

What if change plug-in or file replace the old ?

What plugin should I replace? I wanna try. I use ojs 3.1.1.4

Thank you

31

Hi @Muhammad_Khoiruddin

I’m not sure what you mean. OJS is designed to run as a unit - if you replace bits of code with other bits from other versions, you’re going to have problems. The plugins are designed to run with the version of OJS they were developed for.

Regards,
Jason

32

Dear @jnugent,
I’m sorry my question was not clear.

I mean, I’m worried some code broke by myself. maybe. I don’t know.
I use OJS 3.1.1.4, so I will replace it with the same version as you said above.

so I will replace it with the same version too, but I don’t know what plugin should be replaced.

  1. Acron Plugin
  2. usageStat Plugin
  3. etc. to support fill in db metric and statistic counter

I do not want to upgrade because I have familiar with this version.

Thank you.

33

Hi @Muhammad_Khoiruddin

Those plugins come with OJS so if you’re replacing OJS and downloading your installation from the PKP website you will get the correct version automatically.

Cheers,
Jason

34

i came here again after upgrade my OJS version from 3.1.1-4 to 3.2.1-1. and
download statistics still not work
db metrics no data updated

and this folder update every day

35

@jnugent

Successfully upgrade OJS from 3.1.1-4 to 3.2.1-1, but this download statistic still not work. what should to do?

Thank you

36

this is like ours, the counter cannot update, but logs update everyday …
this errors is same, after our hosting provider upgrade their server, so there are some errors and need to add some line code to our .htaccess. and until now I am not yet find any solution to this error.