Announcement

Collapse
No announcement yet.

Error in table handler? vb admin cp

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

  • Error in table handler? vb admin cp

    Just installed/replaced hard drive on my server. No VB database errors until I just tried to track my latest registrations that were "email confirmation needed" usergroup. (Email wasn't working for a while and I wanted to re-email them)

    I got this error in the admin cp:

    Warning: MySQL: Unable to save result set in /home/httpd/vhosts/hystersisters.com/httpdocs/vb2/admin/db_mysql.php on line 87



    Database error in vBulletin Control Panel 2.2.8:

    Invalid SQL: SELECT user.userid,username,usergroupid,birthday,specialevent,email,parentemail,coppauser,homepag e,icq,aim,yahoo,signature,usertitle,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastpost) AS lastpost,posts,ipaddress,userfield.* FROM user,userfield WHERE 1=1 AND usergroupid=3 AND joindate>UNIX_TIMESTAMP('2003-02-20') AND userfield.userid=user.userid ORDER BY username LIMIT 0,300
    mysql error: Got error 134 from table handler

    mysql error number: 1030

    Date: Wednesday 05th of March 2003 10:32:42 AM
    Script: http://www.hystersisters.com/vb2/vb2/admin/user.php
    Referer: http://hystersisters.com/vb2/admin/u...tion=modify&s=
    Any idea what we've missed that needs fixing?

    Thanks!
    Kathy
    Senior Member
    Last edited by Kathy; Wed 5 Mar '03, 8:40am.
    Fan Club member for VBulletin Dev and Support Team ;)

    Hysterectomy - GirlsGetGoing.com - Fabulous Fifty

    I'm frequently asked about the skin designer for my forums. ForumSkin.com

  • #2
    Error code 134: Record was already deleted (or record file crashed)

    Run these queries in phpMyAdmin:

    REPAIR TABLE user;
    REPAIR TABLE userfield;
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thank you Steve
      Fan Club member for VBulletin Dev and Support Team ;)

      Hysterectomy - GirlsGetGoing.com - Fabulous Fifty

      I'm frequently asked about the skin designer for my forums. ForumSkin.com

      Comment

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