2nd Request (SQL)

Avatar
  • Answered
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!
Avatar
JacobIMH

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 ([email protected]) 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