Buying Need help with Vbulletin errors in MySQL

Discussion in 'Programming' started by lacaliboy, Jul 25, 2011.

0
  1. #1
    I need some help with my VBulletin forums. For the last few days I have been getting these errors and I cannot find out why. Im looking for someone experienced only with VB and MySQL for this job.

    Pay: $5 - $20

    I have been getting around 1-15 emails a minute with the following VB errors.

    ************************************************************

    Database error in vBulletin 4.1.3:

    Invalid SQL:
    DELETE FROM strikes WHERE striketime < 1311635923;

    MySQL Error : Table './ftastrea_newvb/strikes' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Monday, July 25th 2011 @ 08:18:43 PM
    Error Date : Monday, July 25th 2011 @ 08:18:43 PM
    Script : http://www.streamwarez.com/login.php?do=login
    Referrer :
    IP Address : 222.254.110.93
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

    ***************************************************
     
    lacaliboy, Jul 25, 2011 IP
  2. creativeGenius

    creativeGenius Well-Known Member

    Messages:
    273
    Likes Received:
    5
    Best Answers:
    1
    Trophy Points:
    120
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    just use the repair function on phpmyadmin
     
    creativeGenius, Jul 25, 2011 IP
  3. Cucumba123

    Cucumba123 Well-Known Member

    Messages:
    1,403
    Likes Received:
    34
    Best Answers:
    3
    Trophy Points:
    150
    As Seller:
    100% - 1
    As Buyer:
    100% - 1
    #3
    Try the repair function in the admin panel first as it may fix potential errors which phpmyadmin may not recognize.
     
    Cucumba123, Jul 26, 2011 IP
  4. lacaliboy

    lacaliboy Well-Known Member

    Messages:
    179
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    115
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    That was the first thing i tried. Now im getting "missing database errors".
     
    lacaliboy, Jul 29, 2011 IP
  5. Cucumba123

    Cucumba123 Well-Known Member

    Messages:
    1,403
    Likes Received:
    34
    Best Answers:
    3
    Trophy Points:
    150
    As Seller:
    100% - 1
    As Buyer:
    100% - 1
    #5
    Hmm.. Can you post the whole log?
     
    Cucumba123, Jul 30, 2011 IP