SQLSTATE[42000]: Syntax error or access violation: 1064

[Dontorpedo]

full Error:

PDOException 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 '= '1'' at line 1 http://mydomain/admin/pages/1/build

I have used #8 issuecomment-625410309
to add your pagebuilder into my exististing app,

added created a page (filled only name, didn't know if data and layout should be filled)

i created than the button for the building route

http://mydomain/admin/pages/1/build

but then the error appears, what can i do about it?

thanks
Denis

[HansSchouten]

Layout should be the folder name of the layout that you use. By default it should be master. When does the error appear? Is it when you create a page or when you go to the build URL?

[Dontorpedo]

it appears when i go to the build url.

[HansSchouten]

Is the page layout now set to master, do you have theme files and are you sure you have the latest config.php? Your config should be similar to: https://github.com/HansSchouten/Laravel-Pagebuilder/blob/master/config/pagebuilder.php.

The query syntax '= '1'' does not contain any information on what goes wrong. It is just contains the id of the page and that should exist. Maybe try further debugging it by adding some dd() in PHPageBuilder\Modules\GrapesJS\PageBuilder method renderPageBuilder().

[Dontorpedo]

yes i have set the layout to master, the themfiles are in the /themes folder in the root of the project.

ok, i have updated the config file, the outcome changed somehow..

now i have a white page, no further error, also nothing in logfile :(

[HansSchouten]

Do you see the loading animation? Then maybe check your browser console for JavaScript errors or inspect the page source for PHP errors that are not displayed.

[Dontorpedo]

ha, was on wrong url.. now it works.. thank your very much!

what should i see on the builderpage? at the moment i see only this

https://share.getcloudapp.com/OAuBq6LP

[Dontorpedo]

oh ok, in the demo is only a header, thought there are more blocks, nice package, have to play around with it. thank you for your great support!