AbanteCart Community

Shopping Cart Operations => Support => Topic started by: popustda on September 21, 2015, 05:47:09 AM

Title: !MySQL Database size exceeded!
Post by: popustda on September 21, 2015, 05:47:09 AM
Hello guys,
Can someone please help me with this. I reached my limit of 1GB and i dont know why my _banner_stat_ is 0,9GB big. What is inside it and how can i clean it without damaging my webshop?
i am attaching the pic so you can see my problem.
Please some1 help me solve this
Title: Re: !MySQL Database size exceeded!
Post by: abolabo on September 21, 2015, 07:10:12 AM
you can remove data from this table manually, via phpMyAdmin.
just run
Code: [Select]
DELETE FROM 9u9_banner_stat;
Title: Re: !MySQL Database size exceeded!
Post by: popustda on September 21, 2015, 10:55:08 AM
and this will not affect my website functionality?
Title: Re: !MySQL Database size exceeded!
Post by: Basara on September 22, 2015, 01:56:05 AM
The DELETE statement is used to delete records from a table. So your banner statistics will be removed.
Please backup before run this query
Title: Re: !MySQL Database size exceeded!
Post by: helperbee on October 02, 2015, 12:04:12 PM
I think I should clear out Banner Statistics now that the shop is live so that we have more accurate view and conversion count.

Is the new name of the table ab_banner_stat?  My version of AbanteCart is 1.2.2.

If so, then is this the correct command to clear the table? (Yes, my first time using phpMyAdmin).

DELETE FROM ab_banner_stat;

I couldn't find another way from the Admin Dashboard to reset the banner stats. Thanks for your assistance.
Title: Re: !MySQL Database size exceeded!
Post by: abolabo on October 02, 2015, 03:54:53 PM
we already added this functionality in our todo-list. Will be