My Brain is Jello! I desperately hope someone can help me with this problem. One of my Php queries is returning this error for ONLY one of my users when they run the query. For everyone else the query runs fine. This appears to be a MySQL error. Can anyone give me a clue to how to resolve it. Any and all suggestions are much appreciated. Have a Great Day!
arran
6:29 pm on Apr 20, 2005 (gmt 0)
Sounds like you've got some table corruption. Either use 'repair table' or drop and recreate the offending table.
This error probably only happen for one user because your 'where' clause selects a different subset of rows for each user. It just so happens that that this user is selecting one or more corrupt rows.
Shaman13
7:38 pm on Apr 20, 2005 (gmt 0)
Thanks Arran You confirmed my suspicions. Unfortunately the repair table does not seem to solve the problem. Do you think if I duplicate the table and drop the original corrupt table. Then rename the copy to the original name it will work?
arran
8:40 pm on Apr 20, 2005 (gmt 0)
You will probably run into problems when you hit the corrupt row(s). If so, use the where clause to select as much of the table as possible (use several different queries to try and work round the problematic row(s)). Sounds like you will have to write off the corrupt rows. :(
jatar_k
9:20 pm on Apr 20, 2005 (gmt 0)
have you run check table as well? does it now say the table is ok?
