|
Geek Advertising Banner System GAB is a highly configurable banner management system for vBulletin. |
Advertisement | |
Learn how to remove ads |
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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 : |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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) |
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
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 |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
Yeah its absolutely fine on my new host, very strange must of been the timeout settings on the old server. Thanks for your help
|
Thread Tools | |
Display Modes | |
|
|
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 |