Using Host Site as Test Site

[jazzman247315378]

Anyone out there using their host site as test site? New to Powerstore and having difficulty setting up local testing server with DWCS3 so decided to upload to host site but having trouble. Any advice/hints would be appreciated.

[Ray Borduin]

It should work using your live site for testing. What problems are you having?

[David Stringer]

Anyone out there using their host site as test site? New to Powerstore and having difficulty setting up local testing server with DWCS3 so decided to upload to host site but having trouble. Any advice/hints would be appreciated.

Hi Jazzman,

I've put the site up on the following test area but having a few teething problems! I have done a few mods to the site though!

http://www.stringer-family.co.uk

Outline your problems and I'm sure you'll get an answer.

[jazzman247315378]

Good point David -- we are all new to it. I guess I should have clarified a little more and said I'm new to the "eCommerce/catalog" site building world -- not to html.

I purchased PowerStore with the hopes that I could have more control over the look and feel of the store as opposed to the monotonous look of a "stock" store.

The difficulty I'm having is that I have:
1. Downloaded and printed all of the help files for PowerStore and have done each
point as a checklist.
2. Set up my sql and phpserver -- I can see the table structure on my host
2. uploaded my local files to my web host (http://www.webassist.com/go/signup/1and1) via DWCS3 (after trying
to edit the .dwt file through DWCS3)
3. Attempted to edit/add product

At this stage of the game, I see the files on my host. But I can not get the function. I have checked and rechecked paths, but I am still not having any luck. What am I missing?

[jazzman247315378]

Here's the message I am getting when I attempt to access a page directly from Firefox:

Fatal error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /homepages/33/d267431537/htdocs/Connections/localhost.php

Looked through my localhost file and not seeing the problem. It is pointing to the sql file.

Suggestions?

[David Stringer]

Here's the message I am getting when I attempt to access a page directly from Firefox:

Fatal error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /homepages/33/d267431537/htdocs/Connections/localhost.php

Looked through my localhost file and not seeing the problem. It is pointing to the sql file.

Suggestions?

Have you also configured and uploaded the globals.php file?

That's the first file called by the Products_Results.php file etc.

As you're using Dreamweaver, do you see any tables in your Databases file?

[Ray Borduin]

It looks like your database connection information is invalid. Most likely the database server setting is wrong. This is set in the connections file itself probably where the error is occurring.

[David Stringer]

Hi Jazzman,

Have you managed to sort this yet?

I wondered if it may help if I give you my configuration of the Connections file?

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "00.00.000.000"; //Put my server IP address here
$database_localhost = "whatever"; // Name of database on server
$username_localhost = "something"; //username for access to database
$password_localhost = "anythingSecure"; //Good password
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>

With this file, Dreamweaver set up correctly and the globals.php file set up, you should be able to view details of the database under the Databases tab in Dreamweaver.
Hope this helps!

[jazzman247315378]

David, thanks for the help. I am going to try this today and see if I can get it working locally and then move it to the host. Appreciate it

[David Stringer]

then move it to the host.

For yourself and others in future, can I mention that in order to upload your graphics from the Admin page to your site, it will be necessary to alter the permission on the upload images folder to 777, otherwise any uploads will probably fail!

Just one of my teething problems solved.

[jazzman247315378]

Thanks for the heads up on 777... I haven't gotten there yet. I am going back to setting up a test server on my local computer and start over. Hasn't been an easy process...looking forward to seeing PowerStore in action...

[jazzman247315378]

Finally sorted the database stuff out. Got site on line. (www.aviationjewelrydesigns.com) but having trouble with payment options. I did a "dummy order" and charged a live credit card $195., but don't know where it went/ Any thoughts?

[Ray Borduin]

What is your payment provider? Did it actually take money from the account or is it in test mode and no money actually changed hands? If it did work it should appear in the merchant terminal for your payment gateway.