CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]

Plus d'informations
il y a 1 mois 3 semaines #174678 par izzysteve
izzysteve a créé le sujet : CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]
Hi,

New to LimeSurvey and installed on my host from download yesterday.

I created a survey, and then wanted to try it out so I copied it (so my original was still clean). Activated the copy and getting the error message in subject when I click Submit.

I found somewhere how to turn on debug, so I did and attach the dump.

I have seen this error on other posts, but they all seem either old or inconclusive.

Help greatly appreciated.

Thanks
Pièces jointes :

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 3 semaines #174680 par jelo
jelo a répondu au sujet : CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]

izzysteve écrit: I created a survey, and then wanted to try it out so I copied it (so my original was still clean). Activated the copy and getting the error message in subject when I click Submit.


Export survey via LSS export and import the survey again (which is a different form of copying a survey).
Same error like you attached here?
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '191564X42X1331' in 'field list'. The SQL statement executed was: UPDATE survey_191564 SET `lastpage`=1, `datestamp`='2018-09-27 17:47:39', `191564X43X1357`=NULL, `191564X43X1359SQ001`=NULL, `191564X43X1359SQ002`=NULL, `191564X43X1359SQ003`=NULL, `191564X43X1359SQ004`=NULL, `191564X43X1359SQ005`=NULL, `191564X43X1359SQ006`=NULL, `191564X43X1359other`=NULL, `191564X43X1360`=NULL, `191564X43X1361`=NULL, `191564X43X1362`=NULL, `191564X43X1363`=NULL, `191564X43X1364`=NULL, `191564X43X1365`=NULL, `191564X43X1366`=NULL, `191564X43X1367`=NULL, `191564X42X1331`='Hidden' WHERE ID=2	</p>

What exact version of LimeSurvey is used? Click on the version number at the bottom to get more infos about your server setup.

I recommend to copy via export / import and check again.
If the you still get the same issue, try with different surveys (e.g. create a new one) and copy via function and export/import. If the issue is not there, you might just have a issue in the survey structure or database.

Perhaps only one question is buggy. One approach is to delete one question or questiongroup in a copy of the survey and try to activate again. If that is still results in an error, you delete another question or questiongroup.
Often you can isolate the buggy question after some time.

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 2 semaines - il y a 1 mois 2 semaines #174694 par DenisChenu
DenisChenu a répondu au sujet : CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]
@jelo : you test on last version ? It's a terribely awfull issue here …
Have you a 1331 question in group 42 ?



EDIT : sorry : think you import included lss … but no lss included

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
Dernière édition: il y a 1 mois 2 semaines par DenisChenu. Raison: see EDIT

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 2 semaines #174699 par izzysteve
izzysteve a répondu au sujet : CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]
@jelo, thanks so much for your suggestions.

I believe I am right up to date on the version as only just installed - Version 3.14.9+180917

I tried your export/import approach to a new survey; activated and it worked fine.

Given the source survey in each case (the initial copy, then the export/import) has not changed, I assume there is a bug in the copy function?

Unless there are any other suggestions, I will raise a bug with the LS team.

Thanks again @jelo

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 2 semaines #174707 par izzysteve
izzysteve a répondu au sujet : CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]
lsa file as requested

This survey (191564) and the lss I attached to the bug report is the one that crashes with the dump
Pièces jointes :

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!