MYSQL/PhpMyAdmin problem

Hello all,

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
STR: `
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

SQL-query :

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

MySQL said:


Unknown column 'time_per_entr' in 'where clause'

Thanks for any input!

Ok, I can't believe out of all the people out there no one has used php/mysql in a proffesional environment, or has had any corruption type problems. Someone has got to know something, or everyone is a newbie on this forum.

I'm definatly having corruption type problems, such as column names will magically have a space in front of it all of a suddden, or a query comes up empty even though it comes back successful.

Please, if anyone has dealt with any corrption issues with mysql, please respond.