Wrong database type 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
Locked
JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Wrong database type

Post by JasnaSontag » Thu Oct 06, 2022 10:55 am

OMG how can I convert MySQL 5.7.36 to MariaDB 10.6.5 and exchange it in Joomla4 I made? :eek:

gws
Joomla! Champion
Joomla! Champion
Posts: 5950
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Wrong database type

Post by gws » Thu Oct 06, 2022 11:04 am

Export (via phpmyadmin) the mysql DB to your desktop ,create the new DB in maria-db and import the exported sql into the maria DB.

JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Re: Wrong database type

Post by JasnaSontag » Thu Oct 06, 2022 11:08 am

gws wrote:
Thu Oct 06, 2022 11:04 am
Export (via phpmyadmin) the mysql DB to your desktop ,create the new DB in maria-db and import the exported sql into the maria DB.
I can't import, I get this Error.
And how will I exchange it in Joomla?
You do not have the required permissions to view the files attached to this post.

gws
Joomla! Champion
Joomla! Champion
Posts: 5950
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Wrong database type

Post by gws » Thu Oct 06, 2022 11:28 am

If your on a shared hosting ask the host to check the error messages.

JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Re: Wrong database type

Post by JasnaSontag » Thu Oct 06, 2022 11:41 am

gws wrote:
Thu Oct 06, 2022 11:28 am
If your on a shared hosting ask the host to check the error messages.
I do it offline in WAMP.

gws
Joomla! Champion
Joomla! Champion
Posts: 5950
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Wrong database type

Post by gws » Thu Oct 06, 2022 12:01 pm

check the maria db settings in the wamp menu.

JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Re: Wrong database type

Post by JasnaSontag » Thu Oct 06, 2022 12:10 pm

lol ok never mind, I can make new web from begining and everything copy, but now I see I can't make web with MariaDB because only options are MySQLi and MySQLi(PDO). So can't make Joomla 4 with MariaDB?

gws
Joomla! Champion
Joomla! Champion
Posts: 5950
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Wrong database type

Post by gws » Thu Oct 06, 2022 12:26 pm

maria db works with MySqli and MySqli pdo.
Maria DB is a fork of MySql by the original developers,for the most part they are similar.

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

Re: Wrong database type

Post by toivo » Thu Oct 06, 2022 12:30 pm

You can use MariaDB with the same drivers. If you run both MariaDB and MySQL servers in Wampserver and MySQL uses 3306, use 3307 as the port for MariaDB.
Toivo Talikka, Global Moderator

JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Re: Wrong database type

Post by JasnaSontag » Thu Oct 06, 2022 12:51 pm

toivo wrote:
Thu Oct 06, 2022 12:30 pm
You can use MariaDB with the same drivers. If you run both MariaDB and MySQL servers in Wampserver and MySQL uses 3306, use 3307 as the port for MariaDB.
it is like that, but in Joomla global config I can choose only MySQLi and MySQLi(PDO). I'm sorry if I ask something stupid.
You do not have the required permissions to view the files attached to this post.

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

Re: Wrong database type

Post by toivo » Thu Oct 06, 2022 1:18 pm

Did you try those drivers with port 3307? Use the database host localhost:3307
Toivo Talikka, Global Moderator

JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Re: Wrong database type

Post by JasnaSontag » Thu Oct 06, 2022 1:35 pm

toivo wrote:
Thu Oct 06, 2022 1:18 pm
Did you try those drivers with port 3307? Use the database host localhost:3307
now I put this in new instalation but got same error

On live server is MariaDB 10.3.36 and I made web in WAMP with MySQL 5.7.36, but maybe must make empty base there before installation from Kickstart. It is not mine, I'll know later does it work.
You do not have the required permissions to view the files attached to this post.

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 119
Joined: Thu Mar 20, 2014 1:29 pm

Re: Wrong database type

Post by Leen57 » Thu Oct 06, 2022 2:41 pm

Which version of wamp are you using because maybe
is more convenient to install a new version
or expand yours with extras
https://sourceforge.net/projects/wampse ... .0/Addons/
You do not have the required permissions to view the files attached to this post.

vsudo
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed May 12, 2021 10:44 am

Re: Wrong database type

Post by vsudo » Fri Oct 07, 2022 5:28 am

You can use mysqldump to export your database and then import into mariadb

JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Re: Wrong database type

Post by JasnaSontag » Fri Oct 07, 2022 4:09 pm

Ok, I wasn't on forum, and during that time web is upload and I see that server is not swith on MySQL, but it seems he converted my Joomla to MariaDB lol. Now I have only hmepage, and any link in menu doesn't work. I use helix with SP age builder - free version, and I can't open any sp-page, can't open Joomla articles, can't open contact, links don't work. Error is:
Not Found
The requested URL was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Would someone help me please to make them to work?
You do not have the required permissions to view the files attached to this post.

JasnaSontag
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 244
Joined: Mon Aug 26, 2019 10:58 am
Location: Zagreb, Croatia
Contact:

Re: Wrong database type

Post by JasnaSontag » Fri Oct 07, 2022 5:33 pm

omg I turned off SEO redirection and now website works


Locked

Return to “Installation Joomla! 4.x”