[Slashcode-general] Any mysql users out there?

[Marc G. F. <sc...@hu...>]

Okay, got a problem loading the data ... one table doesn't seem to want to 
create, and I don't know enough about MySQL to see the bug in this TABLE 
schema:

  You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near '' at line 
19 -- CREATE TABLE firehose_view(
         id mediumint(8) unsigned NOT NULL auto_increment,
         uid MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
         viewname VARCHAR(24) NOT NULL DEFAULT 'unnamed',
         useparentfilter ENUM("no","yes") DEFAULT "yes",
         tab_display ENUM("no","yes") DEFAULT "no",
         options_edit ENUM("no","yes") DEFAULT "no",
         admin_maxitems tinyint NOT NULL DEFAULT -1,
         maxitems tinyint NOT NULL DEFAULT -1,
         seclev mediumint UNSIGNED NOT NULL DEFAULT '0',

         filter VARCHAR(255) NOT NULL DEFAULT '',
         orderby ENUM("popularity","createtime", "editorpop", "activity", 
"neediness", "") DEFAULT "createtime",
         orderdir ENUM("ASC", "DESC", "") DEFAULT "DESC",
         color VARCHAR(16) NOT NULL DEFAULT '',
         duration ENUM("7","-1","") DEFAULT '',
         mode ENUM ("full","fulltitle", "") DEFAULT "",
         mixedmode ENUM("1","0","") DEFAULT "",
         pause ENUM("1","0","") DEFAULT ""

Anyone?

----
Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
sc...@hu...                                     http://www.hub.org

Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:sc...@hu...