[mysql error] CDbCommand failed to execute the SQL statement

More
5 years 1 month ago - 5 years 1 month ago #80146 by pawciak
pawciak created the topic: [mysql error] CDbCommand failed to execute the SQL statement
Hey Guys,

first of all - amazing piece of work! But i have a tiny problem. While on localhoest for first time everything went ok, after moving script to server i get following error (after trying to start filling the survey)
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'datestamp' in 'field list'. The SQL statement executed was: INSERT INTO `lime_survey_585565` (`startlanguage`, `datestamp`, `startdate`, `ipaddr`) VALUES (:startlanguage, :datestamp, :startdate, :ipaddr)

This is the rest of error page: http://justpaste.it/z2a
If you need screenshot just let me know

Any ideas how to fix it manually? Im working on the newest version of LS. Thanks!
Last Edit: 5 years 1 month ago by pawciak.

Please Log in to join the conversation.

More
5 years 1 month ago #80202 by Mazi
Mazi replied the topic: [mysql error] CDbCommand failed to execute the SQL statement
It looks like you are using Limesurvey version 2 which isn't stable yet.

When does the error show up?

Please open a ticket at the Bugtracker and...
  1. Give as much information as possible
  2. Attach your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.
  3. Provide step-by-step instructions how to reproduce the problem.
  4. If possible/helpful please provide screenshots

Afterwards please post the link to the Bugtracker so we can follow the progress.

Thanks!


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.

Start now!

Just create your account and start using Limesurvey today.

Register now