Posted by gideon2 on January 10, 2011 at 8:44am
Hi everyone,
i just got register to this group... trying to find some help for our church website.
I got this error on my front page
* user warning: Incorrect key file for table 'node'; try to repair it query: SELECT COUNT() FROM node n WHERE n.promote = 1 AND n.status = 1 in /home/mmccon/public_html/dev/includes/database.mysql.inc on line 120.
user warning: Incorrect key file for table 'node'; try to repair it query: SELECT n.nid, n.sticky, n.created FROM node n WHERE n.promote = 1 AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 5 in /home/mmccon/public_html/dev/includes/database.mysql.inc on line 120.Drupal version is 4.7.2
Thanks in advance :)
Comments
i think nacorrupt po ung
i think nacorrupt po ung database nyo. try repairing it as suggested.
phpadmin
Thanks for the reply.... I tried checking it in phpadmin and found it you're right
SQL resultHost: localhost
Database: hide
Generation Time: Jan 10, 2011 at 06:44 PM
Generated by: phpMyAdmin 2.11.11.1 / MySQL 5.1.52
SQL query: REPAIR TABLE
node,term_synonym;Rows: 4
Table Op Msg_type Msg_text
hide_drpl2.node repair Error Incorrect key file for table 'node'; try to repair it
hiden_drpl2.node repair error Corrupt
hide_drpl2.term_synonym repair Error Incorrect key file for table 'term_synonym'; try to repair it
hide_drpl2.term_synonym repair error Corrupt
how can i repair it?
you might have done so. sbi
you might have done so. sbi kc s post mo. not sure.
SQL query: REPAIR TABLE node, term_synonym;
eto additional info on how to repair your tables
http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
Help Please - I am a Small Business without Drupal Support!
Warning: Cannot modify header information - headers already sent by (output started at /var/www/sites/esdrmv.com/public/includes/common.inc:2525) in drupal_send_headers() (line 1048 of /var/www/sites/esdrmv.com/public/includes/bootstrap.inc).
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal_core_com_sllabs_esddev.webform' doesn't exist: SELECT w.*, n.title AS title FROM {webform} w LEFT OUTER JOIN {node} n ON w.nid = n.nid WHERE (w.block = :db_condition_placeholder_0) AND (n.type IN (:db_condition_placeholder_1)) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => webform ) in webform_block_info() (line 1404 of /var/www/sites/esdrmv.com/public/sites/all/modules/webform/webform.module).
ErrorThe website encountered an unexpected error. Please try again later. .
Renee Mitchell