mahara-contributors team mailing list archive

[Ghada El-Zoghbi <1939359@xxxxxxxxxxxxxxxxxx>]

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