Stories
Slash Boxes
Comments

Slash Open Source Project

This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login
Loading... please wait.
  • 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.
      • by mo´se (676) on Saturday January 05 2002, @07:00AM (#3918) Homepage Journal
        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

        Thanks!
        • Again, please file a bug report [sourceforge.net]. That is how we can make sure things get the attention they need.
          • 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;