#586 Clicked column User Class heading to order by

open
nobody
Users (45)
5
2012-10-15
2012-10-15
Peter Garner
No

Administer Group: Anonymous

[ - 3.1.0 alpha - ] [ Mon Oct 15 21:50:37 2012 ]
-----------------------------------------------------------------------------------------------
#### USER AGENT: Mozilla/5.0 (X11; U; Linux x86_64; en-gb) AppleWebKit/531.2+ (KHTML, like Gecko) Version/5.0 Safari/531.2+ Debian/squeeze (2.30.6-1) Epiphany/2.30.6
#### ACCT: ID: 2 - Login: mreditor - e-mail: editor@petergarner.net
#### URL: #### REFERRER: http://www.petergarner.net/bitweaver/users/admin/edit_group.php?group_id=-1
#### HOST: www.petergarner.net
#### IP: 82.71.1.246
#### DB: mysqli://gBitDbUser@localhost/CMS
#### SQL: SELECT `user_id`, `group_id`, `group_name` , `group_desc`, `group_home`, `is_default`, `is_public` FROM `BWusers_groups` ORDER BY `perm_level` ASC
#### ERROR CODE: Errno: 1054 Message: Unknown column 'perm_level' in 'order clause'

}}}}}} LINE: 672, /media/OPT/www/petergarner.net/htdocs/bitweaver/kernel/BitDbAdodb.php
}}}}}} -> bit_error_string(Array[6])
}}}}} LINE: 1072, /media/OPT/www/petergarner.net/htdocs/bitweaver/util/adodb/adodb.inc.php
}}}}} -> bitdb_error_handler(mysqli, EXECUTE, 1054, Unknown column 'perm_level' in 'order clause', SELECT `user_id`, `group_id`, `group_name` , `group_desc`, `grou..., false, Object:ADODB_mysqli)
}}}} LINE: 1047, /media/OPT/www/petergarner.net/htdocs/bitweaver/util/adodb/adodb.inc.php
}}}} -> ADOConnection::_Execute(SELECT `user_id`, `group_id`, `group_name` , `group_desc`, `grou..., false)
}}} LINE: 260, /media/OPT/www/petergarner.net/htdocs/bitweaver/kernel/BitDbAdodb.php
}}} -> ADOConnection::ADOConnection::Execute(SELECT `user_id`, `group_id`, `group_name` , `group_desc`, `grou..., Array[0])
}} LINE: 319, /media/OPT/www/petergarner.net/htdocs/bitweaver/users/BitPermUser.php
}} -> ADOConnection::ADOConnection::BitDbAdodb::query(
SELECT `user_id`, `group_id`, `group_name` , `group_desc`, `..., Array[0])
} LINE: 139, /media/OPT/www/petergarner.net/htdocs/bitweaver/users/admin/edit_group.php
} -> ADOConnection::ADOConnection::BitDbAdodb::BitPermUser::getAllGroups(Array[10])

$_GET:
array (
'sort_mode' => 'perm_level_asc',
)

$_COOKIE:
array (
'BWSESSION' => 'gqpuc4osglhh0su1an19qmime7',
'bit-user-aspacewithinaspace' => 'gqpuc4osglhh0su1an19qmime7',
'tz_offset' => '3600',
'javascript_enabled' => 'y',
'webfxtab_' => '1',
'__utma' => '103112449.1534775402.1350249221.1350249221.1350249221.1',
'__utmz' => '103112449.1350249221.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)',
)

Discussion