Results missing after 1.15.5 Release

  • Resolved Nicholas Birch

    (@nickbirch)


    1 year, 11 months ago

    It may be a coincidence, but the WordPress H5P Plugin was updated yesterday from version 1.15.4 to version 1.15.5 and today the quiz results don’t display and the message “There are no logged results for this content” comes up for both of the Results I would expect to see.

    The release notes for 1.15.5 say “Improve data loading by fetching user data in a separate query rather than joining wp_users. This will allow for storing data across multiple databases.”, which suggests there have been changes in the area of results that may have led to this problem.

    Is there any way to relink the existing results, revert to 1.15.4 or otherwise solve this if it is unrelated to the release?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author icc0rz

    (@icc0rz)

    Hi,
    We need some more details on this to get to the bottom of it.
    Do you know if this happens for you on a “vanilla” WordPress, or if you have a special setup?

    Thread Starter Nicholas Birch

    (@nickbirch)

    Thanks for replying.

    This on a live site with other plugins. The results data that I can’t see via the H5P Plugin is real user data collected from courses attended. I think the data is still in the database as the SNORDIAN’s H5PxAPIkatchu plugin can still access the xAPI values related to the same results.

    I did try reverting the plugin to 1.15.4 yesterday, but the made no difference, and of course I don’t know whether the upgrade was the cause or a coincidence.

    I have also just enabled Troubleshooting mode and just the H5P Plugin activated. This made no difference with 1.15.5 installed.

    Nick

    Thread Starter Nicholas Birch

    (@nickbirch)

    I have also tried to add another record by undertaking the quiz. The quiz works as normal and displays a score at the end, BUT no results appear via the results link.

    efox

    (@foxylearning)

    I’m testing 1.15.5 release on a staging site and I’m also having trouble with the results. I’m unable to access any results for my H5P content. When I click the “results” link for a piece of content, “Loading data” shows for quite a while before returning a “Failed to load data” message. This appears to happen with any type of H5P content (tested with Question Set, Interactive Video, and Interactive Book so far). All the data is retrieved and displayed just fine with the 1.15.4 version of the plugin on my production site.

    efox

    (@foxylearning)

    I just checked my staging site’s logs and it appears that this issue may be due to an SQL error:

    2022-12-13 12:45:32.238689 [NOTICE] [29382] [69.166.233.116:54796:HTTP2-29#staging.mysite.com] [STDERR] WordPress database 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 '.score,
              hr.max_score,
              hr.opened,
              hr.fi' at line 3 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 = 323
        ORDER BY hr.finished DESC
        LIMIT 0, 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

    @icc0rz This is a bug that already has a fix, see https://github.com/h5p/h5p-wordpress-plugin/pull/148

    Plugin Author icc0rz

    (@icc0rz)

    Thanks Oliver, we’ll get your fix out as soon as possible!

    Plugin Author icc0rz

    (@icc0rz)

    The fix should be out now.

    Thread Starter Nicholas Birch

    (@nickbirch)

    That seems to have fixed the problem.

    Many thanks.

    Nick

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Results missing after 1.15.5 Release’ is closed to new replies.