Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Move LimeSurvey to new server with MySQL STRICT mode ON

  • stevelegare
  • stevelegare's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 1 month ago #194310 by stevelegare
Move LimeSurvey to new server with MySQL STRICT mode ON was created by stevelegare
We move our LimeSurvey instance to a new server with MySQL strict mode.


When I try to import responses from a deactivated survey table i have this error
Code:
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field 'startdate' doesn't have a default value

That error seems to be related at the creation of "survey_123456" table with no default value for startdate field.

versionnumber=2.05+
dbversionnumber=178

Can someone help us with this?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 1 month ago #194349 by DenisChenu
Replied by DenisChenu on topic Move LimeSurvey to new server with MySQL STRICT mode ON

stevelegare wrote: versionnumber=2.05+
dbversionnumber=178

Error already reported and fixed if i don't make error ...

Update to 3LTS or 2.6lts
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • stevelegare
  • stevelegare's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 1 month ago #194370 by stevelegare
Replied by stevelegare on topic Move LimeSurvey to new server with MySQL STRICT mode ON
Thanks for your reply.
I know but we can't now. We will upgrade in a few months
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source