Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

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

After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77316

  • TomTom82
  • TomTom82's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 10
  • Karma: 0
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: 2 years 5 months ago by TomTom82.
The administrator has disabled public write access.

Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77322

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6318
  • Thank you received: 810
  • Karma: 242
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
The administrator has disabled public write access.

Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77420

  • TomTom82
  • TomTom82's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 10
  • Karma: 0
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: 2 years 5 months ago by TomTom82.
The administrator has disabled public write access.

Re: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77425

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6318
  • Thank you received: 810
  • Karma: 242
Hello,

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

And you have to deactivate/activate your survey.

Denis
The administrator has disabled public write access.

Aw: Re: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77456

  • TomTom82
  • TomTom82's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 10
  • Karma: 0
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... :(
The administrator has disabled public write access.

Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77589

  • ElToro1966
  • ElToro1966's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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: 2 years 5 months ago by ElToro1966. Reason: Clean-up
The administrator has disabled public write access.

Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77599

  • titoun31
  • titoun31's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 95
  • Thank you received: 11
  • Karma: 6
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
The administrator has disabled public write access.

Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77600

  • titoun31
  • titoun31's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 95
  • Thank you received: 11
  • Karma: 6
Same problem ... same fix below
The administrator has disabled public write access.

Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77640

  • ElToro1966
  • ElToro1966's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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:
The administrator has disabled public write access.

Re: Aw: Re: After update to 1.92: Surveys cannot be completed / strange erorr message 2 years 5 months ago #77649

  • yyassaman
  • yyassaman's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Thanks! This file has solved the problem
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.120 seconds
Donation Image