FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » MySQL Error: #1075 during upgrade to 2.6.15
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
icon11.gif  MySQL Error: #1075 during upgrade to 2.6.15 [message #26281] Tue, 12 July 2005 22:11 Go to next message
keneisman is currently offline  keneisman   United States
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 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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 Go to previous messageGo to next message
keneisman is currently offline  keneisman   United States
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 Go to previous messageGo to next message
keneisman is currently offline  keneisman   United States
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 Go to previous message
Ilia is currently offline  Ilia   Canada
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

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: i can't install the forum
Next Topic: My new problem(error)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 18 05:25:47 GMT 2024

Total time taken to generate the page: 0.02322 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software