SQL technical problems

Category: Opencart

simonbk
284 Points
Asked:
2013-01-03 10:11 am EST

Hits: 1,151
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

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

JacobIMH
Staff
9,968 Points
2013-01-03 11:47 am EST
Hello simonbk, I apologize for the issues that you've been having.

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

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!