|
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
|
|||
|
|||
MySQL error every day
Hi there.
I receive a single MySQL error every day at exactly 3:09am. Quote:
|
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thank you Morgan.
Is there a way to deactivate the stats and then re-activate them in the future if needed? |
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
Ok, thanks.
Is it perfectly safe for the rest of my site if I drop that table? |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
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? |
#8
|
||||
|
||||
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 |
#9
|
|||
|
|||
Right, I will do what is in post 2 now.
Thank you for your support. |
Thread Tools | |
Display Modes | |
|
|
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 |