[solved] ORDER BY ASC LIMIT 0,25 Bug2

[ponsfrilus]

Code: Select all

DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 0,25' at line 6

When trying to look up for an user in registration (/manager/registration)

Change ligne 687 of ocs23/classes/registration/RegistrationDAO.inc.php from

Code: Select all

    case 'user': return 'u.last_name';

to

Code: Select all

    case 'id':
    case 'user':
      return 'u.last_name';

[ponsfrilus]

See bug#5382

[ponsfrilus]

Or change it to:

Code: Select all

    case 'id': return 'u.user_id';

if you want to sort them in the ID order....

[ponsfrilus]

Code: Select all

--- a/classes/registration/RegistrationDAO.inc.php
+++ b/classes/registration/RegistrationDAO.inc.php
@@ -687,6 +687,7 @@
          case 'type': return 'r.type_id';
          case 'registered': return 'r.date_registered';
          case 'paid': return 'r.date_paid';
+         case 'id': return 'r.registration_id';
          default: return null;
       }
    }


Thanks for the patch!