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

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

Tried the change ... no difference ... :(

On Sat, 26 Sep 2009, gnul wrote:

> 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
>

----
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...