Database error when searching ? :-(
Permalink
Hi,
Suddenly I get this error, when searching for users on my site :
Can anyone tell me why this is?
I have a userattribute called "last_name", but why does it fail?
Suddenly I get this error, when searching for users on my site :
mysql error: [1054: Unknown column 'ak_last_name' 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 '%stephan%' OR u.uEmail like '%stephan%' OR ak_last_name like '%stephan%' OR ak_first_name like '%stephan%' OR ak_middle_name like '%stephan%' ) order by uDateAdded desc limit 0,10 ")
Can anyone tell me why this is?
I have a userattribute called "last_name", but why does it fail?
above options you can find at the time of add/edit user attributes
my options are as follows
Please try using my screenshot:http://awesomescreenshot.com/0daoy7g27...