I had an extra , in schema.sql in the CREATE TABLE discussions stuff... much annoying. There are still errors in the schema, I'm working to track them down so I can get this to install. Yay 2.2.2 =/
I am not sure what you're referring to offhand. Please submit bug reports, with patches if you have them, and we'll take care of it for the next release if appropriate.
Install on 2.2.2 breaks, period. Please provide us a workaround at least. See the trace below
[SNIP]
What is the email address of the account? [slash@eyemax.pif.net]
DBD::mysql::db do failed: You have an error in your SQL syntax near ') TYPE = myisam' at line 1 at bin/install-slashsite line 341.
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 discussions ( id mediumint UNSIGNED NOT NULL auto_increment, sid char(16) DEFAULT '' NOT NULL, title varchar(128) NOT NULL, url varchar(255) NOT NULL, topic smallint UNSIGNED NOT NULL, ts datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, type enum("open","recycle","archived") DEFAULT 'open' NOT NULL, uid mediumint UNSIGNED NOT NULL, commentcount smallint UNSIGNED DEFAULT '0' NOT NULL, flags enum("ok","delete","dirty") DEFAULT 'ok' NOT NULL, section varchar(30) NOT NULL, KEY (sid), FOREIGN KEY (sid) REFERENCES stories(sid), FOREIGN KEY (uid) REFERENCES users(uid), FOREIGN KEY (topic) REFERENCES topics(tid), INDEX (type,uid,ts),) TYPE = myisam
eyemax:/usr/local/slash # mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 3.23.33-log
mysql> exit
Bye
eyemax:/usr/local/slash # uname -a
Linux eyemax 2.4.2 #1 Mon Mar 12 12:22:18 GMT 2001 ppc unknown
Ok... This has worked for me (I mean it installs now, nothing more) :
slash@eyemax:~/slash-2.2.2/sql/mysql > diff -Bu slashschema_create.sql.ORIG slashschema_create.sql
--- slashschema_create.sql.ORIG Sat Jan 5 13:15:11 2002
+++ slashschema_create.sql Sat Jan 5 13:16:57 2002
@@ -240,6 +240,8 @@
FOREIGN KEY (uid) REFERENCES users(uid),
FOREIGN KEY (topic) REFERENCES topics(tid),
INDEX (type,uid,ts),
+ KEY (sid),
+ PRIMARY KEY (id)
) TYPE = myisam;
broken stuff in the install (Score:1)
Re:broken stuff in the install (Score:2)
Next release, are you sure ?! (Score:2)
[SNIP]
What is the email address of the account? [slash@eyemax.pif.net]
DBD::mysql::db do failed: You have an error in your SQL syntax near ') TYPE = myisam' at line 1 at bin/install-slashsite line 341.
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 discussions ( id mediumint UNSIGNED NOT NULL auto_increment, sid char(16) DEFAULT '' NOT NULL, title varchar(128) NOT NULL, url varchar(255) NOT NULL, topic smallint UNSIGNED NOT NULL, ts datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, type enum("open","recycle","archived") DEFAULT 'open' NOT NULL, uid mediumint UNSIGNED NOT NULL, commentcount smallint UNSIGNED DEFAULT '0' NOT NULL, flags enum("ok","delete","dirty") DEFAULT 'ok' NOT NULL, section varchar(30) NOT NULL, KEY (sid), FOREIGN KEY (sid) REFERENCES stories(sid), FOREIGN KEY (uid) REFERENCES users(uid), FOREIGN KEY (topic) REFERENCES topics(tid), INDEX (type,uid,ts),) TYPE = myisam
eyemax:/usr/local/slash # mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 3.23.33-log
mysql> exit
Bye
eyemax:/usr/local/slash # uname -a
Linux eyemax 2.4.2 #1 Mon Mar 12 12:22:18 GMT 2001 ppc unknown
Thanks!
Parent
Re:Next release, are you sure ?! (Score:3, Informative)
Re:Next release, are you sure ?! (Score:2)
slash@eyemax:~/slash-2.2.2/sql/mysql > diff -Bu slashschema_create.sql.ORIG slashschema_create.sql
--- slashschema_create.sql.ORIG Sat Jan 5 13:15:11 2002
+++ slashschema_create.sql Sat Jan 5 13:16:57 2002
@@ -240,6 +240,8 @@
FOREIGN KEY (uid) REFERENCES users(uid),
FOREIGN KEY (topic) REFERENCES topics(tid),
INDEX (type,uid,ts),
+ KEY (sid),
+ PRIMARY KEY (id)
) TYPE = myisam;