Re: mysql setup issue [message #203 is a reply to message #202] |
Thu, 24 January 2002 07:55 |
hackie
Messages: 177 Registered: January 2002
Karma:
|
Senior Member Core Developer |
|
|
shnikees wrote on Thu, 24 January 2002 1:59 AM | Hey whats up everyone,
I'm having a problem install the FUD board, on step three of the web based installation I'm getting the error
Failed to create table fud_search ( CREATE TABLE fud_search ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, word CHAR(255), UNIQUE(word) ) ), SQL Reason: Column 'word' is used with UNIQUE or INDEX but is not defined as NOT NULL
I cant figure out for the life of me why it cant create the table, any insight would be appreciated
Thanks shnikees
|
You are using an old version of MySQL, it doesn't support NULL indexes, this isn't a problem though.. replace in the installer with the file I attached for you, it should solve this problem.
(do not forget to ungzip the file before copying it over, i.e. $ gzip -d fud_search.tbl.gz )
cc intelligence.c -o intelligence
$ ./intelligence
Segmentation fault
|
|
|