Filament•3mo ago

Visual Builder Email Template Error

Hi, I'm using Email Template editor plugin from Visual Builder https://github.com/visualbuilder/email-templates and using postgre database, the plugin is working nicely on local server. And then I got this error on production server:

"SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer LINE 1: ...om "vb_email_templates_themes" where "is_default" = 1 and "v... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "vb_email_templates_themes" where "is_default" = 1 and "vb_email_templates_themes"."deleted_at" is null limit 1)"

"SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer LINE 1: ...om "vb_email_templates_themes" where "is_default" = 1 and "v... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "vb_email_templates_themes" where "is_default" = 1 and "vb_email_templates_themes"."deleted_at" is null limit 1)"

Maybe someone using this plugin too and can help me to solve this? The column on the database is already mapped with boolean type and filled in with True or False condition.

GitHub

GitHub - visualbuilder/email-templates: Email Template Editor for F...

Email Template Editor for Filament. Contribute to visualbuilder/email-templates development by creating an account on GitHub.

3 Replies

awcodes•3mo ago

You should reach out to the plugin author either via the plugin channel on here or through GitHub issues.

kisutOP•3mo ago

I've created them but they seem to be inactive, I also tried their email but it's not accepting incoming messages.

awcodes•3mo ago

Then my advice is to find another solution. But maybe they are just on holiday or something like that. Don’t know.

Gaming

Programming

Visual Builder Email Template Error