Kapitan Posted December 8, 2013 Report Share Posted December 8, 2013 Hi I got problem with airmail when i try send NOTAM to all pilots i got that error : Fatal error: Uncaught exception 'Exception' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's message inbox on 12/08/2013', '26', '1386530821')' at line 2' in /home/enterairva/domains/enterairva.pl/public_html/core/common/MailData.class.php:92 Stack trace: #0 /home/enterairva/domains/enterairva.pl/public_html/core/modules/Mail/Mail.php(130): MailData::send_new_mail('118', '1', 'Test', 'You received a ...', 26, 1386530821) #1 /home/enterairva/domains/enterairva.pl/public_html/core/modules/Mail/Mail.php(22): Mail->send() #2 [internal function]: Mail->index() #3 /home/enterairva/domains/enterairva.pl/public_html/core/classes/MainController.class.php(218): call_user_func_array(Array, Array) #4 /home/enterairva/domains/enterairva.pl/public_html/index.php(60): MainController::RunAllActions() #5 {main} thrown in /home/enterairva/domains/enterairva.pl/public_html/core/common/MailData.class.php on line 92 When i try send normal mail its ok Quote Link to comment Share on other sites More sharing options...
Kapitan Posted January 11, 2014 Author Report Share Posted January 11, 2014 Hi I got problem with airmail when i try send NOTAM to all pilots i got that error : Fatal error: Uncaught exception 'Exception' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's message inbox on 12/08/2013', '26', '1386530821')' at line 2' in /home/enterairva/domains/enterairva.pl/public_html/core/common/MailData.class.php:92 Stack trace: #0 /home/enterairva/domains/enterairva.pl/public_html/core/modules/Mail/Mail.php(130): MailData::send_new_mail('118', '1', 'Test', 'You received a ...', 26, 1386530821) #1 /home/enterairva/domains/enterairva.pl/public_html/core/modules/Mail/Mail.php(22): Mail->send() #2 [internal function]: Mail->index() #3 /home/enterairva/domains/enterairva.pl/public_html/core/classes/MainController.class.php(218): call_user_func_array(Array, Array) #4 /home/enterairva/domains/enterairva.pl/public_html/index.php(60): MainController::RunAllActions() #5 {main} thrown in /home/enterairva/domains/enterairva.pl/public_html/core/common/MailData.class.php on line 92 When i try send normal mail its ok Any one ? Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted January 12, 2014 Administrators Report Share Posted January 12, 2014 Do other air mail functions work for sending mail? If so, do some of the pilots get the NOTAM? If so, does it stop at the same use each time? If not, are you using a character that is not supported by your settings in mysql? Quote Link to comment Share on other sites More sharing options...
Kapitan Posted January 25, 2014 Author Report Share Posted January 25, 2014 Do other air mail functions work for sending mail? Yes everthing work fine If so, do some of the pilots get the NOTAM? Everyone get notam message just when you click send thats error show If so, does it stop at the same use each time? I cant tell you If not, are you using a character that is not supported by your settings in mysql? No we dont use When i replace all files and sql look like airmail work fine for few day then same error after that. Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted January 26, 2014 Members Report Share Posted January 26, 2014 What is your mysql version ? Quote Link to comment Share on other sites More sharing options...
Kapitan Posted January 26, 2014 Author Report Share Posted January 26, 2014 version: 5.5.31 Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted February 3, 2014 Administrators Report Share Posted February 3, 2014 I would look closely at the message and/or user names that are being used when this occurs as with the limited information I would have to guess it is a unsupported character getting into the sql string. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.