When added blog plugin and tried to access pages with blogPosts and blogCategories components on it error rised.
In short: mismatch data type with system_files.attachment_id (varchar in DB) and query where it (integer).
db log:
2025-09-07 16:13:38.362 EDT [1941] ERROR: operator does not exist: character varying = integer at character 67
2025-09-07 16:13:38.362 EDT [1941] HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
2025-09-07 16:13:38.362 EDT [1941] STATEMENT: select * from "system_files" where "system_files"."attachment_id" in (1) and "system_files"."attachment_type" = $1 and "field" = $2 order by "sort_order" asc
running on:
OS: OpenBSD 7.7
webserver: OpenBSD httpd
DB: postgresql-server-17.5
PHP: php-8.2.29
WinterCMS: 1.2.8
p.s.
when change attachment_id to integer no error but not sure this right thing
When added blog plugin and tried to access pages with blogPosts and blogCategories components on it error rised.
In short: mismatch data type with system_files.attachment_id (varchar in DB) and query where it (integer).
db log:
2025-09-07 16:13:38.362 EDT [1941] ERROR: operator does not exist: character varying = integer at character 67
2025-09-07 16:13:38.362 EDT [1941] HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
2025-09-07 16:13:38.362 EDT [1941] STATEMENT: select * from "system_files" where "system_files"."attachment_id" in (1) and "system_files"."attachment_type" = $1 and "field" = $2 order by "sort_order" asc
running on:
OS: OpenBSD 7.7
webserver: OpenBSD httpd
DB: postgresql-server-17.5
PHP: php-8.2.29
WinterCMS: 1.2.8
p.s.
when change attachment_id to integer no error but not sure this right thing