Canvas: Saving content with PostgreSQL

[canatufkansu]

Hi,

I installed the Canvas to my existing laravel project which I first upgraded from 5.8 to 6.0 then installed auth scaffolding. Right now when go to localhost/canvas I can login and start writing a post but when I click to publish on the top left side system says "Published" but doesn't save the post to the database. Also when return to dashboard I cannot see any published posts. I'm using Postgresql and I can see all of the Canvas tables created but they are all empty. How can I find the problem ?

Thanks,

[canatufkansu]

I have just figured out that when I open developer console on Chrome, when I click save I get the following error.

message: "SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type uuid: "create" (SQL: select count(*) as aggregate from "canvas_posts" where "slug" = post-b53ecc39-df2b-4159-8b45-3ccef110e351 and "id" <> create and ("slug" = post-b53ecc39-df2b-4159-8b45-3ccef110e351 and "user_id" = 1))"
exception: "Illuminate\Database\QueryException"
file: "/Applications/MAMP/htdocs/fizbot-website-v2/vendor/laravel/framework/src/Illuminate/Database/Connection.php"

What I understood is in the database "id" column in "uuid" type so when this query try to run Postgresql cannot check "id" <> create because create value is not a uuid type. It is a varchar. Maybe this lead will help to identify the issue.

[austintoddj]

That's very helpful, thanks @canatufkansu.

I'll see what I can do to make a fix for this.

[canatufkansu]

My Laravel Framework is 6.18.3 and I just installed Canvas so it is probably the latest version. By the way I updated my comment at the top which is probably a better lead.

[austintoddj]

Much appreciated!

[thewwwizard]

New to laravel, testing blog packages. Same problem.
PostgreSQL 11.4
PHP 7.3.1
Laravel 7.4.0

[austintoddj]

Fixed in v5.3.7