Announcement

Collapse
No announcement yet.

mySQL Error on Threads !! Please Help !!

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

  • mySQL Error on Threads !! Please Help !!

    There seems to have been a slight problem with the World of Britney.com Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience


    Database error in vBulletin 2.2.1:

    Invalid SQL:
    SELECT
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    WHERE post.postid IN (0,67483,67782,67832,67995,68823,68842,69165,72407,73230,73970,74056)
    ORDER BY dateline

    mysql error: Can't open file: 'attachment.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Thursday 07th of February 2002 02:19:00 PM
    Script: http://www.wobforums.com/showthread....&threadid=8370
    Referer: http://www.wobforums.com/forumdisplay.php?s=&forumid=26


    ***
    I am on Windows 2k Advanced Server.
    mySQL version: 3.23.38


    Hmm, it's not really a "slight" problem, lol, it's a HUGE problem. The forums display fine, but that is the error I am presented with when I try to view a thread, immediate assitance is required, please advise. Thanks.

    -Ruben
    http://www.worldofbritney.com
    Last edited by WoBber; Thu 7 Feb '02, 11:24am.

  • #2
    1. close forum via admin panel
    2. upload repair.php from extras folder in vB zip file
    3. load it in browser yourdomain/admin/repair.php
    4. read instructions to run the command/url to repair your database
    5. reopen forum when all tables check out as OK...

    note sessions table will report repair not supported which is normal
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      Thank you sir.

      I did it, but it gave me an error about SQL timing out after 30 seconds. It still fixed my problem though.

      Have any idea on how I can make that time out greater?

      -Ruben

      Comment


      • #4
        try adding these 2 lines after the error_reporting line in repair.php

        ini_set ("max_execution_time", "180")
        ini_set ("memory_limit", "16")
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment

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