Joomla 4 Supported Databases Topic is solved

Need help installing Joomla! 4.x? For all Joomla! 4.x installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
pschmehl
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 179
Joined: Wed Jul 08, 2015 5:50 pm
Location: Richardson, TX
Contact:

Joomla 4 Supported Databases

Post by pschmehl » Sat Aug 13, 2022 6:32 pm

We're currently running Joomla 3.10 on Crocweb using MariaDB 10.3.35. I'm beginning the planning stages for upgrading to Joomla 4, and I note that the supported dbs are mysql and postgresql. MariaDB is apparently unsupported. MariaDB is the only option we have at our current hosting company. The version we're on is supposed to be the equivalent of mysql 5.7.

MariaDB seems to be diverging more and more from mysql as the versions increment. Are we going to be unable to upgrade to Joomla 4? Is it a crapshoot?

One idea I have is to create a brand new Joomla 4.0 install using MariaDB and see if it works. I'm wondering if anyone has tested version 4 on MariaDB? And if I create a brand new install, is there a path to migrate the existing installation to the new install?
Technical contact for Vietnam Veterans for Factual History
Paul Schmehl paul.schmehl@gmail.com

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29303
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Joomla 4 Supported Databases

Post by Per Yngve Berg » Sat Aug 13, 2022 6:45 pm

I cannot recollect that anyone has posted on this forum about that MariaDB not being compatible.

pschmehl
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 179
Joined: Wed Jul 08, 2015 5:50 pm
Location: Richardson, TX
Contact:

Re: Joomla 4 Supported Databases

Post by pschmehl » Sat Aug 13, 2022 6:56 pm

Thank you. Another question, if you don't mind. Is there a way to get a list of all installed and active extensions that are NOT Joomla project extensions? I have fourteen pages of extensions in the current install.
Technical contact for Vietnam Veterans for Factual History
Paul Schmehl paul.schmehl@gmail.com

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41913
Joined: Sat Apr 05, 2008 9:58 pm

Re: Joomla 4 Supported Databases

Post by Webdongle » Sat Aug 13, 2022 7:42 pm

https://downloads.joomla.org/technical-requirements has no mention of MariaDB. Would be good for the devs to say which versions of MariaDB are supported. Until then try it and see.

If the database is not compatible then the pre update check will not show.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 12735
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: How to find out which extensions are not those created by the J! project

Post by sozzled » Sat Aug 13, 2022 7:56 pm

pschmehl wrote:
Sat Aug 13, 2022 6:56 pm
Thank you. Another question, if you don't mind. Is there a way to get a list of all installed and active extensions that are NOT Joomla project extensions? I have fourteen pages of extensions in the current install.
It's not a good idea to open a discussion topic in a technical forum for one subject and then to completely change the subject. Doing this confuses other people who may be searching for an answer to one question only to find "answers" about something completely different.

In addressing the original question—which databases are supported in J! 4—I refer you to https://downloads.joomla.org/technical-requirements although, as @Webdongle says, there's no mention specifically to MariaDB or versions of it. However, as you have now asked a question on completely different matter, you will see that I have changed the subject in my reply.

How to find out which extensions are not those created by the J! project?

There are a few ways you can do this:

1) Go to System » Manage » Extensions use the filter to select the Core Extensions (see screenshot below):
j4x-extensionsManage.png
If you select the Non-core Extensions instead, you will have a list of everything that is not a "Joomla!-[project]" extension.

2) Go to System » Manage » Extensions and browse the "fourteen pages of extensions" looking at the Author column. :)

3) Use the Forum Post Assistant [FPA] to generate the report and post it here: any extension displayed in brown-coloured font is an extension that is not a "Joomla!-[project]" extension. See, for example, the FPA report shown >>> here <<< to give you an idea.

There are other ways you can differentiate between "Joomla" and "non-Joomla" extensions if you're clever with writing SQL queries and you know where to look in the database but, once you choose one of those methods, it's fairly straightforward to produce "a list". ;)
You do not have the required permissions to view the files attached to this post.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk: https://j4xdemo.enduring.com.au
:)

pschmehl
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 179
Joined: Wed Jul 08, 2015 5:50 pm
Location: Richardson, TX
Contact:

Re: Joomla 4 Supported Databases

Post by pschmehl » Sat Aug 13, 2022 8:07 pm

Thanks, Webdongle. I followed the upgrade instructions and changed the channel to Joomla Next so I could see the update list. I got this: Required PHP & Database Settings : Passed, so I assume that the MariaDB is at least compatible enough to work.

I've got a long list of extensions to check on, so plenty of work ahead before I begin testing.

Thanks to both of you for the help.
Technical contact for Vietnam Veterans for Factual History
Paul Schmehl paul.schmehl@gmail.com

pschmehl
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 179
Joined: Wed Jul 08, 2015 5:50 pm
Location: Richardson, TX
Contact:

Re: How to find out which extensions are not those created by the J! project

Post by pschmehl » Sat Aug 13, 2022 8:22 pm

sozzled wrote:
Sat Aug 13, 2022 7:56 pm
pschmehl wrote:
Sat Aug 13, 2022 6:56 pm
Thank you. Another question, if you don't mind. Is there a way to get a list of all installed and active extensions that are NOT Joomla project extensions? I have fourteen pages of extensions in the current install.
It's not a good idea to open a discussion topic in a technical forum for one subject and then to completely change the subject. Doing this confuses other people who may be searching for an answer to one question only to find "answers" about something completely different.
I apologize.
sozzled wrote:
Sat Aug 13, 2022 7:56 pm
In addressing the original question—which databases are supported in J! 4—I refer you to https://downloads.joomla.org/technical-requirements although, as @Webdongle says, there's no mention specifically to MariaDB or versions of it.
It turns out that all I had to do was change the channel to Joomla Next and the software told me that MariaDB 10.3.35 is compatible with Joomla 4. So, that question has been resolved.
sozzled wrote:
Sat Aug 13, 2022 7:56 pm
However, as you have now asked a question on completely different matter, you will see that I have changed the subject in my reply.

How to find out which extensions are not those created by the J! project?

There are a few ways you can do this:

1) Go to System » Manage » Extensions use the filter to select the Core Extensions (see screenshot below):

j4x-extensionsManage.png

If you select the Non-core Extensions instead, you will have a list of everything that is not a "Joomla!-[project]" extension.
Considering that I'm on Joomla 3.10, this isn't very useful advice.
sozzled wrote:
Sat Aug 13, 2022 7:56 pm
2) Go to System » Manage » Extensions and browse the "fourteen pages of extensions" looking at the Author column. :)
Not a viable option.
sozzled wrote:
Sat Aug 13, 2022 7:56 pm
3) Use the Forum Post Assistant [FPA] to generate the report and post it here: any extension displayed in brown-coloured font is an extension that is not a "Joomla!-[project]" extension. See, for example, the FPA report shown >>> here <<< to give you an idea.
This means I have to install an app on my server and figure out how to use it AND prevent other people from using it. No thanks.
sozzled wrote:
Sat Aug 13, 2022 7:56 pm
There are other ways you can differentiate between "Joomla" and "non-Joomla" extensions if you're clever with writing SQL queries and you know where to look in the database but, once you choose one of those methods, it's fairly straightforward to produce "a list". ;)
Perhaps a viable option, but by changing the channel to Joomla Next I received a list of extensions that need to be checked. Which leaves me wondering why this wasn't the very first option suggested.
Technical contact for Vietnam Veterans for Factual History
Paul Schmehl paul.schmehl@gmail.com

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41913
Joined: Sat Apr 05, 2008 9:58 pm

Re: Joomla 4 Supported Databases

Post by Webdongle » Sat Aug 13, 2022 8:37 pm

@pschmehl
Make a backup with https://extensions.joomla.org/extension/akeeba-backup/ then use it to transfer the site to a test environment. https://www.wampserver.com/en/ is good for a virtual host on your PC (mamp on a mac)
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 14979
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: Joomla 4 Supported Databases

Post by toivo » Sat Aug 13, 2022 9:25 pm

pschmehl wrote:
Sat Aug 13, 2022 8:22 pm
This means I have to install an app on my server and figure out how to use it AND prevent other people from using it.
The Forum Post Assistant (FPA) is not a Joomla extension. Download it from https://forumpostassistant.github.io/docs/, upload the extracted file fpa-en.php manually to the main Joomla folder, run it and then delete it, again manually. The FPA is a very useful tool for auditing and troubleshooting a Joomla site.
Toivo Talikka, Global Moderator


Post Reply

Return to “Installation Joomla! 4.x”