FUDforum: FUDforum Installation Issues » MySQL Error: #1075 during upgrade to 2.6.15

Home » FUDforum » FUDforum Installation Issues » MySQL Error: #1075 during upgrade to 2.6.15

Show: Today's Messages :: Polls :: Message Navigator

MySQL Error: #1075 during upgrade to 2.6.15 [message #26281]

Tue, 12 July 2005 22:11

keneisman

Messages: 68
Registered: May 2005

Karma: 0

Member

Full error message:
Beginning SQL Upgrades
MySQL Error: #1075 (Incorrect table definition; there can be only one auto column and it must be defined as a key): ALTER TABLE GEMSForum_thread_view CHANGE pos pos INT NOT NULL AUTO_INCREMENT

I've had this error before and you said that it was due to the format of the thread_view table being InnoDB. The table is InnoDB again, this time. However, I've tried changing the table to MyISAM and I've even tried dropping the table. I still get the error message and the re-created thread_view table is InnoDB again Crying or Very Sad

.

Any help would be greatly appreciated.

Ken

Report message to a moderator

Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26283 is a reply to message #26281]

Tue, 12 July 2005 22:21

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Was the table type MyISAM prior to the upgrade?

FUDforum Core Developer

Report message to a moderator

Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26284 is a reply to message #26281]

Tue, 12 July 2005 22:25

keneisman

Messages: 68
Registered: May 2005

Karma: 0

Member

I didn't look specifically before the upgrade. But I seem to remember that it was MyISAM because I remember it standing out against (looking different than) all the other InnoDB tables.

Ken

Report message to a moderator

Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26285 is a reply to message #26281]

Tue, 12 July 2005 22:27

keneisman

Messages: 68
Registered: May 2005

Karma: 0

Member

I just restored my backup database and yes, it was MyISAM prior to the upgrade.

Ken

Report message to a moderator

Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26287 is a reply to message #26285]

Tue, 12 July 2005 22:52

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Make sure that the table does not exist, then apply the following patch to the upgrade script and run this patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7106

FUDforum Core Developer

Report message to a moderator

Previous Topic:	i can't install the forum
Next Topic:	My new problem(error)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 22:17:33 GMT 2025

Total time taken to generate the page: 0.02254 seconds