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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
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 18:11 Go to next message
keneisman is currently offline  keneisman   United States
Messages: 68
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
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
Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26283 is a reply to message #26281] Tue, 12 July 2005 18: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
add to buddy list
ignore all messages by this user
Was the table type MyISAM prior to the upgrade?

FUDforum Core Developer
Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26284 is a reply to message #26281] Tue, 12 July 2005 18:25 Go to previous messageGo to next message
keneisman is currently offline  keneisman   United States
Messages: 68
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
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
Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26285 is a reply to message #26281] Tue, 12 July 2005 18:27 Go to previous messageGo to next message
keneisman is currently offline  keneisman   United States
Messages: 68
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
I just restored my backup database and yes, it was MyISAM prior to the upgrade.

Ken
Re: MySQL Error: #1075 during upgrade to 2.6.15 [message #26287 is a reply to message #26285] Tue, 12 July 2005 18:52 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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 Oct 24 00:12:30 EDT 2017

Total time taken to generate the page: 0.00671 seconds