Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 20 Dec 2011, 17:31
[email protected] p@ndu is offline
 
Join Date: Jan 2009
Getting mysql errors

Hi Guys

my forum i recently updated to 4.1.9 versions and i am getting all this error notifications via email i will be thankfull if some one help me to solve them

Error 1:

Database error in vBulletin 4.1.9:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '66.249.66.11', 1, 'Emperor', '', 'post.dateline', 'DESC', 0.00162, 1, '12060,12030,11926,11862,11833,11779', 1324394595, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"use rs\";a:1:{i:3;s:7:\"Emperor\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"st arteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', '72da748794b3b9dff864e7cc822fcac9');


Error Number : 1146
Request Date : Tuesday, December 20th 2011 @ 08:53:15 PM
Error Date : Tuesday, December 20th 2011 @ 08:53:15 PM
do=findthanks_user_gave&u=3[/url]
Referrer :
IP Address : 66.249.66.11
Username : Unregistered
Classname : vB_Database
MySQL Version :

Error 2:

Database error in vBulletin 4.1.9:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_awclsoftware AS phrasegroup_awclsoftware,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_awclsoftware' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 20th 2011 @ 10:26:33 PM
Error Date : Tuesday, December 20th 2011 @ 10:26:33 PM
Referrer :
IP Address : 66.249.66.131
Username :
Classname : vB_Database
MySQL Version :
Eroor 3 :

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/******/public_html/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Saturday, December 17th 2011 @ 01:48:42 PM
Error Date : Saturday, December 17th 2011 @ 01:48:42 PM
Referrer :
IP Address : 66.249.71.210
Username :
Classname : vB_Database
MySQL Version :

Last edited by [email protected]; 18 Jun 2013 at 15:13.
Reply With Quote
  #2  
Old 20 Dec 2011, 20:25
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Errors 1 and 2 look like you probably have mods that are no longer compatible. (There is no "search" table, and the missing column from error #2 looks like an add-on).

If you keep seeing error #3 you should contact your host and ask them about it.
Reply With Quote
  #3  
Old 21 Dec 2011, 03:45
[email protected] p@ndu is offline
 
Join Date: Jan 2009
Hi

As you said those mods aren't supported i removed them but after that got this errors and how to resolve the search table problem

Error 4:

Database error in vBulletin 4.1.9:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (184437) ORDER BY post_thanks.username ASC;


Error Number : 1146
Request Date : Wednesday, December 21st 2011 @ 02:20:39 AM
Error Date : Wednesday, December 21st 2011 @ 02:20:39 AM
Referrer :
IP Address : 66.249.66.131
Username : Unregistered
Classname : vB_Database
MySQL Version :
Error 5 :


Database error in vBulletin 4.1.9:

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_awclsoftware AS phrasegroup_awclsoftware,
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

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))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_awclsoftware' in 'field list'
Error Number : 1054
Request Date : Wednesday, December 21st 2011 @ 09:06:26 AM
Error Date : Wednesday, December 21st 2011 @ 09:06:26 AM
IP Address : 124.***.***.***
Username :
Classname : vB_Database
MySQL Version :

and as for error : 3 i am hosting on a vps and are their any settignns i must edit to resolve it

Thank you

Last edited by [email protected]; 18 Jun 2013 at 15:14.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 10:47.

Layout Options | Width: Wide Color: