[Slashcode-general] MySQL dev's out there ... ?

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

Get this at the final stages of install:

DBD::mysql::db do failed: 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 'KEY uid (uid),) TYPE=InnoDB' at line 1 at 
bin/install-slashsite line 413.


withthe command being:

Failed command: CREATE TABLE preview (  preview_id mediumint UNSIGNED NOT 
NULL auto_increment,  uid mediumint UNSIGNED NOT NULL,        src_fhid 
mediumint UNSIGNED NOT NULL DEFAULT 0, preview_fhid mediumint UNSIGNED NOT 
NULL DEFAULT 0,     title VARCHAR(255) NOT NULL DEFAULT '', introtext text 
NOT NULL,        bodytext text NOT NULL, active ENUM("no","yes") DEFAULT 
"yes",  PRIMARY KEY (preview_id)        KEY uid (uid),) TYPE=InnoDB

Does someone with mysql knowledge know why, and how to fix?

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