Getting Error in xerte X (git X-v3.7.4-2-g3c75844)

[GaneshKandu]

Hi

Getting Error in xerte X (git X-v3.7.4-2-g3c75844)

Site Administration > LTI/Moodle settings. (Not Tsugi/LTI) > LTI Keys

Error No: 1146 - 0MySQL error Table 'xerte_db.lti_keys' doesn't exist
Query:

#0 {{PATH}}/website_code/php/management/site.php(325): UoN_LTI->get_lti_keys()
#1 {main}

[ronm123]

Hi was this an upgrade? If so you need to run upgrade.php. But also tsugi isn't installed with Xerte you have to add and configure that manually.

[torinfo]

This table is the 'old'lti keys configuration in management.php, not Tsugi.

And indeed, if this is an upgrade, please run http(s):///upgrade.php

[GaneshKandu]

Its Normal install of latest not upgrade

[torinfo]

I just did a fresh install. The error suggests that the table lti_keys does not exist, but as far as I can tell it is created correctly, if I do a clean install. Could you please check your database and database credentials? (the credentials that are used, can be found in database.php.)

[GaneshKandu]

@torinfo Did you installed with table_prefix ? install with table_prefix, table_prefix is null there

$stmt = $this->db->prepare("SELECT * FROM " . $this->parm['table_prefix'] . "lti_keys $extra");

i have installed with table_prefix

expected query is with table_prefix

SELECT * FROM prexe_lti_keys;

in my case its without table_prefix

SELECT * FROM lti_keys;

[torinfo]

Ah.. I'll fix it. Thank you for helping us solving this.

[GaneshKandu]

@torinfo @ronm123 look at https://github.com/thexerteproject/xerteonlinetoolkits/pull/803

[GaneshKandu]

i am still getting same issue in xerte online toolkits 3.7.11

[JohnSmith-LT]

Hi @GaneshKandu

I'm just going through some Xerte issues that remain open and wondering if you can confirm the status of this one? I've looked at the code and it was seemingly patched in October 2018 (Line 322 below to include $xerte_toolkits_site->database_table_prefix) but you replied that the problem still existed afterwards? Is this still the case?

https://github.com/thexerteproject/xerteonlinetoolkits/blob/1af4da3059fca472a8eede95ea853a3263abc4e2/website_code/php/management/site.php#L320-L323

Please let me know your thoughts and i'll look into it or will close in 10 days.

John

[GaneshKandu]

@JohnSmith-LT its working now