As the developers of Open Journal Systems, Open Conference Systems, Open Harvester Systems, and Open Monograph Press, the PKP team are experts in helping journal managers and conference organizers make the most of their online publishing projects. PKP Publishing Services offers support for:

As a customer of PKP Publishing Services, you will not only receive direct, personalized support from the PKP Development Team, but will be contributing to the ongoing development of the PKP applications. All funds raised by PKP Publishing Services go directly toward enhancing our free, open source software. For more information, please contact us.

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

DB Error: ERROR: syntax error at or near "ORDER" LINE 3: ORDER BY day DESC ^

after I have logged out but left the web page as it is in my web browser until the following days. Once when I used the side bar login panel with my user credential after clicking LOGIN, and the other time when I click the LOGIN link on the navigation bar.

When the above happens, I just visit the base URL to login from there. It seems like a stale SSID problem.

Also, do I need to modify the table usage_stats_temporary_records as I don't see the field entry_time in the table? (I see a field metric in the table which I assume is being used somewhere else.)

In addition, in the schema.xml, the field entry_time is listed last after the field file_type whereas the code to manipulate the field entry_time is between the field day and country_id. Are these correct as they are?

Did you manage to fix this? Related to your questions previously, you just need to apply the patch in question and run an upgrade using the upgrade tool, something like this: php tools/upgrade.php upgrade

So the usage_stats_temporary_records table will get update automatically.

Yes, I did manage to patch OJS and run the DB upgrade tool. Overall, it seems to resolve this issue.

By the way, I have to manually disable the "Null" flag for the field "entry_time" even though the schema.xml file has declared the field NOTNULL. It must be something on my particular setup - unsure though.