Did you by any chance remove your usb device without logging it off from the system? The some data might still have been in the cache and not written to the table which might have caused this error.
Anyhow - to access the database I would install PHPMyAdmin on the sever - if you use xampp you most likely have it anyway. If repairing does not help, just drop this table and create it new - I don't think that the ezsession table holds any relevant information.
Thanks, Claudia.
I made a copy of the mysql database.
I dropped ezsession and had still an error concerning ezcontentobject_version. I dropped ezcontentobject_version.
Now I don't get any errormessages from MYSQL, but I still get no access to my site anymore...
I think dropping ezcontentobject_version was a bad idea. The table ezsession holds afaik only session data, thus is is not incredibly important whereas ezcontentobject_version holds permanent data which is important for maintaining the objects. Hopefully I am wrong but I don't think you can recreate this data if the table is so corrupted that it cannot be repaired. What happened when you tried to repair the table? Do you get any error messages at all now?
As Claudia said, dropping ezsession is not much of a problem but dropping ezcontentobject_version was probaly not a good idea so I think your backup might come in handy :)
One easy way to repair your tables, is to use the tools shipped with mysql:
~ # mysqlrepair -A -e -v --auto-repair -p
Issuing this as root will prompt for the root password (-p) of your database instance and then do an extended (-e) check and automagically repair (--auto-repair) of all (-A) tables in the database, verbosley (-v) showing what is happening.
If you don't want to do it from the commandline but have access to phpMyAdmin then you can mark all tables in the database you have trouble with and select 'repair'. This will then do almost the same as above.
...and as always. Don't forget to take backups of all your databases before you do anything of this. :)
Thanks, David. I tried to repair the two tables, using phpadmin.
Having that done, I could access my siteaccess again (admin). However, I could only see the root node of the content tree, all the other content was gone...Behaviour was strange (couldn't access class management).
Perhaps it's better to downgrade to an older backup... Hmmm.... Or still any other ideas?
You must be logged in to post messages in this topic!
