Multi Tenant Plugin - Issue with versions.

[nunesunil]

Describe the Bug

Hi @JarrodMFlesch , there's an issue in versions for collections with multi-tenancy plugin. I have used the payload multi tenancy example to reproduce this issue with Version enable for Page Collection.

[19:23:44] ERROR: Cannot find field for path at tenant err: { "type": "APIError", "message": "Cannot find field for path at tenant", "stack": APIError: Cannot find field for path at tenant at getTableColumnFromPath (webpack-internal:///(rsc)/./node_modules/.pnpm/@payloadcms+drizzle@3.22.0_@libsql+client@0.14.0_@types+react@19.0.1_payload@3.22.0_gra_18a45a32524f937fd5fcab94be82d61d/node_modules/@payloadcms/drizzle/dist/queries/getTableColumnFromPath.js:582:11) at parseParams (webpack-internal:///(rsc)/./node_modules/.pnpm/@payloadcms+drizzle@3.22.0_@libsql+client@0.14.0_@types+react@19.0.1_payload@3.22.0_gra_18a45a32524f937fd5fcab94be82d61d/node_modules/@payloadcms/drizzle/dist/queries/parseParams.js:60:242) at buildAndOrConditions (webpack-internal:///(rsc)/./node_modules/.pnpm/@payloadcms+drizzle@3.22.0_@libsql+client@0.14.0_@types+react@19.0.1_payload@3.22.0_gra_18a45a32524f937fd5fcab94be82d61d/node_modules/@payloadcms/drizzle/dist/queries/buildAndOrConditions.js:14:88) at parseParams (webpack-internal:///(rsc)/./node_modules/.pnpm/@payloadcms+drizzle@3.22.0_@libsql+client@0.14.0_@types+react@19.0.1_payload@3.22.0_gra_18a45a32524f937fd5fcab94be82d61d/node_modules/@payloadcms/drizzle/dist/queries/parseParams.js:37:123) at buildQuery (webpack-internal:///(rsc)/./node_modules/.pnpm/@payloadcms+drizzle@3.22.0_@libsql+client@0.14.0_@types+react@19.0.1_payload@3.22.0_gra_18a45a32524f937fd5fcab94be82d61d/node_modules/@payloadcms/drizzle/dist/queries/buildQuery.js:25:77) at find (webpack-internal:///(rsc)/./node_modules/.pnpm/@payloadcms+drizzle@3.22.0_@libsql+client@0.14.0_@types+react@19.0.1_payload@3.22.0_gra_18a45a32524f937fd5fcab94be82d61d/node_modules/@payloadcms/drizzle/dist/find/findMany.js:29:119) "data": null, "isOperational": true, "isPublic": false, "status": 500, "name": "APIError" } ⨯ [TypeError: Cannot read properties of undefined (reading 'map')] { digest: '918307918' }

Screen.Recording.2025-02-09.at.7.23.36.pm.mov

Link to the code that reproduces this issue

https://github.com/nunesunil/payload-issues/blob/main/src/collections/Pages/index.ts

Reproduction Steps

https://github.com/nunesunil/payload-issues

Which area(s) are affected? (Select all that apply)

plugin: other

Environment Info

Binaries:
  Node: 22.13.1
  npm: 10.9.2
  Yarn: N/A
  pnpm: 10.2.1
Relevant Packages:
  payload: 3.22.0
  next: 15.1.6
  @payloadcms/graphql: 3.22.0
  @payloadcms/next/utilities: 3.22.0
  @payloadcms/richtext-lexical: 3.22.0
  @payloadcms/translations: 3.22.0
  @payloadcms/ui/shared: 3.22.0
  react: 19.0.0
  react-dom: 19.0.0
Operating System:
  Platform: darwin
  Arch: arm64
  Version: Darwin Kernel Version 24.3.0: Thu Jan  2 20:24:23 PST 2025; root:xnu-11215.81.4~3/RELEASE_ARM64_T6020
  Available memory (MB): 32768
  Available CPU cores: 10

[JarrodMFlesch]

@nunesunil Can you install the latest version of all the payload packages and let me know if you still run into this? I am unable to recreate on 3.22.0

[nunesunil]

@JarrodMFlesch v3.22 solves the issue

[nunesunil]

Apologies @JarrodMFlesch , but I need to reopen this issue. After running several tests, I discovered that the problem persists if the user has tenants assigned. For example, when we created users in the seed -

`await payload.create({
collection: 'users',
data: {
email: 'demo@payloadcms.com',
password: 'demo',
roles: ['super-admin'],
},
});

await payload.create({
	collection: 'users',
	data: {
		email: 'tenant1@payloadcms.com',
		password: 'demo',
		tenants: [
			{
				roles: ['tenant-admin'],
				tenant: tenant1.id,
			},
		],
		username: 'tenant1',
	},
});`

If we login in with 'demo@payloadcms.com' the version is working as expected. But, if with 'tenant1@payloadcms.com' there is a issue as shown above.

[dev-luizf]

I'm having the same error after setting up the multi tenant plugin on a project with the website template.

I created a user and assigned it to a tenant. When I access any collection on the admin panel using the tenant login, it shows this error on console:
https://i.imgur.com/NREgIV7.png

I'm using postgres and the only thing a did different when configuring the plugin was naming the tenants collection as "organizations".

[dev-luizf]

I was able to fix it by removing the tenantsArrayField configuration from the users collection:

https://i.imgur.com/IlFBzQs.png

And setting this configuration directly in the multiTenantPlugin config:

https://i.imgur.com/gMHTLOR.png

My previous code was based on the example from the multi-tenant plugin, with some modifications to fix type errors, but it seems to have been incorrect. So, I applied the configuration directly in the plugin, where there is no need to set additional properties beyond the ones I want to modify.

[nunesunil]

@dev-luizf It is not working for me,can you share the code to reproduce?

[dev-luizf]

@nunesunil this is my plugins config on the payload config:

  plugins: [
    ...plugins,
    multiTenantPlugin<Config>({
      collections: {
        courses: {},
      },
      tenantsSlug: Organizations.slug,
      tenantField: {
        access: {
          read: () => true,
          update: ({ req }) => {
            if (isAdmin(req.user)) {
              return true
            }
            return getUserTenantIDs(req.user).length > 0
          },
        },
      },
      tenantsArrayField: {
        rowFields: [
          {
            name: 'roles',
            type: 'select',
            defaultValue: ['tenant-viewer'],
            hasMany: true,
            options: ['tenant-admin', 'tenant-viewer'],
            required: true,
          },
        ],
      },
      userHasAccessToAllTenants: (user) => isAdmin(user),
    }),
    // storage-adapter-placeholder
  ],

My tenant collection:

import { isAdminAccess } from '@/access/isAdmin'
import { isAdminOrOrgAdminAccess } from '@/access/isAdminOrOrgAdmin'
import type { CollectionConfig } from 'payload'

export const Organizations: CollectionConfig = {
  slug: 'organizations',
  access: {
    create: isAdminAccess,
    delete: isAdminOrOrgAdminAccess,
    read: ({ req }) => Boolean(req.user),
    update: isAdminOrOrgAdminAccess,
  },
  admin: {
    useAsTitle: 'name',
  },
  fields: [
    {
      name: 'name',
      type: 'text',
      required: true,
    },
  ],
  timestamps: true,
}

And my user collection:

import type { CollectionConfig } from 'payload'

import { authenticated } from '../../access/authenticated'
import { isAdmin } from '@/access/isAdmin'

export const Users: CollectionConfig = {
  slug: 'users',
  access: {
    admin: authenticated,
    create: authenticated,
    delete: authenticated,
    read: authenticated,
    update: authenticated,
  },
  admin: {
    defaultColumns: ['name', 'email'],
    useAsTitle: 'name',
  },
  auth: true,
  fields: [
    {
      name: 'name',
      type: 'text',
    },
    {
      name: 'roles',
      type: 'select',
      defaultValue: 'user',
      hasMany: false,
      options: ['admin', 'user'],
      access: {
        update: ({ req }) => {
          return isAdmin(req.user)
        },
      },
    },
  ],
  timestamps: true,
}