No announcement yet.

SQL Errors

  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Errors

    All of a sudden I'm getting SQL errors in PM's and I think in the user galleries. Nothing changed on the site.

    [FONT=Arial]Database error in vBulletin 3.7.2:[/FONT]
    [FONT=Arial]Invalid SQL:[/FONT]
    [FONT=Arial]                                  SELECT pm.*, pmtext.*[/FONT]
    [FONT=Arial]                                              , icon.title AS icontitle, icon.iconpath[/FONT]
    [FONT=Arial]                                  FROM pm AS pm[/FONT]
    [FONT=Arial]                                  LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)[/FONT]
    [FONT=Arial]                                  LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)[/FONT]
    [FONT=Arial]                                  WHERE pm.userid=905 AND pm.folderid=0[/FONT]
    [FONT=Arial]                                  ORDER BY pmtext.dateline DESC[/FONT]
    [FONT=Arial]                                  LIMIT 0, 50;[/FONT]
    [FONT=Arial]MySQL Error   : Can't create/write to file '/var/lib/mysql/#sql_e17_0.MYI' (Errcode: 13)[/FONT]
    [FONT=Arial]Error Number  : 1[/FONT]
    [FONT=Arial]Request Date  : Friday, August 22nd 2008 @ 11:21:44 AM[/FONT]
    [FONT=Arial]Error Date    : Friday, August 22nd 2008 @ 11:21:44 AM[/FONT]
    [FONT=Arial]Script        : /forums/private.php[/FONT]
    [FONT=Arial]Referrer      : /forums/index.php[/FONT]
    [FONT=Arial]IP Address    : [/FONT]
    [FONT=Arial]Username      : [/FONT]
    [FONT=Arial]Classname     : vB_Database[/FONT]
    [FONT=Arial]MySQL Version : 5.0.45[/FONT]
    [COLOR=black][FONT=Courier New]Database error in vBulletin 3.7.2: [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Invalid SQL: [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]SELECT albumpicture.*, album.*, user.username, user.usergroupid, [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]FROM albumpicture AS albumpicture [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid) [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]LEFT JOIN user AS user ON(user.userid = album.userid) [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]WHERE album.state = 'public' [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]ORDER BY rand(NOW()) DESC LIMIT 0, 4; [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]MySQL Error   : Can't create/write to file '/var/lib/mysql/#sql_e17_0.MYI' [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New](Errcode: 13) [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Error Number  : 1 [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Request Date  : Friday, August 22nd 2008 @ 10:40:58 AM [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Error Date    : Friday, August 22nd 2008 @ 10:40:58 AM [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Script        : [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Referrer      : [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]IP Address    : [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Username      : [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]Classname     : vB_Database [/FONT][/COLOR]
    [COLOR=black][FONT=Courier New]MySQL Version : [/FONT][/COLOR]
    Last edited by dklassen; Fri 22 Aug '08, 12:09pm.

  • #2
    OS error code 13: Permission denied

    This is a server issue. It cannot write to the /var/lib/mysql directory. You need to contact your host about this.
    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
      Do you have Booyah! by chance?
      Lampstand Christian Forum


      • #4
        What's that?

        It looks like it's affecting user cp and PM's.


        • #5
          Booyah is a hosting company. Your response would most likely indicate that you do not use Booyah.
          Lampstand Christian Forum


          • #6
            I'm at DotEasy. Not a bad host but not that great either. I'm thinking HostGator may be better.

            Turns out they migrated me to another server and didn't tell me. Now we have SQL issues.


            • #7
              I have been pretty happy with Booyah! so far. The owner is the best when it comes to customer service. I had db errors earlier today and he fixed it, no problem. I switched to Booyah! from siteground (who were terrible for vb hosting).

              I hope you find a solution soon! I know it can be irritating.
              Lampstand Christian Forum


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