SQL-SQLSERVER-001
sqlsrv
SQL Server driver
Joomla 4 dropped SQL Server. There is no compatibility plugin for this.
sqlsrv → MySQL / MariaDB / PostgreSQL
What you will see
- Database driver not available
- Could not connect to the database
Symptoms people search
joomla 4 installer will not accept sql server
Replace this code
Swap sqlsrv for MySQL / MariaDB / PostgreSQL.
Joomla 3
Remove or stop calling this
public $dbtype = 'sqlsrv';Joomla 4 / 6
Use this instead
Move the site to MySQL 8 / MariaDB / PostgreSQL. SQL Server is not a Joomla 4+ driver.How to fix it
- 1Plan a database migration to MySQL or PostgreSQL before the Joomla 4 hop.
Also known as
SQL Server · sqlsrv · mssql
There is no 1:1 swap for this one. The architecture changed. If you cannot rewrite it, Infyways can.
Related issues
- Joomla 3 → 4Joomla API
JSubMenuHelper
JSubMenuHelper::addEntry() → HTMLHelper::_('sidebar.addEntry') plus the sidebar view placeholder
- Joomla 3 → 4SQL / schema
MyISAM engine in install SQL
ENGINE=MyISAM → ENGINE=InnoDB
- Joomla 3 → 4SQL / schema
0000-00-00 dates
'0000-00-00 00:00:00' → NULL
- Joomla 3 → 4Joomla API
JSession::clear($key) now clears everything
$session->clear('mynamespace') → $session->remove($key)
- Joomla 3 → 4PHP
JString / StringHelper
JString → Joomla\String\StringHelper
- Joomla 3 → 4PHP
JStringInflector / JStringNormalise
JStringInflector → Joomla\String\Inflector / Normalise