search

verbb / vizy

A flexible visual editor for Craft CMS
Other
44 stars 8 forks source link

Database error : column "fill" does not exist #275

Closed bartroelands closed 9 months ago

bartroelands commented 9 months ago

Describe the bug

When I create a new Vizy field type and and try to edit the field I get a database exception:

SQLSTATE[42703]: Undefined column: 7 ERROR: column "fill" does not exist LINE 1: ...ight", "width", "format", "quality", "interlace", "fill", "u... ^ The SQL being executed was: SELECT "id", "name", "handle", "mode", "position", "height", "width", "format", "quality", "interlace", "fill", "upscale", "parameterChangeTime", "uid" FROM "imagetransforms" ORDER BY "name"

Steps to reproduce

  1. Go to craft settings
  2. Create new field
  3. Select field type 'Vizy'
  4. Save
  5. Edit field

Craft CMS version

Craft Pro 4.5.12

Plugin version

2.1.14

Multi-site?

NO

Additional context

I am evaluating Vizy on a local dev machine running DDEV and on a Postgres database (version 11). I had postgres database issues with other plugins in the past. Maybe a compatibility issue ?

bartroelands commented 9 months ago

Hi,

This issue was aparently linked to a missed database migration in Craft that was suppose to create the columns fill and upscale. For some reason these were not created in my test database (?). Adding the columns manually solved the issue. Not related to Vizy plugin ... closing the issue