t_bergman Posted March 17, 2015 Report Share Posted March 17, 2015 See Below Quote Link to comment Share on other sites More sharing options...
t_bergman Posted March 17, 2015 Author Report Share Posted March 17, 2015 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. Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted March 17, 2015 Administrators Report Share Posted March 17, 2015 Looks like the second now() function is in quotes. It is reading it as 'now()' instead of a time value would be my guess. Quote Link to comment Share on other sites More sharing options...
t_bergman Posted March 18, 2015 Author Report Share Posted March 18, 2015 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. 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.