DeveloperSide.NET Forums

DeveloperSide.NET => Web.Developer Server Suite Community Edition,
Public Support Forum => Topic started by: night2dark2 on August 05, 2008, 10:13:43 PM



Title: MySQL error?
Post by: night2dark2 on August 05, 2008, 10:13:43 PM
I never actually received this error while running the suite on xp but now im receiving it every day on server 2003.

the error is as below

Code:
Database error in vBulletin 3.6.8:

Invalid SQL:

select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
group by s.s_by having TS > 0
order by TS desc limit 10;

MySQL Error  : Can't create/write to file '#sql_e4dc_0.MYD' (Errcode: 17)
Error Number : 1
Date         : Tuesday, August 5th 2008 @ 05:51:37 PM
Script       : http://forums.revgamers.net/forums/vbshout.php?do=archive
Referrer     :
IP Address   : LOGGED
Username     : lsa2007
Classname    : vB_Database


Title: Re: MySQL error?
Post by: admin on August 06, 2008, 12:47:40 AM
Maybe its due to a newer vBulletin version? Was the instance on XP a different version?

I'm not much of an sql guy so I can't see if anything is wrong with that sql statement. Try the vbulletin support forums.


Title: Re: MySQL error?
Post by: night2dark2 on August 06, 2008, 12:48:48 AM
Well after i delete the tmp file it created, everything in mysql starts working again. people @ mysql forums said it might be due to the mysql configuration