Dolibarr ERP & CRM » Bugs » bug #1782 Error upgrading from 3.5.1 to 3.6.2 with MySQL strict mode ONSnapshot| Details |
| Submitted by: | Marcos García (marcosgdf) | | Submitted on: | 2015-01-02 19:01 |
| Last Modified 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: | None |
| Resolution: | None | |
Answer now
|
|