close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Powergallery & MySql 5 on 1and1

Thread began 2/04/2010 7:47 pm by steve204795 | Last modified 2/08/2010 12:29 pm by Justin Nemeth | 1201 views | 7 replies |

steve204795

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?

Sign in to reply to this post

Jimmy Wu

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.

Sign in to reply to this post

steve204795

connection

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

Sign in to reply to this post

steve204795

Simplexml

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

Sign in to reply to this post

steve204795

1and1 workaround

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

Sign in to reply to this post

Justin Nemeth

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

Sign in to reply to this post

steve204795

1and1

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

Sign in to reply to this post

Justin Nemeth

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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...