Forums / Install & configuration / trouble with demokernel.sql
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
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?
Sunday 11 May 2003 2:09:20 am
Here it is:
http://ez.no/developer/ez_publish_3/contributions/ez_302_demokernelsql_for_phpmyadmin