[Resolved - Not a DataTables issue] - Editor error - not sure what is causing this.
[Resolved - Not a DataTables issue] - Editor error - not sure what is causing this.
boicenet
Posts: 47Questions: 12Answers: 1
I've been using DataTables/Editor for several weeks now. All of a sudden I'm seeing the following error message at the bottom of the Editor screen when attempting to change one data value (dropdown option with only two values - YES or NO). I did not intentionally make any changes to cause this error. I can update other fields with no error. Any ideas on how to track down the cause of this?
SQLSTATE[42000]: Syntax error or access violation: 1172 Result consisted of more than one row
Thank you.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Update: This only occurs when I have multiple unrelated records in the DataTable.
Was a problem with some MySQL Trigger code.