PIREP Submit Error

[t_bergman]

See Below

[t_bergman]

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.

[simpilot]

Looks like the second now() function is in quotes. It is reading it as 'now()' instead of a time value would be my guess.

[t_bergman]

Looks like the second now() function is in quotes. It is reading it as 'now()' instead of a time value would be my guess.

I got the same error when I took away the quotes, 'NOW()' is also being inserted into the submitdate field and it works perfectly, this is why i can't figure out why the modifydate is not working.

I did a clean install on the windows server, to make sure its not a carryover issue from a linux server, but the same result happened.