hi
i installed this module and after that things went wrong..and then i was not being allowed to disable it in the modules..and hence i used FTP to remove the module files to another folder..but still things are bad...
pls help..and i am also not able to access many portions of the installation..i get access denied..pls sugggest how to resolve this issue.

Warning: Got error 134 from table handler query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /hsphere/local/home/lordkris/spiritualnectar.com/includes/database.mysql.inc on line 172

Warning: Got error 124 from table handler query: UPDATE cache SET data = 'a:826:{s:13:\"theme_default\";s:5:\"fancy\";s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:17:\"menu_primary_menu\";s:1:\"2\";s:19:\"menu_secondary_menu\";s:1:\"2\";s:15:\"install_profile\";s:7:\"default\";s:17:\"node_options_page\";a:1:{i:0;s:6:\"status\";}s:12:\"comment_page\";s:1:\"2\";s:18:\"drupal_private_key\";s:64:\"787d24e2930300daf5d2105f6b958c2e5d02409288bed77fb416fe37838ad6a0\";s:19:\"file_directory_temp\";s:4:\"/tmp\";s:19:\"file_directory_path\";s:5:\"files\";s:14:\"file_downloads\";s:1:\"1\";s:9:\"cron_last\";i:1176625329;s:9:\"clean_url\";s:1:\"1\";s:21:\"date_default_timezone\";s:5:\"19800\";s:22:\"configurable in /hsphere/local/home/lordkris/spiritualnectar.com/includes/database.mysql.inc on line 172

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/lordkris/spiritualnectar.com/includes/database.mysql.inc:172) in /hsphere/local/home/lordkris/spiritualnectar.com/includes/bootstrap.inc on line 488

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/lordkris/spiritualnectar.com/includes/database.mysql.inc:172) in /hsphere/local/home/lordkris/spiritualnectar.com/includes/bootstrap.inc on line 489

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/lordkris/spiritualnectar.com/includes/database.mysql.inc:172) in /hsphere/local/home/lordkris/spiritualnectar.com/includes/bootstrap.inc on line 490

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/lordkris/spiritualnectar.com/includes/database.mysql.inc:172) in /hsphere/local/home/lordkris/spiritualnectar.com/includes/bootstrap.inc on line 491

Comments

dman’s picture

dman commented

I can't see any mention of anything related to import_html in those error messages, but it does look like you've somehow got your variables table corrupted.
First things I'd do are open up a MYSQL query and run
"DELETE FROM cache;" (it's totally safe)
Then, depending on how you access your database (PHPMYADMIN would be cool) try and review the entries in the 'variables' table.
If there's a row there - possibly starting with the key "configurable" that has a carriage return in it, try deleting that.

Or it could be something a little deeper - like a genuine MYSQL table corruption. In which case you have to figure out the 'REPAIR TABLE' syntax.
I can't imagine how it could be related to import_html itself, unless possibly the server process timed out right on the last millisecond when some critical change was being made to the DB. And that's just a guess. Can you access enough DB admin tools to try the normal maintainence options?

Looking at your site, I'm seeing slightly different complaints. It seems some of the views plugins are not loading right. Is there a SIZE limit on your database size? it seems to be refusing to do some operations. If so, I'd 'DELETE FROM watchdog;' (that's also safe)

A search on 'error 134 from table handler' points to table corruption, and it seems that 'REPAIR TABLE' will do it for you ... although it's only the cache table, so DELETE is also fine.

... just part of looking after MYSQL I guess.

dman’s picture

dman commented
Status: Active » Postponed (maintainer needs more info)

Any more info on this issue?

gurukripa’s picture

gurukripa commented

SQL query:

REPAIR TABLE

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SQL query:

DELETE FROM cache

MySQL said: Documentation
#1016 - Can't open file: 'cache.MYI'. (errno: 145)

dman’s picture

dman commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

whatever this was, there's no reason to suspect it was importhtml - just DB maintainence/corruption