Powercms within Design Extender and 1and1 webhosts

Hi - Having used Powercms on a few sites over the last few year, I have just signed up for an additional hosting A/c with 1and1 only to find they have moved up to MySQL 5.5 and require SFTP which in its self is OK for file uploads but when I try to create a connection file it then requires MySQLi which the latest version of Design Extender 1.2.1 does not use, does it??

A sample of the MySQLi.php connection file suggested by 1and1 is attached.

I have created a new database and have the correct credentials for it but am unable to create a connection file, therefore I can't start the process of uploading the remaining Powercms files and start running the install wizard.

Any help would be appreciated.

Mac

MySQLi shouldn't care if you use MySQLi or not. That is probably an issue with an upgrade to your php version. What happens when you try to use the standard MySQL connection?

It isn't as simple as updating the connection. All of the php code that refers to the database would have to be updated as well. The easiest solution is to move to a php version 6 or lower which should still support standard mysql connections. The more difficult solution is updating all of the CMS code, not just the connection, to mySQLi.

Hi Ray

....What happens when you try to use the standard MySQL connection?....
1st step - I defined site and created webpage
2nd step - "Add content to PowerCMS" and this requires that I get to creating/defining a connection, I'm using Dreamweaver CS4 and the normal requirements to define a connection display, having triple checked the user name database names ect. I get MySQL Error#: 2002 and can't go any further.

...... The easiest solution is to move to a php version 6 or lower
I'm using XAMPP for windows 5.6.3 which has PHP 5.6.3.
1and1 are using PHP 7.0

Their database connect help says:
Copy and paste the following code to your PHP script to set up the database connection.
For your security, we are not showing the password.
Please always connect to the database through your website. The direct access to the database via your local PC (external ODBC connection) is not possible.
Please note that PHP 5.5 and later versions do not support MySQL. Please use the MySQLi code instead.

Regards Mac

The issue is with your live server using php 7. You can downgrade to php 6 or below in the 1and1 admin control panel so that you can use mysql instead of mysqli.

I've downgraded to PHP 5.6 which moves me on but I still have a connection issue which tells me:
Error encounted when connecting to your database.
Followed quickly with HTP: Error 404

I have checked my site definitions and when I click test both Remote info and Testing server (via FTP) tells me they connected successfully.

I have checked the connection file and I get the same Error HTP Error 404 as above when I click test.

I can't see the wood for the trees at the moment, maybe come at it on a new day.

Mac

It is probably an issue with the url specified in your site definition for your testing server in Dreamweaver. If you send me your exported site definition I can see if I can spot the problem.

See attched

It looks like you didn't include the username and password in your export, so I couldn't fully test it.

I couldn't get to the url specified. Are you sure that is the correct url?

That's what I use with FileZiller for SFTP with port 22

New exported file attached with passwords and usernames.

The "Web URL" field shouldn't be the FTP address, it should be the web address. You just need to update that bottom field to be the url that you would use to browse to your web site.