This error shows up when you change/upgrade the PHP version of your Joomla website to PHP 7.XX. This is because the mysql extension is removed in PHP 7. You may need to change all those functions in PHP code to mysqli_* instead of mysql_* if you want to use PHP 7 for your Joomla website. In cPanel EasyApache 4, the mysqli extension is provided by the mysqlnd package. For example:
Category: Mysql
Enable systemd to allow MySQL to be in /home directory
There are many cases systemd doesn’t allow the MySQL to work from a new/custom data directory path. It still restricts the path and stick to the default /var/lib/mysql even if we try to change it. To override this, disable ProtectHome on the following file.
Mysql error followed by Openfire XMPP server halt
I faced an issue as my IM messenger suddenly got disconnected from the openfire xmpp server. I checked the internet connection to my computer and it was still looking fine. So I hop into openfire server and tried to manually start it. It showed as openfire service starting, but it went off suddenly. I checked some of its logs and could see the issue was with connectivity to mysql service running in same box. Following […]
Proper Method To Change Default Mysql Engine Permanently
Here the mysql engine is set to InnoDB by default and I want to change it to MyISAM for long run. It was the old way setting parameter “skip-innodb” and commenting “innodb_file_per_table=1” in my.cnf file. Additionally we used to execute mysql query “SET storage_engine=MYISAM;”. Now a days, the above changes wont work and perhaps the mysql server doesn’t come back after initiating a restart since the changes made. The proper method is set the variable […]
Recent Comments