[CMS] Database Error - Verify and repair Node table

[Sula]

Hi,

I have recently started to get database errors when uploading large files to an article.

In addition, when clicking on 'Verify and repair Node table' in admincp i get a database error with the following message.

Database error in vBulletin 4.0.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 'XXXXXXXX242612'@'%' to database 'forum1_0_sulasystems_co_uk'
Error Number  : 1044
Request Date  : Monday, December 13th 2010 @ 04:20:12 PM
Error Date    : Monday, December 13th 2010 @ 04:20:12 PM
Script        : http://XXXXXXXX.co.uk/forum/admincp/cms_content_admin.php?do=fix_nodes
Referrer      : http://XXXXXXXX.co.uk/forum/admincp/index.php?do=nav
IP Address    : XXXXXXXXX
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.90-log

Can someone tell me if this is a serious error and also how i could fix it.

Thanks

PS. some of the information i have removed from the error, as i am not confident of what the error is showing.

[Steve Machol]

Your DB user does not have CREATE permissions for this database. You need to give that user full permissions. If you need more specific help on how to do that, contact your host.

[Sula]

Okay thanks Steve,

Ill give it a go, but im a bit worried about how the settings for the DB user would have changed... we haven't modified any of the settings since our forum was established 3 months ago and have never had an error previously.

[Steve Machol]

Any changes to this would have been on the server level. vB has no control over those permissions.