No announcement yet.

Database error...please help...

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error...please help...

    Hi there--

    I requested a 'server hardening' service through my provider to tighten up security. After it was completed, I immediately starting having a problem wtih Vbulletin 3.5. The error message is as follows:

    Database error in vBulletin 3.5.0:

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

    MySQL Error : Can't create/write to file '/tmp/#sql_956_0.MYI' (Errcode: 13)
    Error Number : 1
    Date : Thursday, October 20th 2005 @ 05:55:33 AM
    Script :
    Referrer :

    I've received hundreds of these messages-- presumably after an individual tries to look at their pms. I also cannot access the Vbulletin admin options. I wrote back to the host and they told me they do not support Vbulletin. Furthermore, they told me that nothing should be stored in the /tmp/ directory due to security concerns. They suggested I have a misconfiguration of some sort.

    Any suggestions on how I might fix this? Thank you so much in advance!


  • #2
    13 = Permission denied

    Make sure you have a /tmp dir and that it is chmod 777


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