upgrade from 3.1 to 3.3

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
BF79
Registered User
Posts: 522
Joined: Fri Feb 13, 2015 1:28 pm
Name: Fouad B

Re: upgrade from 3.1 to 3.3

Post by BF79 »

I have General Error
SQL ERROR [ mysqli ]

only when I try to save full backup include this
Image

I dont have error if I do like this

Image

where can i remove this phpbb_statistics_online
User avatar
warmweer
Jr. Extension Validator
Posts: 11665
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: upgrade from 3.1 to 3.3

Post by warmweer »

BF79 wrote: Tue Jul 23, 2024 12:44 pm Image

where can i remove this phpbb_statistics_online
It's a database table so deleting it from the database is the logical step.
However there may be extra fields in the config table related to that extension so these would also have to be deleted.
And: I don't know the extension so you need to check whether there are other (new?) tables involved.
Another thing: IMPORTANT: before deleting anything from the database, take a database backup to make sure you can restore anything wrongly deleted.
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
janus_zonstraal
Registered User
Posts: 6600
Joined: Sat Aug 30, 2014 1:30 pm

Re: upgrade from 3.1 to 3.3

Post by janus_zonstraal »

Maybe it was this extension:
viewtopic.php?t=2258476
Sorry! My English is bat ;) !!!
BF79
Registered User
Posts: 522
Joined: Fri Feb 13, 2015 1:28 pm
Name: Fouad B

Re: upgrade from 3.1 to 3.3

Post by BF79 »

warmweer wrote: Tue Jul 23, 2024 12:59 pm
BF79 wrote: Tue Jul 23, 2024 12:44 pm Image

where can i remove this phpbb_statistics_online
It's a database table so deleting it from the database is the logical step.
However there may be extra fields in the config table related to that extension so these would also have to be deleted.
And: I don't know the extension so you need to check whether there are other (new?) tables involved.
Another thing: IMPORTANT: before deleting anything from the database, take a database backup to make sure you can restore anything wrongly deleted.
Thanks for helping.. but I don't know where and how !!!
Can I let it like this and when I want to save the backup I exclude from the list?
BF79
Registered User
Posts: 522
Joined: Fri Feb 13, 2015 1:28 pm
Name: Fouad B

Re: upgrade from 3.1 to 3.3

Post by BF79 »

janus_zonstraal wrote: Tue Jul 23, 2024 2:54 pm Maybe it was this extension:
viewtopic.php?t=2258476
No not this one...but I think abandoned ext statistics online
User avatar
warmweer
Jr. Extension Validator
Posts: 11665
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: upgrade from 3.1 to 3.3

Post by warmweer »

BF79 wrote: Tue Jul 23, 2024 3:30 pm ...
Thanks for helping.. but I don't know where and how !!!
That almost implies you used a 1-click installation for your board, in which case your host would be the place to seek support.

If you have access to phpMyAdmin it's just a matter of selecting the table and removing it (and in the config_table checking whether there are new fields specific to the extension and removing those).
BF79 wrote: Tue Jul 23, 2024 3:30 pm Can I let it like this and when I want to save the backup I exclude from the list?
Yes, but it's clutter and even with a new version of the extension (in the doubtful case it will be continued or taken over in the future) you'll probably have to manipulate that table in one way or another ... so [I'll be blunt] it's about time you had a look at the Knowledge Base (it contains a number of entries with solutions to various problems and includes basic instructions regarding the use of phpMyAdmin for selected cases.

Is it an option to restore your 3.1 board and redo the upgrade (following the instructions in Upgrading from 3.1 to 3.3?


BTW there is an unofficial STK for 3.1. You might consider using that to clean the 3.1 database before upgrading.
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.
BF79
Registered User
Posts: 522
Joined: Fri Feb 13, 2015 1:28 pm
Name: Fouad B

Re: upgrade from 3.1 to 3.3

Post by BF79 »

warmweer wrote: Tue Jul 23, 2024 4:32 pm
I still have this version 3.1.11 .. should be ok to fix ??
I just discovered another problem when I wanted to install style. impossible to install
msg :
style: Information
Could not get the style configuration file for: aero

install style:
Information
No uninstalled styles detected.
User avatar
janus_zonstraal
Registered User
Posts: 6600
Joined: Sat Aug 30, 2014 1:30 pm

Re: upgrade from 3.1 to 3.3

Post by janus_zonstraal »

I still have this version 3.1.11 .. should be ok to fix ??
Yes
I just discovered another problem when I wanted to install style. impossible to install
msg :
style: Information
Could not get the style configuration file for: aero
What version of the style, phpbb and style versions have to match.
Sorry! My English is bat ;) !!!
BF79
Registered User
Posts: 522
Joined: Fri Feb 13, 2015 1:28 pm
Name: Fouad B

Re: upgrade from 3.1 to 3.3

Post by BF79 »

sorry for late ... but my version 3.1.11 can works with php 7.3 ?
because now The minimum PHP version available is 7.3 on shared hosting.
User avatar
janus_zonstraal
Registered User
Posts: 6600
Joined: Sat Aug 30, 2014 1:30 pm

Re: upgrade from 3.1 to 3.3

Post by janus_zonstraal »

Do you see errors?
Sorry! My English is bat ;) !!!
User avatar
Madalin10
Registered User
Posts: 102
Joined: Wed Jun 18, 2014 2:42 pm
Name: Madalin C.

Re: upgrade from 3.1 to 3.3

Post by Madalin10 »

BF79 wrote: Sun Sep 15, 2024 6:55 pm sorry for late ... but my version 3.1.11 can works with php 7.3 ?
because now The minimum PHP version available is 7.3 on shared hosting.
phpBB 3.1.11 can only run with php versions between php 5.3.3 and php 7.0.
https://awesome-web.design - I offer phpBB & web design services at fair prices.
User avatar
Anișor
Translator
Posts: 330
Joined: Tue Jan 08, 2013 9:36 pm
Location: Arbroath, Angus, Scotland

Re: upgrade from 3.1 to 3.3

Post by Anișor »

Madalin10 wrote: Mon Sep 16, 2024 8:06 am
BF79 wrote: Sun Sep 15, 2024 6:55 pm sorry for late ... but my version 3.1.11 can works with php 7.3 ?
because now The minimum PHP version available is 7.3 on shared hosting.
phpBB 3.1.11 can only run with php versions between php 5.3.3 and php 7.0.
In order to ensure compatibility with PHP 8 while using the OAuth login, we have decided to increase the minimum required PHP version to PHP 7.2.
That’s stated in the 3.1.11 announcement topic.
Edit: The minimum version is 7.2 up to 8.0 you can find that info in the composer.json : "php": "^7.2 || ^8.0.0",
And to answer the question of the OP, you should be fine.
User avatar
Madalin10
Registered User
Posts: 102
Joined: Wed Jun 18, 2014 2:42 pm
Name: Madalin C.

Re: upgrade from 3.1 to 3.3

Post by Madalin10 »

Anișor wrote: Mon Sep 16, 2024 8:09 am
Madalin10 wrote: Mon Sep 16, 2024 8:06 am

phpBB 3.1.11 can only run with php versions between php 5.3.3 and php 7.0.
In order to ensure compatibility with PHP 8 while using the OAuth login, we have decided to increase the minimum required PHP version to PHP 7.2.
That’s stated in the 3.1.11 announcement topic.
Edit: The minimum version is 7.2 up to 8.0 you can find that info in the composer.json : "php": "^7.2 || ^8.0.0",
And to answer the question of the OP, you should be fine.

Code: Select all

PHP 5.3.3+ and PHP < 7.0 with support for the database you intend to use.
That's from phpbb 3.1.11 docs. The tests I've made:

While trying to install the version with php 7.1, 7.2, 7.3.
Image

Image

I could only install it while using php below 7.0, in my case php 5.6. After installed it, tried to run it with php 7.2 or php 7.3 and the results:
Image

+ https://i.gyazo.com/d42d1f1230032ba1753 ... e07e4a.png

I don't think that's usable. :)
Last edited by Madalin10 on Mon Sep 16, 2024 9:19 am, edited 1 time in total.
https://awesome-web.design - I offer phpBB & web design services at fair prices.
User avatar
Anișor
Translator
Posts: 330
Joined: Tue Jan 08, 2013 9:36 pm
Location: Arbroath, Angus, Scotland

Re: upgrade from 3.1 to 3.3

Post by Anișor »

Madalin10 wrote: Mon Sep 16, 2024 8:30 am
Anișor wrote: Mon Sep 16, 2024 8:09 am



That’s stated in the 3.1.11 announcement topic.
Edit: The minimum version is 7.2 up to 8.0 you can find that info in the composer.json : "php": "^7.2 || ^8.0.0",
And to answer the question of the OP, you should be fine.

Code: Select all

PHP 5.3.3+ and PHP < 7.0 with support for the database you intend to use.
That's from phpbb 3.3.11 docs. The tests I've made:

While trying to install the version with php 7.1, 7.2, 7.3.
Image

Image

I could only install it while using php below 7.0, in my case php 5.6. After installed it, tried to run it with php 7.2 or php 7.3 and the results:
Image

+ https://i.gyazo.com/d42d1f1230032ba1753 ... e07e4a.png

I don't think that's usable. :)
You are right I thought about 3.3.11 for some reason. Maybe the topic title confused me.
BF79
Registered User
Posts: 522
Joined: Fri Feb 13, 2015 1:28 pm
Name: Fouad B

Re: upgrade from 3.1 to 3.3

Post by BF79 »

the conclusion is not possible !!!! :(

Return to “[3.3.x] Support Forum”