error after moved to new server(MySQL server has gone away) Session halted.

[Agoenxz]

When members click ads the it comes to cheatcheck, it sometimes working but sometimes shows an error like this>
Database error: Invalid SQL: SELECT user_id FROM sessions WHERE (sess_id = '47TXk0MU1EVTBPVEkzTW') AND (sess_id2='47TXk') AND (user_id='47') and (remote_ip='79.227.23.37' or ipvoid='1')
MySQL Error: 2006 (MySQL server has gone away)
Session halted.

also the forum is error too>
Database Error: MySQL server has gone away
File: /home/myclickz/public_html/forum/Sources/Security.php
Line: 279

im wondering what is MySQL server means?? and also if someone might now now whats the problem is... tks in advance!

[cobraptc]

When members click ads the it comes to cheatcheck, it sometimes working but sometimes shows an error like this>
Database error: Invalid SQL: SELECT user_id FROM sessions WHERE (sess_id = '47TXk0MU1EVTBPVEkzTW') AND (sess_id2='47TXk') AND (user_id='47') and (remote_ip='79.227.23.37' or ipvoid='1')
MySQL Error: 2006 (MySQL server has gone away)
Session halted.

also the forum is error too>
Database Error: MySQL server has gone away
File: /home/myclickz/public_html/forum/Sources/Security.php
Line: 279

im wondering what is MySQL server means?? and also if someone might now now whats the problem is... tks in advance!

You will need to talk to your hosting provider to see what is going on with the mysql server.

[Agoenxz]

so is this a server problem??

[757jterrell]

Whenever you see this in an error message:

MySQL server has gone away

Means that the server's sql resources have dropped or were over loaded.  This is a hosting issue. If you tell your host that your are getting sql drops then they should be able to fix it pretty easy.

[Agoenxz]

Whenever you see this in an error message:

MySQL server has gone away

Means that the server's sql resources have dropped or were over loaded.  This is a hosting issue. If you tell your host that your are getting sql drops then they should be able to fix it pretty easy.

i did tell him tho, and still hasnt get fixed yet...

[757jterrell]

It really is a host issue not a script issue. If you host does not fix sql drops, then I would look for another host, ask specifically for high resource hosting.

[Agoenxz]

It really is a host issue not a script issue. If you host does not fix sql drops, then I would look for another host, ask specifically for high resource hosting.

yes... tks! it fixed now, but i have new problems, the emailer seems working fine but the ads alerts and paid emails wouldnt send any emails to member. do u know whats wrong??

[cARRIE]

Go to your cpanel > cron jobs

check if you have these 3 crons

/usr/bin/curl --silent http://www.domain.com/cron-ad-alert.php?pwd=password 2 > /dev/null     

*/5   *   *   *   *

/usr/bin/curl --silent http://www.domain.com/pemailcron2.php?pwd=password 2 > /dev/null     

*/10   *   *   *   *

/usr/bin/curl --silent http://www.domain.com/pemailcron.php?pwd=password 2 > /dev/null     

5   0   */2   *   *

Cron jobs for Aurora
http://auroraadmintraining.info/index.php/topic,46.msg57.html#msg57
 

[Agoenxz]

Go to your cpanel > cron jobs

check if you have these 3 crons

/usr/bin/curl --silent http://www.domain.com/cron-ad-alert.php?pwd=password 2 > /dev/null     

*/5   *   *   *   *

/usr/bin/curl --silent http://www.domain.com/pemailcron2.php?pwd=password 2 > /dev/null     

*/10   *   *   *   *

/usr/bin/curl --silent http://www.domain.com/pemailcron.php?pwd=password 2 > /dev/null     

5   0   */2   *   *

Cron jobs for Aurora
http://auroraadmintraining.info/index.php/topic,46.msg57.html#msg57
 

yes its all ready done & seems working good now..  tks!

[cARRIE]

Great, i'm glad its working now. 

[Agoenxz]

Great, i'm glad its working now. 

i am very glad too!!