No announcement yet.

A problem when viewing a forum

  • Filter
  • Time
  • Show
Clear All
new posts

  • A problem when viewing a forum


    Please can anyone help me to fix this major problem. When I try to view a forum, this error msg shows up:

    Database error in vBulletin 2.3.0:

    Invalid SQL:
    SELECT DISTINCT post.userid, IF(votenum>=2,votenum,0) AS votenum,
    IF(votenum>=2 AND votenum > 0,votetotal/votenum,0) AS voteavg, 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 = '1' AND post.visible = 1) LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
    WHERE thread.threadid IN (0,875,766,374,597)
    ORDER BY sticky DESC, lastpost DESC

    mysql error: Can't create/write to file '/tmp/#sqlbd_bc94_1.MYI' (Errcode: 13)

    mysql error number: 1

    Date: Wednesday 29th of October 2003 10:35:55 PM


  • #2
    Error code 13: Permission denied

    Your db user does not have permission to write to the tmp directory. Upload the phpinfo.php file from the 'extras' directory of the zip file to your forums directory. Then post the URL here. This will help us troubleshoot the problem.
    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.


    • #3
      Hi again,

      Thank you my friend for perlying so fast .

      I solved the problem by uploading the file forumdisplay.php and overwrite it to the existing one. I hope that is enough!!. If its not enough please be with me.

      Thank you very much again.

      And more, Thank you for making life better.

      God pless you.


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