By norseman on

When trying to install the tables (version 4.1), I get the following error (there seems to be something wrong with the sql file):
SQL-query :

* - * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - * - * - CREATE TABLE access(

aid tinyint( 10 ) NOT NULL auto_increment,
mask varchar( 255 ) NOT NULL default '',
type varchar( 255 ) NOT NULL default '',
status tinyint( 2 ) NOT NULL default '0',
PRIMARY KEY ( aid ) ,
UNIQUE KEY mask( mask )
) TYPE = MyISAM

MySQL said:

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

CREATE TABLE ac' at line 2

I have tried using the 4.0 file, and it works, but gives errors in Drupal.

Thanks for your help!

Comments

ax’s picture

ax commented

here: the 4.1.0 fix doesn't fix the problem that phpMyAdmin cannot import
the install database because of the bad "---" comment in line 4. you may consider changing it to "--<space>--..." or use something different than mysqldump (which generates the "---") to generate the database file. see href="http://www.mysql.com/doc/en/ANSI_diff_comments.html">http://www.mysql.com/doc/en/ANSI_diff_comments.html

dries: see what i mean? feel like fixing?