Announcement

Collapse
No announcement yet.

Strange DB Error On Search

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

  • Steve Machol
    replied
    Error code 134: Record was already deleted (or record file crashed)

    Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.

    Leave a comment:


  • DiscussAnything
    started a topic Strange DB Error On Search

    Strange DB Error On Search

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=130 ORDER BY dateline DESC LIMIT 1
    mysql error: Got error 134 from table handler

    mysql error number: 1030

    Date: Saturday 05th of April 2003 02:45:54 AM
    Script: http://www.discussanything.com/forums/forums/search.php?s=&action=getnew
    Referer: <A href="http://www.discussanything.com/forums/index.php?s=">http://www.discussanything.com/forums/index.php?s=</a>
    This only happens to select users. It happens WHENEVER they try to use anything search related.

    I've tried logging into their accounts, changing settings/options/usergroups and it always happens for specific users.

    I thought the problem was related to just 1 or 2 users, but now it seems 5-10 of my active users are having this problem when trying to search. Anyone have any ideas? I am not quite sure what that error message means...

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