1. Forums
  3. Community Discussions
  5. Community Builder
  7. Potential Bug
  9. Using "formatname" in sorting tab of list creates a sql error

Using "formatname" in sorting tab of list creates a sql error

9 years 6 months ago #250584 by pvh
Using "formatname" in sorting tab of list creates a sql error was created by pvh
When I set the Sorting parameter of List to Field "Formated name", it creates the following SQL error:

Error: 1054 - Unknown column 'formatname' in 'order clause' SQL=SELECT DISTINCT ue.*, u.*, '' AS 'NA' FROM xxxx_users u JOIN xxxx_user_usergroup_map g ON g.`user_id` = u.`id` JOIN xxxx_comprofiler ue ON ue.`id` = u.`id` WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND ue.banned = 0 AND g.group_id IN (1) AND `cb_awbawkswitch` = 'AWB' ORDER BY `formatname` ASC LIMIT 0, 30
The following user(s) said Thank You: ncpac

Please Log in to join the conversation.

9 years 6 months ago #250585 by nant
Replied by nant on topic Using "formatname" in sorting tab of list creates a sql error

pvh wrote: When I set the Sorting parameter of List to Field "Formated name", it creates the following SQL error:

Error: 1054 - Unknown column 'formatname' in 'order clause' SQL=SELECT DISTINCT ue.*, u.*, '' AS 'NA' FROM xxxx_users u JOIN xxxx_user_usergroup_map g ON g.`user_id` = u.`id` JOIN xxxx_comprofiler ue ON ue.`id` = u.`id` WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND ue.banned = 0 AND g.group_id IN (1) AND `cb_awbawkswitch` = 'AWB' ORDER BY `formatname` ASC LIMIT 0, 30


Thanks for providing feedback here - I assume that this is a CB 2.0 site?

If yes, this has already been fixed and available in our nightly builds and will be part of next CB 2.0.1 release.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Community Discussions
  5. Community Builder
  7. Potential Bug
  9. Using "formatname" in sorting tab of list creates a sql error
Time to create page: 0.177 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Community Discussions
  4. Community Builder
  5. Potential Bug
  6. Using "formatname" in sorting tab of list creates a sql error

Search

Login / Logout

User Menu