vb.org Archive

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.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

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