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

Unable to Install PowerCMS on remote site following successful localhost installation.

Thread began 3/05/2015 1:00 pm by Mac McCarthy | Last modified 3/05/2015 6:28 pm by Jason Byrnes | 837 views | 5 replies |

Mac McCarthy

Unable to Install PowerCMS on remote site following successful localhost installation.

Adding Design Extenders PowerCMS to an existing small site I was very happy to find all OK when testing using localhost.

I proceeded to upload all files to the remote host and opening the page I expected to be presented with the "Getting Started" screen when I open the first page (index.php)

But I get two warnings:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/fhlinux159/c/camacweb.com/user/htdocs/WA_Globals/WA_Globals.php on line 41

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/fhlinux159/c/camacweb.com/user/htdocs/WA_Globals/WA_Globals.php on line 67
No database selected

I set up one "Dynamic MYSQL Conection" file for both localhost and remote during the installation process which clearly work locally. However I noticed that an additional connection file has been created called "_PowerCMSconnection" which has duplicated credentials, not sure why, but I assumed all OK. I have also double checked the credentials used in the connection files which are all good.

When I tried to use ../install_cms or ...admin_cms the both took me to the Admin login screen and then subsequently to the same errors as above.

Not sure where to go from here??

Update:
Removed txt file from connections folder and got as far as step 4of5 when I get following error:
ERROR: Failed to save the settings in the database. Please verify your database connection.

Moving forward, still need help please.

Update2:
Imported sql script .../install_cms/scripts/db.sql ad all completed, WOW I surprised myself!

However what did I do wrong with the above procedure?
No longer urgent.

Sign in to reply to this post

Jason ByrnesWebAssist

  mported sql script .../install_cms/scripts/db.sql ad all completed, WOW I surprised myself!

However what did I do wrong with the above procedure?
No longer urgent.  



it sounds like you didn't export the local database and import it to the remote site. the installation scripts creates the needed tables on the local host, if this table don't exist on the remote server, it won't work.

by running the sql script, you created the needed tables.

Sign in to reply to this post

Mac McCarthy

Thanks Jason

I spoke to soon as I am now getting following errors on browsing to the page.

Warning: include(C:/xampp/htdocs/CamacWeb15/WA_CMS/addtosite.php) [function.include]: failed to open stream: No such file or directory in /home/fhlinux159/c/camacweb.com/user/htdocs/index.php on line 34

Warning: include(C:/xampp/htdocs/CamacWeb15/WA_CMS/addtosite.php) [function.include]: failed to open stream: No such file or directory in /home/fhlinux159/c/camacweb.com/user/htdocs/index.php on line 34

Warning: include() [function.include]: Failed opening 'C:/xampp/htdocs/CamacWeb15/WA_CMS/addtosite.php' for inclusion (include_path='.:/usr/share/pear-php5') in /home/fhlinux159/c/camacweb.com/user/htdocs/index.php on line 34

I have checked that addtosite.php has been uploaded.

Sign in to reply to this post

Jason ByrnesWebAssist

it looks like you had Dreamweaver update some of the file paths to use your local path instead of the original relative path.

you should upload a fresh copy of the files.

Sign in to reply to this post

Mac McCarthy

Jason
Fresh copy uploaded and all working as expected, thanks for your perseverance.
Mac

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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