{"action":"created","issue":{"url":"https://api.github.com/repos/mistic100/Piwigo/issues/50","labels_url":"https://api.github.com/repos/mistic100/Piwigo/issues/50/labels{/name}","comments_url":"https://api.github.com/repos/mistic100/Piwigo/issues/50/comments","events_url":"https://api.github.com/repos/mistic100/Piwigo/issues/50/events","html_url":"https://github.com/mistic100/Piwigo/issues/50","id":97225374,"number":50,"title":"[notification] affichage erreur envoi notification","user":{"login":"plegall","id":9326959,"avatar_url":"https://avatars.githubusercontent.com/u/9326959?v=3","gravatar_id":"","url":"https://api.github.com/users/plegall","html_url":"https://github.com/plegall","followers_url":"https://api.github.com/users/plegall/followers","following_url":"https://api.github.com/users/plegall/following{/other_user}","gists_url":"https://api.github.com/users/plegall/gists{/gist_id}","starred_url":"https://api.github.com/users/plegall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plegall/subscriptions","organizations_url":"https://api.github.com/users/plegall/orgs","repos_url":"https://api.github.com/users/plegall/repos","events_url":"https://api.github.com/users/plegall/events{/privacy}","received_events_url":"https://api.github.com/users/plegall/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mistic100/Piwigo/labels/minor","name":"minor","color":"ededed"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-25T13:05:26Z","updated_at":"2015-07-25T20:43:04Z","closed_at":"2015-07-25T13:09:31Z","body":"**Reported by patnoe on 29 Aug 2007 10:05**\n\n**Version:** 1.7.0\n\nA l&#039;envoi de la Notification par mail j&#039;ai les messages suivant qui s&#039;affichent\r\n\r\nSELECT count(distinct image_id) as CountId\r\n\r\n  FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id\r\n  WHERE date_available &gt; &#039;&#039;\r\n    AND date_available &lt;= &#039;2007-08-29 08:47:11&#039;\r\n      AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,\r\netc.....))\r\n;\r\n[mysql 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 &#039;))&#039; at line 6\r\n\r\nWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\\www\\phpwebgallery\\include\\functions_notification.inc.php on line 152\r\n\r\nSELECT count(distinct category_id) as CountId\r\n\r\n  FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id\r\n  WHERE date_available &gt; &#039;&#039;\r\n    AND date_available &lt;= &#039;2007-08-29 08:47:11&#039;\r\n      AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,\r\netc.........))\r\n;\r\n[mysql 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 &#039;))&#039; at line 8\r\n\r\nWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\\www\\phpwebgallery\\include\\functions_notification.inc.php on line 152\r\n\r\nSELECT count(distinct image_id) as CountId\r\n\r\n  FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id\r\n  WHERE date_available &gt; &#039;&#039;\r\n    AND date_available &lt;= &#039;2007-08-29 08:47:11&#039;\r\n      AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,\r\netc........))\r\n;\r\n[mysql 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 &#039;))&#039; at line 6\r\n\r\nWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\\www\\phpwebgallery\\include\\functions_notification.inc.php on line 152\r\n\r\nSELECT count(distinct category_id) as CountId\r\n\r\n  FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category AS ic ON image_id = id\r\n  WHERE date_available &gt; &#039;&#039;\r\n    AND date_available &lt;= &#039;2007-08-29 08:47:11&#039;\r\n      AND (ic.category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83etc...........))\r\n;\r\n[mysql 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 &#039;))&#039; at line 6\r\n\r\nWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\\www\\phpwebgallery\\include\\functions_notification.inc.php on line 152\r\n\n\n**Additional information:** http://forum.phpwebgallery.net/viewtopic.php?pid=69247#p69247\n\n[Piwigo Bugtracker #739](http://piwigo.org/bugs/view.php?id=739)"},"comment":{"url":"https://api.github.com/repos/mistic100/Piwigo/issues/comments/124890093","html_url":"https://github.com/mistic100/Piwigo/issues/50#issuecomment-124890093","issue_url":"https://api.github.com/repos/mistic100/Piwigo/issues/50","id":124890093,"user":{"login":"plegall","id":9326959,"avatar_url":"https://avatars.githubusercontent.com/u/9326959?v=3","gravatar_id":"","url":"https://api.github.com/users/plegall","html_url":"https://github.com/plegall","followers_url":"https://api.github.com/users/plegall/followers","following_url":"https://api.github.com/users/plegall/following{/other_user}","gists_url":"https://api.github.com/users/plegall/gists{/gist_id}","starred_url":"https://api.github.com/users/plegall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plegall/subscriptions","organizations_url":"https://api.github.com/users/plegall/orgs","repos_url":"https://api.github.com/users/plegall/repos","events_url":"https://api.github.com/users/plegall/events{/privacy}","received_events_url":"https://api.github.com/users/plegall/received_events","type":"User","site_admin":false},"created_at":"2015-07-25T20:43:04Z","updated_at":"2015-07-25T20:43:04Z","body":"**Comment posted by rub on 29 Aug 2007 10:48**\n\nIl ne s&#039;agit pas d&#039;un pb NBM pure mais ca se produit lors de la construction du cache.\r\nPour rappel, la galerie de patnoe contient énormément de données."}}