Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Error.


Guest

Recommended Posts

Posted

Hi,

 

I have just been trying to add osCommerce UK Debit Card (Switch) payment facility to my cart. I have run the SQL and when i try and enter my admin section i get the following error:

 

Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home5/skypower/webs/ssl/cameron-flights/cart/catalog/admin/includes/functions/database.php on line 17

Unable to connect to database server!

 

 

I have triple checked all my work and made sure the files have been uploaded etc.

 

Does anyone know why this would happen? I am also using MYSQLV4 (mysql4db-1). I don?t know if this would be the reason.

 

 

Any help would be appreciated.

 

 

Neil

Posted
mysql_pconnect():

 

Check in your configure.php files to make sure that use_pconnect is set to false. Some hosts won't allow you to run sql with persistent connections. It is good form, places less strain on the server, if you execute a query and then it's ended.

 

Vger

Posted

also in the admin/configuration there are some /tmp file settings, which need to be changed (no way of oscommerce doing this during installation, up to you after installation), create a tmp inside your own document root area ABOVE your public path

Posted

I managed to solve it, but thanks for the reply...

 

I do however have more questions if you are willing to reply?

 

When I enter a card and something is wrong I seem to get code in the text, for example:

 

The card you have entered is a <b>Solo</b><br>At this time we do not accept <b>Solo</b> as payment.

 

Any ideas why this is happening? Do i need to edit a file?

 

Again Many Thanks for all your replies.

 

 

Neil

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...