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
Topic Author
Offline
Premium Member

More

5 years 5 days 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
Offline
LimeSurvey Community Team & Official Partner

More

5 years 4 days 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.

stevelegare
Topic Author
Offline
Premium Member

More

5 years 4 days 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

Welcome to the LimeSurvey Community Forum

Move LimeSurvey to new server with MySQL STRICT mode ON

Lime-years ahead

Legal

About Us

Open Source