Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL Error.


Recommended Posts



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.




Link to comment
Share on other sites



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.



Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.




Link to comment
Share on other sites


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

  • Create New...