vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Team: Hot or Not? Ready for Traffic Explosion? vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! vBSEO Helps Forum Earn $100/day from Google AdSense Discover the Power of "Long Tail Search" Crawlability Inc. Files for SEO Technology Patent
se sw

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 ...

Go Back   vBulletin SEO Forums > vBSEO SEO Plugin > Troubleshooting

3.2.0 RC5 Database error 3.2.0 RC5 Database error

Enhancing 80 million pages.

 Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1  
Old 05-03-2008, 09:00 AM
MissKalunji's Avatar
Senior Member
  
Real Name: Mj
Join Date: Mar 2006
Location: Canada
Posts: 135
Send a message via AIM to MissKalunji Send a message via MSN to MissKalunji Send a message via Yahoo to MissKalunji
3.2.0 RC5 Database error
I get a database error upgrading the Plugin

Quote:
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 05-03-2008, 09:09 AM
Junior Member
  
Real Name: nexia lys
Join Date: Nov 2007
Location: Quebec city, ca
Posts: 4
tis is related to your database structure, you may have to "repair" that table from inside phpMyAdmin...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 05-03-2008, 09:13 AM
MissKalunji's Avatar
Senior Member
  
Real Name: Mj
Join Date: Mar 2006
Location: Canada
Posts: 135
Send a message via AIM to MissKalunji Send a message via MSN to MissKalunji Send a message via Yahoo to MissKalunji
oh lord :-/ ok i did everything turned out ok...when i did repair

Does vbseo supports mysql 5?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 05-03-2008, 09:15 AM
Mert Gökçeimam's Avatar
vBSEO Moderator
vBSEO Total Customer SupportDesign for SEO
  
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 6,291
Blog Entries: 2
Send a message via MSN to Mert Gökçeimam
Yes vBSEO support mysql 5
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 05-03-2008, 09:17 AM
MissKalunji's Avatar
Senior Member
  
Real Name: Mj
Join Date: Mar 2006
Location: Canada
Posts: 135
Send a message via AIM to MissKalunji Send a message via MSN to MissKalunji Send a message via Yahoo to MissKalunji
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 05-03-2008, 09:19 AM
MissKalunji's Avatar
Senior Member
  
Real Name: Mj
Join Date: Mar 2006
Location: Canada
Posts: 135
Send a message via AIM to MissKalunji Send a message via MSN to MissKalunji Send a message via Yahoo to MissKalunji
ah great my whole site crashed
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7  
Old 05-03-2008, 09:20 AM
Mert Gökçeimam's Avatar
vBSEO Moderator
vBSEO Total Customer SupportDesign for SEO
  
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 6,291
Blog Entries: 2
Send a message via MSN to Mert Gökçeimam
As nexialys suggested you need to repair that table via phpmyadmin or ssh mysql panel
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8  
Old 05-03-2008, 09:23 AM
MissKalunji's Avatar
Senior Member
  
Real Name: Mj
Join Date: Mar 2006
Location: Canada
Posts: 135
Send a message via AIM to MissKalunji Send a message via MSN to MissKalunji Send a message via Yahoo to MissKalunji
i did and it keeps reporting "ok" and the phrase databse has 0 now after trying to repair it
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9  
Old 05-03-2008, 09:48 AM
Junior Member
  
Real Name: nexia lys
Join Date: Nov 2007
Location: Quebec city, ca
Posts: 4
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10  
Old 05-03-2008, 09:52 AM
MissKalunji's Avatar
Senior Member
  
Real Name: Mj
Join Date: Mar 2006
Location: Canada
Posts: 135
Send a message via AIM to MissKalunji Send a message via MSN to MissKalunji Send a message via Yahoo to MissKalunji
aww man they have no backup great

thanks anyways
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« PR still 3,i have nofollow for mylinks,plz help | vbSEO not working after server migration »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads

Thread Thread Starter Forum Replies Last Post
Database Error for 3.6.10 CoffeeToki Bug Reporting 8 05-01-2008 12:39 AM
Database error webgroup Troubleshooting 1 05-08-2007 05:34 PM
Database error. ChefTalk Troubleshooting 3 03-24-2007 12:05 PM
database error help hornstar6969 General Discussion 1 02-01-2007 05:26 AM
database error UnderEstimated Troubleshooting 9 12-01-2006 05:46 AM


All times are GMT -4. The time now is 06:51 AM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc.