[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