Announcement

Collapse
No announcement yet.

Problem with board Database Error

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

  • Problem with board Database Error

    One my forum at www.shakiraholics.com/board i can view posts, but cant view the forums only the posts inside the Forum, when i click on a forum like "Shakira" it says this

    Database error in vBulletin 2.2.8:
    Invalid SQL:
    SELECT DISTINCT post.userid, post2.pagetext as pagetext, icon.title as icontitle,icon.iconpath,
    thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
    lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attac h
    FROM thread
    LEFT JOIN icon ON (icon.iconid = thread.iconid)
    LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '8' AND post.visible = 1) LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
    WHERE thread.threadid IN (0,6064,6161,6146,6149,6156,6150,6160,6113,6154,6155,6162,5851,6153,5982,6144,6157,6152,61 27,6135,6101,6133,6031,6145,6139,6030,5114,6112)
    ORDER BY sticky DESC, lastpost DESC


    mysql error: Got error 28 from table handlermysql error number: 1030
    Date: Sunday 08th of December 2002 07:52:16 AM
    Script: http://shakiraholics.com/board/board...&forumid=2
    Referer: http://shakiraholics.com/board/index.php?s=

    Info:

    Apache/1.3.22 (Unix) (Red-Hat/Linux) mod_ssl/2.8.5 OpenSSL/0.9.6b PHP/4.1.2
    http://www.shakiraholics.com/board


    Anyone can help ASAP? Thanks!

  • #2
    Error code 28: No space left on device

    Shut down your forums immedaitely before any db corruption takes place. Then inform your web host that the MySQL partition havs run out of space. They'll need to free up some space. Once they've done that run repair.php to make sure your database is okay, then reopen your forums.
    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
      Originally posted by Steve Machol
      Error code 28: No space left on device

      Shut down your forums immedaitely before any db corruption takes place. Then inform your web host that the MySQL partition havs run out of space. They'll need to free up some space. Once they've done that run repair.php to make sure your database is okay, then reopen your forums.
      Thanks That fix it, i contact them and they was doing mantiance or something

      Comment

      Loading...
      Working...
      X