Back to limesurvey.org

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

More
6 years 8 months 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.
Partner Banner
More
6 years 8 months 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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
6 years 8 months 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.
Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source