I've changed everything back to the NOW() Command, I've figured out (though reading the manual) that the command is supported in mysql 5.6.
The error's phpVMS is throwing are below
=====
Time: 03.17.15 01:08:34
=====
Time: 03.17.15 01:08:34
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > PIREPS->SubmitPIREP > PIREPS->viewpireps > PIREPS->mine > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps (`pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `aircraft`, `flighttime`, `route`, `submitdate`, `fuelused`, `source`, `route_details`, `load`, `distance`, `landingrate`, `rawdata`, `flighttime_stamp`, `exported`, `modifieddate`, `accepted`, `expenselist`, `flighttype`) VALUES ('1', 'HPH', '118', 'KAPF', 'MYNN', '2', '1.10', 'CYY DEEDS WORPP CURVE DHP VKZ SKIPS LEEVI SWIMM WOOZE RAJAY PRINE HINZY ZQA', NOW(), '214.5', 'manual', 'a:13:{s:3:\"CYY\";O:8:\"stdClass\":11:{s:2:\"id\";s:5:\"29291\";s:4:\"name\";s:3:\"CYY\";s:5:\"title\";s:7:\"Cypress\";s:6:\"airway\";s:4:\"Q102\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:3:\"560\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"26.153400\";s:3:\"lng\";s:10:\"-81.778198\";s:4:\"freq\";s:6:\"108.60\";s:4:\"type\";s:1:\"3\";}s:5:\"DEEDS\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"8992\";s:4:\"name\";s:5:\"DEEDS\";s:5:\"title\";s:5:\"DEEDS\";s:6:\"airway\";s:2:\"B9\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:3:\"210\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.977863\";s:3:\"lng\";s:10:\"-81.233223\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:5:\"WORPP\";O:8:\"stdClass\":11:{s:2:\"id\";s:5:\"65582\";s:4:\"name\";s:5:\"WORPP\";s:5:\"title\";s:5:\"WORPP\";s:6:\"airway\";s:3:\"V35\";s:11:\"airway_type\";s:1:\"L\";s:3:\"seq\";s:2:\"95\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.893400\";s:3:\"lng\";s:10:\"-80.973999\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:5:\"CURVE\";O:8:\"stdClass\":11:{s:2:\"id\";s:5:\"65581\";s:4:\"name\";s:5:\"CURVE\";s:5:\"title\";s:5:\"CURVE\";s:6:\"airway\";s:3:\"V35\";s:11:\"airway_type\";s:1:\"L\";s:3:\"seq\";s:2:\"90\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.783199\";s:3:\"lng\";s:10:\"-80.638199\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:3:\"DHP\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"3371\";s:4:\"name\";s:3:\"DHP\";s:5:\"title\";s:7:\"Dolphin\";s:6:\"airway\";s:4:\"A509\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:3:\"260\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.799801\";s:3:\"lng\";s:10:\"-80.348999\";s:4:\"freq\";s:6:\"113.90\";s:4:\"type\";s:1:\"3\";}s:3:\"VKZ\";O:8:\"stdClass\":11:{s:2:\"id\";s:5:\"15442\";s:4:\"name\";s:3:\"VKZ\";s:5:\"title\";s:12:\"Virginia Key\";s:6:\"airway\";s:4:\"J113\";s:11:\"airway_type\";s:1:\"H\";s:3:\"seq\";s:3:\"500\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.751900\";s:3:\"lng\";s:10:\"-80.154297\";s:4:\"freq\";s:6:\"117.10\";s:4:\"type\";s:1:\"3\";}s:5:\"SKIPS\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"1321\";s:4:\"name\";s:5:\"SKIPS\";s:5:\"title\";s:5:\"SKIPS\";s:6:\"airway\";s:4:\"A301\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:4:\"2513\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.553892\";s:3:\"lng\";s:10:\"-79.274368\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:5:\"LEEVI\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"8849\";s:4:\"name\";s:5:\"LEEVI\";s:5:\"title\";s:5:\"LEEVI\";s:6:\"airway\";s:4:\"B760\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:4:\"2590\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.539801\";s:3:\"lng\";s:10:\"-79.212601\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:5:\"SWIMM\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"1573\";s:4:\"name\";s:5:\"SWIMM\";s:5:\"title\";s:5:\"SWIMM\";s:6:\"airway\";s:4:\"A315\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:4:\"2511\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.499779\";s:3:\"lng\";s:10:\"-79.038361\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:5:\"WOOZE\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"9555\";s:4:\"name\";s:5:\"WOOZE\";s:5:\"title\";s:5:\"WOOZE\";s:6:\"airway\";s:5:\"BR53V\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:3:\"230\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.425900\";s:3:\"lng\";s:10:\"-78.719299\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:5:\"RAJAY\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"3562\";s:4:\"name\";s:5:\"RAJAY\";s:5:\"title\";s:5:\"RAJAY\";s:6:\"airway\";s:4:\"A555\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:4:\"2700\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.299793\";s:3:\"lng\";s:10:\"-78.181335\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:5:\"HINZY\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"3564\";s:4:\"name\";s:5:\"HINZY\";s:5:\"title\";s:5:\"HINZY\";s:6:\"airway\";s:4:\"A555\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:4:\"2707\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.114500\";s:3:\"lng\";s:10:\"-77.683998\";s:4:\"freq\";s:0:\"\";s:4:\"type\";s:1:\"3\";}s:3:\"ZQA\";O:8:\"stdClass\":11:{s:2:\"id\";s:4:\"3565\";s:4:\"name\";s:3:\"ZQA\";s:5:\"title\";s:6:\"Nassau\";s:6:\"airway\";s:4:\"A555\";s:11:\"airway_type\";s:1:\"B\";s:3:\"seq\";s:4:\"2710\";s:3:\"loc\";s:3:\"NAM\";s:3:\"lat\";s:9:\"25.040400\";s:3:\"lng\";s:10:\"-77.470398\";s:4:\"freq\";s:6:\"112.70\";s:4:\"type\";s:1:\"3\";}}', '28', '242.9669232532', '0', '', '1:10:00', '0', 'NOW()', '0', '0', 'SP');
Error: (1292) - Incorrect datetime value: 'NOW()' for column 'modifieddate' at row 1
=====
=====
=====
Time: 03.17.15 01:08:34
=====
Time: 03.17.15 01:08:34
Backtrace: DB::write_debug > DB::query > ActivityData::addActivity > PIREPData::fileReport > PIREPS->SubmitPIREP > PIREPS->viewpireps > PIREPS->mine > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO `phpvms_activityfeed` (`pilotid`, `refid`, `type`, `message`, `submitdate`) VALUES (1,,1,'has filed a PIREP from KAPF to MYNN', 2015-03-17 01:08:34)
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 '1,'has filed a PIREP from KAPF to MYNN', 2015-03-17 01:08:34)' at line 4
=====
=====
What I really care about is the first error as its keeping me from filing PIREPS, what I can't understand is why the modified date is throwing the error and not the submit date. Both columns within the database are set up EXACTLY alike.
The server is Win2k8 R2 IIS7.5, php v5.4 running under the fastcgi impersonate, and mysql v5.6. phpVMS version is SimPilot 5.5.1
The site is not writing any errors to errors.txt. What could be causing this and is there a solution?
I've been able to put a bandaid over it by changing the modifieddate column to varchar but I don't know if that will mess things up in the long run.