Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
Reload this Page MySQL Database errors
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-20-2012, 10:00 AM
NickTGA NickTGA is offline
 
Join Date: Apr 2012
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL Database errors
Hi all

I moved recently and for some reason the DB has errors. I imported and reimported 5 times and still there are errors. There were none prior to moving...

Anyway, wondering if any can help eradicate these for me?

Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 11:20:47 PM
Error Date    : Saturday, May 19th 2012 @ 11:20:47 PM
Script        : http://www.unrealkillers.com/
Referrer      : 
IP Address    : 10.20.4.59
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

Cannot use database unrealkl_forum

MySQL Error   : Access denied for user 'unrealkl_forum'@'localhost' to database 'unrealkl_forum'
Error Number  : 1044
Request Date  : Saturday, May 19th 2012 @ 10:57:34 PM
Error Date    : Saturday, May 19th 2012 @ 10:57:34 PM
Script        : http://www.unrealkillers.com/thanks.php?do=statistics
Referrer      : 
IP Address    : 66.249.73.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT 
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo_chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid) 
WHERE user.userid = 190;

MySQL Error   : Table 'unrealkl_forum.user' doesn't exist
Error Number  : 1146
Request Date  : Saturday, May 19th 2012 @ 10:22:26 PM
Error Date    : Saturday, May 19th 2012 @ 10:22:26 PM
Script        : http://www.unrealkillers.com/
Referrer      : 
IP Address    : 190.199.182.132
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin 4.1.12:

Invalid SQL:
SELECT userid, usergroupid, membergroupids, infractiongroupids, username, password, salt FROM user WHERE username = '|uK|SilverWing';

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Friday, May 18th 2012 @ 03:13:09 PM
Error Date    : Friday, May 18th 2012 @ 03:13:10 PM
Script        : http://www.unrealkillers.com/login.php?do=login
Referrer      : http://www.unrealkillers.com/modcp/index.php
IP Address    : 75.119.229.6
Username      : |uK|SilverWing
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
/home/unrealkillers/public_html/includes/class_core.php on line 317

MySQL Error   : 
Error Number  : 
Request Date  : Friday, May 18th 2012 @ 03:13:11 PM
Error Date    : Friday, May 18th 2012 @ 03:13:11 PM
Script        : http://www.unrealkillers.com/forumdisplay.php/33-Technical-Problems
Referrer      : 
IP Address    : 208.115.113.88
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT 
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_dbtech_vbsignatures AS phrasegroup_dbtech_vbsignatures,
language.phrasegroup_user AS phrasegroup_user,
language.phrasegroup_album AS phrasegroup_album,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo_chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid) 
WHERE user.userid = 1;

MySQL Error   : Unknown column 'language.phrasegroup_dbtech_vbsignatures' in 'field list'
Error Number  : 1054
Request Date  : Friday, May 18th 2012 @ 03:58:47 PM
Error Date    : Friday, May 18th 2012 @ 03:58:47 PM
Script        : http://www.unrealkillers.com/vbsignatures.php
Referrer      : 
IP Address    : 86.19.247.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:14:14 PM
Error Date    : Saturday, May 19th 2012 @ 08:14:14 PM
Script        : http://www.unrealkillers.com/
Referrer      : 
IP Address    : 200.85.212.123
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:19:00 PM
Error Date    : Saturday, May 19th 2012 @ 08:19:00 PM
Script        : http://www.unrealkillers.com/
Referrer      : http://www.unrealkillers.com/
IP Address    : 91.236.74.134
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:20:41 PM
Error Date    : Saturday, May 19th 2012 @ 08:20:41 PM
Script        : http://www.unrealkillers.com/
Referrer      : 
IP Address    : 201.241.82.36
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:21:56 PM
Error Date    : Saturday, May 19th 2012 @ 08:21:56 PM
Script        : http://www.unrealkillers.com/forum.php
Referrer      : 
IP Address    : 109.124.190.25
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:23:42 PM
Error Date    : Saturday, May 19th 2012 @ 08:23:42 PM
Script        : http://www.unrealkillers.com/showthread.php/930-IST-II-Player-Signup?p=17182&viewfull=1
Referrer      : 
IP Address    : 66.249.73.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:25:31 PM
Error Date    : Saturday, May 19th 2012 @ 08:25:31 PM
Script        : http://www.unrealkillers.com/forum.php
Referrer      : 
IP Address    : 86.19.247.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:28:00 PM
Error Date    : Saturday, May 19th 2012 @ 08:28:00 PM
Script        : http://www.unrealkillers.com/forum.php
Referrer      : 
IP Address    : 86.19.247.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:30:39 PM
Error Date    : Saturday, May 19th 2012 @ 08:30:39 PM
Script        : http://www.unrealkillers.com/showthread.php/930-IST-II-Player-Signup?p=16492&viewfull=1
Referrer      : 
IP Address    : 66.249.73.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 08:32:22 PM
Error Date    : Saturday, May 19th 2012 @ 08:32:22 PM
Script        : http://www.unrealkillers.com/showthread.php/930-IST-II-Player-Signup?p=15859&viewfull=1
Referrer      : 
IP Address    : 66.249.73.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,



post.pagetext AS description,
thread.*


FROM thread AS thread




LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


WHERE thread.threadid = 1959;

MySQL Error   : Table 'unrealkl_forum.thread' doesn't exist
Error Number  : 1146
Request Date  : Saturday, May 19th 2012 @ 08:41:15 PM
Error Date    : Saturday, May 19th 2012 @ 08:41:15 PM
Script        : http://www.unrealkillers.com/showthread.php/1959-Report
Referrer      : 
IP Address    : 66.249.73.18
Username      : Unregistered
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

Cannot use database unrealkl_forum

MySQL Error   : Access denied for user 'unrealkl_forum'@'localhost' to database 'unrealkl_forum'
Error Number  : 1044
Request Date  : Saturday, May 19th 2012 @ 10:19:57 PM
Error Date    : Saturday, May 19th 2012 @ 10:19:57 PM
Script        : http://www.unrealkillers.com/showthread.php/930-IST-II-Player-Signup?p=16365&viewfull=1
Referrer      : 
IP Address    : 66.249.73.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT 
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo_chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid) 
WHERE user.userid = 190;

MySQL Error   : Table 'unrealkl_forum.user' doesn't exist
Error Number  : 1146
Request Date  : Saturday, May 19th 2012 @ 10:22:26 PM
Error Date    : Saturday, May 19th 2012 @ 10:22:26 PM
Script        : http://www.unrealkillers.com/
Referrer      : 
IP Address    : 190.199.182.132
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

Cannot use database unrealkl_forum

MySQL Error   : Access denied for user 'unrealkl_forum'@'localhost' to database 'unrealkl_forum'
Error Number  : 1044
Request Date  : Saturday, May 19th 2012 @ 10:57:34 PM
Error Date    : Saturday, May 19th 2012 @ 10:57:34 PM
Script        : http://www.unrealkillers.com/thanks.php?do=statistics
Referrer      : 
IP Address    : 66.249.73.18
Username      : 
Classname     : vB_Database
MySQL Version :
Code:
Database error in vBulletin :

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

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, May 19th 2012 @ 11:20:47 PM
Error Date    : Saturday, May 19th 2012 @ 11:20:47 PM
Script        : http://www.unrealkillers.com/
Referrer      : 
IP Address    : 10.20.4.59
Username      : 
Classname     : vB_Database
MySQL Version :
So many errors...not sure why or how would really appreciate some assistance.
Reply With Quote
  #2  
Old 05-20-2012, 10:09 AM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
All the db error but 2 are related to permissions issues. Make sure that the db user has full permissions/access to the db.

The other 2 db errors are related to missing tables. It looks like you are missing the user and thread tables from the db. Can you check the db and see if those 2 tables are there or are indeed missing?
Reply With Quote
  #3  
Old 05-20-2012, 10:13 AM
Christos Teriakis Christos Teriakis is offline
 
Join Date: Jul 2011
Location: Thessaloniki, Greece
Posts: 1,228
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Have you updated includes/config.php with your new database settings?

Chris
Reply With Quote
  #4  
Old 05-20-2012, 10:18 AM
NickTGA NickTGA is offline
 
Join Date: Apr 2012
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Seems I posted prematurely

Even though I'd done it ealier, re-uploading a fresh config.php resolved all the issues for the time being.

Thanks for all your assistance guys
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 02:30 AM.

Contact Us - Archive - Top

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.04176 seconds
  • Memory Usage 2,220KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (20)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete