vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   random database error... (https://vborg.vbsupport.ru/showthread.php?t=253981)

JMEWLS` 11-20-2010 02:07 AM

random database error...
 
This is the error...

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user '(edited)'@'localhost' (using password: YES) /home/(edited)/public_html/forums/includes/class_core.php on line 313

It happened suddenly, I don't understand the problem. I've edited nothing. No staff have.

Outbackmark 11-20-2010 02:41 AM

It's telling you the password/username in the config.php are not working, for that to happen the password/user has one of 3 problems..
The password or username have been changed in the config.php or in the CPanel under mysql databases. (Unlikely in this case as nothing would work)
The permissions for that user are insufficient for the particular operation it was trying to carry out at the time.

It is strange that this has occurred suddenly, although you don't say what you were doing when you got the error.
If it is something that requires an entry deleted and you have not set the user up with the permission to delete items, it will still be able to write and fetch posts etc but not delete anything and this is the type of error you will get on the occasions when a deletion is called for.

These are the selections you can make when giving a user permissions in the DB.....
SELECT CREATE INSERT ALTER UPDATE DROP DELETE LOCK TABLES
INDEX REFERENCES CREATE TEMPORARY TABLES CREATE ROUTINE
EXECUTE
If you have left one that's needed occasionally unchecked when setting the user up, such as DELETE, you will get this error when the software is trying to delete a post or attachment.

There is no way to check which permissions have or have not been applied, the easiest fix is to check the username in your config.php file, close the board, remove the user and then put it back again with all the required permissions, then reopen the board.

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

I just tried to open your site and it is not accessing the DB at all, check your config.php and the user in the Cpanel/Mysql Databases.
Make sure the dbanme is correct in the conig.php as well.

JMEWLS` 11-20-2010 03:29 AM

The dbname and everything is correct, as I said it hasn't been altered at all as I'm the only one with access to the root files and MySQL etc.

Bradley_Wint 11-20-2010 03:30 AM

Are you on a shared server?

JMEWLS` 11-20-2010 03:42 AM

VPS shared hosting.

Bradley_Wint 11-20-2010 03:45 AM

Have you checked that MySQL itself is running properly?

JMEWLS` 11-20-2010 03:54 AM

Seems to be running fine.

Bradley_Wint 11-20-2010 03:59 AM

Verify there are no extra spaces in the username, database or password field. Also double check that the info is correct.

JMEWLS` 11-20-2010 04:17 AM

Quintuple checked, even re-download/entered the values in the config file. I'm blank.

KevinL 11-20-2010 04:23 AM

Means that there is to many connections to the database. Talk to your host about the connections.


All times are GMT. The time now is 11:39 PM.

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.01025 seconds
  • Memory Usage 1,722KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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