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

Powerstore2 - MySQL and admin page problem

Thread began 1/21/2010 2:52 am by leon_chia215336 | Last modified 1/21/2010 12:56 pm by neilo | 3813 views | 6 replies |

leon_chia215336

Powerstore2 - MySQL and admin page problem

Hi, I am a just a layman trying to setup online store, dun know much about software languages. I need your help.

I have uploaded all powerstore files to the server (/public_html). I can see the main page and navigate around but when I append /admin to the url, it says page not found. What is wrong?

www.sgpremiumshop.com

Another problem I encounter is that the connection to the database is giving "An Unidentified error has Occurred." when I do a test with Dreamweaver 8.
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "sgpremiu_store";
$username_localhost = "sgpremiu_leon";
$password_localhost = "****";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>

I do not have test server, I am uploading directly to live to the remote server.

MYSQL version is 5.0.87



I am stuck here. Any help would be appreciated.

Thank you, Leon.

Sign in to reply to this post

neilo

Hi Leon,

Try 'Admin' (with an uppercase 'A').

See if that does it.

Sign in to reply to this post

leon_chia215336

Hi neilo,

The capital A works fine! Never come across that website is case sensitive!

Any solution for the database connection? When it gives error in Dreamweaver, will it still work in actual life website?

Cheers!

Sign in to reply to this post

Office Guy-172461

Linux/Unix servers are case sensitive.

See if these articles help:

How to create a connection to a MySQL database
157/

Creating a dynamic site definition in Dreamweaver
151/

Sign in to reply to this post

neilo

Hi Leon,

There is every likelihood that your database connection will be fine when accessed from your live site, and completely understandable that you will get the error message when testing from within Dreamweaver. It can be done, but usually this would be by arrangement with your hosting company, or by a special accommodation in your control panel. It is a security measure.

I'm not keen on uppercase letters in URLs (my preference) - and there doesn't seem to be an accepted naming convention at WA at the moment. Power CMS gives the admin folder a small 'a', and PowerStore, an uppercase. It's the same often with images/Images, - broken links 'live' that appeared to be working just fine locally.

If you do have problems with the connection later on, check out Office Guy's links, and if problems persist, then post back.

Sign in to reply to this post

Office Guy-172461

Hey neilo,

I'm with you on the naming conventions. I guess you could look on it as a security "feature" but I suspect it has more to do with who was coding at the moment. :)

Sometimes you can turn on remote db access through cPanel, but I've always preferred to use a testing server (see link included in previous articles).

Sign in to reply to this post

neilo

Yes - I have been using the remote server for testing dbs myself for the last couple of years, - the cpanels had the option. Over the past couple of weeks, the hosting company I use were hacked, all servers /cpanels / ftp out of action for odd hours each day while data was shifted, sifted and transferred, and new security measures put in place. All passwords for cpanels/ftp/databases reset - so around 27 sites unmanageable and 8 databases offline until I had requested new passwords by email (27 'send me my password' individual emails) and redone about 60 logins.

Sorry, forgot what I was talking about. Yes - no more remote access (for now anyway).

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