{"action":"created","issue":{"url":"https://api.github.com/repos/zenphoto/zenphoto/issues/967","labels_url":"https://api.github.com/repos/zenphoto/zenphoto/issues/967/labels{/name}","comments_url":"https://api.github.com/repos/zenphoto/zenphoto/issues/967/comments","events_url":"https://api.github.com/repos/zenphoto/zenphoto/issues/967/events","html_url":"https://github.com/zenphoto/zenphoto/issues/967","id":105447839,"number":967,"title":"1.4.9 issue with Codeblocks content in a page","user":{"login":"vincent3569","id":1224809,"avatar_url":"https://avatars.githubusercontent.com/u/1224809?v=3","gravatar_id":"","url":"https://api.github.com/users/vincent3569","html_url":"https://github.com/vincent3569","followers_url":"https://api.github.com/users/vincent3569/followers","following_url":"https://api.github.com/users/vincent3569/following{/other_user}","gists_url":"https://api.github.com/users/vincent3569/gists{/gist_id}","starred_url":"https://api.github.com/users/vincent3569/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vincent3569/subscriptions","organizations_url":"https://api.github.com/users/vincent3569/orgs","repos_url":"https://api.github.com/users/vincent3569/repos","events_url":"https://api.github.com/users/vincent3569/events{/privacy}","received_events_url":"https://api.github.com/users/vincent3569/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-09-08T18:55:18Z","updated_at":"2015-09-13T17:36:29Z","closed_at":null,"body":"Hi,\r\n\r\nin a page, I have some php in Codeblocks do display pictures of a dynamic album (portfolio)\r\n\r\nit works well with zenphoto 1.4.8\r\nit doesn't work with zenphoto 1.4.9\r\n\r\nthe code used:\r\n\r\n````\r\n<!-- ok ombre -->\r\n<script type=\"text/javascript\" src=\"/themes/zpArdoise/js/imagesloaded.pkgd.min.js\"></script>\r\n<script type=\"text/javascript\" src=\"/themes/zpArdoise/js/masonry.pkgd.min.js\"></script>\r\n\r\n<?php\r\n$album = newAlbum(\"images/portfolio.alb\");\r\nif (is_object($album)) {\r\n\tmakeAlbumCurrent($album);\r\n} ?>\r\n<div id=\"portfolio-wrap\" style=\"margin: 0 auto; padding: 0;\">\r\n\t<?php while (next_image(true)) { ?>\r\n\t\t\t<a class=\"portfolio-item colorbox\" style=\"margin: 10px ;\" href=\"<?php echo html_encode(getUnprotectedImageURL()); ?>\" title=\"<?php echo getBareImageTitle(); ?>\">\r\n\t\t\t\t<?php \r\n\t\t\t\tif (getFullWidth() > getFullHeight()) {\r\n\t\t\t\t\tprintCustomSizedImage (getAnnotatedImageTitle(), NULL, 235, 150, 235, 150, NULL, NULL, 'ombre', NULL, true);\r\n\t\t\t\t} else if (getFullWidth() < getFullHeight()) {\r\n\t\t\t\t\tprintCustomSizedImage (getAnnotatedImageTitle(), NULL, 150, 235, 150, 235, NULL, NULL,  'ombre', NULL, true);\r\n\t\t\t\t} else  {\r\n\t\t\t\t\tprintCustomSizedImage (getAnnotatedImageTitle(), NULL, 150, 150, NULL, NULL, NULL, NULL,  'ombre', NULL, true);\r\n\t\t\t\t} ?>\r\n\t\t\t</a>\r\n\t<?php } ?>\r\n</div>\r\n\r\n<script type=\"text/javascript\">\r\n\t$(function(){\r\n\t\tvar $container = $('#portfolio-wrap');\r\n\r\n\t\t$container.imagesLoaded(function(){\r\n\t\t\t$container.masonry({\r\n\t\t\t\titemSelector : '.portfolio-item',\r\n\t\t\t\tcolumnWidth: 5\r\n\t\t\t});\r\n\t\t});\r\n\t});\r\n</script>\r\n````\r\n\r\nthe error in debug log:\r\n\r\n```` {171055:Tue, 08 Sep 2015 18:50:20 GMT}\r\nUSER ERROR: MySQLi Error: ( SELECT DISTINCT `id`,`show`,`albumid`, `filename`, `title` FROM `[prefix]images` WHERE (`id` IN (630,902,907,910,918,937,945,1043,1046,1050,1062,1064,1110,1193,1219,1226,1411,1435,1585,1664,1707,1888,1918,2017,2018,2040,2045,2050,2228,2412,2474,2527,2533,2617,2624,2824,2925,2995,3122,3159,3164,3168,3202,3303)) ORDER BY ASC ) failed. MySQLi returned the error 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 'ASC' at line 1 in /home/avbo7291/public_html/zenphoto_test/zp-core/functions-db-MySQLi.php on line 78\r\ntrigger_error called from query (functions-db-MySQLi.php [78])\r\nfrom SearchEngine->getSearchImages (class-search.php [1548])\r\nfrom SearchEngine->getImages (class-search.php [1623])\r\nfrom dynamicAlbum->getImages (class-album.php [1770])\r\nfrom AlbumBase->getNumImages (class-album.php [385])\r\nfrom getNumImages (template-functions.php [2026])\r\nfrom getTotalPages (template-functions.php [757])\r\nfrom next_image (template-functions.php [2071])\r\nfrom eval (template-functions.php(4448) : eval()'d code [11])\r\nfrom printCodeblock (template-functions.php [4448])\r\nfrom include (pages.php [15])\r\nfrom include (index.php [129])\r\nfrom index.php [28] ````"},"comment":{"url":"https://api.github.com/repos/zenphoto/zenphoto/issues/comments/139898626","html_url":"https://github.com/zenphoto/zenphoto/issues/967#issuecomment-139898626","issue_url":"https://api.github.com/repos/zenphoto/zenphoto/issues/967","id":139898626,"user":{"login":"vincent3569","id":1224809,"avatar_url":"https://avatars.githubusercontent.com/u/1224809?v=3","gravatar_id":"","url":"https://api.github.com/users/vincent3569","html_url":"https://github.com/vincent3569","followers_url":"https://api.github.com/users/vincent3569/followers","following_url":"https://api.github.com/users/vincent3569/following{/other_user}","gists_url":"https://api.github.com/users/vincent3569/gists{/gist_id}","starred_url":"https://api.github.com/users/vincent3569/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vincent3569/subscriptions","organizations_url":"https://api.github.com/users/vincent3569/orgs","repos_url":"https://api.github.com/users/vincent3569/repos","events_url":"https://api.github.com/users/vincent3569/events{/privacy}","received_events_url":"https://api.github.com/users/vincent3569/received_events","type":"User","site_admin":false},"created_at":"2015-09-13T17:36:29Z","updated_at":"2015-09-13T17:36:29Z","body":"Seems to work now with this revert commit.\r\nAccording to me, this is a critical bug that requires a new release of zenphoto."}}