[Erp5-dev] mysql 4.0.20 and comma

[Sebastien Robin]

Hi all,

I had a problem with some queries with mysql 4.0.20. Now, mysql does not
work if there is too much commas in your queries. So it is possible that
some query used since a very long time in erp5 will be broken very soon.

For example, the query does not work with mysql 4.0.20 :
CREATE TABLE `message` (
`uid` int(11) NOT NULL auto_increment,
PRIMARY KEY (`uid`),
) TYPE = InnoDB;

You need to remove the last comma, so that this query will be fine :

CREATE TABLE `message` (
`uid` int(11) NOT NULL auto_increment,
PRIMARY KEY (`uid`)
) TYPE = InnoDB;


Sebastien.
--
Sebastien ROBIN

About www.nexedi.com

Nexedi is a consulting and development services company helping small and
medium organisations to choose open source / free software and fulfill
their IT application needs. Nexedi is the founder of the ERP5 project, a
Free / Open Source ERP software based on innovative technologies
(www.erp5.org).

About www.storever.com

Storever provides a reliable source for OpenBrick, WiFi infrastructure,
notebooks and servers preconfigured with the GNU/Linux operating system