BUZZPURGE (purge your bt_api_requests table instantly from control panel)

Get Started | Login

Discussion Forums > Self Hosted Control Panels

Replies: 3 Views: 90

mrDavid BTMods.com Posts: 3936 Reg: May 21, 2011 San Diego, CA 51,910	confirm \| cancel 08/03/12 10:11 PM (13 years ago) BUZZPURGE (purge your bt_api_requests table instantly from control panel) Hi all, just released this modification, enjoy! ---------------------------------------------------------------- DESCRIPTION ---------------------------------------------------------------- * A modification to your buzztouch server to enable easy and fast purge (deletion) for your mysql database bt_api_requests table directly from your bt-server control panel. Please see screenshot and instructions. The bt_api_requests table in the mySQL database can grow to extraordinary numbers. It's not unheard of for this tables to hold many millions of rows. Depending on your hardware and other server variables, this may or may not pose a problem. However, low-cost, low-performance webservers may experience a performance hit if the size of the table grows too large. In this case, you'll want to consider purging this data ocassionally. Before purging the data, you'll want to carefully consider it's usefullness. Do you need to keep a copy for later reference? Reporting? Analytics? - [email protected] (not endorsing this mod or this site at all) -------------------------------------------------------------- SCREENSHOT --------------------------------------------------------------- https://buzztouchmods.com/downloads/images/purge.png --------------------------------------------------------------- DOWNLOAD THIS MOD ---------------------------------------------------------------- ** DOWNLOAD BUZZPURGE: https://buzztouchmods.com/downloads.php?cat_id=2&download_id=44 * see our BUZZBACKUP modification here! https://buzztouchmods.com/downloads.php?cat_id=2&download_id=35 ---------------------------------------------------------------- TO INSTALL: ---------------------------------------------------------------- 1. OPEN buzzpurge.php AND EDIT LINE 10 AND 11 WITH YOUR BUZZ SERVER DATABASE INFO. 2. PLACE buzzpurge.php IN YOUR SERVER ROOT FOLDER (bt-server/buzzpurge.php) 3. REPLACE maintenance.php IN YOUR SERVER FOLDER (bt-server/admin/maintenance.php) DONE! ---------------------------------------------------------------- TO USE: ---------------------------------------------------------------- 1. Login as ADMIN on your buzz server. 2. GO TO Admin > System Maintenance > Purge massive database tables (BUZZPURGE) 3. CLICK PURGE DATABASE. DONE! Thanks! MrDavid (Follow me on buzztouch!) http://www.buzztouch.com/MrDavid ** DOWNLOAD: https://buzztouchmods.com/downloads.php?cat_id=2&download_id=44 ---------------------------------------------------------------- IMPORTANT NOTES: ---------------------------------------------------------------- 1. If your table is not bt_api_requests (standard), and its maybe MYSITE_api_requests - it will not work. To fix this, edit buzzpurge.php and edit line 19: MYSITE_api_requests 2. If your using BUZZBACKUP as well, use the maintenance.php file below instead of the one included in this download, as that will show both options (buzzpurge and buzzbackup) in your control panel. here: https://buzztouchmods.com/downloads/maintenance_both.zip Thank you! David buzztouchmods.com Title Comments Hi all, just released this modification, enjoy! ---------------------------------------------------------------- DESCRIPTION ---------------------------------------------------------------- * A modification to your buzztouch server to enable easy and fast purge (deletion) for your mysql database bt_api_requests table directly from your bt-server control panel. Please see screenshot and instructions. The bt_api_requests table in the mySQL database can grow to extraordinary numbers. It's not unheard of for this tables to hold many millions of rows. Depending on your hardware and other server variables, this may or may not pose a problem. However, low-cost, low-performance webservers may experience a performance hit if the size of the table grows too large. In this case, you'll want to consider purging this data ocassionally. Before purging the data, you'll want to carefully consider it's usefullness. Do you need to keep a copy for later reference? Reporting? Analytics? - David@Buzztouch.com (not endorsing this mod or this site at all) -------------------------------------------------------------- SCREENSHOT --------------------------------------------------------------- https://buzztouchmods.com/downloads/images/purge.png --------------------------------------------------------------- DOWNLOAD THIS MOD ---------------------------------------------------------------- ** DOWNLOAD BUZZPURGE: https://buzztouchmods.com/downloads.php?cat_id=2&download_id=44 * see our BUZZBACKUP modification here! https://buzztouchmods.com/downloads.php?cat_id=2&download_id=35 ---------------------------------------------------------------- TO INSTALL: ---------------------------------------------------------------- 1. OPEN buzzpurge.php AND EDIT LINE 10 AND 11 WITH YOUR BUZZ SERVER DATABASE INFO. 2. PLACE buzzpurge.php IN YOUR SERVER ROOT FOLDER (bt-server/buzzpurge.php) 3. REPLACE maintenance.php IN YOUR SERVER FOLDER (bt-server/admin/maintenance.php) DONE! ---------------------------------------------------------------- TO USE: ---------------------------------------------------------------- 1. Login as ADMIN on your buzz server. 2. GO TO Admin > System Maintenance > Purge massive database tables (BUZZPURGE) 3. CLICK PURGE DATABASE. DONE! Thanks! MrDavid (Follow me on buzztouch!) http://www.buzztouch.com/MrDavid ** DOWNLOAD: https://buzztouchmods.com/downloads.php?cat_id=2&download_id=44 ---------------------------------------------------------------- IMPORTANT NOTES: ---------------------------------------------------------------- 1. If your table is not bt_api_requests (standard), and its maybe MYSITE_api_requests - it will not work. To fix this, edit buzzpurge.php and edit line 19: MYSITE_api_requests 2. If your using BUZZBACKUP as well, use the maintenance.php file below instead of the one included in this download, as that will show both options (buzzpurge and buzzbackup) in your control panel. here: https://buzztouchmods.com/downloads/maintenance_both.zip Thank you! David buzztouchmods.com

Fred@mySkylla com Android Fan Posts: 5259 Reg: Oct 03, 2011 location unknow... 62,560	08/03/12 11:14 PM (13 years ago) Super excellent. Fred Comments Super excellent. Fred

xtremeesolutions Code is Art Posts: 106 Reg: Nov 19, 2011 FootHill Ranch,... 6,610	12/06/12 01:49 AM (13 years ago) Hi David, This message is showing on my self hosted control panel. {"result":"invalid", "message":"serverError", "fromDavid":"Have a look at line 68 config.php in the root of your install, the software is having trouble with your database settings"} When I check my Server that It shows that your bt_api_requests table has been corrupted. So Can I purge this table. Please tell me what type of data is stored in this table and how much important it is. I am not able to work on BT server because of this error so please suggest me. Thanks Rakesh Comments Hi David, This message is showing on my self hosted control panel. {"result":"invalid", "message":"serverError", "fromDavid":"Have a look at line 68 config.php in the root of your install, the software is having trouble with your database settings"} When I check my Server that It shows that your bt_api_requests table has been corrupted. So Can I purge this table. Please tell me what type of data is stored in this table and how much important it is. I am not able to work on BT server because of this error so please suggest me. Thanks Rakesh

xtremeesolutions Code is Art Posts: 106 Reg: Nov 19, 2011 FootHill Ranch,... 6,610	12/06/12 02:36 AM (13 years ago) Hi David, This message is showing on my self hosted control panel. {"result":"invalid", "message":"serverError", "fromDavid":"Have a look at line 68 config.php in the root of your install, the software is having trouble with your database settings"} When I check my Server that It shows that your bt_api_requests table has been corrupted. So Can I purge this table. Please tell me what type of data is stored in this table and how much important it is. I am not able to work on BT server because of this error so please suggest me. Thanks Rakesh Comments Hi David, This message is showing on my self hosted control panel. {"result":"invalid", "message":"serverError", "fromDavid":"Have a look at line 68 config.php in the root of your install, the software is having trouble with your database settings"} When I check my Server that It shows that your bt_api_requests table has been corrupted. So Can I purge this table. Please tell me what type of data is stored in this table and how much important it is. I am not able to work on BT server because of this error so please suggest me. Thanks Rakesh

Login + Screen Name Required to Post Login to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.