{"action":"closed","issue":{"url":"https://api.github.com/repos/jeroenrnl/zoph/issues/101","repository_url":"https://api.github.com/repos/jeroenrnl/zoph","labels_url":"https://api.github.com/repos/jeroenrnl/zoph/issues/101/labels{/name}","comments_url":"https://api.github.com/repos/jeroenrnl/zoph/issues/101/comments","events_url":"https://api.github.com/repos/jeroenrnl/zoph/issues/101/events","html_url":"https://github.com/jeroenrnl/zoph/issues/101","id":290394194,"number":101,"title":"zoph 0.9.7","user":{"login":"lizdodd","id":1972006,"avatar_url":"https://avatars1.githubusercontent.com/u/1972006?v=4","gravatar_id":"","url":"https://api.github.com/users/lizdodd","html_url":"https://github.com/lizdodd","followers_url":"https://api.github.com/users/lizdodd/followers","following_url":"https://api.github.com/users/lizdodd/following{/other_user}","gists_url":"https://api.github.com/users/lizdodd/gists{/gist_id}","starred_url":"https://api.github.com/users/lizdodd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lizdodd/subscriptions","organizations_url":"https://api.github.com/users/lizdodd/orgs","repos_url":"https://api.github.com/users/lizdodd/repos","events_url":"https://api.github.com/users/lizdodd/events{/privacy}","received_events_url":"https://api.github.com/users/lizdodd/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2018-01-22T09:11:01Z","updated_at":"2018-03-02T21:51:36Z","closed_at":"2018-03-02T21:51:36Z","author_association":"NONE","body":"@jeroenrnl \r\nThis is fabulous work. I really appreciate that you have improved the search time, because with the thousands of photos I have stored in Zoph the slow search has made it hard to use.\r\nI updated today.\r\nWhen entering some albums to see the first page of photos I got an error instead of creating a map (not every album, so I am not sure what the trigger is. \r\n\r\nstring(614) \"#0 /var/www/zoph/classes/db/db.inc.php(149): PDOStatement->execute() #1 /var/www/zoph/classes/zophTable.inc.php(633): db\\db::query(Object(db\\select)) #2 /var/www/zoph/classes/place.inc.php(399): zophTable::getRecordsFromQuery(Object(db\\select)) #3 /var/www/zoph/classes/place.inc.php(534): place->getAutoCover('random') #4 /var/www/zoph/classes/geo/marker.inc.php(73): place->getQuicklook() #5 /var/www/zoph/classes/place.inc.php(419): geo\\marker::getFromObj(Object(place), 'geo-place') #6 /var/www/zoph/classes/photo.inc.php(1237): place->getMarker() #7 /var/www/zoph/photos.php(225): photo->getMarker() #8 {main}\" SELECT DISTINCT ar.photo_id AS photo_id FROM zoph_photos AS p INNER JOIN zoph_view_photo_avg_rating AS ar ON p.photo_id = ar.photo_id WHERE (p.location_id=22) ORDER BY rand() LIMIT 1;SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared Fatal Error: SQL failed db.inc.php: 159.\r\nfatal error\r\n\r\n Another error is instead of one of the albums in a group with a thumbnail.\r\nThis is from an album page with sub-albums displayed.\r\n\r\nstring(861) \"#0 /var/www/zoph/classes/db/db.inc.php(149): PDOStatement->execute() #1 /var/www/zoph/classes/zophTable.inc.php(633): db\\db::query(Object(db\\select)) #2 /var/www/zoph/classes/album.inc.php(455): zophTable::getRecords\r\n\r\n[it looks like an incomplete message]\r\n\r\nI'm going to be looking more at Zoph, so I expect I could be reporting some more errors. \r\n"}}
{"actor":{"display_login":"jeroenrnl"}}