April 14th, 2004, 04:11 PM
Join Date: Feb 2004
Time spent in forums: 4 Days 5 h 2 m 4 sec
Reputation Power: 10
I'm having this problem with my databases. When I try to edit a row in phpmyadmin, it will give me a query error saying unclosed quote or something, and looking at the query I see that it is incomplete. Part of it will be just chopped off. Sometimes it will give me a query error of unknown column, and I can plainly see that it chopped the query right in the middle of the offending column name.
I've fixed this on another table in the past by giving the table a different name and rebuilding the table, but now its hitting more important databases. My experience leads me to believe that its a hard drive problem, but countless scandisks, and hd tests all come back ok.
Just want to see if anyone else can confirm a possible hardware issue, or if there is something else going on that might look like a hardware issue but isn't.
Here is the actual message when clicking the edit button for a row in MyPhpAdmin:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unclosed quote @ 812
SQL: SELECT * FROM `blah` WHERE `blah2` = '46474' AND `blah3` = '16:38' AND `blah4` = '2004-04-13' AND `blah5` = 'kjhgkjhg' AND `blah6` LIKE 0x506c6561736520726561737369676e20 AND `blah7` = '33775' AND `time_per_entr <- This should actually be time_per_entry
SELECT * FROM `blah` WHERE `blah2` = '46474' AND `blah3` = '16:38' AND `blah4` = '2004-04-13' AND `blah5` = 'kjhgkjhg' AND `blah6` LIKE 0x506c6561736520726561737369676e20 AND `blah7` = '33775' AND `time_per_entr <- This should actually be time_per_entry
Unknown column 'time_per_entr' in 'where clause'
Thanks for any input!
Last edited by edacsac : April 14th, 2004 at 04:16 PM.