Unknown column 'profile_single_auto.value' in 'order clause' query: SELECT DISTINCT [#267540]

Need to add profile column identifiers in LEFT JOIN regardless of selection.

Comment	File	Size	Author
#1	advuser.5.x-2.x-dev.patch	4.24 KB	Anonymous (not verified)

Comments

Anonymous (not verified) commented 8 June 2008 at 17:45

Status:

Active

» Reviewed & tested by the community

Status	File	Size
new	advuser.5.x-2.x-dev.patch	4.24 KB

The attached patch resolves this issue and applies some optimization for the profile_fields table queries and user_roles function call.

Anonymous (not verified) commented 8 June 2008 at 17:47

Status:

Reviewed & tested by the community

» Fixed

Committed to CVS.

Anonymous (not verified) commented 22 June 2008 at 17:52

Status:

Fixed

» Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.