SQLI error with LTI plugin

  • Resolved thierryherman

    (@thierryherman)


    1 year, 5 months ago

    I am using the LTI extensions to link a wordpress site to a Moodle platform (for testing purposes). It works on my localhost installation but I got an error on a shared hosted installation (WordPress version is 6.2.2 in both cases).

On the shared hosting : ceLTIc LTI class library version 4.10.3; LTI tool 3.2.1

On my localhost installation: ceLTIc LTI class library version 4.10.0; LTI tool 3.1.0

Here is the message I got :

Une erreur de type E_ERROR a été causée dans la ligne 365 du fichier /wp-content/plugins/celtic-lti/vendor/celtic/lti/src/DataConnector/DataConnector_mysqli.php. Message d’erreur : Uncaught Error: Call to undefined method mysqli_stmt::get_result() in /wp-content/plugins/celtic-lti/vendor/celtic/lti/src/DataConnector/DataConnector_mysqli.php:365
    Stack trace:

0 /wp-content/plugins/celtic-lti/vendor/celtic/lti/src/Tool.php(568): ceLTIc\LTI\DataConnector\DataConnector_mysqli->getPlatforms()

1 /wp-content/plugins/lti-tool/includes/LTI_Tool_List_Table.php(225): ceLTIc\LTI\Tool->getPlatforms()

2 /wp-content/plugins/lti-tool/lti-tool.php(438): LTI_Tool_List_Table->prepare_items()

3 /wp-includes/class-wp-hook.php(308): lti_tool_platforms('')

4 /wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters('', Array)

5 /wp-includes/plugin.php(517): WP_Hook->do_action(Array)

6 /wp-admin/admin.php(259): do_action('toplevel_page_l…')

7 {main
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Stephen P Vickers

    (@spvickers)

    Thanks for reporting this issue; I have not encountered this before. What version of PHP are you running on your server? (Note that I am assuming, whilst you have reported this to the forum for the LTI Platform plugin, your issue relates to the LTI Tool plugin.)

    Plugin Author Stephen P Vickers

    (@spvickers)

    The issue you report looks consistent with mysqlnd not being installed on your server (see the PHP documentation for mysqli_stmt::get_result). Have you checked this?

    Thread Starter thierryherman

    (@thierryherman)

    Thanks for your quick response. I am running PHP 7.4 and mysqlnd is active.

    Plugin Author Stephen P Vickers

    (@spvickers)

    I also see references to needing nd_mysqli extension as well. Do you have that installed as well? It does look like a server configuration issue to me, rather than an issue with the LTI Tool or ceLTI LTI Library plugins.

    Thread Starter thierryherman

    (@thierryherman)

    I tried to activate nd_mysqli but he activation was skipped due to a conflict (but with no information about the cause of the conflict).

    Plugin Author Stephen P Vickers

    (@spvickers)

    Still sounds like a server configuration issue to me, so one to take up with your hosting provider.

    If you find you are unable to enable the mysqli_stmt::get_result method, then let me know and I’ll see if a workaround is possible, but this appears to be a standard PHP method and I have not had this issue reported by other users of the LTI Tool plugin.

    Plugin Author Stephen P Vickers

    (@spvickers)

    I assume this has now been resolved; let me know if not.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘SQLI error with LTI plugin’ is closed to new replies.

Tags