trouble with demokernel.sql

Author Message

Douglas Holt

Monday 31 March 2003 10:41:42 pm

just downloaded and attempting to install ezpublish-3.0-1 on a hosted 'nix server and get this error when I use phpMyAdmin to populate the ezpublish db that I created. This is the error.

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

Ekkehard Dörre

Tuesday 01 April 2003 2:46:30 am

There is a problem with the dump for phpmyadmin, go inside the sql-file with a text editor and remove all comments by hand:
--
-- Dumping data for table 'ezapprove_items'
--

then it works. But just search and replace -- with ## causes problems, because sometimes there are -- in the tables.

Greetings ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

Douglas Holt

Sunday 06 April 2003 8:47:33 pm

rather than editing my incorrect file by hand I would like someone to post or send me the corrected demokernel.sql file. I shouldn't have to fix this myself to try this CMS that I have heard so many good things about. Can someone point me to a corrected version of demokernel.sql?

Ekkehard Dörre

Sunday 11 May 2003 2:09:20 am

Here it is:

http://ez.no/developer/ez_publish_3/contributions/ez_302_demokernelsql_for_phpmyadmin

Greetings ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.