Sortable Columns when change column name or display column

Submitted by jordinini on Thu, 2009-03-19 20:10.Troubleshooting

I don't know what I'm doing wrong but I receive the follow error

Searching Error:field "sprecio" does not appear to be indexed. Has Indexing been started yet? If you manually added index, please use "Refresh Index" action in Dashboard. If Error shows Null and wildcard is used, it's because of too many matches and please consider increase the minimal prefix length

when I changed the column name in SQL subsequent query,
for example:
SELECT user AS usename FROM users WHERE id_user=?
and then I try to do search with this specified sortable column.

In Sortable column Table appears correct as 'username' , and I've configured to be displayed as 'username' in the same table, however when I try a order search by this column , it doesn work.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Submitted by jordinini on Thu, 2009-03-19 20:17.

I had to Refresh Index afterwards