whats this error and how do i fix it

[lasto]

Invalid SQL:
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
LEFT JOIN user AS user ON user.userid = gamesessions.userid
LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='aim' AND score='1139') OR (gamename='airfox' AND score='32125') OR (gamename='aliens' AND score='30315') OR (gamename='alienterminator' AND score='43116') OR (gamename='asteroids' AND score='39220') OR (gamename='bloodypingu' AND score='1327') OR (gamename='bowling_tgfg' AND score='192') OR (gamename='breakout' AND score='107910') OR (gamename='candy' AND score='494') OR (gamename='chopper' AND score='2616') OR (gamename='copter' AND score='3610') OR (gamename='curveball' AND score='29235') OR (gamename='eggs' AND score='289') OR (gamename='enemyshooting' AND score='5600') OR (gamename='flexicombat' AND score='11291') OR (gamename='frogger' AND score='806') OR (gamename='ivtetris' AND score='5404') OR (gamename='juggler' AND score='125') OR (gamename='kickups' AND score='364') OR (gamename='killkenny' AND score='75200') OR (gamename='maeda' AND score='11330') OR (gamename='minigolf' AND score='144') OR (gamename='minikickups' AND score='57') OR (gamename='monkeylander' AND score='27470') OR (gamename='pacman' AND score='97390') OR (gamename='penguin' AND score='3235') OR (gamename='pinball' AND score='2345') OR (gamename='pinguslap' AND score='680') OR (gamename='plasmanautonfire' AND score='151') OR (gamename='plops' AND score='7300') OR (gamename='pooljam' AND score='15020') OR (gamename='radialsnake' AND score='158') OR (gamename='ronnorthjewels' AND score='123070') OR (gamename='sealbounce' AND score='1725') OR (gamename='simon' AND score='44') OR (gamename='simpsonsshooter' AND score='3000') OR (gamename='smacktherabbit' AND score='54') OR (gamename='snake' AND score='2847') OR (gamename='snipers' AND score='28220') OR (gamename='snowrider' AND score='11391') OR (gamename='soap_bubble' AND score='6020') OR (gamename='spacehunter' AND score='1590') OR (gamename='spaceinvaders' AND score='178740') OR (gamename='spankthemonkey' AND score='905') OR (gamename='spiderjump' AND score='320') OR (gamename='ssl' AND score='1895') OR (gamename='starrynight' AND score='1960') OR (gamename='tetris' AND score='74163') OR (gamename='towerball' AND score='26250') OR (gamename='vbtetris' AND score='1103826') OR (gamename='yeti1_5shots' AND score='1456') AND sessiontype IN (1,2) ORDER BY gamesessions.gamename DESC

mysql error: Can't create/write to file '/tmp/#sql1153_4c5cc_4.MYD' (Errcode: 23)

mysql error number: 1

[Zachery]

Originally Posted by lasto

Invalid SQL:
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
LEFT JOIN user AS user ON user.userid = gamesessions.userid
LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='aim' AND score='1139') OR (gamename='airfox' AND score='32125') OR (gamename='aliens' AND score='30315') OR (gamename='alienterminator' AND score='43116') OR (gamename='asteroids' AND score='39220') OR (gamename='bloodypingu' AND score='1327') OR (gamename='bowling_tgfg' AND score='192') OR (gamename='breakout' AND score='107910') OR (gamename='candy' AND score='494') OR (gamename='chopper' AND score='2616') OR (gamename='copter' AND score='3610') OR (gamename='curveball' AND score='29235') OR (gamename='eggs' AND score='289') OR (gamename='enemyshooting' AND score='5600') OR (gamename='flexicombat' AND score='11291') OR (gamename='frogger' AND score='806') OR (gamename='ivtetris' AND score='5404') OR (gamename='juggler' AND score='125') OR (gamename='kickups' AND score='364') OR (gamename='killkenny' AND score='75200') OR (gamename='maeda' AND score='11330') OR (gamename='minigolf' AND score='144') OR (gamename='minikickups' AND score='57') OR (gamename='monkeylander' AND score='27470') OR (gamename='pacman' AND score='97390') OR (gamename='penguin' AND score='3235') OR (gamename='pinball' AND score='2345') OR (gamename='pinguslap' AND score='680') OR (gamename='plasmanautonfire' AND score='151') OR (gamename='plops' AND score='7300') OR (gamename='pooljam' AND score='15020') OR (gamename='radialsnake' AND score='158') OR (gamename='ronnorthjewels' AND score='123070') OR (gamename='sealbounce' AND score='1725') OR (gamename='simon' AND score='44') OR (gamename='simpsonsshooter' AND score='3000') OR (gamename='smacktherabbit' AND score='54') OR (gamename='snake' AND score='2847') OR (gamename='snipers' AND score='28220') OR (gamename='snowrider' AND score='11391') OR (gamename='soap_bubble' AND score='6020') OR (gamename='spacehunter' AND score='1590') OR (gamename='spaceinvaders' AND score='178740') OR (gamename='spankthemonkey' AND score='905') OR (gamename='spiderjump' AND score='320') OR (gamename='ssl' AND score='1895') OR (gamename='starrynight' AND score='1960') OR (gamename='tetris' AND score='74163') OR (gamename='towerball' AND score='26250') OR (gamename='vbtetris' AND score='1103826') OR (gamename='yeti1_5shots' AND score='1456') AND sessiontype IN (1,2) ORDER BY gamesessions.gamename DESC

mysql error: Can't create/write to file '/tmp/#sql1153_4c5cc_4.MYD' (Errcode: 23)

mysql error number: 1

Looks like your MySQL cannot write to that, error 23 means too many files are open and 1 is Operation not permitted

[lasto]

so how do i find out why 2 many files are open and fix this problem.Its gone away now but it may come back.

[Zachery]

Your system was problay overloaded at that point in time,

[lasto]

seems everything was - ftp went down - email went down (im on virtual hosting) and sent email to host but they say everything is fine when it clearly aint as i get weird errors going into my c-panel so the problem has to lie with them.