Closed (outdated)
Project:
Invite
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
23 Dec 2009 at 19:44 UTC
Updated:
29 Apr 2022 at 03:22 UTC
Jump to comment: Most recent
While sorting the invitation details list by users, I get the following error:
user warning: Unknown column 'ifu.nameISNULL01DESCu.name' in 'order clause' query: SELECT i.email, i.invitee AS uid, u.name, i.created, i.expiry, i.joined, i.canceled FROM invite i LEFT JOIN users u ON u.uid = i.invitee AND u.uid <> 0 WHERE i.uid = 1 ORDER BY ifu.nameISNULL01DESCu.name ASC LIMIT 0, 50 in modules/invite/invite_admin.inc on line 288.
It seems that the field value in the table header definition gets malformed:
array('data' => t('Username'), 'field' => 'if(u.name IS NULL, 0, 1) DESC, u.name'),
I'm not sure what the expression is for, but a simple
array('data' => t('Username'), 'field' => 'u.name'),
does the job. At least with mysql.
Comments
Comment #1
dale42I'm helping the Invite module maintainers by cleaning up old issues.
Drupal 6 is no longer supported so I'm setting the issue status to Closed (outdated). Information on what that means is here: Issue Status field.
If you have a question about one of the current versions of the module please do submit a new issue.
And thanks for posting what worked for your fix.
Comment #2
dale42