2nd Request (SQL)

Category: Opencart

simonbk
284 Points
Asked:
2013-01-11 11:22 am EST

Hits: 525
My 2nd request for you folks to fix this.

When working in my Open Cart Admin area when I hit save (In any area) the below happens:


Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95 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

After that happens it takes me about three times to even get back into my site.
Oh, by the way, the item I was working on "Was not saved". I have to do it all over again.

When trying to get back in it says the common "website unavailable".

Also, this started on the week you folks were working on SQL on your end.

Please escalate this!!

Fix this please!

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,521 Points
2013-01-11 1:46 pm EST
Hello simonbk, sorry to hear that you were having some temporary issues connecting to the MySQL service on the server.

Our system administration team does constantly monitor all critical services on our servers, so if something like this is happening, it should be resolved shortly as they troubleshoot the root cause of these problems rather quickly since it could affect many user's sites.

On a shared server unfortunately every once in awhile a temporary service problem like this could happen if there are a ton of MySQL requests happening at once, or some sort of error encountered in the MySQL service itself.

Were you encountering these errors yesterday? I do see in the MySQL logs there were some errors encountered around 8PM EST for a few minutes.

Typically I'd recommend when you have an issue like this to shoot an email to (support@inmotionhosting.com) being sure to include the last 4 digits of the credit card on file or the current AMP password to your account for verification.

You'd want to include the time you were having issues, and the duration it was occurring for, that way it can be escalated to our system administration department. They can then determine if it was a server wide issue at that time, or possibly if it was something directly related to your own account such as hitting your maximum number of database connections at once.

- Jacob

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

Like this Question?

News / Announcements

WordPress wp-login.php brute force attack
Updated 2014-07-17 06:43 pm EST
Hits: 201133

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!