Re: [Slashcode-general] Any mysql users out there?

[gnul <nul...@gm...>]

On Sat, Sep 26, 2009 at 6:01 PM, Marc G. Fournier <sc...@hu...> wrote:
>
> 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?
>

Try this for the first column in the table:
        id mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY,

Also, you need a trailing ')' for the CREATE statement, but you may
have just omitted that in the email.

 -gnul