[BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Get Involved
User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by DoYouSpeakWak » Sat Mar 28, 2009 12:09 am

Yes we do. :D

Personally i would run the cleaner on 3.0.3, then the db_update.php from a 3.0.3 (do this no matter what you do btw), update it two 3.0.4 add the mods you need. Delete your current 3.0.4 and copy the newly updated 3.0.4 to its location.

Im not sure you can just move the database over to a diffrent board. iwe newer done it. Since the data you need are on the 3.0.3 i see no reason to do this. Work on one board and move it. Safest solution imo.

As mentioned in the first post in this topic. that download only works up to 3.0.2, there have been changes in the standard phpbb3 database since then so you need to use the one i posted. it works with all 3.0.X versions.

Remember them backups :P
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

the.ronin
Registered User
Posts: 184
Joined: Sun Oct 05, 2008 10:53 pm

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by the.ronin » Sat Mar 28, 2009 1:27 pm

DoYouSpeakWak wrote:... then the db_update.php from a 3.0.3 (do this no matter what you do btw) ...
Ah yes, thank you for this. I need to download the 3.03 to 3.04 automatic update package and use the db_update.php from there in the 3.03 build, right?

User avatar
Hippie459MN
Registered User
Posts: 917
Joined: Mon Oct 15, 2007 10:13 pm
Location: Minnesota, USA
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by Hippie459MN » Sun May 10, 2009 11:42 pm

DoYouSpeakWak wrote:I love this way of cleaning my site. So i made a update.

This have been tested on fresh installs of 300,301,302,303,304 with no errors.

http://psyhosting.info/Clean_SQL.rar

Also works on updated sites. tryed to do the 300, update it to 301, run the clean no prob. Did that all the way to 304. Same just flawless.
Thanks to the original author and thank you for this. Worked like a champ to clean out my DB of a bunch of mods. :D

User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by DoYouSpeakWak » Tue May 19, 2009 8:56 am

I have pmed almsamim about taking over this mod. Got some ideas and the time for it. almsamim have not been active or online for some time. Occupied with education is my guess :)

So its hard to say when i can update it, but some development have been done so when i/if i get the go a new version should be ready.

Wak
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

MaLeKo
Registered User
Posts: 210
Joined: Tue May 06, 2008 3:32 am

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by MaLeKo » Fri May 22, 2009 3:34 am

We need an update :shock:

User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by DoYouSpeakWak » Fri Jun 19, 2009 7:56 pm

Gonna give it a few hours tonight. Hopefully we can find a solution for the future of this mod.
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

Peter77sx
Registered User
Posts: 3253
Joined: Wed Nov 09, 2005 2:51 pm

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by Peter77sx » Sat Jun 20, 2009 2:57 am

Would be nice to be able to select the tables to clean...
this was an request of mine a while back

Kinda like the phpbb2 version of this..
http://www.phpbb.com/community/viewtopic.php?t=293867
we would just check the tables we wanted cleaned out. :)

User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by DoYouSpeakWak » Sat Jun 20, 2009 8:44 pm

I agree it needs more functions and no erros when runned. the mysql seems a bit outdated. I gotta read up on it before i can get rid of the errors.

It works on 3.0.5 as it is. :)
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

MaLeKo
Registered User
Posts: 210
Joined: Tue May 06, 2008 3:32 am

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by MaLeKo » Mon Jun 22, 2009 11:53 pm

Peter77sx wrote:Would be nice to be able to select the tables to clean...
Supported! Also ability to see summaries of changes in db made by 3rd party mods before proceeding to clean the db

User avatar
Ashley.S.
Registered User
Posts: 468
Joined: Mon Aug 04, 2008 6:01 pm
Location: Falmouth, Cornwall, UK
Name: Ashley .S.
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by Ashley.S. » Tue Jun 23, 2009 6:21 pm

this mod might be very handy, I'm going to keep an eye on it
Regards,
-Ashley.S. [ ProphpBB Free Forum Hosting Moderator ]

User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by DoYouSpeakWak » Mon Aug 31, 2009 4:37 pm

This functionality is now included in the Support Toolkit. So this mod seems no longer to be needed. But it still works and may be worth saving a copy of if this topic get closed.
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

User avatar
Ashley.S.
Registered User
Posts: 468
Joined: Mon Aug 04, 2008 6:01 pm
Location: Falmouth, Cornwall, UK
Name: Ashley .S.
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by Ashley.S. » Mon Aug 31, 2009 5:19 pm

DoYouSpeakWak wrote:This functionality is now included in the Support Toolkit. So this mod seems no longer to be needed. But it still works and may be worth saving a copy of if this topic get closed.
I found the STK version ok, but when it came to clearing out the database, it only would check for additions like phpbb_ads , etc. not actually look into phpbb_config, phpbb_users, etc. for additional queries that might have been added so you could easily miss important parts of remaining SQL queries from mods that you have uninstalled.
Regards,
-Ashley.S. [ ProphpBB Free Forum Hosting Moderator ]

User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Re: [BETA] SQL Database Clean from MODs v0.0.1 for phpBB3

Post by DoYouSpeakWak » Mon Aug 31, 2009 10:21 pm

Ashley.S. wrote:
DoYouSpeakWak wrote:This functionality is now included in the Support Toolkit. So this mod seems no longer to be needed. But it still works and may be worth saving a copy of if this topic get closed.
I found the STK version ok, but when it came to clearing out the database, it only would check for additions like phpbb_ads , etc. not actually look into phpbb_config, phpbb_users, etc. for additional queries that might have been added so you could easily miss important parts of remaining SQL queries from mods that you have uninstalled.
Thanks for clearing that up. I was sure it did look into all that as well. I have thought off making a umil checker. But not sure how precisely yet. But that would be another mod and not a update on this.
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

Locked

Return to “[3.0.x] MODs in Development”