Bonjour à tous,
A cause de problème de time out lié au serveur apache utilisé (je n'ai pas la main dessus), j'ai activé la gestion des sessions dans la base de données POSTGRES.
Cela fonctionnait avec une build 205 un peu ancienne (décembre de mémoire), mais plus maintenant.

Le bug suivant a été créé par un autre membre de la communauté : bugs.limesurvey.org/view.php?id=9592

La correction est arrivé hier, j'ai mis la nouvelle version, mais toujours le même constat.

D'autres peuvent revérifier avant que je relance le sujet ?

Salut,

Ici, Carsten semble avoir shooté : SET bytea_output='escape'; sur une des table, mais pas de l'avoir mis lors de la mise à jour ?

Pas trop le temps de tester tout de suite ....

Mais si tu confirme que cela ne fonctione toujours pas :
- Active le debug = 2 et le debugSQL à 1.
- Regarde le log dans firebug (ou autre console javascript)
- Réouvre en donnant le log qui montre un problème (ou tout le log si tu ne trouve pas).

Denis

Je suis désolé, je suis pas trop habitué à Firebug (je viens de l'installer) :blush:
J'ai choisi le panneau console puis :
ALL
et la j'ai un log énorme :laugh:

Mais si je choisi erreur, il n'y en a pas.

Je le colle ici pour savoir si c'est ça :

---

Debut de log

---

[17:23:17.031][trace][system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
index (ligne 72)
[17:23:17.034][trace][system.db.CDbConnection] Opening DB connection
index (ligne 73)
[17:23:17.067][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1
index (ligne 74)
[17:23:17.088][trace][system.db.CDbCommand] Executing SQL: DELETE FROM "lime_sessions" WHERE expire<:expire. Bound with :expire=1432142597
index (ligne 75)

[17:23:17.090][trace][system.db.CDbCommand] Querying SQL: SELECT "data"
FROM "lime_sessions"
WHERE expire>:expire AND id=:id. Bound with :expire=1432142597, :id='d0l99n27fpf9su8pccr8668237'

index (ligne 76)
[17:23:17.100][trace][system.db.ar.CActiveRecord] SettingGlobal.findAll()
index (ligne 77)
[17:23:17.100][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM "lime_settings_global" "t"
index (ligne 78)
[17:23:17.338][trace][system.db.ar.CActiveRecord] Survey.findByPk()
index (ligne 79)
[17:23:17.339][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=333673 LIMIT 1
index (ligne 80)
[17:23:17.342][trace][system.db.ar.CActiveRecord] SurveyLanguageSetting.findByPk()
index (ligne 81)

[17:23:17.348][trace][system.db.CDbCommand] Querying SQL: SELECT "t"."surveyls_survey_id" AS "t0_c0", "t"."surveyls_language" AS "t0_c1", "t"."surveyls_title" AS "t0_c2", "t"."surveyls_description" AS "t0_c3", "t"."surveyls_welcometext" AS "t0_c4", "t"."surveyls_endtext" AS "t0_c5", "t"."surveyls_url" AS "t0_c6", "t"."surveyls_urldescription" AS "t0_c7", "t"."surveyls_email_invite_subj" AS "t0_c8", "t"."surveyls_email_invite" AS "t0_c9", "t"."surveyls_email_remind_subj" AS "t0_c10", "t"."surveyls_email_remind" AS "t0_c11", "t"."surveyls_email_register_subj" AS "t0_c12", "t"."surveyls_email_register" AS "t0_c13", "t"."surveyls_email_confirm_subj" AS "t0_c14", "t"."surveyls_email_confirm" AS "t0_c15", "t"."surveyls_dateformat" AS "t0_c16", "t"."surveyls_attributecaptions" AS "t0_c17", "t"."email_admin_notification_subj" AS "t0_c18", "t"."email_admin_notification" AS "t0_c19", "t"."email_admin_responses_subj" AS "t0_c20", "t"."email_admin_responses" AS "t0_c21", "t"."surveyls_numberformat" AS "t0_c22", "t"."attachments" AS "t0_c23", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1", "survey"."admin" AS "t1_c2", "survey"."active" AS "t1_c3", "survey"."expires" AS "t1_c4", "survey"."startdate" AS "t1_c5", "survey"."adminemail" AS "t1_c6", "survey"."anonymized" AS "t1_c7", "survey"."faxto" AS "t1_c8", "survey"."format" AS "t1_c9", "survey"."savetimings" AS "t1_c10", "survey"."template" AS "t1_c11", "survey"."language" AS "t1_c12", "survey"."additional_languages" AS "t1_c13", "survey"."datestamp" AS "t1_c14", "survey"."usecookie" AS "t1_c15", "survey"."allowregister" AS "t1_c16", "survey"."allowsave" AS "t1_c17", "survey"."autonumber_start" AS "t1_c18", "survey"."autoredirect" AS "t1_c19", "survey"."allowprev" AS "t1_c20", "survey"."printanswers" AS "t1_c21", "survey"."ipaddr" AS "t1_c22", "survey"."refurl" AS "t1_c23", "survey"."datecreated" AS "t1_c24", "survey"."publicstatistics" AS "t1_c25", "survey"."publicgraphs" AS "t1_c26", "survey"."listpublic" AS "t1_c27", "survey"."htmlemail" AS "t1_c28", "survey"."sendconfirmation" AS "t1_c29", "survey"."tokenanswerspersistence" AS "t1_c30", "survey"."assessments" AS "t1_c31", "survey"."usecaptcha" AS "t1_c32", "survey"."usetokens" AS "t1_c33", "survey"."bounce_email" AS "t1_c34", "survey"."attributedescriptions" AS "t1_c35", "survey"."emailresponseto" AS "t1_c36", "survey"."emailnotificationto" AS "t1_c37", "survey"."tokenlength" AS "t1_c38", "survey"."showxquestions" AS "t1_c39", "survey"."showgroupinfo" AS "t1_c40", "survey"."shownoanswer" AS "t1_c41", "survey"."showqnumcode" AS "t1_c42", "survey"."bouncetime" AS "t1_c43", "survey"."bounceprocessing" AS "t1_c44", "survey"."bounceaccounttype" AS "t1_c45", "survey"."bounceaccounthost" AS "t1_c46", "survey"."bounceaccountpass" AS "t1_c47", "survey"."bounceaccountencryption" AS "t1_c48", "survey"."bounceaccountuser" AS "t1_c49", "survey"."showwelcome" AS "t1_c50", "survey"."showprogress" AS "t1_c51", "survey"."questionindex" AS "t1_c52", "survey"."navigationdelay" AS "t1_c53", "survey"."nokeyboard" AS "t1_c54", "survey"."alloweditaftercompletion" AS "t1_c55", "survey"."googleanalyticsstyle" AS "t1_c56", "survey"."googleanalyticsapikey" AS "t1_c57" FROM "lime_surveys_languagesettings" "t" LEFT OUTER JOIN "lime_surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=333673 AND "t"."surveyls_language"='en')

---

Fin de LOG

---

Si c'est ok, je créé un nouveau bug avec comme lien l'ancien.

En suivant ce lien (vu dans le bugtracker) : github.com/yiisoft/yii/issues/3476

Le premier intervenant indique qu'il a changer de type de données : i changed the bytea into varchar

Si c'est ça, il faudrait modifier le type pour une base active...bon je dis surement des bétises, mais il n'y a que ceux qui en disent pas qui n'en font pas :lol:

Salut,

On a bien les infos de session dans le log:
Il faudrais regarder si c'est différent avec la prévisualisation ?
Et poster les 2 logs :
Log : visu de question
Log : prévisu de questions.

Tu es bien sur la 150520 , et tu a bien renouveler ta session (fermer le navigateur puis réouvrir).

Denis
PS: tu n'as pas le bouton "reopen" sur le rapport ?
PS2: oui, il semble que il n'y ai pas de update de la BDD si elle a était mise à jour ...

Je reprends les messages pour répondre :
Il faudrais regarder si c'est différent avec la prévisualisation ?
Et poster les 2 logs :
Log : visu de question
17:45:45.946][trace][system.db.CDbCommand] Executing SQL: DELETE FROM "lime_sessions" WHERE expire<:expire. Bound with :expire=1432143945
17 (ligne 203)

[17:45:45.948][trace][system.db.CDbCommand] Querying SQL: SELECT "data"
FROM "lime_sessions"
WHERE expire>:expire AND id=:id. Bound with :expire=1432143945, :id='lsl08ohp8d1jujag975mkkjij3'

Log : prévisu de questions.
[17:39:10.736][trace][system.db.CDbCommand] Executing SQL: DELETE FROM "lime_sessions" WHERE expire<:expire. Bound with :expire=1432143550
index (ligne 75)

[17:39:10.738][trace][system.db.CDbCommand] Querying SQL: SELECT "data"
FROM "lime_sessions"
WHERE expire>:expire AND id=:id. Bound with :expire=1432143550, :id='lsl08ohp8d1jujag975mkkjij3


Tu es bien sur la 150520 , et tu a bien renouveler ta session (fermer le navigateur puis réouvrir).
Oui bien sur la 150520

Denis
PS: tu n'as pas le bouton "reopen" sur le rapport ? non juste modify
PS2: oui, il semble que il n'y ai pas de update de la BDD si elle a était mise à jour ...

Voila chef :laugh:

Je n'avais pas vu ton poste précédent.
Donc : oui tu peux créer un nouveau bug avec:
- Indiquer child of : le numéro du précédent
- Indiquer que ta BDD semble avoir le mauvais bytea_output (si tu peux le vérifier ou le faire vérifier, ca serait cool, mais dans ce cas ...)

Voici un apercu avec pgadmin.

Je poste le bug demain... je dois rentre plus tot aujourd'hui.

Bug posté : bugs.limesurvey.org/view.php?id=9644