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:

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

[Message index]

		MySQL Error: #1075 during upgrade to 2.6.15 By: keneisman on Tue, 12 July 2005 22:11
		Re: MySQL Error: #1075 during upgrade to 2.6.15 By: Ilia on Tue, 12 July 2005 22:21
		Re: MySQL Error: #1075 during upgrade to 2.6.15 By: keneisman on Tue, 12 July 2005 22:25
		Re: MySQL Error: #1075 during upgrade to 2.6.15 By: keneisman on Tue, 12 July 2005 22:27
		Re: MySQL Error: #1075 during upgrade to 2.6.15 By: Ilia on Tue, 12 July 2005 22:52

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: Wed Nov 27 11:38:18 GMT 2024

Total time taken to generate the page: 0.04006 seconds