10/1/10
Friday 12:49am
Date Posted: 10/1/10
K, I got some of it figured out. Apparently you can't insert a value of 0 into a table in which the column has the auto increment value set. This can be altered if I had administration rights, but I do not. You can read about it here: How AUTO_INCREMENT behaves depending on the SQL mode: Section 5.1.6, "Server SQL Modes".
The simple solution to this is to turn off auto increment for that table and use a code snippet that I am currently updating to insert your row at the correct location. The "correct location" being the row that auto increment would assign it to if it were behaving as it should.
It is late. I'll have to work on this some more later.
TAGS: none
All Memo Tags
allegory 1, anime 1, article 6, audio 2, books 3, bug 19, code 1, commercial 1, computer 15, election 2, ereader 5, fixed 11, games 24, hard to remember 1, history 1, keyboard shortcuts 1, links 3, memo blog 1, mini-review 10, moving 2, music 1, mysql 1, news 31, none 1843, opera 69, politics 9, private 15, quotes 1, reformat hard drive 19, sgopc 1, site update 15, site version 205, sleep 3, star wars 2, story 4, swtor 1, texas 1, video 5, website 22, windows 10 1, wishlist 3