Announcement

Collapse
No announcement yet.

Email crash!

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

  • Email crash!

    Database error in vBulletin 3.6.1:

    Invalid SQL:

    SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate,
    useractivation.activationid
    FROM user AS user
    LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
    LEFT JOIN useractivation AS useractivation ON (useractivation.userid = user.userid AND useractivation.type = 0)
    WHERE
    1=1 AND (user.usergroupid = 28)
    AND user.email <> ''
    AND (options & 16)
    ORDER BY userid
    LIMIT 0, 500;

    MySQL Error : Table './Sql21549_1/useractivation' is marked as crashed and should be repaired
    Error Number : 145
    Date : Saturday, May 19th 2007 @ 01:45:13 PM
    Script : http://88.149.192.114/forum/admincp/...?do=dosendmail
    Referrer : http://88.149.192.114/forum/admincp/email.php?do=start
    IP Address : 88.149.228.109
    Username : BiEdDoS
    Classname : vB_Database


    What i can do for fix it?

  • #2
    Originally posted by BieDdoS View Post
    Database error in vBulletin 3.6.1:

    Invalid SQL:

    SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate,
    useractivation.activationid
    FROM user AS user
    LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
    LEFT JOIN useractivation AS useractivation ON (useractivation.userid = user.userid AND useractivation.type = 0)
    WHERE
    1=1 AND (user.usergroupid = 28)
    AND user.email <> ''
    AND (options & 16)
    ORDER BY userid
    LIMIT 0, 500;

    MySQL Error : Table './Sql21549_1/useractivation' is marked as crashed and should be repaired
    Error Number : 145
    Date : Saturday, May 19th 2007 @ 01:45:13 PM
    Script : http://88.149.192.114/forum/admincp/...?do=dosendmail
    Referrer : http://88.149.192.114/forum/admincp/email.php?do=start
    IP Address : 88.149.228.109
    Username : BiEdDoS
    Classname : vB_Database


    What i can do for fix it?
    Code:
    REPAIR TABLE useractivation;
    run that query

    Comment


    • #3
      tnx i try

      Comment

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