Upgrading from phpBB 3.0.12 to phpBB 3.1.5 - removing the leftover code.

[Anuj Dhawan]

Hi,

I've updated my board from phpBB 3.0.12 to 3.1.5. Board seems to work fine but I observe two "Tabs" in the ACP - 1. ACP_CATS_MODS and 2. WPM_Setting.

I could delete the WPM_setting using SYSTEM/Administration Control Panel/ but when I try to delete ACP_CATS_MODS - following error shows up:

Error
Unable to remove module, it has assigned children. Please remove or move all children before performing this action.

I think, ACP_CATS_MODS is left over from "AutoMOD" and is not needed in phpBB 3.1.5, yes? Is yes, how do I delete it - please guide.

[KevC]

If you have not added any extensions you can remove non standard modules and permissions by:

1. Make sure you make a backup of your database before proceeding.
2. Uploading this file, modission_reset.php, to the root of your board installation on the server.
3. Log into the board as a founder and/or admin.
4. Navigate your browser to the file, for example http://www.example.com/example_forum/modission_reset.php
5. Choose modules and permissions and run the file
6. It will tell you how many modules and permissions it deletes, or may give you some other message if all is not well. Make a note of that.
7. It should automatically delete itself from the server, if it can't it will tell you.

[Anuj Dhawan]

Thanks KevC - that did the trick.

I think the answer for next question should be yes, though would like to confirm it - Once I 'run the file', it'll delete all the "non standard modules and permissions", that means board can be considered as a fresh installation with DB from the old board, yes?

[KevC]

yes

[Anuj Dhawan]

Thanks for all your help, appreciate your time.

[Paph]

This may be a silly question but as it says in this post title, I'm going to upgrade from 3.0.9 to 3.1.6 (yea I know, I'm a bit behind the times ).
I have a few mods installed on the current board and I understand about using the modission_reset.php file to clean the database of the unneeded tables created by those mods.

My question is: It states at the top of the modission_reset.php file;

<?php
/**
* Version 1.3.4 Oyabun1 2015 (phpBB 3.1.5)

Will this work with 3.1.6 or should I update to 3.1.5, run this file, then update that to 3.1.6?

[Oyabun1]

<?php
/**
* Version 1.3.4 Oyabun1 2015 (phpBB 3.1.5)

Will this work with 3.1.6 or should I update to 3.1.5, run this file, then update that to 3.1.6?

It has been checked to work with 3.1.6

I understand about using the modission_reset.php file to clean the database of the unneeded tables created by those mods.

modission_reset.php doesn't do that. It merely removes modules and permissions added by MODs, not tables or any other database changes.

[Paph]

<?php
/**
* Version 1.3.4 Oyabun1 2015 (phpBB 3.1.5)

Will this work with 3.1.6 or should I update to 3.1.5, run this file, then update that to 3.1.6?

It has been checked to work with 3.1.6

Great! Thanks.

I understand about using the modission_reset.php file to clean the database of the unneeded tables created by those mods.

modission_reset.php doesn't do that. It merely removes modules and permissions added by MODs, not tables or any other database changes.

Oops! I guess I misunderstood it's use. So I still need to use the installers for the mods to uninstall them to delete the database tables, or manually delete those tables?
If so, would there be a need to run the modission_reset.php?

[Oyabun1]

Oops! I guess I misunderstood it's use. So I still need to use the installers for the mods to uninstall them to delete the database tables, or manually delete those tables?

Yes, however if you have already upgraded you won't be able to use their installers.

Note that most database changes from MODs can just be left in place without causing any issues. Modules and permissions can create issues, hence the file to remove those.

[Paph]

No, I have not upgraded yet. Luckily I only have 4 mods installed that require uninstalling data from the database.

OK! I understand now (I think). I'll uninstall the mods, update to 3.1.6, then run the file you supplied.
I do have a test site I can use to test this out first, and I can clone the existing forum to this test site to be able to actually work with it as I'll be working with the live site before I upgrade the live site, so any problems that may arise can be dealt with before the actual upgrade to the live forum.

Thanks for your help. It's much appreciated.