Dolibarr ERP & CRM » Bugs » bug #1891 Upgrade to 3.7 (from 3.6) KO Project taskDernières modifications
Répondre
État Détails |
Submitted by: | braito (braito) | | Submitted on: | 02/03/2015 13:00 |
Last Modified On: | 02/03/2015 13:00 | |
Summary: | Upgrade to 3.7 (from 3.6) KO Project task |
Description: | Error in the update:
Error DB_ERROR_SYNTAX: ALTER TABLE llx_projet_task CHANGE COLUMN duration_effective real DEFAULT 0 NULL;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'real DEFAULT 0 NULL' at line 1
Request 926 sql='ALTER TABLE llx_projet_task CHANGE COLUMN planned_workload real DEFAULT 0 NULL;'
Error DB_ERROR_SYNTAX: ALTER TABLE llx_projet_task CHANGE COLUMN planned_workload real DEFAULT 0 NULL;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'real DEFAULT 0 NULL' at line 1
|
Step to reproduce bug: | |
Detected in version: | 3.7.0 | | Category: | Core Problem |
Severity: | 5 - Major | | OS Type/Version: | |
PHP version: | | | Database type and version: | |
Etat |
Status: | Open | | Assigned to: | Maxime Kohlhaas (atm-maxime) |
Resolution: | Fixed | |
Commentaires- Maxime Kohlhaas 11/03/2015 11:05
- Hello,
This seems to be fixed, I just tried an upgrade 3.6 -> 3.7 and it went well.
In the script, I saw this :
Request 925 sql='ALTER TABLE llx_projet_task MODIFY COLUMN duration_effective real DEFAULT 0 NULL;'
Request 926 sql='ALTER TABLE llx_projet_task MODIFY COLUMN planned_workload real DEFAULT 0 NULL;'
So it seems that 'CHANGE COLUMN' has been replaced by 'MODIFY COLUMN'.
Regards,
|
|
This seems to be fixed, I just tried an upgrade 3.6 -> 3.7 and it went well.
In the script, I saw this :
Request 925 sql='ALTER TABLE llx_projet_task MODIFY COLUMN duration_effective real DEFAULT 0 NULL;'
Request 926 sql='ALTER TABLE llx_projet_task MODIFY COLUMN planned_workload real DEFAULT 0 NULL;'
So it seems that 'CHANGE COLUMN' has been replaced by 'MODIFY COLUMN'.
Regards,
Aucun→ Maxime Kohlhaas (atm-maxime)Aucun→ Fixed