Check out the LimeSurvey source code on GitHub!

PostgreSQL with Sessions Issue

2 years 8 months ago - 2 years 8 months ago #110185 by Gordon55M
I found this issue in the bug tracker here: but it is marked as solved and I am using Version 2.05+ Build 140612, so I thought this would have been included in my version.

The admin side works without issue with regards to the sessions being used on the postgresql database side. However when I try to start a survey, I get to the 2nd page and have a sessions issue. This happens on all browsers.

This only happens to PostgreSQL, when I switch the db to be MySQL it works no problem. Data is being written to the lime_sessions table when I check the db as well so I figure it should work. Thoughts?

// Uncomment the following line if you need table-based sessions
		 'session' => array (
			 'class' => 'system.web.CDbHttpSession',
			 'connectionID' => 'db',
			 'sessionTableName' => '{{sessions}}',


We are sorry but your session has expired.

Either you have been inactive for too long, you have cookies disabled for your browser, or there were problems with your connection."
Last Edit: 2 years 8 months ago by Gordon55M. Reason: Added survey error code regarding sessions at the bottom.

Please Log in to join the conversation.

1 year 9 months ago #120704 by riqcles
Fixed on the new build, but not for me.
You can try ?

LimeSurvey version 2.05 build 141020 / 2.00 + build 131107 / 1.85+ (hors service ! yes ! )
OS : CentOS 6.5 / PHP 5.4.33/ 5.3.13
BDD : PostGresql 9.3.4 / 9.3.1 / 8.4.11

Please Log in to join the conversation.

1 year 9 months ago #120705 by Gordon55M
I actually have kind of gone away from PostgreSQL since I posted this. I found the performance to be very minimal over that of MySQL so I kept it simple and stayed with MySQL. I will however be doing some more research on MariaDB with this and you let you know how it works.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form