You are viewing the PKP Support Forum | PKP Home Wiki

PostgreSQL DB Error for login after 1 day logout...

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

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.

PostgreSQL DB Error for login after 1 day logout...

Postby victorp » Mon Feb 03, 2014 8:23 pm

I have this error message occurring twice on me:

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.

My OJS is v2.4.3 running on Mac OS X 10.8.5 with PHP v5.3.26, Apache HTTP v2.2.24 and PostgreSQL 9.2.4.
Posts: 2
Joined: Sun Jan 26, 2014 8:06 am
Location: Singapore

Re: PostgreSQL DB Error for login after 1 day logout...

Postby asmecher » Tue Feb 04, 2014 9:34 am

Hi victorp,

It looks like some SQL made it into the release that PostgreSQL doesn't support; I've filed this at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=8549. Feel free to CC yourself to the entry so you'll be notified when it changes.

Alec Smecher
Public Knowledge Project Team
Posts: 7710
Joined: Wed Aug 10, 2005 12:56 pm

Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot] and 22 guests