Error When Listing Express Entities
Permalink
I'm in the early stages of developing a website for users to post archery tournaments. Although, I've run into a problem when listing the express entities. Does anybody know how to fix this error I'm getting? It appears when I have checked "Enable Seach" and "Keyword Search", but only after I select the "State" option in "Enable Searching by Attributes". Any other combination I try works just fine. I've also attached photos to help explain what I mean.
An exception occurred while executing 'SELECT count(distinct e.exEntryID) FROM ExpressEntityEntries e LEFT JOIN TournamentExpressSearchIndexAttributes ea ON e.exEntryID = ea.exEntryID WHERE (ak_state like ?) AND (e.exEntryEntityID = ?) LIMIT 1' with params ["%%", "623a3709-afe1-11e8-8427-0cc47a6976b6"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_state' in 'where clause'
Any help is greatly appreciated.
Thanks
Tristan Stephens
An exception occurred while executing 'SELECT count(distinct e.exEntryID) FROM ExpressEntityEntries e LEFT JOIN TournamentExpressSearchIndexAttributes ea ON e.exEntryID = ea.exEntryID WHERE (ak_state like ?) AND (e.exEntryEntityID = ?) LIMIT 1' with params ["%%", "623a3709-afe1-11e8-8427-0cc47a6976b6"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_state' in 'where clause'
Any help is greatly appreciated.
Thanks
Tristan Stephens