Strange MySQL behavior
Posted on 2014-01-11
I have a table called BridgeResponse for poll-type answers of questions.
Field Type Null Key
ResponseID int(10) NO PRI auto_increment
QuestionID tinyint(4) YES MUL
Ordered tinyint(4) YES
AnswerText varchar(256) YES
AnswerCount tinyint(4) YES
Suddenly, my INSERTs of new answers are going to the wrong question id.
The table data looked like this when the problem started.
452 126 1 Very Good 0
453 126 2 Good 0
454 126 3 Fair 0
455 126 4 Poor 0
456 127 1 Very Good 0
Now suddenly every insert insists on using QuestionID 127.
INSERT INTO BridgeResponse Values('',128,1,'Test',0)
467 127 1 Test 0
and another try
INSERT INTO BridgeResponse Values('',128,2,'Test2',0)
468 127 2 Test2 0
This is happening exactly the same in my phpmyadmin program and in the php script that is supposed to add these new answers. I echoed out the $questionid from the php script and it was correct before and after the mysql_query insert, so it has to be the database itself, not the code.
Any idea what might be happening here?