PDA

View Full Version : MySQL Database errors


NickTGA
05-20-2012, 10:00 AM
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?

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 :


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 :

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 :

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 :

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 :


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 :

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 :


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 :


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 :


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 :


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 :


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 :


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 :


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 :


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 :


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 :


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 :


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 :

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 :



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.

borbole
05-20-2012, 10:09 AM
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?

Christos Teriakis
05-20-2012, 10:13 AM
Have you updated includes/config.php with your new database settings?

Chris

NickTGA
05-20-2012, 10:18 AM
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