Hi all,
/sql/mysql/schema.sql has 2 CREATE TABLE statements with extra comments at the end of the sql, returns an error on install. story_text and metamodlog are the 2 statements.
DROP TABLE IF EXISTS metamodlog;
CREATE TABLE metamodlog (
id mediumint UNSIGNED NOT NULL AUTO_INCREMENT,
mmid int UNSIGNED DEFAULT '0' NOT NULL,
uid mediumint UNSIGNED DEFAULT '0' NOT NULL,
val tinyint DEFAULT '0' NOT NULL,
ts datetime,
active tinyint DEFAULT '1' NOT NULL,
INDEX byuser (uid),
INDEX mmid (mmid),
PRIMARY KEY (id) <--- comma was right here
) TYPE=InnoDB;
DROP TABLE IF EXISTS story_text;
CREATE TABLE story_text (
sid char(16) NOT NULL,
introtext text,
bodytext text,
relatedtext text,
rendered text,
PRIMARY KEY (sid) <--- comma was right here
) TYPE=MyISAM;
DBD::mysql::db do failed: You have an error in your SQL syntax near ') TYPE=InnoDB' at line 1 at ./install-slashsite line 387.
The CREATE TABLE command below failed. This almost certainly means
the rest of the slashsite installation will fail, so we're aborting.
This is probably because your SQL user associated with your
DBIx::Password user 'slash' lacks CREATE and/or DROP permissions.
Fix this, or whatever the problem is, and rerun install-slashsite.
Failed command: CREATE TABLE metamodlog ( id mediumint UNSIGNED NOT NULL AUTO_INCREMENT, mmid int UNSIGNED DEFAULT '0' NOT NULL, uid mediumint UNSIGNED DEFAULT '0' NOT NULL, val tinyint DEFAULT '0' NOT NULL, ts datetime, active tinyint DEFAULT '1' NOT NULL, INDEX byuser (uid), INDEX mmid (mmid), PRIMARY KEY (id),) TYPE=InnoDB
|