Database error after moving from mysql to psql

outl1ne / nova-page-manager

Static page and region manager for Laravel Nova - designed for headless CMS's.

MIT License

180 stars 39 forks source link

Database error after moving from mysql to psql #73

Closed Iznaur closed 3 years ago

Iznaur commented 3 years ago

Hello, after changing database saving pages doesn't work for me, i get that error: "SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type boolean: "{{published}}" (SQL: select count(*) as aggregate from "nova_page_manager_pages" where "slug" = / and "id" <> 1 and "published" = {{published}} and "locale" = en and "parent_id" is null)" How can I fix it?

KasparRosin commented 3 years ago

Released 3.5.0 that should hopefully fix this issue. Let us know if this issue persists after updating version.