DeveloperSide.NET Forums
November 22, 2019, 12:48:22 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: MySQL error?  (Read 7390 times)
0 Members and 1 Guest are viewing this topic.
night2dark2
Jr. Member
**
Posts: 98


Yeah Dont really ask.

mfaiotto@msn.com
View Profile WWW
« 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
Logged

Revolution Gamers Host.
Master of all Gunz Server Hosting Needs.
Revolution Gamers International Gaming Commmunity
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #1 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.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
night2dark2
Jr. Member
**
Posts: 98


Yeah Dont really ask.

mfaiotto@msn.com
View Profile WWW
« Reply #2 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
Logged

Revolution Gamers Host.
Master of all Gunz Server Hosting Needs.
Revolution Gamers International Gaming Commmunity
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!