Announcement

Collapse
No announcement yet.

PM mysql error cant private message anymore

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

  • 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.

  • #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


    • #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


      • #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


        • #5
          Following up here:

          http://www.vbulletin.com/forum/showthread.php?t=110500
          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...
          X