Located in the zp-data folder. But the credentials are shown on the setup page where that error appears.

My webspace provider told me that mysqli is enabled, however he would like to have more details what zenphoto is requiring/recommending for propper work.

I have the same issue, and installation fails for 1.4.4.3 as well as 1.4.5. I have installed 1.4.4.3 successfully on another site, but this one just up and failed (on its own, without trying to install anything), although it may be a complication from either a SQL upgrade by my host or a server migration... However, my other Zenphoto sites had no issues so I'm stumped. Will see what my host says...

edit: the original error I got was
your installation has moved from /home2/... to /home1/
your database software has changed from MySql 5.5.29 to 5.5.32
Please reinstall the following setup files from 1.4.3.4...

Do I need to follow those instructions rather than simply upgrading like I was going to do?

You would be advised to perform the re-install before attempting an upgrade. It is never a good idea add complexity to a situation that is not needed to a not working installation.

You're right. Restoring to a backup and performing the operations as indicated resolved my particular issue. Thanks.

I am just wondering if someone could give me the specific requirements in order to use mysqli? I believe I am not the only one that has problems to get mysqli to run. My webspace provider would like to help to get zenphoto to run, however he need to get more information what settings mysqli needs.

Thanks for your help
Norbert

The point is there is nothing that specific.

Zenphoto does exactly the same functions using MySQLi as it does when it uses MySQL. Only the PHP interface is different. But as to specifics, I have said before that the problem is with the credentials you have supplied. For whatever reason they do not work on MySQLi. That is the question to ask of your provider.

In the mean time, why haven't you taken the other suggestion and disabled the MySQLi support in your PHP ini file so that Zenphoto will use MySQL just like it did on your older release? I'm betting that will not work either because of some sort of credentials problem.

Sbillard, thanks for your help. My Zenphoto installation is working fine with mysql, but not with mysqli. I used the same credentials. It is truly a mysqli problem. However, my websapce provide don't have a clue what is wrong. Mysqli is enabled and he don't know what to do.

Hi,

I just had the same problem when trying to upgrade to ZenPhoto 1.4.5.1.
My host has php 5.3.26 and mysql 5.5.30.
Now, although mysqli is installed and enabled, I couldn't get it to work with ZP (I don't remember if in the older versions I used it or mysql driver). The thing is, that during setup, I could select the mysql driver, and then that step would work, but the next setup step (for example, delete extra file) would revert back to using mysqli and thus fail to connect again.
This happened even if I edited the config file manually. It seems there's a bug in the setup script which overwrites the config at every step and reverts it back to using mysqli.
The workaround I found for this was to manually edit the config file to change it to use mysql driver, before continuing to the next step, [b]for each step[/b].

It would be nice if I found why mysqli doesn't work on my host with ZP, but unfortunately I don't have time to debug this. I had to get this upgrade done and move on with my life
But in any case, it is definite that there's a bug in the setup script which overwrites the user selection of DB driver, and this happens at every step of the setup.

Cheers,
o

If you can please try the support build (probably not on a production site) to see if this is fixed now. Otherwise we will carry issues with the next release since especially since I didn't encounter this issue on several shared hosts.

I'm a bit busy at the moment, so I'm not sure when I'll have time for this test.
I'm hosting my website on lunarpages.com shared host plan (the linux version). Maybe you can ask their support for a temporary account to test this?

Thanks for all your work on ZP.

Cheers,
o

Hi,

I just did an update to ZP 1.5.4.2 using softaculous, and the same issues are still there. It still doesn't work with mysqli, and it still doesn't remember my selection of mysql as a driver during the different setup stages.

Sorry I didn't do a proper test with a clean install, but I just to have time for a comprehensive test at the moment.

Cheers,
o

Please contact the softaculous support people. We have no idea of their upgrade process and cannot know what it may or may not have done in contrary to what Zenphoto expects.

I am having the exact problem that Apprentice is. The ZP upgrade installation won't connect to MySQLi using my usual credentials, but when I use the drop-down menu to switch back to MySQL it does not recognize this and reloads the installation screen with MySQLi re-selected (and the same connection warning).

This seems to be a problem with ZenPhoto, it would be nice if you folks could look into it.

What version of Zenphoto are you using?

I'm upgrading to 1.4.5.2. Files are uploaded and the installation screen says everything is a go except for the MySQLi connection issue.

Is this still a softaculous install? I ask, because I have no problem selecting MySQL from the drop-down and reverting to that database handler on the 1.4.5.2 release.

No, just a manual installation.

Try editing the configuration file manually.