Write Error in Composer
Permalink
I have the following error when trying to use the write function in composer:
mysql error: [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 'LIMIT 1' at line 1] in EXECUTE("select
max(cDisplayOrder) from Pages where cParentID = LIMIT 1")
Page Types have been setup to use composer but the error remains.
Any help would be greatly appreciated.
mysql error: [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 'LIMIT 1' at line 1] in EXECUTE("select
max(cDisplayOrder) from Pages where cParentID = LIMIT 1")
Page Types have been setup to use composer but the error remains.
Any help would be greatly appreciated.
Hi John,
Thanks for your reply. I have tried lots of variations and none of them work. The first option I tried was to publish below a certain page and I selected the page, 'Blog' to be the chosen page. Also, when I use the sitemap, select the blog page and edit in composer, I also get this error message, 'Block not found. Unable to edit in composer'.
Any ideas?
WedDev
Thanks for your reply. I have tried lots of variations and none of them work. The first option I tried was to publish below a certain page and I selected the page, 'Blog' to be the chosen page. Also, when I use the sitemap, select the blog page and edit in composer, I also get this error message, 'Block not found. Unable to edit in composer'.
Any ideas?
WedDev
This suggests you have told it to publish below a certain page, but haven't selected which one? Check the Composer Settings:
http://www.concrete5.org/documentation/using-concrete5/dashboard/pa...
John