1. FCPeggy
  2. Sherlock Holmes
  3. News / Announcements
  4. Tuesday, 08 May 2018
  5.  Subscribe via email
With Joomla 4.0 coming, I've noted updating to Joomla 3.8 the announcement with regard to upgrading PHP and that SQL is going.
I'm totally confused and afraid to update - what is going to happen to my existing websites built on SQL databases? Will I have to eventually redesign them?
I really don't understand what is going to happen but understand the need to accommodate newer devices and technology.
What's the industry buzz?
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

You have nothing to worry about. Joomla 4 will continue to use SQL. I suspect what you have read was regarding the sample data when you set up a new Joomla installation. There is currently talk of removing this feature which is SQL based and replacing it with the PHP alternative which already exists in Joomla 3.8.

Ciarán
  1. more than a month ago
  2. News / Announcements
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Ciarán,

https://docs.joomla.org/Potential_backward_compatibility_issues_in_Joomla_4

"This document tracks potential backward compatibility issues for Joomla! 4. Listed are issues which potentially break extensions.
The base of this comparison is Joomla! 3.7. Updated System Requirements

The system requirements have been updated as follows:
PHP 7
MySQL 5.5.3
PostgreSQL 9.2
SQL Server support has been dropped.

PHP MySQL Extension - Joomla no longer supports using PHP's ext/mysql driver (which was removed in PHP 7.0). Joomla will automatically try and use the mysqli extension (available since PHP 5.3) or the mysql PDO Driver (available since PHP 5.3) else it will fail to create a database connection."

My databases are "mysql". If SQL server support has been dropped, is that not the same as "mysql"? Which interpret as being that my database will not connect if I do all of the upgrades required for Joomla 4.0?

This is where my confusion comes from. I would really appreciate some help understanding all this. Your help has always been phenomenal in this forum.

Thank you - -from Canada!
Peggy
  1. more than a month ago
  2. News / Announcements
  3. # 2
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Peggy

What got removed is MS SQL server support from Microsoft in J4. Not MySQL. For MySQL is only an old driver removed because it is deprecated. You can already change to mysqli in your Joomla configuration and all should work as before.

I hope that helps!

Ciarán
  1. more than a month ago
  2. News / Announcements
  3. # 3
Accepted Answer Pending Moderation
0
Votes
Undo
Yes this helps immensely.
So much to learn, so little time...who say's you can't teach an old dog new tricks?
Have a wonderful weekend!
Peggy
  1. more than a month ago
  2. News / Announcements
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.

Join Our Newsletter




We respect your privacy and do not tolerate spam and will never sell, rent, lease or give away your information (name, email, number, etc.) to any third party. Nor will we send you unsolicited email.
Joomla51 - Mullaghmore, Co. Sligo, Ireland
Joomla51.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by
Open Source Matters
the trademark holder in the United States and other countries.