[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?

 >If so, might the auto increment have "run out" (i.e. might the last  
 >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  
 >than you anticipated.
It is incrementing one at a time.

 >What information was on the page that pointed you to the repair  
 >(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.

                            * * * * * * * * * * * * * * * *
                                my online portfolio


More information about the thelist mailing list