| SQL error when upgrading with CVS in eGW [message #21517] |
Thu, 02 December 2004 13:25  |
espen
Messages: 4
Registered: December 2004
Location: Norway
Karma: 0
|
Junior Member |
|
|
Hi, i tried to upgrade fudforum for eGW, becouse i got a lot of errors when using the forum. First i did a update source after a CVS the files, and no improvements, than i did a uninstall/install and got the folowing error when installing.
Database error: Invalid SQL: ALTER TABLE phpgw_fud_thread_view CHANGE pos pos INT NOT NULL AUTO_INCREMENT
mysql Error: 1075 (Incorrect table definition; there can be only one auto column and it must be defined as a key)
anny ideas? I've included the debug and system info dump as text files.
-Espen-
|
|
|
|
|
|
|
|
| Re: SQL error when upgrading with CVS in eGW [message #21526 is a reply to message #21524] |
Thu, 02 December 2004 14:54  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Which version of MySQL 4.1?
MySQL 4.1.5 for example has a bug that causes the query you've demonstrated to fail. In 4.1.6+ you need to make sure MyISAM and not InnoDB tables are being used.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]