After update to 1.92: Surveys cannot be completed / strange erorr message

More
5 years 5 months ago - 5 years 5 months ago #77316 by TomTom82
TomTom82 created the topic: After update to 1.92: Surveys cannot be completed / strange erorr message
Hi there,

as with any updates before, I have used the comfort-update proecdure where the only thing I did was to set all the files' permissions in the /admin directory to "777" during and back to "444" after the update. I didn't edit / delete any files etc., assuming everything would be ok this way as it always was.

But now, when I try to complete a survey that was activated after the update (the ones that were active already before the update seem to work fine), I get error messages like this one:

Unknown column '29167X39X562vname' in 'field list':UPDATE lime_survey_29167 SET `lastpage`='1', `submitdate`='2012-03-25 21:31:24', `29167X39X562vname`='test', `29167X39X562nname`='test', `29167X39X562telef`='test', `29167X39X562handy`='test', `29167X39X562email`='test', `29167X39X568`='ball' WHERE ID=1


Hmpf...any help will be greatly appreaciated! (Note: Otherwise, everything seems to be fine, data integrity check displays no problems etc.)

Thanks!
Last Edit: 5 years 5 months ago by TomTom82.

Please Log in to join the conversation.

More
5 years 5 months ago #77322 by DenisChenu
DenisChenu replied the topic: After update to 1.92: Surveys cannot be completed / strange erorr message
Hello,

Can you test after download and replace admin/activate_function.php please :).

bugs.limesurvey.org/view.php?id=5951
git.io/HP_TIw

Denis

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 .

Please Log in to join the conversation.

More
5 years 5 months ago - 5 years 5 months ago #77420 by TomTom82
TomTom82 replied the topic: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr messag
Hi Denis,

thanks for your reply. I replaced the content of my admin/activate_function.php with the content of https://raw.github.com/LimeSurvey/LimeSurvey/e62b75f9bc9ab479c45c818f9b7400003010afd1/admin/activate_functions.php but still the same problem :(

Thanks,
Thomas
Last Edit: 5 years 5 months ago by TomTom82.

Please Log in to join the conversation.

More
5 years 5 months ago #77425 by DenisChenu
DenisChenu replied the topic: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr messag
Hello,

Try the last one:
github.com/LimeSurvey/LimeSurvey/blob/ma...tivate_functions.php

And you have to deactivate/activate your survey.

Denis

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 .

Please Log in to join the conversation.

More
5 years 5 months ago #77456 by TomTom82
TomTom82 replied the topic: Aw: Re: Aw: Re: After update to 1.92: Surveys cannot be completed / strange eror
At first, it seems to have worked (no error message) but when I try to export the data via excel file, the file is empty - no values listed! Also, when trying to edit the values via the limesurvey menu, it tells me that changes were saved, but when I looked at the values again, they are still the same!

Sorry... :(

Please Log in to join the conversation.

More
5 years 5 months ago - 5 years 5 months ago #77589 by ElToro1966
ElToro1966 replied the topic: After update to 1.92: Surveys cannot be completed / strange erorr message
I have the same problem, or at least a similar one. I get:

Unknown column '79423X1X1' in 'field list':UPDATE ls_survey_79423 SET `lastpage`='1', `submitdate`='2012-03-28 10:56:52', `79423X1X1`='Test', `79423X1X2`='', `79423X1X3`=NULL, `79423X1X4`=NULL, `79423X1X8SQ001`='', `79423X1X8SQ002`='', `79423X1X8SQ003`='', `79423X1X8SQ004`='', `79423X1X5`='test', `79423X1X6`='518746801', `79423X1X7`='', `79423X1X13SQ001`='', `79423X1X13SQ002`='', `79423X1X13SQ003`='', `79423X1X13SQ004`='', `79423X1X13SQ005`='', `79423X1X13SQ006`='', `79423X1X13SQ007`='', `79423X1X13SQ008`='', `79423X1X13SQ009`='', `79423X1X13SQ010`='' WHERE ID=2

:dry:

Is an fix for this available? Thanks.
Last Edit: 5 years 5 months ago by ElToro1966. Reason: Clean-up

Please Log in to join the conversation.

More
5 years 5 months ago #77599 by titoun31
titoun31 replied the topic: After update to 1.92: Surveys cannot be completed / strange erorr message
Hi TomTom,

I had the same problem following my update from LS1.91 to 1.92 : Update required to change the rights of my files.

To fix:
1/ Make the Denis' update (activate-function.php) and desactivate/activate your survey,
2/ Check your config files (config.php and config-default.php), because apparently during the update, the parameters were re-initialized,
3/ For the moment, keep the rights 777 on your files

And test ...

Normally it will be ok. The only problem is your file permissions. Maybe, the easier is to re-install LS 1.92 completely.

Good luck

Please Log in to join the conversation.

More
5 years 5 months ago #77600 by titoun31
titoun31 replied the topic: After update to 1.92: Surveys cannot be completed / strange erorr message
Same problem ... same fix below

Please Log in to join the conversation.

More
5 years 5 months ago #77640 by ElToro1966
ElToro1966 replied the topic: After update to 1.92: Surveys cannot be completed / strange erorr message
I exported the surveys I had already made, deleted the 1.92installation, reinstalled 1.91 and imported the surveys. Works fine now, but:

I am new to Lime Survey and this error was the first thing that happened after making my first survey. This is rather worrying... How much testing is done prior to updates? :dry:

If you guys need more people doing testing, I hereby volunteer. :cheer:

Please Log in to join the conversation.

More
5 years 5 months ago #77649 by yyassaman
yyassaman replied the topic: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr messag
Thanks! This file has solved the problem

Please Log in to join the conversation.

More
5 years 5 months ago #77788 by Mazi
Mazi replied the topic: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr messag

ElToro1966 wrote: I am new to Lime Survey and this error was the first thing that happened after making my first survey. This is rather worrying... How much testing is done prior to updates? :dry:

If you guys need more people doing testing, I hereby volunteer. :cheer:

If you notice any problems, please report them at our Bugtracker. Simple bugs, and especially update problems, are usually fixed quite fast. But if no one reports them, we can't fix it.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
5 years 5 months ago #77880 by TomTom82
TomTom82 replied the topic: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr messag
After having run the comfort updater to Version 1.92+ Build 120330, it seems the problem now has really been fixed in this build!

Thanks to all the people who put their effort into this! :)

Please Log in to join the conversation.

More
5 years 2 months ago #83691 by Galagama
Galagama replied the topic: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr messag
Hey there,

I am using LimeSurvey
Version 1.92+ Build 120711

and still have the same problem/bug during the survey so that it can't be finished.

Bug says:
Unknown column '57788X2X9SQ004' in 'field list':UPDATE lime_survey_57788
SET `lastpage`='2', `datestamp`='1980-01-01 00:00:00',
`57788X2X9SQ001`='L005', `57788X2X9SQ002`='L005',
`57788X2X9SQ003`='L005', `57788X2X9SQ004`='L005',
`57788X2X9SQ005`='L005', `57788X2X13SQ001`='L005',
`57788X2X13SQ002`='L005', `57788X2X13SQ003`='L005',
`57788X2X13SQ004`='L005', `57788X2X13SQ005`='L005', `57788X2X17`='A6',
`57788X18X202`=NULL, `57788X18X202other`=NULL, `57788X18X203`=NULL,
`57788X18X203other`=NULL WHERE ID=12



What can I do?

thanks in advance

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now