It gives me Database error?

[aycan555]

Hi when i have tried to change the users user group it gives me the error below:

 
Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT ranklevel AS l, minposts AS m, rankimg AS i, type AS t, stack AS s, display AS d, ranks.usergroupid AS u
FROM ranks AS ranks
LEFT JOIN usergroup AS usergroup USING (usergroupid)
ORDER BY ranks.usergroupid DESC, minposts DESC;
MySQL Error : Table 'd60270330.ranks' doesn't exist
Error Number : 1146
Date : Thursday, September 21st 2006 @ 12:33:46 PM
Script : [URL]http://www.ultrapaylasim.com/admincp/user.php?do=update[/URL]
Referrer : [URL]http://www.ultrapaylasim.com/admincp/user.php?do=edit&u=300[/URL]
IP Address : 86.141.35.77
Username : KripteX
Classname : vb_database

[Jake Bunce]

You are missing one of the default tables (ranks). You can create that table by running this query:

CREATE TABLE ranks (
	rankid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
	minposts SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	ranklevel SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	rankimg MEDIUMTEXT,
	usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	type SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	stack SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	display SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (rankid),
	KEY grouprank (usergroupid, minposts)
)

If you recently performed an upgrade or other major maintenance that might have broken other stuff, then you might consider redoing that maintenance.

[aycan555]

OK thank you it is working now