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

Dynamic Connections implementation

Thread began 7/08/2016 3:27 pm by tmcbinc99963 | Last modified 8/01/2016 4:50 pm by Ray Borduin | 480 views | 17 replies |

tmcbinc99963

Dynamic Connections implementation

Originally created server settings in DW Manage Sites. Decided to create a Dynamic Connection using the wizard. Updated the include file on one page, but getting multiple errors.

What is the proper procedure for pointing to the new file? Tried naming it the same thing, and also editing the include file, but major errors result either way.
Should I keep the old connection file also, or should it be deleted?
Should the server settings in DW Manage Sites be deleted?
How do you test the additional connections in the Wizard?
How does this work with all the pages that are already uploaded to a remote server?

Both the new and old connection files are attached.

Below are some of the errors:

Notice: Undefined variable: database_ProductsDb in /Applications/MAMP/htdocs/website.com/Prod_results.php on line 101
Notice: Undefined variable: ProductsDb in /Applications/MAMP/htdocs/website.com/Prod_results.php on line 101
Warning: mysql_select_db() expects parameter 2 to be resource, null given in /Applications/MAMP/htdocs/website.com/Prod_results.php on line 101
Notice: Undefined variable: ProductsDb in /Applications/MAMP/htdocs/website.com/Prod_results.php on line 105
Warning: mysql_query() expects parameter 2 to be resource, null given in /Applications/MAMP/htdocs/website.com/Prod_results.php on line 105

In addition, I'm also getting a 'headers not sent' error that I wasn't getting before (only on localhost):

Warning: Cannot modify header information - headers already sent by (output started at /Applications/MAMP/htdocs/website.com/Connections/ProductsDb.php:9) in /Applications/MAMP/htdocs/website.com/Prod_results.php on line 211

Sign in to reply to this post

tmcbinc99963

When will this one be resolved?

Thanks

Sign in to reply to this post

Ray BorduinWebAssist

Usually you could delete the old connection on your local machine and then create a dynamic connection with the same name and then upload it.

Since you used the same name, no other files would need to be updated.

The errors you are seeing are probably because you changed the connection name and your scripts are now out of sync. Try deleting the connections and then creating the dynamic connection with the same name as the one you are replacing.

Sign in to reply to this post

tmcbinc99963

The new file has been created and uploaded to the remote server, but receiving the following error (website names omitted):

Fatal error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /services/webpages/util/p/j/pjeq5yzb.attwebspace.com/website.com/public/website/Connections/ProductsDb.php on line 25

Our ISP has used the credentials listed on the file (not the file itself) to connect successfully.

FTP credentials are in PM if needed.

Dynamic Connection File attached.

Sign in to reply to this post

Ray BorduinWebAssist

Your dynamic connection was set up to work with a different domain. I updated the domain to match the url and it works properly now. It will use the localhost connection unless it recognizes an alternative connection based on the domain.

Sign in to reply to this post

tmcbinc99963

This post has been deleted.

tmcbinc99963

Trying to access the Connections file you corrected.

Tried to view the Connections file source code through ISP control panel, but the Connections file has been replaced with an odd 'WebsiteOS Preferences' file I've never seen before, and can't open.

Opened the remote Connections file through DW Files panel, making sure not to overwrite the local file, but it looks the same as the old local file.

Sign in to reply to this post

Ray BorduinWebAssist

The page you sent before opens for me when I try. Are you going to the same URLs as me? (see private message)

Sign in to reply to this post

tmcbinc99963

Can't find the file you revised. In the ISP control panel directory, the file that's there is the original credentials that were set up by the ISP; not your DynConn file with both local and remote credentials.

When I access the remote servers through DW there's a DynConn file in there, but it's the same file as my old, original file that didn't work.

Both files are in PM

Sign in to reply to this post

Ray BorduinWebAssist

Just change the line:
$domains = explode(",","primrose.com");

to:
$domains = explode(",","tommcbrideinc.com");

That is odd... I just downloaded the version from your server and it was updated. Are you looking in the /primrose/Connections/ folder?

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