Welcome, Guest
Username: Password: Remember me
Pleas keep in mind that SPAM will be deleted instantly
  • Page:
  • 1

TOPIC: Search bug, 1054 Unknown column

Search bug, 1054 Unknown column 2 years 4 months ago #4173

  • tilapia
  • tilapia's Avatar Topic Author
  • Offline
  • Posts: 2
  • Thank you received: 0
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 or Create an account to join the conversation.

Search bug, 1054 Unknown column 2 years 4 months ago #4187

  • Dirk
  • Dirk's Avatar
  • Offline
  • Posts: 1016
  • Karma: 21
  • Thank you received: 183
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 or Create an account to join the conversation.

  • Page:
  • 1
Moderators: Dirkjoest