close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

What does this mean?

Thread began 11/09/2009 12:09 pm by ben_bradley348417 | Last modified 11/10/2009 4:08 pm by ben_bradley348417 | 1719 views | 8 replies |

ben_bradley348417

What does this mean?

Warning: mysql_pconnect() [function.mysql-pconnect]: Unknown MySQL server host 'uks47018' (1) in /home/users/uks47018/html/frockonvintage.co.uk/test/PowerStore200/Connections/localhost.php on line 9

Fatal error: Unknown MySQL server host 'uks47018' (1) in /home/users/uks47018/html/frockonvintage.co.uk/test/PowerStore200/Connections/localhost.php on line 9

Why cant see a simple index.php file uploaded?

Sign in to reply to this post

neilo

That seems to be telling you that the settings for your database connection are incorrect.

(PowerStore200/Connections/localhost.php)

Check that those settings are OK (server host is usually set to 'localhost')

Sign in to reply to this post

ben_bradley348417

Cheers Neilo,

Can you give me an example of yours please? So I can see how mine relates to it to put the right info in there.

Sign in to reply to this post

neilo

Hiya,

Yes - it looks as though we even use the same web hosting providers (UKServers)!

Here is what my code looks like: (I have left out my password and changed some details):

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "uks66xxx";
$username_localhost = "uks66xxx";
$password_localhost = "XXXXXXXX";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?


This is the final configuration that will be uploaded to the web server.

My connection for my local machine testing server is similar:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "mydatabase";
$username_localhost = "root";
$password_localhost = "mypassword";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>


If you are with UKServers, and if you use the default provided database settings, your database and username will probably both be uks47018 and the password is likely to be the same as your control panel login; but if you created a new database or new user, they will be appended by a suffix (i.e. uks47018newdb uks47018newuser).

If in doubt about your password, go to your control panel and create a new user and password.

Post back if you need more help!

Sign in to reply to this post

ben_bradley348417

Originally Said By: neilo
  Hiya,

Yes - it looks as though we even use the same web hosting providers (UKServers)!

Here is what my code looks like: (I have left out my password and changed some details):
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "uks66xxx";
$username_localhost = "uks66xxx";
$password_localhost = "XXXXXXXX";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?

This is the final configuration that will be uploaded to the web server.

My connection for my local machine testing server is similar:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "mydatabase";
$username_localhost = "root";
$password_localhost = "mypassword";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>

If you are with UKServers, and if you use the default provided database settings, your database and username will probably both be uks47018 and the password is likely to be the same as your control panel login; but if you created a new database or new user, they will be appended by a suffix (i.e. uks47018newdb uks47018newuser).

If in doubt about your password, go to your control panel and create a new user and password.

Post back if you need more help!  


-------------------
Thanks neil, its a small world both using UKservers. A great simple cheap company, i seem to think.

Thanks for your reply, i managed to get the header for the index page up, and when I clicked on a link it was looking for a different directory, with the PowerStore 200/ etc

THis is what im getting after moving the files out of the folder,
PowerStore200 copy/WA_Globals/WA_Globals.php

So it still doesnt like it, but I obviously dont want the website to have any reference to PowerStore200 in the URL?

Where have I gone wrong now?

Thanks in advance!

Sign in to reply to this post

neilo

Hi Ben,

Yes, UKServers are a great company (based in Somerset) - they always know what they're talking about.

Which is more than can be said for me.

Changing directory names in a solution like PowerStore can open a can of worms - there are many interconnected facets all needing to know where each other are. It would take someone like Ray, Jason, Eric or the WA Experts to fully know the impact of such a change and how to where the references need to be changed in the php files.

It may be that you just need to change the reference in your PowerStore200/WA_Globals/WA_Globals.php file to your renamed directory, but I wouldn't want to send you down a path that someone else might have to unravel later on. The menu system could also be a problem.

What happens if you revert back to the default name and configuration? Does your site load OK?

I would suggest reverting back to that, so it functions OK, then posting a new thread to ask for the steps to change the directory name.

If you do experiment, I would make a backup of all your site files/structure beforehand so you can revert to it if necessary.

For anybody who may have a good idea what to do and might jump in here, a link to your site would help them.

Sorry not to be more helpful (if it were me, I'd leave the default names as supplied!)

PS - There's a UKServers in Somerset (where I am) and also one in Rugby!

Sign in to reply to this post

ben_bradley348417

Cheers neilo,

Managed to get working now, ended up deleteing everything and just copying the raw files straight back into the folder to upload, so now its not looking for the powerstore200 folder it came with on download.

Have you done many sites with powerstore? Send some examples if you have please?

What would you use to edit all the css? Just go for it hand coding?

Sign in to reply to this post

neilo

Glad to hear you got things going.

I have not made ANY sites with powerstore, but have created the functionality of a store (small one) using other DW extensions (Power CMS, DataAssist, iWrite, SecurityAssist). If ever I were required to make a fully featured all-singing/dancing store I would use PowerStore.

To have a look at what other folks are doing with PowerStore (and other WA tools) have a browse through These

For the css I would first back-up the existing stylesheet(s) so that I can revert to this if I get in a mess, then start by opening the template and seeing what styles I want to apply site-wide, and use the styles panel to make changes. I would need to have a pretty good idea of the effect each change to the stylesheet was having throughout the site, so would be inclined to check pretty much all the pages in 'live' view - or - previewing in different browsers after each change to make sure I wasn't running into problems.

Changes to specific pages (assuming there were just one or two) I would do by adding a class to the element css, and keeping the class style in the head section of that page.

Cheers

Sign in to reply to this post

ben_bradley348417

Much appreciated Neilo!!!

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