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.

Hi Leon,

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

See if that does it.

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!

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/

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.

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

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