Bug #565

Custom view in browse users error

Added by Calin Ipate about 2 years ago. Updated about 2 years ago.

Status:Closed Start date:12/05/2009
Priority:Normal Due date:
Assignee:Tom Moore % Done:

100%
Category:Admin Control Panel
Target version:1.4.12
Reproducibility:Always Database Type:
Reported In MyBB Version:1.4.10 Database Version:
PHP Version: SQA assignments:
Browser:

Description

I was just making a custom view in browse users menu from AdminCP. The fields selected to show : Username and warning level. I told him to sort by warning level ascending and descending and in both cases the following error ocurred :

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'warninglevel' in 'order clause'
Query:
SELECT u.* FROM mods_users u WHERE 1=1 ORDER BY warninglevel asc LIMIT 0, 200

Associated revisions

Revision 4584
Added by Tom Moore about 2 years ago

Fixes Custom view in browse users error (fixes:565)

History

#1
Updated by Matt Rogowski about 2 years ago

I can reproduce on the latest SVN.

#2
Updated by Ryan Gordon about 2 years ago

Is this a 1.6 bug or a 1.4 bug?

#3
Updated by Calin Ipate about 2 years ago

1.4

#4
Updated by Matt Rogowski about 2 years ago

Sorry should have made that clearer, I tested on 1.4 SVN, can't test on 1.6 as the JS for dragging the fields isn't working, but that's another matter.

#5
Updated by Tom Moore about 2 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Applied in changeset r4584.

To me, the entire sortby switch statement seemed wrong. It wouldn't sort for anything other than post count or username for me, so I altered the logic slightly. It should work properly now...

#6
Updated by Tom Moore about 2 years ago

  • Category set to Admin Control Panel
  • Assignee set to Tom Moore
  • Target version set to 1.6.0 Beta

#7
Updated by Ryan Gordon about 2 years ago

  • Target version changed from 1.6.0 Beta to 1.4.12

#8
Updated by Chris W. B. about 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF