Powergallery & MySql 5 on 1and1

I have a 5.0 mysql database on my 1and1 account but the install is reading 4.XX .. where do i input db connection script ? or bypass the auto install?

You can change the connection file after running through the install wizard by changing the PowerGallery.php file in the Connections directory. Make sure you run the db.sql on your database from the install/scripts directory.

Hi - the problem is that the install wiz is stuck at 1.php .. I created connections/powergallery.php & ran created the tables in phpmyadmin

I changed the parameter in 1.php to 4 to fake the install requirements and now it says simplexml is not installed .. my host, 1and1 says php5 and simple xml are installed

create a new database at 1and1 (make sure you choose mysql 5 - unfortunately the install script sees it as 4.4.9)

edit install/1.php

change line 8 to 'simplexml' => true,
change iine 13 to $_SESSION['serverchecklist']['php'] = (intval(phpversion()) >= 4);

create or modify .htaccess with the following:

AddType x-mapp-php5 .php
AddHandler x-mapp-php5 .php

now you can run the powergallery install wizard on your 1and1 account

Just to clarify a few things about this. I would not recommend bypassing anything on the installer script, if it errors out that means the solution will not install or run correctly. The point of the installer is to help track down your issue so you can fix it, so bypassing it won't really fix anything. As you noted, when you faked the PHP setting, it errored out on SimpleXML. That is because SimpleXML is only available in PHP 5. And that is why it said PHP 5 was needed in the first place.

In your case, it was actually erroring out since you have PHP 4 enabled, it wasn't an issue with your MySQL version. The fix for 1&1 is making the .htaccess file, but you shouldn't edit any of the other install files.

There is also no need to create the connections file or populate the database yourself, the installer also handles this for you.

-justin

ok thanks ... you should alert 1and1 users that they need to add the htaccess file even though they choose mysql 5

For future reference, I found this post Neil made about 1&1: showpost.php?p=32173&postcount=5. That is a good point about making this fix more known. And just to clarify for others reading this thread, MySQL 5 and PHP 5 are separate things you will need to enable.

-justin