After seeing
this post
, I started messing around with the LTI settings in xerte, and found that I get an error when I try to list the LTI keys:
Code:
Error No: 1146 - 0MySQL error Table 'xerte.lti_keys' doesn't exist
Query:
#0 /www/training.nocc/html/xerte/website_code/php/management/site.php(220): UoN_LTI->get_lti_keys()
#1 {main}
That function runs this query:
Code:
$this->db->prepare("SELECT * FROM " . $this->parm['table_prefix'] . "lti_keys $extra")
But instead of taking table_prefix from databases.php, as far as I can tell it's initialized to an empty string at the top of the file and never updated after that. I've had the same prefix since installation, so even if the installer should have hard-set this value, it looks like that didn't happen.
To confirm, I added a line to get_lti_keys to make it print its query to Apache's error log, and sure enough, no prefix is used.
I manually set table_prefix on line 21 of LTI/ims-lti/UoN_LTI.php, and so far things seem to be working now.
