Supporting each other

Community forums

Welcome, Guest

Forum

Main Forum

Bugs and Issues

table_prefix not being set properly in UoN_LTI.php

Report any technical problems you discover and discuss solutions.

Page:
1

TOPIC:

table_prefix not being set properly in UoN_LTI.php 10 years 3 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 Inloggen or Create an account to join the conversation.

table_prefix not being set properly in UoN_LTI.php 10 years 3 months ago #2096

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