vb.org Archive - how to fix this error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - how to fix this error (https://vborg.vbsupport.ru/showthread.php?t=274857)

ForceHSS

11-30-2011 09:30 AM

how to fix this error

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

Code:

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	11-30-2011 05:08 PM

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

11-30-2011 05:38 PM

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

kh99	11-30-2011 09:33 PM

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

ForceHSS

11-30-2011 10:21 PM

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

HMBeaty

11-30-2011 10:31 PM

Do you have/use cPanel?

ForceHSS

12-01-2011 03:58 AM

1 Attachment(s)

this is what it is

HMBeaty

12-01-2011 04:00 AM

Quote:

Originally Posted by ForceHSS (Post 2273566)

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

Quote:

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.

All times are GMT. The time now is 09:20 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01070 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: