[13/01/07] Clean phpBB SQL Tables

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Post Reply

Rating:

Excellent!
32
80%
Very Good
2
5%
Good
0
No votes
Fair
1
3%
Poor
5
13%
 
Total votes: 40

Extensions Robot
Extensions Robot
Extensions Robot
Posts: 27979
Joined: Sat Aug 16, 2003 7:36 am

[13/01/07] Clean phpBB SQL Tables

Post by Extensions Robot » Sat May 28, 2005 3:50 pm

MOD Name: Clean phpBB SQL Tables
Author: Vic D'Elfant
MOD Description: Originally designed to clean your database prior to re-installing phpBB, this tool allows you to remove all SQL tables, fields contained by the phpBB tables, and unknown entries in phpbb_config which do not belong to a so-called "vanilla" phpBB installation. This tool is particularly useful if you want to remove all tables/fields which have been created by MODs if you want to start all over again, or to remove a specific MOD.

A resource related to this MOD is the "Re-install / Update phpBB" Knowledge Base article, which can be found here: http://www.phpbb.com/kb/article.php?article_id=271

Note that this MOD currently only works in combination with a MySQL database.


MOD Version: 1.0.9 (Updated 01/13/07)
Tested on phpBB Version: 2.0.22

Download File: clean_tables_1.0.9.zip
mods overview page: View
File Size: 43730 Bytes



Support for this MOD needs to be asked within this topic. The phpBB Teams are not responsible or required to give anyone support for this MOD. By installing this MOD, the phpBB Support Team or phpBB MODifications Team may not be able to provide support.

This MOD has only been tested by the phpBB MOD Team with the phpBB version listed in the topic. It may not work in any other versions of phpBB.
Last edited by Extensions Robot on Mon Apr 30, 2007 12:30 am, edited 1 time in total.
(this is a non-active account manager for the phpBB Extension Customisations Team)

Darkmonkey
Former Team Member
Posts: 1707
Joined: Fri Oct 24, 2003 3:48 pm
Location: Where the trout streams flow and the air is nice

Post by Darkmonkey » Sat May 28, 2005 3:57 pm

MOD Validated/Released

Notes:
This tool allows you to remove any alien SQL tables and fields in your database (Those which do not belong to a "vanilla" phpBB installation). It is particularly useful if you want to remove any tables/fields created by a MOD.

A resource related to this MOD is the "Re-install / Update phpBB" Knowledge Base article, which can be found here: http://www.phpbb.com/kb/article.php?article_id=271

Note that this MOD currently only works in combination with a MySQL database.

Vic D'Elfant
Former Team Member
Posts: 6203
Joined: Sun May 02, 2004 6:21 pm
Location: NL, Maastricht
Contact:

Post by Vic D'Elfant » Sat May 28, 2005 4:00 pm

Although the word "MOD" probably makes you think "let's install it with EasyMOD", I'd recommed you to do it the manual way, as that probably would save you some time. It's just one file which you have to upload anyway.

How to use this tool
  • Step 1
    Open the zipfile and extract the /install directory to your hard drive

    Step 2
    Create a directory called "install" in the root of your board, and copy the contents of your local /install directory into it

    Step 3
    Point your browser to the file (e.g. http://www.domain.com/forum/install/clean_tables.php), and you'll see a list of all tables, fields and configuration settings from your SQL database which don't belong to phpBB itself (if any). Remove the checks in front of tables, fields and configuration settings which you don't want to drop. After having double-checked that you are not about to remove valuable data, click the "Clean tables" button on the bottom of the screen

    Step 4
    Remove the /install directory from the root of your forum. Your board will remain disabled as long as you haven't removed it
Disclaimer
  • Note that it is entirely your own responsibility to create a backup of your SQL table prior to running this tool. This tool should only be used if you know what you're doing! Assistance on how to remove a specific MOD should be gained from that MOD's support topic
Related resource
  • The Re-install / Update phpBB Knowledge Base article might be useful in case you're going to use this tool to clean all MOD traces prior re-installing your board
Last edited by Vic D'Elfant on Mon Jan 02, 2006 11:31 pm, edited 4 times in total.
midd.ag • DTP, web development & printing
http://www.midd.ag

afterlife_69
I've Been Banned!
Posts: 630
Joined: Tue Nov 30, 2004 10:35 am

Post by afterlife_69 » Tue Jun 14, 2005 11:22 am

Thanks, This has been extremly useful for eXtreme phpBB

Vic D'Elfant
Former Team Member
Posts: 6203
Joined: Sun May 02, 2004 6:21 pm
Location: NL, Maastricht
Contact:

Post by Vic D'Elfant » Tue Jun 14, 2005 12:17 pm

You're welcome :)

Vic
midd.ag • DTP, web development & printing
http://www.midd.ag

Iv@n
Registered User
Posts: 151
Joined: Mon Mar 07, 2005 6:41 am
Location: user not available

Post by Iv@n » Tue Jun 28, 2005 2:37 pm

does this remowes all post and users and categories etc. from my forum

Vic D'Elfant
Former Team Member
Posts: 6203
Joined: Sun May 02, 2004 6:21 pm
Location: NL, Maastricht
Contact:

Post by Vic D'Elfant » Tue Jun 28, 2005 2:41 pm

MOD description wrote: ... this tool allows you to remove all SQL tables and fields from your database which do not belong to a so-called "vanilla" phpBB installation. This tool is particularly useful if you want to remove all tables/fields which have been created by MODs ...

So no, it will not remove any data like posts, users, categories, etc. It will, however, remove fields which do not belong to a "vanilla" phpBB install (and if you choose to)

Vic



Edit: fixed typo... heh
Last edited by Vic D'Elfant on Tue Jun 28, 2005 2:46 pm, edited 1 time in total.
midd.ag • DTP, web development & printing
http://www.midd.ag

DemonBob
Registered User
Posts: 226
Joined: Thu Jan 15, 2004 7:04 pm
Location: Louisiana, United States
Contact:

Post by DemonBob » Tue Jun 28, 2005 2:43 pm

Wow vary usefully. Got rid of all my uninstall mod's tab;e alterations very quick :) Faster the phpmyadmin

Vic D'Elfant
Former Team Member
Posts: 6203
Joined: Sun May 02, 2004 6:21 pm
Location: NL, Maastricht
Contact:

Post by Vic D'Elfant » Tue Jun 28, 2005 2:47 pm

I'm glad to hear it was useful to you :)

Vic
midd.ag • DTP, web development & printing
http://www.midd.ag

Iv@n
Registered User
Posts: 151
Joined: Mon Mar 07, 2005 6:41 am
Location: user not available

Post by Iv@n » Tue Jun 28, 2005 2:49 pm

It is must have mod. Excellent.

whatusername
Registered User
Posts: 35
Joined: Fri Feb 25, 2005 1:23 pm
Contact:

Post by whatusername » Tue Jun 28, 2005 3:04 pm

This is the I'm looking for! Now I can update to Olympus when it comes!

Vic D'Elfant
Former Team Member
Posts: 6203
Joined: Sun May 02, 2004 6:21 pm
Location: NL, Maastricht
Contact:

Post by Vic D'Elfant » Tue Jun 28, 2005 3:06 pm

Hehehe... thanks 8)

The phpBB 2 -> phpBB 3 convertor will probably only extract data from the fields which it'll be able to store in its database though ;)

Vic
midd.ag • DTP, web development & printing
http://www.midd.ag

Iv@n
Registered User
Posts: 151
Joined: Mon Mar 07, 2005 6:41 am
Location: user not available

Post by Iv@n » Wed Jun 29, 2005 3:54 am

I started it and it said i have no mods and i have. :o

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25388
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Post by Paul » Wed Jun 29, 2005 8:03 am

Does it delete also not default rows at the config table?

User avatar
Anon
Former Team Member
Posts: 7019
Joined: Fri Jan 02, 2004 7:33 am
Location: Christchurch, New Zealand

Post by Anon » Wed Jun 29, 2005 8:25 am

Iv@n wrote: I started it and it said i have no mods and i have. :o


Well your ones didn't edit SQL did they? :P

Post Reply

Return to “[2.0.x] MOD Database Releases”