Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2011, 04:31 PM
p@ndu p@ndu is offline
 
Join Date: Jan 2009
Posts: 260
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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:

Quote:
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:\"users\";a:1:{i:3;s:7:\" Emperor\";}s:6:\"forums\";i:0;s:7:\"options\";a:3: {s:11:\"starteronly\";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:

Quote:
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 :

Quote:
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 :
Reply With Quote
  #2  
Old 12-20-2011, 07:25 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 12-21-2011, 02:45 AM
p@ndu p@ndu is offline
 
Join Date: Jan 2009
Posts: 260
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:

Quote:
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 :


Quote:
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
Reply With Quote
Reply


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 09:42 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.09778 seconds
  • Memory Usage 2,194KB
  • Queries Executed 13 (?)
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
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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_postinfo_query
  • fetch_postinfo
  • 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