Custom Report Generator no data in spreadsheet

Yes the base_url is correct.
In the config.inc.php - base_url = “http://cjpe.journalhosting.ucalgary.ca

In the log files I have:-
130.225.243.84 - - “2015-04-09 01:43:34” http://cjpe.journalhosting.ucalgary.ca/cjpe/index.php/cjpe/article/download/82/pdf 200 “Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:36.0) Gecko/20100101 Firefox/36.0”

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?

Regards,
Edward

Edward, the base_url is not correct, I think.

It should be the url that gives access to the system. And this is http://cjpe.journalhosting.ucalgary.ca/cjpe

Try setting this and reprocessing the files again. Just move them to stage and they should be processed next time.

Cheers,
Bruno

Done, I will check on Monday to see how the stats are looking.

Thanks,
Edward

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?

Thanks,
Edward

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.

Cheers,
Bruno

There is no data. So problem generating the report.

Thanks,
Edward

Edward, I see no other option other than what I proposed last message. Can you provide the data for me to debug it locally? Thanks.

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.

Thanks,
Edward

Sent private message. Cheers.

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:-

  1. this applies to OJS-2.4.3 apply the recommended patches.
  2. 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
  3. 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.
  4. base url was not set up correctly I did not realize I had to include the journal folder in the url.
  5. 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.

Regards,
Edward

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.

Thanks,
Edward

Edward, can you please post your PHP error log? That might help like the previous time. Thanks.

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.

Thanks,
Edward

What if I’m using lighttpd? Where will I be able to find php logs?

Hi @asenath,

This might help: http://redmine.lighttpd.net/projects/lighttpd/wiki

Cheers,
Bruno

Hi all,

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.

Thanks

@Dein,

You can try this page: http://pkp.sfu.ca/wiki/index.php?title=OJS_2.4.2_Recommended_Patches

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.

Cheers,
Bruno

Hey Bruno,

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.

Kudos,
Dein

Hey @beghelli,

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.

Thanks,
Dein

@Dein,

Do you still have problems with this? I think you’ve already followed this: My published file views or statistics reports shows no data. What do I do?

Everything that I described there is ok? If not, what it’s described there that’s not the same on your side?

Thanks,
Bruno