Results 1 to 10 of 10

3.2.0 RC5 Database error

This is a discussion on 3.2.0 RC5 Database error within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I get a database error upgrading the Plugin Database error in vBulletin 3.7.0: Invalid SQL: DELETE FROM phrase WHERE product ...

  1. #1
    Senior Member MissKalunji's Avatar
    Real Name
    Mj
    Join Date
    Mar 2006
    Location
    Canada
    Posts
    207
    Liked
    2 times

    3.2.0 RC5 Database error

    I get a database error upgrading the Plugin

    Database error in vBulletin 3.7.0:

    Invalid SQL:
    DELETE FROM phrase WHERE product = 'crawlability_vbseo' AND languageid = -1;

    MySQL Error : Incorrect key file for table './xxx/phrase.MYI'; try to repair it
    Error Number : 126
    Request Date : Saturday, May 3rd 2008 @ 09:01:03 AM
    Error Date : Saturday, May 3rd 2008 @ 09:01:03 AM
    Script : http://www.dancehallareaz.com/forum/...=productimport
    Referrer : http://www.dancehallareaz.com/forum/...?do=productadd
    IP Address : xxx
    Username : xxx
    Classname : vB_Database
    MySQL Version : 5.0.45-community

  2. #2
    Junior Member
    Real Name
    nexia lys
    Join Date
    Nov 2007
    Location
    Quebec city, ca
    Posts
    13
    Liked
    0 times
    tis is related to your database structure, you may have to "repair" that table from inside phpMyAdmin...

  3. #3
    Senior Member MissKalunji's Avatar
    Real Name
    Mj
    Join Date
    Mar 2006
    Location
    Canada
    Posts
    207
    Liked
    2 times
    oh lord :-/ ok i did everything turned out ok...when i did repair

    Does vbseo supports mysql 5?

  4. #4
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    Yes vBSEO support mysql 5
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  5. #5
    Senior Member MissKalunji's Avatar
    Real Name
    Mj
    Join Date
    Mar 2006
    Location
    Canada
    Posts
    207
    Liked
    2 times
    uhmph :S ok then

    i guess i have to talk to my host?

    Code:
    MySQL Error   : Table './xxx/phrase' is marked as crashed and should be repaired

  6. #6
    Senior Member MissKalunji's Avatar
    Real Name
    Mj
    Join Date
    Mar 2006
    Location
    Canada
    Posts
    207
    Liked
    2 times
    ah great my whole site crashed

  7. #7
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    As nexialys suggested you need to repair that table via phpmyadmin or ssh mysql panel
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  8. #8
    Senior Member MissKalunji's Avatar
    Real Name
    Mj
    Join Date
    Mar 2006
    Location
    Canada
    Posts
    207
    Liked
    2 times
    i did and it keeps reporting "ok" and the phrase databse has 0 now after trying to repair it

  9. #9
    Junior Member
    Real Name
    nexia lys
    Join Date
    Nov 2007
    Location
    Quebec city, ca
    Posts
    13
    Liked
    0 times
    the entire table was dropped... because the file database of your server was corrupted... when repairing it, the system created an empty shell instead of grabbing the old content back.

    this is rare, strange it comes for a small element like the ^phrases... ask your host if he can bring back a backup and repair/upgrade the database engine... it is the host's fault.

  10. #10
    Senior Member MissKalunji's Avatar
    Real Name
    Mj
    Join Date
    Mar 2006
    Location
    Canada
    Posts
    207
    Liked
    2 times
    aww man they have no backup great

    thanks anyways

Similar Threads

  1. Database Error for 3.6.10
    By CoffeeToki in forum Bug Reporting
    Replies: 8
    Last Post: 05-01-2008, 01:39 AM
  2. Database error
    By webgroup in forum Troubleshooting
    Replies: 1
    Last Post: 05-08-2007, 06:34 PM
  3. Database error.
    By ChefTalk in forum Troubleshooting
    Replies: 3
    Last Post: 03-24-2007, 01:05 PM
  4. database error help
    By hornstar6969 in forum General Discussion
    Replies: 1
    Last Post: 02-01-2007, 06:26 AM
  5. database error
    By UnderEstimated in forum Troubleshooting
    Replies: 9
    Last Post: 12-01-2006, 06:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •