search

verbb / zen

A Craft CMS plugin to manage content across multiple environments with ease.
Other
2 stars 0 forks source link

PostgreSQL Compatibility; Installation Fails #1

Closed haslo closed 8 months ago

haslo commented 8 months ago

Describe the bug

The plugin always assumes that the backend is MySQL, and thus does not install on PostgreSQL backends.

Steps to reproduce

  1. Install CraftCMS with a PostgreSQL backend
  2. Try to install the Zen plugin
  3. Observe error message "type 'longblob' does not exist", which stems from https://github.com/verbb/zen/blob/7ad1e8d5a60b9f93a3f2a2f996ee97c4999b5393/src/migrations/Install.php#L40

Craft CMS version

4.5.9

Plugin version

1.0.0

Multi-site?

No

Additional context

This is on a fresh install. The plugin obviously works fine with MySQL, but PostgreSQL doesn't have the "longblob" type.

engram-design commented 8 months ago

Ah, my mistake - I actually thought longblob was available on both. Fixed in 1.0.1