Announcement

Collapse
No announcement yet.

Database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • borbole
    replied
    Originally posted by Panni100 View Post
    It worked thanks!
    You are welcome. Glad to have been of help.

    Leave a comment:


  • Panni100
    replied
    It worked thanks!

    Leave a comment:


  • borbole
    replied
    Originally posted by Panni100 View Post
    A moderator posted an article on the cms and when I tried to add a couple of images on the article a Database error occurs.

    Database error in vBulletin 4.0.3:

    Invalid SQL:
    INSERT INTO searchcore_text (searchcoreid, title, keywordtext)
    VALUES ( )
    ON DUPLICATE KEY UPDATE searchcoreid = VALUES(searchcoreid), title = VALUES(title), keywordtext = VALUES(keywordtext);

    MySQL Error : Incorrect key file for table './******/searchcore_text.MYI'; try to repair it
    Error Number : 126
    Request Date : Sunday, June 6th 2010 @ 07:16:10 AM
    Error Date : Sunday, June 6th 2010 @ 07:16:15 AM
    Script :
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version : 5.1.30

    my mod put some page break tags in there this probably has nothing to do with it but I thought it was worth mentioning. I tried editing other mods articles and there wasnt a problem.

    Possible bug?


    Go to your Acp-Maintenance-Repair / Optimize Tables. Choose the table that is reported as crashed and then select the Repair Tables option. Better yet, try to run a Repair?Optimize for all the db tables.

    Or go to the phpmyadmin at the CP of your host, seelct the db that your forum resides on, choose the table that is reported as crashed and all the way to the bottom where it says: With Selected, choose for the repair option.

    Or run this query at the SQL box at phpmyadmin:

    Code:
    REPAIR TABLE 'searchcore_text';
    If repairing the table won''t work, then drop that table and then recreate it again by copy/paste its structure from the mysql-schema.php file inside the install folder at the vb package.

    If none of the above ways will work, then you should contact your host about it. Hope it helps.

    Leave a comment:


  • Panni100
    started a topic [CMS] Database error

    Database error

    A moderator posted an article on the cms and when I tried to add a couple of images on the article a Database error occurs.

    Database error in vBulletin 4.0.3:

    Invalid SQL:
    INSERT INTO searchcore_text (searchcoreid, title, keywordtext)
    VALUES ( )
    ON DUPLICATE KEY UPDATE searchcoreid = VALUES(searchcoreid), title = VALUES(title), keywordtext = VALUES(keywordtext);

    MySQL Error : Incorrect key file for table './******/searchcore_text.MYI'; try to repair it
    Error Number : 126
    Request Date : Sunday, June 6th 2010 @ 07:16:10 AM
    Error Date : Sunday, June 6th 2010 @ 07:16:15 AM
    Script :
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version : 5.1.30

    my mod put some page break tags in there this probably has nothing to do with it but I thought it was worth mentioning. I tried editing other mods articles and there wasnt a problem.

    Possible bug?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X