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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-30-2008, 05:53 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default [help] im always get min 300message/day (database error)

hello im always get 300 messages minimum/day.
message is : error.

Its the sample :

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/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Friday, May 30th 2008 @ 02:49:16 PM
Error Date : Friday, May 30th 2008 @ 02:49:17 PM
Script : http://anakayam.us/forum/showthread.php?t=10412
Referrer : http://anakayam.us/forum/indonesian-...er/index2.html
IP Address : 125.163.208.178
Username :
Classname : vB_Database
MySQL Version :

--------------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/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Friday, May 30th 2008 @ 02:49:14 PM
Error Date : Friday, May 30th 2008 @ 02:49:15 PM
Script : http://anakayam.us/forum/forumdisplay.php?f=18
Referrer : http://anakayam.us/forum/
IP Address : 125.163.7.157
Username :
Classname : vB_Database
MySQL Version :==========
======================
Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT *
FROM bbcode;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 30th 2008 @ 02:49:10 PM
Error Date : Friday, May 30th 2008 @ 02:49:14 PM
Script : http://anakayam.us/forum/indonesian-bugil-cover/
Referrer : http://anakayam.us/forum/
IP Address : 222.124.219.54
Username : gauzkeren
Classname : vB_Database
MySQL Version :
===================
Database error in vBulletin 3.7.0:

Invalid SQL:

UPDATE session
SET lastactivity = 1212173406, location = '/forum/', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.6;MEGAUPLOAD 1.0'
WHERE sessionhash = '2eef7daac48dba5fb6ea371c2ef75f62';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 30th 2008 @ 02:50:06 PM
Error Date : Friday, May 30th 2008 @ 02:50:18 PM
Script : http://anakayam.us/forum/
Referrer : http://anakayam.us/forum/
IP Address : 203.89.24.230
Username : Unregistered
Classname : vB_Database
MySQL Version :
===================
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/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Friday, May 30th 2008 @ 02:50:17 PM
Error Date : Friday, May 30th 2008 @ 02:50:18 PM
Script : http://anakayam.us/forum/showthread.php?t=57
Referrer : http://anakayam.us/forum/setengah-baya/
IP Address : 202.59.166.78
Username :
Classname : vB_Database
MySQL Version :
========================Database error in vBulletin 3.7.0:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('7fcd0b5937fd2656d9040d8c6a516c5c', 14418, '125.163.7.157', '4e2a8730267cc25f2374b5ebc92ecc15', 1212173404, '/forum/showthread.php?t=994', 0, 0, 1, 97, 994, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14;MEGAUPLOAD 1.0', 0, 0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 30th 2008 @ 02:50:04 PM
Error Date : Friday, May 30th 2008 @ 02:50:13 PM
Script : http://anakayam.us/forum/how-profess...dari-pink.html
Referrer : http://anakayam.us/forum/how-profess...ri-pink-4.html
IP Address : 125.163.7.157
Username : bexaloy
Classname : vB_Database
MySQL Version :
if i get error message in email . my guest always reset to 0 (kickout from my site)
im confused about this.
if im reinstall my forum in to vb.3.7.1,is my problem solved or not ?

thanks
how i can fixed this?
Reply With Quote
  #2  
Old 05-30-2008, 06:04 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If your Guest list is always being reset, or 'erased', then I am guessing mysql is reseting itself. You need to look in your mysql error logs to see if this is happening. (I could have sworn you already posted about this and I suggested the exact same thing. edit: I did - Sometimes my guest always Kick Out)

For more reading about the errors:

MySQL Server has gone away: http://www.vbulletin.com/docs/html/t...mysql_goneaway

MySQL can't connect: http://www.vbulletin.com/docs/html/cantconnect
Reply With Quote
  #3  
Old 05-30-2008, 06:08 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im not familiar with that.and my host support say thats nothing error in mysql vbulletin log.

how about if im upgrade my vbulletin in to vb.3.7.1 its my problem sovled?
Reply With Quote
  #4  
Old 05-30-2008, 06:20 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by geevest.com View Post
how about if im upgrade my vbulletin in to vb.3.7.1 its my problem sovled?
No.
Reply With Quote
  #5  
Old 05-31-2008, 08:26 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Check the uptime for MySQL. Most likely it gets restarted often.

PS My guess is that your host is not telling the complete truth.
Reply With Quote
  #6  
Old 06-01-2008, 12:54 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

until now my host support says its because vbulletin.not my host.
what should i do for this?
Reply With Quote
  #7  
Old 06-01-2008, 12:59 PM
toonysnn toonysnn is offline
 
Join Date: Sep 2006
Location: Texas
Posts: 511
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It is your host. MySQL problems are server sided, most of the time.
Are you on a shared, VPS/VDS, or dedicated server?
Reply With Quote
  #8  
Old 06-02-2008, 02:49 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im using dedicated server.
maybe this thread problem move to : https://vborg.vbsupport.ru/showthread.php?t=181223
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 11:20 PM.


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.07835 seconds
  • Memory Usage 2,235KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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
  • 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