Public bug reported: zoph 0.9.4-4 mysql-server 5.7.35-0ubuntu0.18.04.2 Linux Mint 19.3 (Ubuntu 18.04)
I installed zoph to my notebook and I try to configure it for the first time. I do not have experience with this package and it is painfull process... I am at stage that I can login to the web interface (http://localhost/zoph/), I can create new user, album, places, categories. I miss any option to upload photos through web interface. I added my user to group "zoph" and now I can use "zoph CLI" interface (test "zoph -V"). I uploaded the first photo with "zoph img001.jpg", it was without problem. THE BUG: I open "photos" (http://localhost/zoph/photos.php) in web interface and I see long SQL error: #0 db\db::query(db\select Object ([db\selectjoins] => ,[db\selectgroupby] => Array (),[*union] => Array (),[*subquery] => ,[*table] => zoph_photos,[*tables] => Array ([p] => photos),[*alias] => p,[*fields] => Array ([0] => DISTINCT p.photo_id,[1] => p.name,[2] => p.path,[3] => p.width,[4] => p.height),[*params] => ,[*where] => ,[*having] => ,[*order] => Array ([0] => p.date asc,[1] => p.time asc,[2] => p.photo_id asc),[*count] => 12,[*offset] => 0)) called at [/usr/share/zoph/www/php/classes/zophTable.inc.php:611] #1 zophTable::getRecordsFromQuery(db\select Object ([db\selectjoins] => ,[db\selectgroupby] => Array (),[*union] => Array (),[*subquery] => ,[*table] => zoph_photos,[*tables] => Array ([p] => photos),[*alias] => p,[*fields] => Array ([0] => DISTINCT p.photo_id,[1] => p.name,[2] => p.path,[3] => p.width,[4] => p.height),[*params] => ,[*where] => ,[*having] => ,[*order] => Array ([0] => p.date asc,[1] => p.time asc,[2] => p.photo_id asc),[*count] => 12,[*offset] => 0)) called at [/usr/share/zoph/www/php/photo_search.inc.php:477] #2 get_photos(Array (), 0, 12, , user Object ([person] => person Object ([home] => ,[work] => ,[fields] => Array ([person_id] => 1,[first_name] => Unknown,[last_name] => Person,[middle_name] => ,[called] => ,[gender] => ,[dob] => ,[dod] => ,[home_id] => ,[work_id] => ,[father_id] => ,[mother_id] => ,[spouse_id] => ,[notes] => ,[coverphoto] => ,[pageset] => ,[email] => ,[createdby] => 1)),[prefs] => prefs Object ([prefscolor_scheme] => ,[fields] => Array ([user_id] => 1,[show_breadcrumbs] => 1,[num_breadcrumbs] => 8,[num_rows] => 3,[num_cols] => 4,[max_pager_size] => 10,[random_photo_min_rating] => 0,[reports_top_n] => 5,[color_scheme_id] => 1,[slideshow_time] => 5,[language] => ,[recent_photo_days] => 7,[auto_edit] => 0,[camera_info] => 1,[allexif] => 0,[autocomp_albums] => 1,[autocomp_places] => 1,[autocomp_categories] => 1,[autocomp_photographer] => 1,[autocomp_people] => 1,[fullsize_new_win] => 0,[view] => list,[autothumb] => highest,[child_sortorder] => sortname)),[lang] => language Object ([iso] => en,[name] => English ,[languagefilename] => lang/en,[languagetranslations] => Array ()),[fields] => Array ([user_id] => 1,[person_id] => 1,[user_class] => 0,[view_all_photos] => 1,[delete_photos] => 1,[user_name] => admin,[password] => $2y$10$cFl.NZJDITXBg6Etl3udd.JpNkgzsRIwBoJf7f5AWqi9Itv1HJY6q,[browse_people] => 1,[browse_places] => 1,[browse_tracks] => 1,[edit_organizers] => 1,[detailed_people] => 1,[see_hidden_circles] => 1,[detailed_places] => 1,[import] => 1,[download] => 1,[leave_comments] => 1,[allow_rating] => 1,[allow_multirating] => 0,[allow_share] => 0,[lightbox_id] => ,[lastnotify] => ,[lastlogin] => 2021-10-16 21:52:40,[lastip] => ::1))) called at [/usr/share/zoph/www/php/photos.php:64] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'zoph.p.date' which is not in SELECT list; this is incompatible with DISTINCT Fatal Error: SQL failed db.inc.php: 156. fatal error ** Affects: zoph (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1947473 Title: cannot view photos To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/zoph/+bug/1947473/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
