Database error please help =(

[Onoredone]

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT *,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
 FROM user WHERE usergroupid = '2,10,11' ORDER BY RAND() LIMIT 25;

MySQL Error   : Can't create/write to file '/tmp/#sql_bbd_0.MYD' (Errcode: 17)
Error Number  : 1
Request Date  : Monday, May 4th 2009 @ 05:27:23 PM
Error Date    : Monday, May 4th 2009 @ 05:27:23 PM
Script        : http://xxxxx.xxx
Referrer      : 
IP Address    : xxx.xxx.xxx.xxx
Username      : xxxxx
Classname     : vB_Database
MySQL Version : 5.0.51a-community

This is what I get when I go to my forum home i.e when i click the header of my forum. Suddenly happened.Was working fine previously.

-Odo

 

[PAKIS-RULEZ]

disable all mods from includes.php

add the following in the end of the file

define('DISABLE_HOOKS', 1);

should be in /includes/config.php
remember put it in the end of that file


and enable 1 mod at a time and check which one is creating problems

or if not the most would be is template issues


oh you probably missing some files when u uploaded ur ftp files.. reupload them and it should fix

 

[bluescorpion]

Need to get your Hosting Provider to fix the database problem