The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Advertising Banner System

Geek Advertising Banner System GAB is a highly configurable banner management system for vBulletin.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2008, 09:50 PM
truCido truCido is offline
Junior Member
 
Join Date: Dec 2005
Posts: 19
Geek Advertising Banner License Holder 
Default Getting mysql error

Hi, I've used GAB in the past and recently bought a new license and installed it again however I am having a few problems. since I installed the script my host has restricted my hosting and said that my site is causing the server to fall over.

I'm getting hundreds of emails with the below error:

Code:
Invalid SQL:
SELECT id,img,views,url,type,trackviews,trackhits,html,frequency,title,height,width,catid,templatetype
                       FROM GAB_ads
                       WHERE isactive = 1 AND (scripts = '||' OR scripts = '' OR scripts LIKE '%|showthread|%')
                        AND (forums LIKE '%|7|%' OR forums = '' OR forums = '||')  AND (startdate<9000 || startdate<1218144914) AND (enddate<9000 || enddate>1218144914);

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Thursday, August 7th 2008 @ 05:35:14 PM
Error Date    : Thursday, August 7th 2008 @ 05:37:15 PM
Script        : http://www.vag******.co.uk/forums/showthread.php?t=7423
Referrer      :
IP Address    : **.**.**.**
Username      : Unregistered
Classname     : vb_database
MySQL Version :
Reply With Quote
  #2  
Old 08-08-2008, 04:02 AM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Seems like a server issue, especially so as your host restricted your hosting. There is nothing wrong with that query assuming you don't have a billion ads. Maybe your host will tell you what about your site is bothering the server, but if not and you remain restricted, chances are that you will get more "MySQL server has gone away" messages on other queries, not just those related to GAB . Here are some links that might help you:
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #3  
Old 08-08-2008, 10:07 AM
truCido truCido is offline
Junior Member
 
Join Date: Dec 2005
Posts: 19
Geek Advertising Banner License Holder 
Default

Thanks Morgan, but only when I activate GABS do I get any errors.

I would assume its something to do with the query being quite large and it closing the connection (although the query does actually complete)
Reply With Quote
  #4  
Old 08-08-2008, 01:53 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Run the following query and copy-paste the output here. Also check the links in the previous post:
Code:
EXPLAIN SELECT id,img,views,url,type,trackviews,trackhits,html,frequency,title,height,width,catid,templatetype
FROM GAB_ads
WHERE isactive = 1 AND (scripts = '||' OR scripts = '' OR scripts LIKE '%|showthread|%')
AND (forums LIKE '%|7|%' OR forums = '' OR forums = '||')  AND (startdate<9000 || startdate<1218144914) AND (enddate<9000 || enddate>1218144914);
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #5  
Old 08-08-2008, 06:47 PM
truCido truCido is offline
Junior Member
 
Join Date: Dec 2005
Posts: 19
Geek Advertising Banner License Holder 
Default

Yeah because I dont have control of the server really theres not much I can do, so I've changed my host! Will keep you updated on how it goes...

Code:
id 	select_type 	table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
1 	SIMPLE 	GAB_ads 	ALL 	NULL 	NULL 	NULL 	NULL 	2 	Using where
Reply With Quote
  #6  
Old 08-09-2008, 03:26 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

It looks like there are only two rows in the table being queried, so I cannot see how that would cause a "MySQL server has gone away" message. Hopefully things work out with your new host.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #7  
Old 08-11-2008, 08:27 AM
truCido truCido is offline
Junior Member
 
Join Date: Dec 2005
Posts: 19
Geek Advertising Banner License Holder 
Default

Quote:
Originally Posted by Morgan View Post
It looks like there are only two rows in the table being queried, so I cannot see how that would cause a "MySQL server has gone away" message. Hopefully things work out with your new host.
Yeah its absolutely fine on my new host, very strange must of been the timeout settings on the old server. Thanks for your help
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL error every day Hengis Geek Advertising Banner System 8 12-09-2009 06:21 PM
mysql error during restore clearchannel Geek Article and Review System 23 01-23-2007 06:38 PM
Mysql error after reinstall? CAMS GeekMart 11 07-03-2006 01:10 AM
Products - Items MySQL Error... DerTobi75 GeekMart 21 12-07-2005 12:20 PM
[fixed][3.0.8] - Vendor mysql db error GoTTi GeekMart 4 08-23-2005 09:53 PM


All times are GMT. The time now is 01:58 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.