PostgreSQL with Sessions Issue

Mehr
3 Jahre 1 Monat her - 3 Jahre 1 Monat her #110185 von Gordon55M
Gordon55M erstellte das Thema PostgreSQL with Sessions Issue
I found this issue in the bug tracker here: bugs.limesurvey.org/view.php?id=8076 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}}',
		 ),
 

"Error

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."
Letzte Änderung: 3 Jahre 1 Monat her von Gordon55M. Begründung: Added survey error code regarding sessions at the bottom.

Bitte Anmelden um der Konversation beizutretten.

Mehr
2 Jahre 2 Monate her #120704 von riqcles
riqcles antwortete auf das Thema: PostgreSQL with Sessions Issue
Fixed on the new build, but not for me.
You can try ?

LimeSurvey version 2.06 build 141020 / future 2.62 / 63 build dernière en date :)
OS : CentOS 7.1 / PHP 5.6.27
BDD : PostGresql 9.4.6 /

Bitte Anmelden um der Konversation beizutretten.

Mehr
2 Jahre 2 Monate her #120705 von Gordon55M
Gordon55M antwortete auf das Thema: PostgreSQL with Sessions Issue
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.

Bitte Anmelden um der Konversation beizutretten.

Haben Sie schon bei unserer Kundenumfrage mitgemacht?

Verpassen Sie nicht Ihre Chance auf tolle Preise.

Klicken sie hier um teilzunehmen:

Jetzt starten

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten