Some people using a script I wrote have reported an occasional problem where sometimes the mySQL table will report being "in use" and not allow any changes to be made to it. Repairing the table fixes the problem, but any idea why this is happening? Is it the fault of the script? Or something else?
Are you using locking commands? Transactional stuff?
Nope. The only mysql commands I use in conjunction with the tables are INSERT, UPDATE, DELETE, and SELECT. That's it.