TOPIC:

table_prefix not being set properly in UoN_LTI.php 9 years 9 months ago #2093

UsernameNumber
Topic Author
Offline
New Member
Posts: 5
Thank you received: 1

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:

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:

$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.

Please Log in or Create an account to join the conversation.

table_prefix not being set properly in UoN_LTI.php 9 years 8 months ago #2096

tom Offline Administrator Posts: 1293 Thank you received: 308	Thank you for the heads up. I'll log it as a bug.
	Please Log in or Create an account to join the conversation.