Hello

I am getting an error whenever I search on the user search in the backend. It seems to be haivng trouble with the additional user attributes I have added to the search. This works fine on my local install apache/php but not so on the live site whihc is php on a windows machine. Any help would be welcome

The error is

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'ak_surname' in 'where clause'] in EXECUTE("SELECT DISTINCT u.uID, u.uName FROM Users u left join UserSearchIndexAttributes on (UserSearchIndexAttributes.uID = u.uID) where 1=1 and ( u.uName like '%zoe%' OR u.uEmail like '%zoe%' OR ak_first_name like '%zoe%' OR ak_surname like '%zoe%' OR ak_organisation like '%zoe%' OR ak_member_id like '%zoe%' OR ak_job_title like '%zoe%' OR (ak_address_address1 like '%zoe%' or ak_address_address2 like '%zoe%' or ak_address_city like '%zoe%' or ak_address_state_province like '%zoe%' or ak_address_postal_code like '%zoe%' or ak_address_country like '%zoe%' ) OR ak_account_active like '%zoe%' OR ak_user_type like '%zoe%' ) order by uDateAdded desc limit 0,10 ") ' in D:\www.vma.org.uk\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 D:\www.vma.org.uk\concrete\libraries\3rdparty\adodb\adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown colum in D:\www.vma.org.uk\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78