No announcement yet.

MySQL DB error, possible table issue.

  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL DB error, possible table issue.

    when any user goes to the PM menu the following error is generated.

    Database error in vBulletin 3.0.7:

    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=15 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 50

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

    mysql error number: 1

    Date: Wednesday 08th of June 2005 03:02:49 PM

    I contacted tech support of my webhost, waiting for reply from them, just seeing if someone here can help give me a headstart on clueing in tech support.


  • #2
    Your host needs to create a /var/tmp directory on this server and chmod it 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.


    • #3
      thanks for the help steve,
      i was wondering what exactly i didn't have permission to after my host had a DB crash.


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