+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: MySQL reported: MySQL not connected errors (/thread-11185.html)
MySQL reported: MySQL not connected errors - sbillard - 2013-09-27
Also what does happen with MySQLi? Do you get errors or just a failure to connect.
MySQL reported: MySQL not connected errors - aster - 2013-09-28
I am getting:
"Error!
MySQLi reported: MySQLi not connected"
My config.php file is already populated with the database info. I also changed the line "$conf['db_software']= 'MySQLi'; to 'MySQL' to see if that forced a MySQL connection, but no luck.
Again, I'm somewhat mystified because before the upgrade installation attempt it was connecting fine.
MySQL reported: MySQL not connected errors - sbillard - 2013-09-28
PHP MySQL is a deprecated database interface, so Zenphoto is attempting to migrate your installation off of it. (PHP MySQLi is the replacement) The underlying database is the same, so if the credentials work for one version of the interface they should work for the other. Apparently, though, there is some possibility of a mis-configured PHP MySQLi. But we have no clues as to what has been done wrong.
Probably your best bet then is to disable the mysqli extension in you PHP ini file until it is properly configured on your site. Your other option is to remove the functions-db-MySQLi.php script from your install. But this will be something you will have to do each release and Setup will complain when it finds it missing.
MySQL reported: MySQL not connected errors - aster - 2013-09-28
Thanks for all the info. I did modify the index.php in the setup folder to put MySQL above MySQLi in the drop-down by default, just to test.
However, it looks like my upgrade installation can't connect to the MySQL database either, so there's actually something else going on here. Again, for the life of me have no idea as everything was working fine an hour ago until I started the ugprade.
MySQL reported: MySQL not connected errors - sbillard - 2013-09-28
Re-check the credentials for MySQL and the database details in the configuration file. These must be incorrect if the connection fails.
One thing to be sure to verify is the database server name. Perhaps that has been change on you.
MySQL reported: MySQL not connected errors - DKON26 - 2013-09-28
Same exact issue as the others. Everything is perfect on setup except for the "MySQLi reported: MySQLi not connected" error. This is on Hostgator. When trying to change it to MySQL, I get the same error only with MySQL instead of MySQLi. I checked the config file and the proper credentials are there.
The only thing in the error log is: [28-Sep-2013 01:01:08] PHP Notice: Undefined variable: o in /home4/usdsd/public_html/zp-core/setup/index.php(718) : eval()'d code on line 29
Issue is with version 1.4.5.2 as version 1.4.4.4 worked fine.
MySQL reported: MySQL not connected errors - DKON26 - 2013-09-28
Different error log in zp-core/setup gives this: [28-Sep-2013 00:52:35] PHP Notice: Undefined variable: confDB in /home4/usdsd/public_html/zp-core/setup/index.php on line 920
MySQL reported: MySQL not connected errors - DKON26 - 2013-09-28
Missed one error in the zp-core/setup error_log: [28-Sep-2013 00:52:35] PHP Fatal error: Call to undefined function db_connect() in /home4/usdsd/public_html/zp-core/setup/index.php on line 947
So that is three errors from the server error logs in different folders. Hope these help fix the issue.
MySQL reported: MySQL not connected errors - sbillard - 2013-09-28
Probably the initial error is the root cause. This is a PHP error in the configuration file. Best guess is that it is a problem in the area of the MySQL credentials statements.
Could you look at what is in the config file circa line 29? Something there is corrupted.