ARV187 Posted March 20, 2013 Report Share Posted March 20, 2013 (edited) Hi, normally we have this errors in log file, how i can fix it? thanks! ===== Time: 03.20.13 04:58:22 ===== Time: 03.20.13 04:58:22 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.53.112.115' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== ===== Time: 03.20.13 11:25:28 ===== Time: 03.20.13 11:25:28 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.32.189.60' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== ===== Time: 03.20.13 11:28:28 ===== Time: 03.20.13 11:28:28 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='95.20.213.42' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== ===== Time: 03.20.13 13:08:39 ===== Time: 03.20.13 13:08:39 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='95.20.213.42' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== ===== Time: 03.20.13 13:23:51 ===== Time: 03.20.13 13:23:51 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='87.221.212.64' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_results > StatsData::UsersOnline > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.* FROM phpvms_pilots p, phpvms_sessions s WHERE s.pilotid = p.pilotid AND DATE_SUB(NOW(), INTERVAL 20 MINUTE) <= s.`logintime` Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_results > StatsData::GuestsOnline > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT s.* FROM phpvms_sessions s WHERE s.pilotid = 0 AND DATE_SUB(NOW(), INTERVAL 20 MINUTE) <= s.`logintime` Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 16:21:32 ===== Time: 03.20.13 16:21:32 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='95.20.213.42' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::PilotCount > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(*) as `total` FROM phpvms_pilots Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_row > StatsData::TotalFlights > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(*) AS `total` FROM `phpvms_pireps` WHERE `accepted`=1 Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::TotalMilesFlown > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT SUM(`distance`) AS `total` FROM phpvms_pireps WHERE accepted = '1' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::TotalSchedules > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(`id`) as `total` FROM phpvms_schedules Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::TotalFlightsToday > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(*) AS `total` FROM phpvms_pireps WHERE DATE(`submitdate`) = CURDATE() Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:23:03 ===== Time: 03.20.13 17:23:03 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:23:03 ===== Time: 03.20.13 17:23:03 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:24:19 ===== Time: 03.20.13 17:24:19 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:24:19 ===== Time: 03.20.13 17:24:19 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:24:47 ===== Time: 03.20.13 17:24:47 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='187.135.47.79' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== Edited July 1, 2013 by ARV187 Quote Link to comment Share on other sites More sharing options...
ARV187 Posted June 30, 2013 Author Report Share Posted June 30, 2013 (edited) I still have same problem ===== Time: 06.30.13 14:18:55 ===== Time: 06.30.13 14:18:55 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > PilotData::updatePilotStats > PIREPAdmin->edit_pirep_post > PIREPAdmin->post_action > PIREPAdmin->viewpending > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalhours`=0, `totalflights`=0 WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== Edited July 1, 2013 by ARV187 Quote Link to comment Share on other sites More sharing options...
freshJet Posted July 1, 2013 Report Share Posted July 1, 2013 Could you edit that to a code snippet rather than a spoiler please? Makes it easier to read and therefore easier to help you... Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted July 1, 2013 Administrators Report Share Posted July 1, 2013 What version is this site running on? Do you get any on screen errors when you are using the "PIREPAdmin" section of the admin side? I see two errors that should point you in a general direction: 1 - ( WHERE `pilotid`= ) looks as though you have PIREPS without a pilot id possibly coming from an ACARS program? You need to look in the database and see if there are pilot id's recorded in all of them or possibly the core file is corrupted. 2 - Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away This could be either that the script is hanging up and leaving the connection to the sql server open which gets closed after a period of inactivity, or the sql server has more connections than it can handle. In the first case, look at the data your are trying to pull from the database, is it there? Is it something it shouldnt be? Is the field missing entirely? In the second case, it is an issue with the host. Have you reloaded the install folder and run the checkinstall function? Did it show any corrupt files? Quote Link to comment Share on other sites More sharing options...
ARV187 Posted July 1, 2013 Author Report Share Posted July 1, 2013 Could you edit that to a code snippet rather than a spoiler please? Makes it easier to read and therefore easier to help you... Done! What version is this site running on? Do you get any on screen errors when you are using the "PIREPAdmin" section of the admin side? I see two errors that should point you in a general direction: 1 - ( WHERE `pilotid`= ) looks as though you have PIREPS without a pilot id possibly coming from an ACARS program? You need to look in the database and see if there are pilot id's recorded in all of them or possibly the core file is corrupted. 2 - Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away This could be either that the script is hanging up and leaving the connection to the sql server open which gets closed after a period of inactivity, or the sql server has more connections than it can handle. In the first case, look at the data your are trying to pull from the database, is it there? Is it something it shouldnt be? Is the field missing entirely? In the second case, it is an issue with the host. Have you reloaded the install folder and run the checkinstall function? Did it show any corrupt files? I must see this with more time, to make all checks. But as an introduction, the phpvms version is : 2.1.v2.1.935, php server is configured as 5.3. but in Cpanelx i see this: Version de PHP 5.2.17 Version de MySQL 5.5.30-cll-lve The others item to check, in a couple of days i will do it. Thanks by the answers!!! Quote Link to comment Share on other sites More sharing options...
ARV187 Posted July 7, 2013 Author Report Share Posted July 7, 2013 Ok, i did all cheks: What version is this site running on? phpvms version is : 2.1.v2.1.935 php server is 5.3 Version the MySQL 5.5.30-cll-lve Do you get any on screen errors when you are using the "PIREPAdmin" section of the admin side? No screen errors. I see two errors that should point you in a general direction:1 - ( WHERE `pilotid`= ) looks as though you have PIREPS without a pilot id possibly coming from an ACARS program? You need to look in the database and see if there are pilot id's recorded in all of them or possibly the core file is corrupted. Pilot id its present in all pireps in DB. 2 - Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away This could be either that the script is hanging up and leaving the connection to the sql server open which gets closed after a period of inactivity, or the sql server has more connections than it can handle. In the first case, look at the data your are trying to pull from the database, is it there? Is it something it shouldnt be? Is the field missing entirely? In the second case, it is an issue with the host. For example, the error #1 "(where `pilotid`= )" data is saved in phpvms_pilots, its there. The error #2 "MySQL server has gone away" has not been repeated, may be a particular time of that day. So i think that this is fixed. Have you reloaded the install folder and run the checkinstall function? Did it show any corrupt files? The result of checkinstall: phpVMS Virtual Airline Administration Software Install Check phpVMS Build Number: v2.1.935 Checking PHP version [OK] PHP version is 5.3.26.x ASP Tags [OK] ASP-style tags are disabled Checking connectivity... [OK] Can contact outside servers Checking for SimpleXML module... [OK] SimpleXML module exists! Checking file hashes for corrupt or mismatched files [Checksum failed] /admin/lib/layout/header.tpl did not match, possibly corrupt or out of date [Checksum failed] /admin/maintenance.php did not match, possibly corrupt or out of date [Checksum failed] /admin/templates/ops_scheduleform.tpl did not match, possibly corrupt or out of date [Checksum failed] /admin/templates/ops_aircraftform.tpl did not match, possibly corrupt or out of date -- Checked 183 files, found 4 errors[/Code] Are modified files to addons options or translations. Other recents & habitual errors: [code] ===== Time: 07.05.13 05:36:11 ===== Time: 07.05.13 05:36:11 Backtrace: DB::write_debug > DB::get_row > PIREPData::getReportDetails > PIREPAdmin->edit_pirep_post > PIREPAdmin->post_action > PIREPAdmin->viewpending > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, s.*, s.id AS scheduleid, p.route, p.route_details, u.pilotid, u.firstname, u.lastname, u.email, u.rank, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng, p.code, p.flightnum, p.depicao, p.arricao, p.price AS price, a.id as aircraftid, a.name as aircraft, a.registration, p.flighttime, p.distance, UNIX_TIMESTAMP (p.submitdate) as submitdate, p.accepted, p.log FROM phpvms_pilots u, phpvms_pireps p LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_schedules s ON s.code = p.code AND s.flightnum = p.flightnum WHERE p.pilotid=u.pilotid AND p.pirepid= Error: (1064) - 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 '' at line 13 ===== Time: 07.05.13 05:56:13 ===== Time: 07.05.13 05:56:13 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS_Free->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='XX.XX.23.221' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== Time: 07.05.13 05:57:24 ===== Time: 07.05.13 05:57:24 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS_Free->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='XX.XX.209.219' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== Time: 07.05.13 14:23:51 ===== Time: 07.05.13 14:23:51 Backtrace: DB::write_debug > DB::get_row > OperationsData::getAircraftInfo > FinanceData::getLoadCount > PIREPData::populatePIREPFinance > PIREPData::fileReport > ACARSData::FilePIREP > kACARS_Free->index > call_user_func_array > MainController::RunAllActions Query: SELECT * FROM phpvms_aircraft WHERE `id`=EF-2000 Error: (1054) - Unknown column 'EF' in 'where clause' ===== ===== Time: 07.06.13 05:00:02 ===== Time: 07.06.13 05:00:02 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance::resetpirepcount > MainController::Run Query: UPDATE phpvms_pilots SET `totalpireps`=318 WHERE `pilotid`=2 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== Time: 07.07.13 09:08:24 ===== Time: 07.07.13 09:08:24 Backtrace: DB::write_debug > DB::get_row > PIREPData::getReportDetails > PIREPAdmin->edit_pirep_post > PIREPAdmin->post_action > PIREPAdmin->viewpending > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, s.*, s.id AS scheduleid, p.route, p.route_details, u.pilotid, u.firstname, u.lastname, u.email, u.rank, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng, p.code, p.flightnum, p.depicao, p.arricao, p.price AS price, a.id as aircraftid, a.name as aircraft, a.registration, p.flighttime, p.distance, UNIX_TIMESTAMP (p.submitdate) as submitdate, p.accepted, p.log FROM phpvms_pilots u, phpvms_pireps p LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_schedules s ON s.code = p.code AND s.flightnum = p.flightnum WHERE p.pilotid=u.pilotid AND p.pirepid= Error: (1064) - 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 '' at line 13 ===== ===== ===== Time: 07.07.13 09:08:25 ===== Time: 07.07.13 09:08:25 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > PilotData::updatePilotStats > PIREPAdmin->edit_pirep_post > PIREPAdmin->post_action > PIREPAdmin->viewpending > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalhours`=0, `totalflights`=0 WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== ===== Time: 07.07.13 10:56:07 ===== Time: 07.07.13 10:56:07 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='xx.xx.99.178' WHERE `pilotid`= Error: (1064) - 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 '' at line 1 ===== The most errors are when a pilot login in kacars, etc or in webpage, work good, not issues, but log phpvms regist a error. Quote Link to comment Share on other sites More sharing options...
ARV187 Posted July 21, 2013 Author Report Share Posted July 21, 2013 up! 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.