Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 08-31-2008, 01:04 PM
stickskills stickskills is offline
 
Join Date: May 2008
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Logout/Query issue.. help!

Alright, I've tried contacting vBulletin.. and changing around the cookie issues on my vBulletin forums within the options, but that didn't work, so PLEASE do not tell me that's the issue as I've even had the vB staff go in and tinker around, and to no avail, the problem persists haha.

Here's the SQL query error that I persistently keep getting. I probably get about 5-15 a day, and apparently these are behind the users getting logged out, and having trouble staying logged in quite a few times a day. If anyone can help, I'm sure I can think of a way to repay you.

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*


FROM ss_post AS post
LEFT JOIN ss_user AS user ON(user.userid = post.userid)
LEFT JOIN ss_userfield AS userfield ON(userfield.userid = user.userid)

WHERE threadid = 7328

ORDER BY postid;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Friday, August 29th 2008 @ 10:04:57 PM
Error Date : Friday, August 29th 2008 @ 10:04:59 PM
Script : http://www.stickskills.com/forum/sho...=hybrid&t=7328
Referrer :
IP Address : (hiding)
Username : Unregistered
Classname : vB_Database
MySQL Version :


I did an import using Impex from a Invision Power Board to a vBulletin board awhile back, not sure if that's going to be helpful at all.
Reply With Quote
  #2  
Old 08-31-2008, 03:11 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

A Lost Connect to MySQL error is a server error. Have you thought of having your server optimized in the Server Configuration forum?
Reply With Quote
  #3  
Old 08-31-2008, 03:26 PM
stickskills stickskills is offline
 
Join Date: May 2008
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm running it from a hosting company, so I wouldn't have direct access to the server, unless there was another way?

I had thought it was just an error with the installation, and was contemplating on just redoing the entire forum and then re-importing the data.
Reply With Quote
  #4  
Old 08-31-2008, 03:41 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway" target="_blank">Lost connection to MySQL server during query</a> - Contact your host if need be.
Reply With Quote
  #5  
Old 08-31-2008, 04:00 PM
stickskills stickskills is offline
 
Join Date: May 2008
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just sent them an e-mail, but would doing the board from scratch help out at all? I was contemplating doing that and then just reimporting the data.
Reply With Quote
  #6  
Old 09-01-2008, 06:53 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by stickskills View Post
but would doing the board from scratch help out at all?
No. This is an issue with the MySQL daemon/server.
Reply With Quote
  #7  
Old 09-01-2008, 03:53 PM
stickskills stickskills is offline
 
Join Date: May 2008
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The issue was the database was coming from one thread, so I locked the thread, and moved it over to a locked thread board within my forums.

The login issue still persists though, and I have absolutely no idea what's causing it. :/

--------------- Added [DATE]1220328708[/DATE] at [TIME]1220328708[/TIME] ---------------

Does anyone have any suggestions at all? I've tried everything I know so far, and can't figure this out..
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 11:40 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.07626 seconds
  • Memory Usage 2,213KB
  • 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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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