Probably A Simple Problem?

[mystifier_uk]

I'm not sure what has happened, but this message comes up when I access the admin area of my shop:

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /homepages/31/d154998088/htdocs/shop/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

Does anyone know what the problem is?? :blink:

[Guest]

I'm not sure what has happened, but this message comes up when I access the admin area of my shop:

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /homepages/31/d154998088/htdocs/shop/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

Does anyone know what the problem is?? :blink:

 

You checked you have but all the corect settings in

ie

localhost

db name

db pass

db username

(!)

[mystifier_uk]

Where? You mean in the database.php file??

[d4funky1]

no, probably best to check the admin/configure.php file and check all the settings are correct there

[mystifier_uk]

Thanks for that d4funky1 - it works okay now! Someone replaced the configure.php file with the default one and the settings got lost! :blink:

 

But now I have another small problem! <_<

 

When I insert a new product into the catalogue and upload a picture it doesn't show up in the Admin Area, but it displays fine when I view the shop at the front end.

 

When I click on properties the Admin Area is trying to access the image at:

 

www.exampledomain.com/catalog/images/cf_1_b.JPG

 

For some reason the Admin Area is missing the '/shop/' part of the address when trying to preview the product image.

 

Can anyone tell me why this is happening and where I can change it?

[d4funky1]

do you mean the '/shop/' part or the '/catalog/' part???

 

Please list both full url's

 

Thanks

D4

[mystifier_uk]

In the Admin Area when I insert a new product and upload an image, the image doesn't show up and when I check to see where it is trying to 'preview' from the url is:

 

www.exampledomain.com/catalog/images/cf_1_b.JPG

 

But the preview url should be:

 

www.exampledomain.com/shop/catalog/images/cf_1_b.JPG

 

The image still shows up in the actual online shop though which is even more confusing!

[muttsnuts]

In the Admin Area when I insert a new product and upload an image, the image doesn't show up and when I check to see where it is trying to 'preview' from the url is:

 

www.exampledomain.com/catalog/images/cf_1_b.JPG

 

But the preview url should be:

 

www.exampledomain.com/shop/catalog/images/cf_1_b.JPG

 

The image still shows up in the actual online shop though which is even more confusing!

Try checking the settings in includes/configure.php this is the file that tells your setup where your images are stored.

[mike_fortke]

You checked you have but all the corect settings in

ie

localhost

db name

db pass

db username

(!)

 

I am having the same problem. Can you give an example of what the localhost would be? I know what my db name pass and username is. Would localhost be www.yourdomain.com

 

I was working on setting my oscommerce site to be secured with my SSL certificate. I was editing some pages none of them being configure.php or database.php and I refreshed to see the same error as mystifier_uk

 

--Bill

[Guest]

Can you give an example of what the localhost would be?

 

Try "localhost". :-"

[mike_fortke]

Try "localhost". :-"

 

OK, I will. Thanks