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
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2009, 12:20 PM
Hengis Hengis is offline
Junior Member
 
Join Date: Apr 2008
Posts: 17
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Question MySQL error every day

Hi there.

I receive a single MySQL error every day at exactly 3:09am.
Quote:
Database error in vBulletin 3.8.1:

Invalid SQL:
CREATE TABLE vb_GAB_temp_stats
SELECT gabid,typeid,m,d,y,script,forum,sum(count) `count`,dateline FROM `vb_GAB_stats`
GROUP BY gabid,typeid,m,d,y,script,forum,dateline;

MySQL Error : Error writing file '/tmp/MYNTjWFr' (Errcode: 28)
Error Number : 3
Request Date : Sunday, December 6th 2009 @ 03:03:20 AM
Error Date : Sunday, December 6th 2009 @ 03:09:10 AM
Script :
Could you please help me with this?
Reply With Quote
  #2  
Old 12-09-2009, 05:01 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

Error code 28 means that there is "no space left on device" i.e., one or more partitions on your server is out of space or doesn't have enough space to complete the operation. My guess is that your vb_GAB_stats table is very large so the vb_GAB_temp_stats cannot be created because the server doesn't have enough space. You can either ask your host to give you more space, or you'll need to run these queries to delete the stats and start over as there isn't enough room to compress the stats:
Code:
# warning: deletes all statistics data !!!!
DROP TABLE IF EXISTS vb_GAB_temp_stats;
TRUNCATE TABLE vb_GAB_stats;
__________________
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 12-09-2009, 05:14 PM
Hengis Hengis is offline
Junior Member
 
Join Date: Apr 2008
Posts: 17
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Thank you Morgan.

Is there a way to deactivate the stats and then re-activate them in the future if needed?
Reply With Quote
  #4  
Old 12-09-2009, 05:55 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

Go to the ACP -> GAB -> Banners and for each banner listed, there are the Track Impressions and Track Clickthroughs options that you can set to no to not track stats, but even if you do that, you will probably still get the database error message because the vb_GAB_stats table already contains data.
__________________
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 12-09-2009, 06:00 PM
Hengis Hengis is offline
Junior Member
 
Join Date: Apr 2008
Posts: 17
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Ok, thanks.

Is it perfectly safe for the rest of my site if I drop that table?
Reply With Quote
  #6  
Old 12-09-2009, 06:12 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

You do not want to drop the vb_GAB_stats table. You do want to run the queries in post two if you want to delete the stats and start fresh with new stats.
__________________
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 12-09-2009, 06:14 PM
Hengis Hengis is offline
Junior Member
 
Join Date: Apr 2008
Posts: 17
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Yes, I think I should.

I have 4,166,467 records in vb_GAB_stats.

Is it best to run them from PHPMyAdmin or from within the VB ACP?
Reply With Quote
  #8  
Old 12-09-2009, 06:19 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

Nope, you do not want to drop the vb_GAB_stats table. Run the two queries in post two. That'll do the right thing. You can run the queries from phpMyAdmin if you want.
__________________
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
  #9  
Old 12-09-2009, 06:21 PM
Hengis Hengis is offline
Junior Member
 
Join Date: Apr 2008
Posts: 17
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Right, I will do what is in post 2 now.

Thank you for your support.
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
Getting mysql error truCido Geek Advertising Banner System 6 08-11-2008 08:27 AM
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 05:47 PM.


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