Hello,
I know this has been discussed and I'm going assumed fixed in the latest version of phpvms, I've had a problem with my phpvms for the past 2 days now the total hours and total flights have not been updating at all before the 2/10/2014 they worked just fine. I've checked the DB it looks like the table is updating but if you run reset PIREP count it does re-count them but never updates the Pilot profile itself or the phpvms_pilot table. I did turn on debug mode and I will post what came up in the logs.txt here, I'm just really stumped as to why they won't update.
The checks you normally ask someone who needs to run, I did that and they all came back as OK. I also sent an email to Jeff about the 1064 as I see the would kACARS in there so I assume he may know something about.
=====
Time: 02.11.14 14:01:22
=====
Time: 02.11.14 14:01:22
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='116.202.177.148' 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: 02.11.14 14:23:03
=====
Time: 02.11.14 14:23:03
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='116.73.138.121' 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: 02.11.14 14:25:29
=====
Time: 02.11.14 14:25:29
Backtrace: DB::write_debug > DB::get_row > OperationsData::getAircraftInfo > FinanceData::getLoadCount > PIREPData::populatePIREPFinance > PIREPData::fileReport > ACARSData::FilePIREP > kACARS->index > call_user_func_array > MainController::RunAllActions
Query: SELECT * FROM phpvms_aircraft WHERE `id`=B77F - GOOD
Error: (1054) - Unknown column 'B77F' in 'where clause'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=16 WHERE `pilotid`=104
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=4 WHERE `pilotid`=107
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=24 WHERE `pilotid`=108
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=36 WHERE `pilotid`=109
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=87 WHERE `pilotid`=110
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=27 WHERE `pilotid`=114
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=9 WHERE `pilotid`=119
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
=====
=====
Time: 02.11.14 20:08:45
=====
Time: 02.11.14 20:08:45
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=15 WHERE `pilotid`=120
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====
Regards,
Chris McWilliams