hey all, new here and certainly no SQL wiz so I could use a little help. please bepatient with me.


2 of the tables in my DB have crashed and the REPAIR TABLE [tablename] QUICK failed so I need to go from there and find the right way (and safest way) to repair the table with no or little data loss. Hope someone can help.

When I run the CHECK, I get this:


infusion_vbb.post check warning Table is marked as crashed and last repair failed
infusion_vbb.post check warning Size of indexfile is: 204800 Should be: 23552
infusion_vbb.post check error Size of datafile is: 1708032 Should be: 1708132
infusion_vbb.post check error Corrupt


and the repair attempt gives me this:

infusion_vbb.post repair info Found block that points outside data file at 1707732
infusion_vbb.post repair error 122 when writing to datafile
infusion_vbb.post repair error 122 when writing to datafile
infusion_vbb.post repair status Operation failed


Found error 122 listed as:

Error 122: A SELECT STATEMENT WITH NO GROUP BY CLAUSE CONTAINS A COLUMN NAME AND A COLUMN
FUNCTION IN THE SELECT CLAUSE OR A COLUMN NAME IS CONTAINED IN THE SELECT CLAUSE BUT NOT IN THE GROUP BY CLAUSE


Because of this, my entire forum is completely down and it's driving me mad. Anyone able to assist me at all? TIA