Upgrade Assistance Tools

https://www.phpbb.com/ideas/
Post Reply
User avatar
MohamedAG
Registered User
Posts: 107
Joined: Mon May 26, 2014 10:06 pm
Location: U.S.A.
Name: Moh Sal
Contact:

Upgrade Assistance Tools

Post by MohamedAG »

Archive Old Topics
Create an archive table with topic id as reference to an html file instead of topic table row for specific date range. (topic id will be intact but topic content will be stored in an html file) ---Optional

Empty Heavy Tables
Delete all data from prefix_search_wordwatch and similar tables that could be regenerated after upgrade and save more sql update process wither by the system or direct sql update.

Split Large Tables
Split large tables to smaller files and apply the database update to these small files to be run individually during system upgrade... Avoiding timeouts and database corruption.

Disabling Extensions and non-default Styles
Automatically disable all extensions and styles (but the default) during upgrade.

This features will be very helpful with people who do not have VPS or DS and yet have a very very large board. It will be a tool that could be used over and over since it has no relationship to the main code and will require less maintenance.

Files you could easy replace them with the new ones.... Database however is not.
User avatar
Toxyy
Registered User
Posts: 944
Joined: Mon Oct 24, 2016 3:22 pm
Location: Namek
Contact:

Re: Upgrade Assistance Tools

Post by Toxyy »

All for empty heavy and splitting tables. That would save a lot of errors on bigger sites.
I am a web developer/administrator, specializing in forums. If you have work you need done or are too lazy to do, pm me!

Some of my extensions:
[3.3][BETA] Post Form Templates || [3.3][BETA] Anonymous Posts || [3.2][3.3][BETA] ACP Merge Child Forums || [3.2][BETA] Sticky Ad || [3.2][DEV] User Delete Topics || [3.3][DEV] Moderate While Searching || [3.3][RC] Short Number Twig Extension
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Upgrade Assistance Tools

Post by warmweer »

I agree with the principal idea of reducing the risk of timeouts, however saving content in html files is overkill since very phpBB user with a functional brain will already have taken a (and possibly more) backup.
I see quite a few NO votes by phpBBteam-members but no arguments so I'm hesitant to give a YES because I suspect I'm not seeing the pitfalls as yet.
Is there a NO-voter willing to share his concerns?
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
david63
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: Upgrade Assistance Tools

Post by david63 »

My view would be that there enough problems with updates/upgrades and adding these options (which I don't totally disagree with) has the potential to create even more problems.

Also as the update/upgrade process is being incorporated into to the core and run from the ACP (not sure when but it has been rumoured in 3.3) this may be unnecessary, possibly even undesirable.
David
Remember: You only know what you know and - you don't know what you don't know!

I now no longer support any of my extensions but they will start to become available here
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Upgrade Assistance Tools

Post by warmweer »

david63 wrote: Wed Jan 03, 2018 9:57 pm ...
Also as the update/upgrade process is being incorporated into to the core and run from the ACP (not sure when but it has been rumoured in 3.3) this may be unnecessary, possibly even undesirable.
Thanks for the info.
Then yes, no point in voting for even 1 of the (sub)proposals.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Post Reply

Return to “phpBB Ideas”