| Error in Step 2 on Installation [message #20479] |
Sat, 16 October 2004 04:13  |
Bugblndr
Messages: 6
Registered: October 2004
Karma: 0
|
Junior Member |
|
|
I'm running a Windows 2003 Server, PHP 4.3.9, MySQL 4.1.5 and attempting to install Fudforum for the first time.
Step 2 is failing and I'm getting the error message:
Failed to create table "fud_thread_view" ("ALTER TABLE fud26_thread_view CHANGE pos pos INT NOT NULL AUTO_INCREMENT"), SQL Reason: Incorrect table definition; there can be only one auto column and it must be defined as a key
Any ideas on what's causing this?
|
|
|
|
|
|
|
|
| Re: Error in Step 2 on Installation [message #20496 is a reply to message #20489] |
Sun, 17 October 2004 17:46  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Try executing the following query followed by the query that has failed and let me know what are the results.
CREATE UNIQUE INDEX fud26_idx_test ON fud26_thread_view (pos, page, forum_id);
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Error in Step 2 on Installation [message #20593 is a reply to message #20582] |
Wed, 20 October 2004 13:11 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
No no, the new query should show the table's indexes, the one we've ran before showed the table fields.
The fix I've implemented was to add another index that according to your comments (queries we've tested) should've solved the problem.
FUDforum Core Developer
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]