SQL State (42s22): Column not found: 1054 Unknown column '' in 'order clause'

[alishahbaz344]

please help me fix this error i'm getting this error illuminate database queryexception
SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'order clause' (SQL: select * from posts where title like %% order by `` asc limit 5 offset 0).
please tell me how can i fix this error

[AdrianHL]

Can you show what you have in the all function within the posts controller? It looks like you have not defined the order by correctly.

I'd suggest you to add a default order by doing something like

$this->grid->orderBy('id', 'asc');