| 2.3.5 installation step 2 and MySQL error [message #8025] |
Tue, 07 January 2003 11:24  |
boortz
Messages: 3
Registered: January 2003
Karma: 0
|
Junior Member |
|
|
My ISP runs MySQL 3.23.54-Max-log and I get this error on step 2
of the installation
Failed to create table fud_thread_view.tbl (CREATE TABLE forum_thread_view ( forum_id INT UNSIGNED NOT NULL, page INT UNSIGNED NOT NULL, thread_id INT UNSIGNED NOT NULL, pos INT UNSIGNED NOT NULL AUTO_INCREMENT, tmp INT UNSIGNED, UNIQUE(forum_id, page, pos), INDEX(forum_id, thread_id) )), SQL Reason: Incorrect table definition; There can only be one auto column and it must be defined as a key
Any ideas how I get around this?
kent
|
|
|
|
| Re: 2.3.5 installation step 2 and MySQL error [message #8026 is a reply to message #8025] |
Tue, 07 January 2003 12:33  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I've tried installing FUDforum using MySQL 3.23.54 and had no encountered the problem you've described. Are you running MySQL that you had compiled yourself or are you using binaries from MySQL's website?
FUDforum Core Developer
|
|
|
|
|
|
| Re: 2.3.5 installation step 2 and MySQL error [message #8029 is a reply to message #8028] |
Tue, 07 January 2003 17:06 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Given that this is a MySQL problem particular to innodb table type this is not something forum the forum to solve. I am surprised that you cannot create regular ISAM and MyISAM tables, perphaps if you tell MySQL to specifically create the table as ISAM it would work?
FUDforum Core Developer
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]