View Single Post
  #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
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01249 seconds
  • Memory Usage 1,852KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (20)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete