Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 10-22-2011, 10:59 AM
temsamane temsamane is offline
 
Join Date: Sep 2010
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 3 Database Errors After 4.1.7 Upgrade

Please help me with these database errors. What are the reasons of these errors? i think each error has another reason.

error 1:

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/******.nl/forums/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Friday, October 21st 2011 @ 10:08:01 AM
Error Date : Friday, October 21st 2011 @ 10:08:01 AM
Script : http://www.******.nl/forums/forum.php
Referrer :
IP Address : support@search.yandex.ru
Username :
Classname : vB_Database
MySQL Version :

error 2:

Quote:
Database error in vBulletin 4.1.7:

Invalid SQL:

UPDATE vfsession
SET lastactivity = 1319231618, badlocation = 0, useragent = 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1'
WHERE sessionhash = '59f010769923f9ba8f21c462243fc02e';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, October 21st 2011 @ 02:13:38 PM
Error Date : Friday, October 21st 2011 @ 02:14:08 PM
Script : http://www.******.nl/forums/admincp/...?do=dosendmail
Referrer : http://www.******.nl/forums/admincp/email.php?do=start
IP Address : 87.211.145.19
Username : admin
Classname : vB_Database
MySQL Version :

error 3:

Quote:
Database error in vBulletin 4.1.7:

Invalid SQL:

SELECT text, languageid, special
FROM vfphrase AS phrase
LEFT JOIN vfphrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
AND varname = 'registeremail' AND languageid IN (-1, 0, 2);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, October 21st 2011 @ 03:00:07 PM
Error Date : Friday, October 21st 2011 @ 03:00:23 PM
Script : http://www.******.nl/forums/register.php?do=addmember
Referrer : http://www.******.nl/forums/register.php
IP Address : 82.156.55.38
Username : Jack'
Classname : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 10-22-2011, 01:19 PM
Reycer Reycer is offline
 
Join Date: Jul 2008
Location: Lebanon, MO (USA)
Posts: 747
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your MYSQL is timing out. You need to reset your timeout on your MYSQL to something higher. You'll need to contact your host provider to have this done.

This read might help you HERE
Reply With Quote
Благодарность от:
temsamane
  #3  
Old 10-22-2011, 09:59 PM
temsamane temsamane is offline
 
Join Date: Sep 2010
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Reycer View Post
Your MYSQL is timing out. You need to reset your timeout on your MYSQL to something higher. You'll need to contact your host provider to have this done.

This read might help you HERE
thank you reycer, you give me the right answer! thnx!
Reply With Quote
  #4  
Old 10-22-2011, 11:49 PM
Reycer Reycer is offline
 
Join Date: Jul 2008
Location: Lebanon, MO (USA)
Posts: 747
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

no problem.
Reply With Quote
Reply

Thread Tools
Display Modes

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 01:04 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.14410 seconds
  • Memory Usage 2,188KB
  • 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
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (1)post_thanks_box_bit
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete