× Pleas keep in mind that SPAM will be deleted instantly

Search bug, 1054 Unknown column

More
7 years 6 months ago #4173 by tilapia
Search bug, 1054 Unknown column was created by tilapia
When entering a query in search field and pressing search button, the following error comes up:

1054, Unknown column 'a.' in 'where clause' SQL=SELECT `id` AS numlinks FROM `database` AS a WHERE (a.`firstname` LIKE '%guru%' OR a.`lastname` LIKE '%guru%' OR a.`` LIKE '%guru%')

Please advise...

Please Log in to join the conversation.

More
7 years 5 months ago #4187 by Dirk
Replied by Dirk on topic Search bug, 1054 Unknown column
Joodb needs 3 Fields assigned to your table.

ID, Title, Absctract, Fulltext

Please check that all these fields are assigned.

You could also try to enable/disable search all fields in your catalog menu settings!

Please Log in to join the conversation.

Moderators: Dirkjoest