dougnyc Posted December 5, 2002 Share Posted December 5, 2002 This is what I get when I try loading my site: Warning: open(/tmp/sess_2020eb9f0190036b21c72bba970e0d7e, O_RDWR) failed: m (69) in /usr/local/etc/httpd/vhosts/www.quickzaps.com/htdocs/catalog/includes/functions/sessions.php on line 67 1016 - Can't open file: 'whos_online.MYD'. (errno: 145) delete from whos_online where time_last_click < '1039112229' [TEP STOP] It has happened before and the solution was to run "repair table customers" in mysql. Now when I do that I get this: SQL-query SQL-query?:?[Edit] repair table customers Table Op Msg_type Msg_text quickzaps.customers repair error 69 when fixing table quickzaps.customers repair status When I view that database in PHPMYADMIN I can see that it's "in use" and I can't repair it with "repair table customers". The two tables that are in use are customers and address_book. What can I do to repair these tables? Link to comment Share on other sites More sharing options...
dougnyc Posted December 5, 2002 Author Share Posted December 5, 2002 Table Op Msg_type Msg_text quickzaps.customers check warning Table is marked as crashed and last repair failed quickzaps.customers check warning Size of indexfile is: 6144 Should be: 4096 quickzaps.customers check error Can't read indexpage from filepos: -1 quickzaps.customers check error Corrupt How can I repair the table when the repair command fails? Link to comment Share on other sites More sharing options...
burt Posted December 5, 2002 Share Posted December 5, 2002 Surely you have a full backup of your database, if not :oops: Remove all of the tables fully, and then re-install your from your backup. Should take no more downtime than a few minutes using PHPMyAdmin. If you don't have a backup, then you are in trouble. Try www.mysql.org Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.