{"action":"created","issue":{"url":"https://api.github.com/repos/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/10","repository_url":"https://api.github.com/repos/sgladstone/com.fountaintribe.hebrewcalendarhelper","labels_url":"https://api.github.com/repos/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/10/comments","events_url":"https://api.github.com/repos/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/10/events","html_url":"https://github.com/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/10","id":176174513,"number":10,"title":"DB error due to month having apostrophe in Sh'vat","user":{"login":"gzh1960","id":6695874,"avatar_url":"https://avatars.githubusercontent.com/u/6695874?v=3","gravatar_id":"","url":"https://api.github.com/users/gzh1960","html_url":"https://github.com/gzh1960","followers_url":"https://api.github.com/users/gzh1960/followers","following_url":"https://api.github.com/users/gzh1960/following{/other_user}","gists_url":"https://api.github.com/users/gzh1960/gists{/gist_id}","starred_url":"https://api.github.com/users/gzh1960/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gzh1960/subscriptions","organizations_url":"https://api.github.com/users/gzh1960/orgs","repos_url":"https://api.github.com/users/gzh1960/repos","events_url":"https://api.github.com/users/gzh1960/events{/privacy}","received_events_url":"https://api.github.com/users/gzh1960/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-09-10T11:11:48Z","updated_at":"2016-09-11T23:06:05Z","closed_at":"2016-09-10T18:17:20Z","body":"**Db error on temp table when a yahrzeit date falls in Sh'vat when the **Calculate job** is run as below**:\r\n**Quick fix** take the apostrophe out of the string so Sh'vat becomes Shvat. This allows the Calculate job to run successfully although it produces on screen:\r\n\"5776-2-30: inside verify function :\r\n\r\n2/30/5776 Test heb: 2/30/5776\r\n\r\n5776-2-30: inside verify function :\r\n\r\n2/30/5776 Test heb: 2/30/57761\" \r\n\r\n**Sample Log**\r\nSep 10 20:26:38  [info] $Fatal Error Details = Array\r\n(\r\n    [callback] => Array\r\n        (\r\n            [0] => CRM_Core_Error\r\n            [1] => exceptionHandler\r\n        )\r\n\r\n    [code] => -2\r\n    [message] => DB Error: syntax error\r\n    [mode] => 16\r\n    [debug_info] => INSERT INTO civicrm_fountaintribe_yahrzeits_temp ( mourner_contact_id,\r\n\t  mourner_name, \r\n\t  deceased_contact_id,\r\n\t  deceased_name, \r\n\t  deceased_date, d_before_sunset,\r\n\t  hebrew_deceased_date, yahrzeit_date ,\r\n\t  yahrzeit_hebrew_date_format_hebrew, yahrzeit_hebrew_date_format_english,\r\n\t  yahrzeit_date_display, relationship_name_formatted, yahrzeit_type,\r\n\t  mourner_observance_preference, plaque_location,\r\n\t  yahrzeit_erev_shabbat_before, yahrzeit_shabbat_morning_before,\r\n\t  yahrzeit_erev_shabbat_after , yahrzeit_shabbat_morning_after,\r\n\t  yahrzeit_date_morning, yahrzeit_relationship_id\r\n\t  )\r\n\t\t\tVALUES(2149, 'XXXX' , 2715,\r\n\t\t\t'XXXX', \r\n\t\t\t '1945-2-9' , 'Yes',\r\n\t\t\t'26 Sh'vat 5705' , '2017-02-21',\r\n\t\t\t'כו שבט התשעז', '26 Sh\\'vat 5777',\r\n\t\t\t'21 February 2017 starting at sunset ', 'husband', '0',\r\n\t\t\t'0', 'Unknown or No Plaque',\r\n\t\t\t'2017-02-17', '2017-02-18', '2017-02-24', '2017-02-25',\r\n\t  \t\t'2017-02-22', '20'  ) [nativecode=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 'vat 5705' , '2017-02-21',\r\n\t\t\t'כו שבט התשעז', '26 Sh\\'vat 5777',\r\n\t\t\t'21' at line 17]"},"comment":{"url":"https://api.github.com/repos/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/comments/246210898","html_url":"https://github.com/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/10#issuecomment-246210898","issue_url":"https://api.github.com/repos/sgladstone/com.fountaintribe.hebrewcalendarhelper/issues/10","id":246210898,"user":{"login":"gzh1960","id":6695874,"avatar_url":"https://avatars.githubusercontent.com/u/6695874?v=3","gravatar_id":"","url":"https://api.github.com/users/gzh1960","html_url":"https://github.com/gzh1960","followers_url":"https://api.github.com/users/gzh1960/followers","following_url":"https://api.github.com/users/gzh1960/following{/other_user}","gists_url":"https://api.github.com/users/gzh1960/gists{/gist_id}","starred_url":"https://api.github.com/users/gzh1960/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gzh1960/subscriptions","organizations_url":"https://api.github.com/users/gzh1960/orgs","repos_url":"https://api.github.com/users/gzh1960/repos","events_url":"https://api.github.com/users/gzh1960/events{/privacy}","received_events_url":"https://api.github.com/users/gzh1960/received_events","type":"User","site_admin":false},"created_at":"2016-09-11T23:06:05Z","updated_at":"2016-09-11T23:06:05Z","body":"Sarah, one thing still, when I run the Calculate job manually the screen fills up with messages like below:\r\n\"5776-2-30: inside verify function :\r\n\r\n2/30/5776 Test heb: 2/30/5776\r\n\r\n5776-2-30: inside verify function :\r\n\r\n2/30/5776 Test heb: 2/30/57761\" \r\nThe job runs successfully.\r\nI assume there must be some monitoring/debugging code somewhere logging the dates,can you check this please? "}}
{"actor":{"display_login":"gzh1960"}}