• efox

    (@foxylearning)


    Attempting to search for a user’s results in the results tab does not work (it times out) and generates this database error in my site logs:

    2023-01-04 18:50:20.614137 [NOTICE] [7481] [149.28.11.90:33530#mysite.com] [STDERR] WordPress database error Unknown column 'u.user_login' in 'where clause' for query SELECT hr.id,
                   hr.user_id,
                  hr.score,
                  hr.max_score,
                  hr.opened,
                  hr.finished,
                  hr.time
            FROM wp_h5p_results hr
            
             WHERE hr.content_id = 324 AND u.user_login LIKE '%name%'
            ORDER BY hr.finished DESC
            LIMIT 20, 20 made by do_action('wp_ajax_h5p_content_results'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_content_results, H5P_Plugin_Admin->print_results, H5P_Plugin_Admin->get_results
  • The topic ‘Database error when searching results’ is closed to new replies.