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