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
  #11  
Old 02-11-2008, 06:50 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

Correct, emptying the GAB_temp_stats table does not affect the GAB_ads table. The 'views' and 'hits' fields in the GAB_ads table get updated when the vB cron job runs.
__________________
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
  #12  
Old 02-16-2008, 09:04 PM
KenDude KenDude is offline
Senior Member
 
Join Date: Nov 2006
Posts: 176
GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Morgan,
The reason I thought I needed to clean this out was because from admincp -> database backup -> backup to file on server

When I run that it starts off by doing
GAB_ads
GAB_cats

Then nothing. I can let it sit for a long long time and nothing... I figured it was because my table had grown to a really large size after a year plus, but deleting the old info out of the table as you suggested got the table size down to about 4-5mb, nothing huge, but yet the database backup still bombs out. I've tried using the database fix table tool several times just to make sure the tables are ok and they all are as far as I can tell.

6 months or more ago this used to work because I would do it once a week or so, then at some point months ago it quit working and I always assumed it was because that GAB_Stats table which is the next on the list had grown too large to backup in that method or something.

Fortunately my ISP does nightly backups and I could ask them to recover one of those, but I sort of liked doing my own backups through the admincp tool.

Any suggestions?
Reply With Quote
  #13  
Old 02-21-2008, 06:35 PM
KenDude KenDude is offline
Senior Member
 
Join Date: Nov 2006
Posts: 176
GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Morgan,
You still around? Everything OK?
Reply With Quote
  #14  
Old 02-21-2008, 11:11 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

Thanks for asking, yes I am doing better. Sorry but I had to be AFK for a bit. Understandably it upset a few people, and I'm not going to say anymore on it other than sometimes life is very difficult. As to your question, are you trying to make a backup of the entire database? If so, doing backups via the ACP is not really the way to go, especially for large forums. Please http://www.vbulletin.com/docs/html/m...atabase_backup for backup options and http://www.vbulletin.com/forum/showp...78&postcount=3 for a bit more information on why doing backups via the ACP may not work.
__________________
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
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
GAB and GAB Stats for vB4 have been released Morgan Announcements 0 05-19-2010 02:58 AM
Advertisers can now see their GAB stats Morgan Announcements 6 08-22-2009 03:56 PM
No stats Noodles Geek Auto-Linker 3 07-03-2007 09:19 AM
Clearing removed articles BobdeBilder Geek Article and Review System 3 04-12-2006 05:34 PM
No stats ? ? rose Geek Advertising Banner System 1 12-10-2005 06:22 PM


All times are GMT. The time now is 09:26 PM.


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