The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.
By JamesKB on
I tried to go to my site ( www.demo.jkbsystesms.com ) today and received massive errors. I have included just a few of them below:
Warning: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '723c84d55241235c10e09bd84f445b90' in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: Can't open file: 'cache.MYI'. (errno: 138) query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) query: SELECT * FROM variable in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: Can't open file: 'cache.MYI'. (errno: 138) query: LOCK TABLES cache WRITE in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: Can't open file: 'cache.MYI'. (errno: 138) query: UPDATE cache SET data = 'N;', created = 1174925224, expire = 0, headers = '' WHERE cid = 'variables' in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: Can't open file: 'cache_page.MYI'. (errno: 138) query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://www.demo.jkbsystems.com/' in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) query: SELECT COUNT(pid) FROM url_alias in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: Can't open file: 'system.MYI'. (errno: 138) query: SELECT * FROM system WHERE type = 'theme' in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
Warning: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Can&#039;t open file: &#039;system.MYI&#039;. (errno: 138)\nquery: SELECT name, filename, throttle, bootstrap FROM system WHERE type = &#039;module&#039; AND status = 1 ORDER BY weight ASC, filename ASC</em> in <em>/home/jkbsyste/public_html/demo/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.demo.jkbsystems.com/', '', '72.154.230.201', 1174925224) in /home/jkbsyste/public_html/demo/includes/database.mysql.inc on line 172
There is considerable more but this should give you an idea. It was working just fine last night ( 25 Mar 07 ).
HELP!! :) Anyhone have any ideas?????
Thanks for your time.
Comments
MySQL Errors
James,
(Un)fortunately, this is not a problem with drupal. The errors you have pasted indicate a problem with your MySQL server. Contact your host or system administrator and tell them that you have a critical error.
Outcome3
Database messed up :(
HiYa Lyal,
Yeppers, it is indeed a corrupted mySQL database, and guess what? My backup on the server and my local machine is also corrupte!!! :( :( It must have become corrupted between the last time I accessed and when the backups where made.
OH BOY!!! I'm so happy!
BTY - Is there a way to edit or delete my original message from this thread??? HUH HUH is there??
:)
Have a good day.
--
James
How did you repair or fix
How did you repair or fix this issue?
I am having the same problem and the table 'cache_page' is showing as 'in use' and I cannot get to it at all.
I didn't fix it. It was a
I didn't fix it. It was a test site so I just scraped the db and started over. All is well now.
Have a good day.
--
James
can you create a backup of
can you create a backup of the database as a SQL file?
If so, modify the resulting backup and restore it. You'll want to be careful and unless you know SQL and understand the data relationships, you'll probably corrupt your DB. So make a copy first. And your pretty safe clearing out the cache and session tables.