I am presented with this Error when trying to install the mySQL database... PLease Help

Wednesday 28 May 2003 10:06:49 am

I am presented with this Error when trying to install the mySQL database... Please Help

============================================================

Error

SQL-query :

--
---------------------------------------------------------
--
--

CREATE TABLE ezapprove_items (
id int(11) NOT NULL auto_increment,
workflow_process_id int(11) NOT NULL default '0',
collaboration_id int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM

MySQL said:

You have an error in your SQL syntax near '---------------------------------------------------------
--
--

CREATE TABLE ez' at line 2

Thursday 19 June 2003 9:18:56 am

Looks like a problem with the kernel_schema.sql with this release, try adding an ; to the end of the CREATE TABLE command.

It looks like its been fixed in svn.

It should look like the below i guess

CREATE TABLE ezapprove_items (
id int(11) NOT NULL auto_increment,
workflow_process_id int(11) NOT NULL default '0',
collaboration_id int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future