SQL technical problems
I have called about this two times. Since you started working on the SQL at Inmotion, I have had multiple problems. I have lost work because OpenCart won't save my work at times. Every other time I login to my C panel my Top Applications will not load......including today. When I tried to access my OpenCart site I got the message below. Fix it!
heartlandpetbeds.com/test
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /home/heartl43/public_html/test/system/database/mysql.php on line 6
Notice: Error: Could not make a database link using heartl43_heart@localhost in /home/heartl43/public_html/test/system/database/mysql.php on line 7
Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 10
Notice: Error: Could not connect to database heartl43_heart in /home/heartl43/public_html/test/system/database/mysql.php on line 11
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 14
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 15
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 16
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 17
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 21
Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 49
Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 49
Notice: Error:
Error No:
SELECT * FROM oc_setting WHERE store_id = '0' in /home/heartl43/public_html/test/system/database/mysql.php on line 49
Warning: mysql_close() expects parameter 1 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 67
heartlandpetbeds.com/test
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /home/heartl43/public_html/test/system/database/mysql.php on line 6
Notice: Error: Could not make a database link using heartl43_heart@localhost in /home/heartl43/public_html/test/system/database/mysql.php on line 7
Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 10
Notice: Error: Could not connect to database heartl43_heart in /home/heartl43/public_html/test/system/database/mysql.php on line 11
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 14
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 15
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 16
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 17
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 21
Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 49
Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 49
Notice: Error:
Error No:
SELECT * FROM oc_setting WHERE store_id = '0' in /home/heartl43/public_html/test/system/database/mysql.php on line 49
Warning: mysql_close() expects parameter 1 to be resource, boolean given in /home/heartl43/public_html/test/system/database/mysql.php on line 67
There were some recent issues with the MySQL service on the server that your site is hosted on. I've spoken with our system administration department and they've told me that these issues shouldn't continue.
It seems that there was an issue temporarily with MySQL writing to the /tmp location on the hard drive, and also we just recently updated MySQL to patch a new security threat in the wild, so MySQL service would have been affected briefly during that upgrade.
If you continue to notice any issues please let us know so that we can continue to investigate any problems.
- Jacob