I now have two tables in my mysql database that have bitten the dust. The error I get from phpMyAdmin is:
Warning: MySQL: Unable to save result set in /my/pathto/phpMyAdmin/sql.php3 on line 53
Warning: MySQL: Unable to save result set in /my/pathto/phpMyAdmin/sql.php3 on line 57
Database mydatabase - table TABLENAME
Error
MySQL said: Got error 134 from table handler
Fortunately, I had the data elsewhere and I was able to recreate the table by copying the CREATE TABLE statement (I was able to view the structure, not the data). So I just made a new table.
I do not have many privileges on this particular server so I am trying to educate myself on what to do and what to look at to figure out the problem so that I can ask an effective question and make rational requests of the db admins on that server.
Could this sort of thing happen because of a singlequote or something making its way into the table? I mean is the problem most likely a flaw in my program I wrote for inserting data, perhaps not sufficient filtering, or is this problem indicative of some deeper issue having to do with the way mysql is installed?
Is isamchk the application the dbadmin would use to check the tables?
Mainly I wish to learn what went wrong and how to avoid this in the future.
Thanks,
Peggy
Warning: MySQL: Unable to save result set in /my/pathto/phpMyAdmin/sql.php3 on line 53
Warning: MySQL: Unable to save result set in /my/pathto/phpMyAdmin/sql.php3 on line 57
Database mydatabase - table TABLENAME
Error
MySQL said: Got error 134 from table handler
Fortunately, I had the data elsewhere and I was able to recreate the table by copying the CREATE TABLE statement (I was able to view the structure, not the data). So I just made a new table.
I do not have many privileges on this particular server so I am trying to educate myself on what to do and what to look at to figure out the problem so that I can ask an effective question and make rational requests of the db admins on that server.
Could this sort of thing happen because of a singlequote or something making its way into the table? I mean is the problem most likely a flaw in my program I wrote for inserting data, perhaps not sufficient filtering, or is this problem indicative of some deeper issue having to do with the way mysql is installed?
Is isamchk the application the dbadmin would use to check the tables?
Mainly I wish to learn what went wrong and how to avoid this in the future.
Thanks,
Peggy