[thelist] broken mysql table
Garth Hagerman
hagerman at mcn.org
Wed Nov 21 15:19:33 CST 2007
>How long has the site been running?
About three years.
>Do you delete the cart after the sale?
No.
>If so, might the auto increment have "run out" (i.e. might the last
cart
>have had a cartId of 2,147,483,647?)
There are 36794 records in that table. The auto increment primary key
in an int(11).
>If that sounds unfeasible take a look at the auto_increment_offset
>server variable - if it's not 1 the cartId may have been growing
faster
>than you anticipated.
It is incrementing one at a time.
>What information was on the page that pointed you to the repair
function
>(i.e. what did it say it was actually repairing, or did it just say it
>made the error "go away") ?
The article was very specific about what to do, but had no info about
what was going on "under the hood". Someone had anonymously submitted
a problem similar to mine. The reply was: "Try to repair this table.
Click on the db name in the left pane, tick the checkbox besides this
table in the right pane, then choose Repair in the drop-down." I
followed those instructions, and phpmyadmin gave a generic message
something like "table repaired successfully", but no info about what
was wrong.
Garth
* * * * * * * * * * * * * * * *
my online portfolio
http://garthhagerman.com/
More information about the thelist
mailing list