It’s the easiest way to post quoted text to your blog, no matter where you find it on the Web. Just select text to quote, add your comments, then publish it instantly to your blog. It’s that simple!
Here’s a problem we had come across today. Whenever we tried inserting data into a certain table, MySQL kept throwing up the following error:
After scratching our heads over this one, we tried to alter the table to set the autoincrement field to the next number and even that failed to fix the problem. Then hunting around the web, we found the cause of this problem. It seems that Mysql throws this error because the field type of the auto increment field is not large enough to hold the next value, so it tries to wraps the count back to ‘0′ where the is already a record with that value.
We changed the field from int to unsigned bigint which fixed the problem for us. So if you face the same problem, check if your autoincrement field has maxed the datatype for that field.
Jun 2008Note: The final appearance of your post may be different, depending upon your blog’s style sheets.
