By gymosphere on

I get these messages:

Warning: Got error 127 from storage engine query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /home/blogfeas/public_html/includes/database.mysql.inc on line 120

Warning: Got error 127 from storage engine query: UPDATE cache SET data = 'a:342:{s:13:\"theme_default\";s:10:\"pushbutton\";s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:19:\"file_directory_temp\";s:4:\"/tmp\";s:18:\"default_nodes_main\";s:2:\"15\";s:13:\"teaser_length\";s:3:\"200\";s:12:\"node_preview\";s:1:\"0\";s:4:\"wipe\";s:13:\"Re-index site\";s:17:\"search_cron_limit\";s:3:\"100\";s:17:\"minimum_word_size\";s:1:\"3\";s:11:\"overlap_cjk\";i:1;s:19:\"node_rank_relevance\";s:1:\"6\";s:16:\"node_rank_recent\";s:1:\"4\";s:18:\"node_rank_comments\";s:1:\"5\";s:36:\"googleanalytics_track_anonymous user\";i:1;s:40:\"googleanalytics_track_authenticated user\";i:1;s:23:\"googleanalytics_account\";s:11:\"UA-413469-6\";s:26 in /home/blogfeas/public_html/includes/database.mysql.inc on line 120

Warning: Cannot modify header information - headers already sent by (output started at /home/blogfeas/public_html/includes/database.mysql.inc:120) in /home/blogfeas/public_html/includes/bootstrap.inc on line 550

Warning: Cannot modify header information - headers already sent by (output started at /home/blogfeas/public_html/includes/database.mysql.inc:120) in /home/blogfeas/public_html/includes/bootstrap.inc on line 551

Warning: Cannot modify header information - headers already sent by (output started at /home/blogfeas/public_html/includes/database.mysql.inc:120) in /home/blogfeas/public_html/includes/bootstrap.inc on line 552

Warning: Cannot modify header information - headers already sent by (output started at /home/blogfeas/public_html/includes/database.mysql.inc:120) in /home/blogfeas/public_html/includes/bootstrap.inc on line 553

Warning: Cannot modify header information - headers already sent by (output started at /home/blogfeas/public_html/includes/database.mysql.inc:120) in /home/blogfeas/public_html/includes/bootstrap.inc on line 554

What should I do?
Please help.

⋅ Categories: Drupal 4.7.x

Comments

Roberto Gerola’s picture

Roberto Gerola commented

Try to empty your cache table.
It seems a table corruption error.

--
http://www.speedtech.it

gymosphere’s picture

gymosphere commented

Can you please teach me how to empty the cache table?

Thanks!

Roberto Gerola’s picture

Roberto Gerola commented

You can use PHPMyAdmin if it is installed on your server.

---
http://www.speedtech.it

sin’s picture

sin commented

REPAIR TABLE cache;
DELETE FROM cache;

To run them use mysql client from command line, PHPMyAdmin or just create and visit a 'page' in Drupal with filter 'PHP' and code:

  db_query('REPAIR TABLE cache');
  db_query('DELETE FROM cache');
gymosphere’s picture

gymosphere commented

1. I cannot access my site.
2. PHPMyAdmin does not seem to execute the query when I put the query into it.
3. I created a php page with

<?php
  db_query('REPAIR TABLE cache');
  db_query('DELETE FROM cache');
?>

and uploaded it, it does not load.

Anyone has any idea how to get around this? Is there a SQL software which I can connect to the database and run the repair and delete query?

Thanks

thorney’s picture

thorney commented

You can download this SQL client for free:

SQLYog Community Edition
http://www.webyog.com/en/downloads.php

Quick install. You'll need to have your SQL host address, username & password for the db, obviously?

gymosphere’s picture

gymosphere commented

I made a php page and uploaded it, I was unable to run it, but now, I can run it, but I get this error:

Fatal error: Call to undefined function: db_query() in /home/blogfeas/public_html/ClearCache.php on line 2

The php file contains only the code:

<?php
  db_query('REPAIR TABLE cache');
  db_query('DELETE FROM cache');
?>

Did I miss anything? Please help, thanks!

gymosphere’s picture

gymosphere commented

I finally got all the problems solved. Yes, the databases need some repairs. The cache needs to be emptied.

Thanks again! You guys are marvelous!