[CDB] Prime Post Revisions

[stone23]

Fixed with version 1.0.3

Hello,
I get 500 error when I want to activate version 1.0.3 and it is impossible to delete the extension data to remove it.

[primehalo]

Have you tried clearing the cache (deleting all files in the /cache/production/ directory)?

[stone23]

The activation of the extension does not end and I end up on a blank page.
I also couldn't delete the data from the extension, the first time I had to use STK to do this and on the second attempt to install I had to do a database restore outright.

The extension is activated locally but on the online forum, it is impossible.

[primehalo]

I tested on both my local test forum and my real forum and it both installed and removed fine, though it did take like a few minutes.

If you're saying it works on your local forum but not on your online forum then try to find out what's different between the two.

The extension DB changes be removed manually by dropping the phpbb_primepostrev table, dropping the 'primepostrev_enable' & 'primepostrev_autoprune' columns from the phpbb_forums table, and dropping the 'primepost_edit_time', 'primepost_edit_user', and 'primepost_edit_count' columns from the phpbb_posts table. Then removing rows in phpbb_modules where the module_langname value starts with 'ACP_PRIMEPOSTREVISIONS' (there are 2) and removing rows in phpbb_config where the config_name column value starts with 'primepostrev_' (there are 3).

The phpbb_migrations table keeps track of migrations so you may also need to delete rows where the migration_name column starts with '\primehalo\primepostrevisions'. I don't know if that is necessary or not.

[stone23]

I managed to delete the data with STK but I get a 504 error if I try to activate the extension.
Must the .git directory contained in the archive be transferred to the server?

ScreenShot085.jpg

[Dark❶]

...
Must the .git directory contained in the archive be transferred to the server?
...

No!
May I know your phpBB version ???

Best regards

[stone23]

May I know your phpBB version ???

Hi,
phpBB version is 3.3.4 and php version is 8.0.7 for online forum and for my local test forum : phpBB: 3.3.4 and php:8.0.2

[Dark❶]

May I know your phpBB version ???

Hi,
phpBB version is 3.3.4 and php version is 8.0.7 for online forum and for my local test forum : phpBB: 3.3.4 and php:8.0.2

then using STK might be the problem,
kindly check this https://www.phpbb.com/customise/db/official_tool/stk/ ,

I suggest that you restore the database via phpMyAdmin,
then try to install the extension.

Best regards

[stone23]

I suggest that you restore the database via phpMyAdmin,
then try to install the extension.

I have already done it and it looks the same.
I also tried to deactivate all the other extensions and try to activate it but it still gives the same result...

[Dark❶]

...
I have already done it and it looks the same.
I also tried to deactivate all the other extensions and try to activate it but it still gives the same result...

Then you need to manually edit the database as suggested here:

...
The extension DB changes be removed manually by dropping the phpbb_primepostrev table, dropping the 'primepostrev_enable' & 'primepostrev_autoprune' columns from the phpbb_forums table, and dropping the 'primepost_edit_time', 'primepost_edit_user', and 'primepost_edit_count' columns from the phpbb_posts table. Then removing rows in phpbb_modules where the module_langname value starts with 'ACP_PRIMEPOSTREVISIONS' (there are 2) and removing rows in phpbb_config where the config_name column value starts with 'primepostrev_' (there are 3).

The phpbb_migrations table keeps track of migrations so you may also need to delete rows where the migration_name column starts with '\primehalo\primepostrevisions'. I don't know if that is necessary or not.

Best regards

[stone23]

Then you need to manually edit the database as suggested here:

...
The extension DB changes be removed manually by dropping the phpbb_primepostrev table, dropping the 'primepostrev_enable' & 'primepostrev_autoprune' columns from the phpbb_forums table, and dropping the 'primepost_edit_time', 'primepost_edit_user', and 'primepost_edit_count' columns from the phpbb_posts table. Then removing rows in phpbb_modules where the module_langname value starts with 'ACP_PRIMEPOSTREVISIONS' (there are 2) and removing rows in phpbb_config where the config_name column value starts with 'primepostrev_' (there are 3).

The phpbb_migrations table keeps track of migrations so you may also need to delete rows where the migration_name column starts with '\primehalo\primepostrevisions'. I don't know if that is necessary or not.

Yes, that is done.

However, every time I manually cleaned up the database I had nothing in the phpbb-modules table ...
Certainly as the extension does not complete the activation, this data is apparently not created.

But I can't understand why ...

[primehalo]

Did you confirm that the updated extension files got uploaded to your live server? If so, perhaps there is a mis-configuration in your server somewhere. A 504 error is a timeout error.

[stone23]

Yes, the files are transferred live to the server.
I don't know if it has a link but I have a similar problem with the Stop Spam Forum extension: I have to delete the data manually and when I want to reactivate the extension, the modules do not install. .

[warmweer]

A 504 error is a timeout error.

My guess it's a timeout problem as I had that on 3.2.11 using php 7.1.11 with max_execution_time =30 (but not with 3.3.4 using php 8.0.7). Increasing max_execution_time to 60 solved that.

I managed to delete the data with STK but I get a 504 error if I try to activate the extension.

Which STK did you use?
The only official STK I know is version 1.0.7-PL3 for phpBB3.0.x.
There have been/are STKs for phpBB3.1.x and 3.2.x but those are not official and AFAIK are not suited for phpBB3.3.x at all.

[stone23]

My guess it's a timeout problem as I had that on 3.2.11 using php 7.1.11 with max_execution_time =30 (but not with 3.3.4 using php 8.0.7). Increasing max_execution_time to 60 solved that.

On my server the max_execution_time is 120s ...

Which STK did you use?
The only official STK I know is version 1.0.7-PL3 for phpBB3.0.x.
There have been/are STKs for phpBB3.1.x and 3.2.x but those are not official and AFAIK are not suited for phpBB3.3.x at all.

STK version is 1.0.19 dev.

I have more and more suspicions about my web host...