Unable to create new collection "Unknown column 'color' in 'field list"

Note
Although the forum says to update to the latest version, this just isn't possible for us right now because we use MySQL version 5 as our database which the new Metabase versions no longer support.

Problem
When trying to create a new collection, the following error occurs ""Unknown column 'color' in 'field list". Then the blue "Create" button turn red to "Failed".

This problem has happened in the past then gone away on it's own within a few hours. In this instance it is still occurring after almost 2 days.

Attempted Solutions

  1. Refresh the page
  2. Log out / log back in

Screenshot 2024-02-01 at 10.34.56 AM

Diagnostic Info
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.21+9",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.21",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.21+9",
"os.name": "Linux",
"os.version": "4.15.0-172-generic",
"user.language": "en",
"user.timezone": "Asia/Shanghai"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.42-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.6"
}
},
"run-mode": "prod",
"version": {
"date": "2023-12-01",
"tag": "v0.47.9",
"branch": "?",
"hash": "d05b06e"
},
"settings": {
"report-timezone": null
}
}
}

No one knows?

we dropped color column in 46 if I'm not mistaken so either:

  1. you're running an old frontend code or
  2. you have a version of the app DB which is requesting color column to be filled
    Remove unused collection `color` column by nemanjaglumac · Pull Request #34239 · metabase/metabase · GitHub

related `load-from-h2` fails when loading from 46.8 into 47.4 trying to load collections · Issue #34582 · metabase/metabase · GitHub

Thank you, I'll pass this up to our devs and see if this fixes it.