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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Powercms within Design Extender and 1and1 webhosts

Thread began 11/24/2016 6:10 pm by Mac McCarthy | Last modified 11/29/2016 7:42 am by Ray Borduin | 101 views | 12 replies |

Mac McCarthy

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Mac McCarthy

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Mac McCarthy

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Mac McCarthy

See attched

Sign in to reply to this post

Ray BorduinWebAssist

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?

Sign in to reply to this post

Mac McCarthy

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

New exported file attached with passwords and usernames.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
loading

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...