how to fix this error

[ForceHSS]

for some time now I have been trying to fix this but have not found how. It use to work but for some reason now it wont

Database error in vBulletin 4.1.7:

Invalid SQL:
CREATE TEMPORARY TABLE cms_nc_orphans AS
					select nc.nodeid FROM cms_nodecategory nc LEFT JOIN cms_node AS node on node.nodeid = nc.nodeid
						WHERE node.nodeid IS NULL;;

MySQL Error   : Access denied for user 'web247-james'@'%' to database 'web247-james'
Error Number  : 1044
Request Date  : Wednesday, November 30th 2011 @ 10:25:39 AM
Error Date    : Wednesday, November 30th 2011 @ 10:25:40 AM
Script        : http://www.my domain.net/cpanel/cms_content_admin.php?do=fix_nodes
Referrer      : http://www.mydomain.net/cpanel/index.php?do=nav
IP Address    : **.**.**.**
Username      : Forcehss
Classname     : vB_Database
MySQL Version : 5.1.56-community-log

[kh99]

I don't really know how to fix it, but I know that there is a separate permission for creating temporary tables, so maybe you need to be granted that permission.

[ForceHSS]

and where would that be found as I am set as super admin on my forums

[kh99]

It's a mySQL thing, and I really don't know much at all about doing mySQL admin.

[ForceHSS]

does any one know the correct query I have tried a few but no luck

[HMBeaty]

Do you have/use cPanel?

[ForceHSS]

this is what it is

[HMBeaty]

Originally Posted by ForceHSS

this is what it is

o.0 ......wtf is that? lol

Anyway, how do you get to your database? How do you add your users to the database(s)?

--------------- Added [DATE]1322720443[/DATE] at [TIME]1322720443[/TIME] ---------------

Problem solved (somewhat) via Skype

https://ssl.extendcp.co.uk/support.cgi?question=546

What are the default / allowed privileges for MySQL databases?

By default on all MySQL databases the current privileges are given -

SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES

CREATE TEMPORARY TABLES, CREATE VIEW, and CREATE ROUTINE privileges can be granted on request to Support.