[Dolibarr-bugtrack] [Bug #1891] Upgrade to 3.7 (from 3.6) KO Project task

[Doliforge]

Ce message ne s'affiche pas correctement? mettez à jour vos préférences utilisateur.

Dolibarr ERP & CRM » Bugs » bug #1891

Upgrade to 3.7 (from 3.6) KO Project task

Dernières modifications

Maxime Kohlhaas (atm-maxime)

11/03/2015 11:05 (Europe/Paris)

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,

Changements :

Assigned to:	Aucun → Maxime Kohlhaas (atm-maxime)
Resolution:	Aucun → Fixed

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,

 Lien direct vers l'artefact  |  Mettre à jour vos préférences