Cannot read properties of undefined (reading 'schema')

[JBSDS]

Hello everyone,

I'm facing an issue since I updated Budibase: I upgraded from version 2.32.11 to the latest available version (above 3.0 ). After this update, I started encountering the following error whenever I use filters that reference "relationships" in the database :

Cannot read properties of undefined (reading 'schema').

For context, I am using MySQL as my database.

I tested a downgrade to version 2.32.11 , and everything works fine in this version. However, my goal is to move to the latest version to take advantage of the new features and improvements. 🙄

Has anyone else encountered this issue ? Or does anyone have ideas on how to diagnose/fix this problem ? Any help or guidance would be greatly appreciated ! 🙏

Thank you in advance for your feedback

{
  "browser": {
    "language": "fr-FR",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36",
    "platform": "Win32",
    "vendor": "Google Inc."
  },
  "server": {
    "budibaseVersion": "3.2.25",
    "hosting": "docker-compose",
    "nodeVersion": "v20.18.1",
    "platform": "linux",
    "cpuArch": "x64",
    "cpuCores": 32,
    "cpuInfo": "13th Gen Intel(R) Core(TM) i9-13900K",
    "totalMemory": "31.22834014892578GB",
    "uptime": "0 day(s), 7 hour(s), 36 minute(s)"
  }
}

[linear]

BUDI-8906 Cannot read properties of undefined (reading 'schema')

[WoisWoi]

I'm also having this problem.

[mike12345567]

Hi @WoisWoi and @JBSDS - would it be possible to provide a schema for a database which exhibits this behaviour? You can export this using the following functionality in Budibase: https://docs.budibase.com/docs/troubleshooting-sql#sql-schema-export

[JBSDS]

Hi @mike12345567, here is the database schema.
MySQL-dump (1).zip

[JBSDS]

Hi @mike12345567 , I updated to version 3.2.28 of Budibase, but I haven't noticed any difference. I'm not sure if this version was supposed to resolve the issue.
Thank you for your help. 🙂

[mike12345567]

Hi @JBSDS - the fix has been merged but not released yet - I'll update this issue once the release goes out next week.

[JBSDS]

It works, thank you! 🙂