SQL Errors

[dklassen]

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]

[Steve Machol]

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.

[gibby]

Do you have Booyah! by chance?

[dklassen]

What's that?

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

[gibby]

Booyah is a hosting company. Your response would most likely indicate that you do not use Booyah.

[dklassen]

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.

[gibby]

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.