|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
I have no other issues, just an issue with this one individual. Here is the error message, how do I fix this for one person, and anyone know why it happened?
[]Script: /medar/ubbt.inc.php Line#: 1611 SQL Error: Incorrect key file for table: 'w3t_Users'. Try to repair it SQL Error #: 1034 Query: UPDATE w3t_Users SET U_SessionId = 'a401bed218424c069af5121745e2c46f', U_LastOn = '1096377068' WHERE U_Number = '7' [/]
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
well you need to repair the whole table.. that error pops up sometimes when the table is corrupted.. do a
repair w3t_Users
from any sql command window
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
OK, did that, just was not sure if there was a pending bug or anything like that.
Thank ya.
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
OK, more issues.
#1034 - Incorrect key file for table: 'w3t_Users'. Try to repair it
AND
Repair error: The handler for the table doesn't support repair
It did not fix this one guy...so still trying to get this one piece of my Users table fixed.
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
OK, I updated my w3t_Users table from ISAM to MyISAM, and then repaired and fixed this issue.
Question - should we even have any ISAM tables left for UBB.Threads, or should they all be converted to MyISAM?
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
all the threads tables should be MyISAM by default.
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
Yap, just finished! Found an old thread by Pappy at UBBCentral where you and he discussed this.
I think my old install just finally caught up with me.
Thanks all.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|