https://bugs.kde.org/show_bug.cgi?id=398037
--- Comment #2 from Ralf Habacker <ralf.habac...@freenet.de> --- >The difference to the KF5 variant is that the URL does not contain 'user=xxx&'. The intention of adding 'user' is probably to see only entries having a relation to the category, but the request simply fails silently in case 'user=' is added. Looking into the implementation https://cgit.kde.org/ocs-apiserver.git/tree/application/controllers/Ocsv1Controller.php#n1447 there is if (!empty($this->_params['user'])) { $tableProjectSelect->where('member.username = ?', $this->_params['user']); } referencing 'member.username'. Running the request (without &user=...) appended with &debug=1 returns the used sql statement, which is <debug select_project="SELECT SQL_CALC_FOUND_ROWS *, `project`.*, `project`.`username` AS `member_username`, `project`.`cat_title` AS `category_title`, `project`.`cat_xdg_type` AS `xdg_type`, `project`.`cat_name_legacy` AS `name_legacy`, (select count(1) as num_files from ppload.ppload_files f where f.active = 1 and f.collection_id = project.ppload_collection_id group by f.collection_id) as num_files FROM `stat_projects` AS `project` WHERE (project.status = 100) AND (project.ppload_collection_id IS NOT NULL) AND (project.project_category_id IN ('339')) HAVING (num_files > 0) ORDER BY laplace_score(project.count_likes,project.count_dislikes) DESC LIMIT 10" select_files="SELECT `project`.* FROM `project` WHERE (1=1)"/> I see no reference to the table 'member' and the column 'username', just a definition of 'member_username' that refers to project.username, which makes me think that using 'member_username' was the original intention. Is there an OCS sandbox where this could be checked? -- You are receiving this mail because: You are watching all bug changes.
