Express List block generates MySQL Error
Permalink
I added an Express List block to a page and got this:
An unexpected error occurred.
An exception occurred while executing 'SELECT count(distinct e.exEntryID) FROM ExpressEntityEntries e LEFT JOIN PublicationExpressSearchIndexAttributes ea ON e.exEntryID = ea.exEntryID WHERE (ak_title like ?) AND (()) AND (e.exEntryEntityID = ?) LIMIT 1' with params ["%%", "88905db8-3684-11e7-a4e3-88fb54b3847c"]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (e.exEntryEntityID = '88905db8-3684-11e7-a4e3-88fb54b3847c') LIMIT 1' at line 1
< Back to Home
I've attached a screenshot of the table.
Anyone have a fix?
An unexpected error occurred.
An exception occurred while executing 'SELECT count(distinct e.exEntryID) FROM ExpressEntityEntries e LEFT JOIN PublicationExpressSearchIndexAttributes ea ON e.exEntryID = ea.exEntryID WHERE (ak_title like ?) AND (()) AND (e.exEntryEntityID = ?) LIMIT 1' with params ["%%", "88905db8-3684-11e7-a4e3-88fb54b3847c"]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (e.exEntryEntityID = '88905db8-3684-11e7-a4e3-88fb54b3847c') LIMIT 1' at line 1
< Back to Home
I've attached a screenshot of the table.
Anyone have a fix?
I just need to update my MySQL version.
I am still getting the error. It only occurs when I check enable search, and then choose a keyword.
Otherwise, I am able to get the block to work through a custom template that I built.
I would like to allow the user to filter the express objects by their topic attribute. I imagine this could be done easily if the search function were working, but it isn't.
Please advise.
Otherwise, I am able to get the block to work through a custom template that I built.
I would like to allow the user to filter the express objects by their topic attribute. I imagine this could be done easily if the search function were working, but it isn't.
Please advise.
Hi Veronikan,
What version of concrete5 are you using?
What version of concrete5 are you using?
# concrete5 Version
Core Version - 8.1.0
Version Installed - 8.1.0
Database Version - 20170123000000
Core Version - 8.1.0
Version Installed - 8.1.0
Database Version - 20170123000000
I got this exact same error today. I suspect the PHP version on this particular server, but I cannot easily upgrade at the moment.
What PHP version are you using?
# concrete5 Version Core Version - 8.1.0 Version Installed - 8.1.0 Database Version - 20170123000000 # PHP Version 5.5.9-1ubuntu4.21
What PHP version are you using?
# PHP Version
7.0.15
MySQL 5.6
7.0.15
MySQL 5.6
