PM mysql error cant private message anymore

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xeon711
    Senior Member
    • Jun 2004
    • 109
    • 3.6.x

    PM mysql error cant private message anymore

    Today I go on to my forums. I see I have a PM. Click on it get a mysql error:
    Database error in vBulletin 3.0.1:

    Invalid SQL:
    SELECT pm.*, pmtext.*
    , icon.title AS icontitle, icon.iconpath
    FROM pm AS pm
    LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
    LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
    WHERE pm.userid=1 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 50

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

    mysql error number: 1

    Date: Thursday 15th of July 2004 03:14:25 PM
    Script: http://cs.tsrealm.com/cs2/vforum/private.php?
    Referer: http://cs.tsrealm.com/cs2/vforum/index.php?
    Does anyone know what the problem is? Your help would be great. I am using IE6 and the vb version is 3.0.1. I am not home and I was not able to update the script. Thanks!

    I looked around in bug tracker and troubleshooting forum. Counld not find anything. Maybe new error? My database used to work last night it did.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Error code 13: Permission denied

    You or your host need to chmod the /tmp directory on the server to 777.
    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

    • xeon711
      Senior Member
      • Jun 2004
      • 109
      • 3.6.x

      #3
      Originally posted by Steve Machol
      Error code 13: Permission denied

      You or your host need to chmod the /tmp directory on the server to 777.
      Why would it change? I did it in the start. Well I figured that. Thanks for the fast reply testing it now!

      Comment

      • xeon711
        Senior Member
        • Jun 2004
        • 109
        • 3.6.x

        #4
        Ok wheres the /tmp? Where do I find it? I looked in vforum dir. and in phpadmin (me = nooby)
        Do I need my webserver admins to do it? I have smartFTP and I just dont see and tmp folder anywhere.
        Thanks!

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          Following up here:

          How do I chmod the /tmp directory on the server to 777. Where is the tmp directory? I have and I know how to chmod but where is the tmp folder?
          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

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