Public bug reported: Mahara: 20.10.1 OS: Linux DB: Postgres (or MySQL) Browser: Any
I just discovered an error that I actually introduced!! I do beg your pardon. In the LDAP sync - htdocs/auth/ldap/lib.php::sync_users(), the following query actually has a syntax error!! It results in this call stack: Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: Call stack (most recent first): Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * get_recordset_sql(string(size 498)) at /var/www/site/auth/ldap/lib.php:1352 Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * AuthLdap->sync_users() at /var/www/site/auth/ldap/lib.php:1692 Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * PluginAuthLdap::auth_ldap_sync_cron() at /var/www/site/lib/mahara.php:1819 Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * call_static_method(string(size 14), string(size 19)) at /var/www/site/lib/cron.php:119 The query in question is the following: $sql = ' SELECT e.extusername, e.firstname, e.lastname, e.email, e.studentid, e.preferredname FROM {auth_ldap_extusers_temp} e " . $sjoinsql . " WHERE u.id IS NULL ORDER BY e.extusername'; The problem is that the string `$sjoinsql` doesn't exist and the quotes are all wrong. I'm so sorry.. I'll get a fix soon. ** Affects: mahara Importance: Undecided Status: New -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: mahara-contributors https://bugs.launchpad.net/bugs/1939359 Title: LDAP Sync: Error with Adding Status in Mahara: New Bug description: Mahara: 20.10.1 OS: Linux DB: Postgres (or MySQL) Browser: Any I just discovered an error that I actually introduced!! I do beg your pardon. In the LDAP sync - htdocs/auth/ldap/lib.php::sync_users(), the following query actually has a syntax error!! It results in this call stack: Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: Call stack (most recent first): Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * get_recordset_sql(string(size 498)) at /var/www/site/auth/ldap/lib.php:1352 Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * AuthLdap->sync_users() at /var/www/site/auth/ldap/lib.php:1692 Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * PluginAuthLdap::auth_ldap_sync_cron() at /var/www/site/lib/mahara.php:1819 Aug 8 00:05:04 08a80cd1bd91 ecs_mahara_prod: * call_static_method(string(size 14), string(size 19)) at /var/www/site/lib/cron.php:119 The query in question is the following: $sql = ' SELECT e.extusername, e.firstname, e.lastname, e.email, e.studentid, e.preferredname FROM {auth_ldap_extusers_temp} e " . $sjoinsql . " WHERE u.id IS NULL ORDER BY e.extusername'; The problem is that the string `$sjoinsql` doesn't exist and the quotes are all wrong. I'm so sorry.. I'll get a fix soon. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1939359/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp