Inserting updating and deleting data to mysql through php
If there is one around the corner, you'll get it free, without having to ask.
(But you can keep the old version if you prefer.) If you ever hit a snag with Regex Buddy, check here whether you have the latest version.
I'm seeing this same problem occuring on a 5.0.51a My SQL Inno DB table. Then delete the records entered, reset the attributes back to int and auto increment. From my experience as DBA I guess either the analyze table or the optimize table does the trick since it is related to indexes.
I'll ask my database admin to rebuild the table as you described. Reloading DB will not a viable solution for production DB (Some tables contains millions of rows). Rgds Joe I am seeing an error like this every now and then in the logs Sql Exception Helper:144 - Duplicate entry '1449-8798' for key 'PRIMARY' But when I do a dump of the database I can't find the key '1449-8798' at all I just did a full repair on the table with My SQL administrator and problem fixed. Tells me that for some reason the row count value got corrupt.
When the Button is clicked, the Insert function of the Sql Data Source is executed which then inserts the records to the database and binds the Grid View again to display the newly inserted record.
Dropping all tables and reloading them from a backup. Unchecked auto increment, change int to varchar save the changes.