Hi Guys i went to sleep last night and when i awoke i was getting the following when trying to get to any of my carts on my vps
mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)
I went through and restarted the MySQL service on the server and it brought the sites back up. However two sites on one domain are still pretty broke. Although technically i can see the pages and the data it looks as though all formatting has gone out the window.
The only thing that happened yesterday was that i out the smartoptimizer on the server and pointed it to one of the carts…
I later removed the code from the .htaccess file so it was not even being used.
from the following two sites you can see that things are in a bad way
http://vspace.net.au/beachpool/index.php
http://vspace.net.au/chique/index.php
Do you have any backups of your sites? It looks like the entire /your_skin/ directory is missing. You said you deleted the SmartOptimizer code from the .htaccess but maybe there's some caching going on.
Try troubleshooting according to this thread - Smartoptimizer - Configuration - CS-Cart Community Forums as it sounds like the users there had the same problems as you, perhaps one of their workarounds can undo this on your carts.
As said before, restore your .htaccess file to the default .htaccess. Delete all the contents of /smartoptimizer/cache/
Delete the contents of /var/cache/
Refresh your page by pressing F5. That should sort it - your skins folder/file structure is in tact.
[quote name='Confusion' timestamp='1363302343' post='157796']
Hi Guys i went to sleep last night and when i awoke i was getting the following when trying to get to any of my carts on my vps
mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
I went through and restarted the MySQL service on the server and it brought the sites back up. However two sites on one domain are still pretty broke. Although technically i can see the pages and the data it looks as though all formatting has gone out the window.
The only thing that happened yesterday was that i out the smartoptimizer on the server and pointed it to one of the carts…
I later removed the code from the .htaccess file so it was not even being used.
from the following two sites you can see that things are in a bad way
http://vspace.net.au…hpool/index.php
[url=“http://vspace.net.au/chique/index.php”]http://vspace.net.au/chique/index.php[/url]
[/quote]
I would try to connect using mysqli driver instead of mysql in for no other reason than security.
i just removed the .htaccess from the public root and everything has come back to normal