UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support MySQL 8.0

Hi,
It seems I need to migrate to a more modern serveras my current is obsolete.

Below is a note from my server provider


It says on ubbcentral.com for version 7.7.5
Requirements
PHP 5.4 or newer
PHP 7.4 recommended
MySQL 5.5 or newer

When reading above one can think that PHP 8.0 works on ver 7.7.5 but it´s not.
Therefore I think it could be the same with MySQL.
What is the highest compatible MySQL version for 7.7.5 ?
Will MySQL 8.0 work with 7.7.5 ?

Thanks in advance

My control panel shows for ubb 7.7.5
PHP Version 7.4.33
MYSQL Version 10.3.39-MariaDB

Hi Ruben,

I was under the belief that MYSQL and MariaDB is two different database options with their own separate version series.

after a look it seems MySQL is now using version 8.0.34 (22 Jun 2023)

is MySQL version 8.0.34 compatible with UBBThreads version 7.7.5?

if not will it be compatible with UBBThreads version 8.0 when it arrives?

kinda yes.
i would check what flavor your mysql 8 is.
my host sell the package as a mysql db but that is what i got
here is from a source
MySQL 8.0 and MariaDB 10.5 are quite different. Still, you may not notice any differences unless you reach into rarely-used features.

Apart from my forum I have very little experience of databases so I would find it easier to ask my provider to upgrade MySQL from 5.7 to 8.0.
No need to change any settings in CP.

The question remains is MySQL 8.0 compatible with UBB version 7.7.5 ?

Looking back on my notes from 2020-10-15, UBBT 7.7.5 works just fine with MySQL 10

screenshot from each of the main test environments:

Thanks Isaac for your reply.
Forgive me if wish to dig deeper as I understand there is a difference between MySQL and MariaDB.
It sounds like apples and pears to me. MySQL version don't seem to be connected to MariaDB versions right? This because MySQL seems to be in version 8.0.34 since June and MariaDB is above 10.4.x

My provider say when I migrate to almalinux8 that
MySQL 8.0 is the lowest possible version supported on a new almalinux8 install
I have only used MySQL and never MariaDB.
So the natural thing for me would be to ask my provider to upgrade to MySQL 8.0.xx
and after checking that all works fine migrate to the almalinux8.
That would update my site so things are not obsolete.

Then when UBBT officially announce version 8.0.x then I can go ahead and update PHP to 8.0.x

Looking at your image Isaac it does not look that you have run any forum on MySQL ver 8.0.x yet???
Is that the right conclusion???

The last thing is that I found out now is that using almalinux8 I can run mariadb 10.3 on it as the lowest version on MariaDB. If I must go this way what do I need to think of then to make it work with my forum???


Thanks in advance for enlighten me 😁

you'll be fine. UBBT775 and UBBT8x have been tested with both MySQL and MariaDB. The forum software isnt doing any crazy complex SQL statements or running advanced database routines. Most all of the database communications are the most basic of SQL commands. This is why it works on SQL going back all the way to MySQL version 5.5

if you need more information about MySQL vs MariaDB, Google search is your friend.

Thanks Isaac
I’ll update to MySQL 8.0.xx and migrate to the new server probably in September due to Holidays and visitors occupying our place in Aug.
Thanks again