Dolibarr ERP & CRM » Bugs » bug #1782 Error upgrading from 3.5.1 to 3.6.2 with MySQL strict mode ONLatest modifications
Answer now
Snapshot| Details |
| Last Modified On: | 2015-01-02 19:01 | | Submitted by: | Marcos García (marcosgdf) |
| Submitted on: | 2015-01-02 19:01 | |
| Summary: | Error upgrading from 3.5.1 to 3.6.2 with MySQL strict mode ON |
| Description: | Request 22 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage ADD COLUMN entity integer DEFAULT 1 NOT NULL;
Invalid default value for 'tms'
Request 23 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN allow_comments tinyint NOT NULL DEFAULT 1;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage ADD COLUMN allow_comments tinyint NOT NULL DEFAULT 1;
Invalid default value for 'tms'
Request 24 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN allow_spy tinyint NOT NULL DEFAULT 1 AFTER allow_comments;'
Request 25 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN fk_user_creat integer AFTER nom_admin;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage ADD COLUMN fk_user_creat integer AFTER nom_admin;
Invalid default value for 'tms'
Request 26 sql='ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN mailsonde mailsonde tinyint NOT NULL DEFAULT 0;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN mailsonde mailsonde tinyint NOT NULL DEFAULT 0;
Invalid default value for 'tms'
Request 27 sql='ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN titre titre TEXT NOT NULL;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN titre titre TEXT NOT NULL;
Invalid default value for 'tms'
Request 28 sql='ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN date_fin date_fin DATETIME NOT NULL;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN date_fin date_fin DATETIME NOT NULL;
Invalid default value for 'tms'
Request 29 sql='ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN format format VARCHAR(2) NOT NULL;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN format format VARCHAR(2) NOT NULL;
Invalid default value for 'tms'
Request 30 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN sujet TEXT;'
Error DB_ERROR_1067: ALTER TABLE llx_opensurvey_sondage ADD COLUMN sujet TEXT;
Invalid default value for 'tms' |
| Step to reproduce bug: | |
| Detected in version: | 3.6.1 | | Category: | Core Problem |
| Severity: | 6 | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Open | | Assigned to: | Laurent Destailleur (eldy) |
| Resolution: | Fixed | |
Comments- Laurent Destailleur 2015-01-05 09:28
- I added this request:
update llx_opensurvey_sondage set tms = now();
into the repair.sql script.
Problem is not into 3.5 to 3.6 migration script but into bug into old version of dolibarr and mysql allowing corrupted data into a timestamp field.
Real fix is just an "advice" to run the repair if this error occurs.
|
|
update llx_opensurvey_sondage set tms = now();
into the repair.sql script.
Problem is not into 3.5 to 3.6 migration script but into bug into old version of dolibarr and mysql allowing corrupted data into a timestamp field.
Real fix is just an "advice" to run the repair if this error occurs.
None→ Laurent Destailleur (eldy)None→ Fixed