As examples.
Part of the issue is that cjpe.synergiesprairies.ca also point to this journal. So I have to edit the log files and change all occurances of “synergiesprairies.ca” to “journalhosting.ucalgary.ca”.
I am assuming all I need to do is changed the files in archives and they will be reprocessed?
Nothing in the Custom Reports
Archive folder has nothing in it.
Processing folder has one file usage_events_20140831.log.
Reject folder has nothing in it.
Stage folder has 313 files in it.
The usageEventLogs folder has 2 files in it usage_events_20150410.log and usage_events_20150413.log.
So what am I missing to get the custom reports working?
Ok, can you run this SQL to check if you have stats data in your database?
SELECT * from metrics where metric_type = ‘ojs::counter’;
If there data there, check the date column and see if it’s related to the last days (after you fixed your base_url). If yes, than try generating the custom report using that time range. If nothing is still the result, than it’s a problem generating the report and we can close this issue and open a new one.
If not, I would ask you if you can provide a database dump from your installation and also some log files for me to debug this locally here. It that’s possible, of course.
Bruno,
How do you want me to get the data to you. I see this forum I cannot attach the file.
I was going to PM you but found I could not attach any files to the PM.
Here is an update that I hope will help anyone else that has problems with Custom Reporting not working.
I am updating this ticket as two issues were not entered that will impact generating the stats,
There was a number of issues in regards to my Custom Reports not working:-
this applies to OJS-2.4.3 apply the recommended patches.
OJS-2.4.3 doesn’t have the entry_time column. If you applied any patch or installed a newer version, you should run the upgrade tool to update the database also and get rid of that error. Run this to update your database: php tools/dbXMLtoSQL.php execute plugins/generic/usageStats/schema.xml
multiple domains for the journal that did not match the base url in the config file which made generating stats sporadic at best if they worked at all.
base url was not set up correctly I did not realize I had to include the journal folder in the url.
I had edited the log files under usageStats to be the same as the base url and moved them to the stage folder to be reprocessed. I had made the changes under a different user that what apache was using so the auto process routine ignored those log files. I had to change the owner for the log files to the same user that apache was running under for the log files to be processed.
Once I had made those changes and let the stats processor run over night when I came in the next morning I had data for the custom reports.
Special thanks to Bruno Beghelli for all his help in resolving this issue. Now I have to go into all of our journals and make sure they are all working.
Hi @beghelli,
I am having the same issue with another journal and these changes did not help. It is running OJS-2.4.3 and using PostgreSQL as the database. I ran the queries listed and the last one did not have any data so nothing is being processed.
Is there a special trick for PostgreSQL to get the stats to work.
The client wants to view counts for the latest issue/year. I viewed a couple of articles yesterday came in today and nothing even though the log file is showing my information.
I will be out of the office for the next three days but will be checking my emails in the morning.
Hi @beghelli,
As soon as I looked at the error log I realized I had forgotten to update my database after applying the patches.
I have edited my followup to this ticket so others do not miss that critical piece of information.
I will check tomorrow or Monday to check if the stats have been updated.
Our system is still running on OJS 2.4.2 as my boss doesn’t feel like to upgrade to 2.4.7 due to his personal reasons. Today, he requested me to generate the statistics report of which i tried using the ‘Report Generator’. But the problem is, i can’t seemed to find anything in the spreadsheet. I have followed the instructions provided in this link My published file views or statistics reports shows no data. What do I do? but the problem still persists. I wish anyone that has solved this issue could help me out by giving some pointers.
But the easiest way is to upgrade to 2.4.7. If you still have problems after that, we can help debugging then. But 2.4.2 is old and LOTS of improvements and bug fixes were implemented since then into the stats code.
Thank you for your reply.Great. I guess it’s better to upgrade the system to 2.4.7 as there are several other bugs that needed to be fixed. Thanks Bruno.
I have installed the current 2.4.7 version of the OJS. However, the problem still persists. Additionally, i would like to know how to display the view times for every articles in public. I was following this thread https://pkp.sfu.ca/support/forum/viewtopic.php?f=9&t=9668&start=30, but couldn’t get to a firm understanding. Please help me.