SQL error, my site flat lined.

[top50servers]

Ok so,

I would consider this kind of urgent but I havent seen anyone else post about this, I may have edited something badly, don't know.

In the past 4 hours my site has flat lined twice, I have not edited ANYTHING other then create a 'cron job here'

Here is the error log.

This one occurred randomly once or twice.

[12-Nov-2013 07:10:15] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home4/top50/public_html/sources/sql/mysql.php on line 48
[12-Nov-2013 07:10:15] PHP Fatal error:  Database error in &quot;<b>/home4/top50/public_html/button.php</b>&quot; on line <b>47</b><br /><br />
in /home4/top50/public_html/sources/sql/mysql.php on line 89
[12-Nov-2013 07:10:23] PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home4/top50/public_html/sources/sql/mysql.php on line 32

These 2 are alternating in the log.

[12-Nov-2013 07:13:22] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home4/top50/public_html/sources/sql/mysql.php on line 48
[12-Nov-2013 07:13:41] PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home4/top50/public_html/sources/sql/mysql.php on line 32

[12-Nov-2013 07:19:22] PHP Warning:  mysql_set_charset() expects parameter 2 to be resource, boolean given in /home4/top50/public_html/sources/sql/mysql.php on line 33
[12-Nov-2013 07:19:22] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home4/top50/public_html/sources/sql/mysql.php on line 34
[12-Nov-2013 07:19:22] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home4/top50/public_html/sources/sql/mysql.php on line 48

Any help would be much appreciated. I would like to iron out these things as my site is growing.

 

[Basti]

It cant connect to mysql, most likely mysql is down. Unless you have not modified your settings_sql.php i would contact your host.

 

[top50servers]

Ok thanks, also.

Can you advice me on this error?

PHP Notice:  Undefined index:  screenshot in /home4/top50/public_html/sources/misc/skin.php(178) : runtime-created function on line 8

I think we talked about it before somewhere but can't remember the answer.

 

[Basti]

Ah that is simply a php notice, no real error. Just tells us that a template tag which is for example in between an if statement does not exist
So the tag is not defined ( dont exist ) if the if statement dont return true.

VL 1.1 will auto handle these case, at least it should, but you never know what happens of different hostings.

Can you tell me exactly where it shows up? and is plugin enabled or disabled? Then ill post a quick update

 

[top50servers]

[15-Nov-2013 14:22:37] PHP Warning:  array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #2 is not an array in /home4/top50/public_html/sources/user_cpl.php on line 50

Any tips for this error? Only one im currently receiving.

 

[Basti]

That is an odd one. It is triggered by a db query which grabs your different sites. Never saw this one.

Does this happen for every of your members or just one specific?

 

[cr33p228]

Ok so,

I would consider this kind of urgent but I havent seen anyone else post about this, I may have edited something badly, don't know.

In the past 4 hours my site has flat lined twice, I have not edited ANYTHING other then create a 'cron job here'

Here is the error log.

This one occurred randomly once or twice.

[12-Nov-2013 07:10:15] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home4/top50/public_html/sources/sql/mysql.php on line 48
[12-Nov-2013 07:10:15] PHP Fatal error:  Database error in &quot;<b>/home4/top50/public_html/button.php</b>&quot; on line <b>47</b><br /><br />
in /home4/top50/public_html/sources/sql/mysql.php on line 89
[12-Nov-2013 07:10:23] PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home4/top50/public_html/sources/sql/mysql.php on line 32

These 2 are alternating in the log.

[12-Nov-2013 07:13:22] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home4/top50/public_html/sources/sql/mysql.php on line 48
[12-Nov-2013 07:13:41] PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home4/top50/public_html/sources/sql/mysql.php on line 32

[12-Nov-2013 07:19:22] PHP Warning:  mysql_set_charset() expects parameter 2 to be resource, boolean given in /home4/top50/public_html/sources/sql/mysql.php on line 33
[12-Nov-2013 07:19:22] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home4/top50/public_html/sources/sql/mysql.php on line 34
[12-Nov-2013 07:19:22] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home4/top50/public_html/sources/sql/mysql.php on line 48

Any help would be much appreciated. I would like to iron out these things as my site is growing.

so did u fix that error ?

 

[Mark]

"Can't connect to local MySQL server"
"A link to the server could not be established"

when those errors happen intermittently without the user doing anything, it means 100% his web server had a mysql outage at that time.