Budibase/budibase · error · Error

Column "${key}" has type "${FieldType.AUTO}" - this is not s

Error message

Column "${key}" has type "${FieldType.AUTO}" - this is not supported.

What it means

Error "Column "${key}" has type "${FieldType.AUTO}" - this is not supported." thrown in Budibase/budibase.

Source

Thrown at packages/server/src/sdk/workspace/tables/external/index.ts:68

    throw new Error(
      "External tables with no `primary` column set will define an `id` column, but we found an `id` column in the supplied schema. Either set a `primary` column or remove the `id` column."
    )
  }

  if (hasTypeChanged(table, oldTable)) {
    throw new Error("A column type has changed.")
  }

  const autoSubTypes = Object.values(AutoFieldSubType)
  // check for auto columns, they are not allowed
  for (let [key, column] of Object.entries(table.schema)) {
    // this column is a special case, do not validate it
    if (key === DEFAULT_PRIMARY_COLUMN) {
      continue
    }
    // the auto-column type should never be used
    if (column.type === FieldType.AUTO) {
      throw new Error(
        `Column "${key}" has type "${FieldType.AUTO}" - this is not supported.`
      )
    }

    if (
      column.subtype &&
      autoSubTypes.includes(column.subtype as AutoFieldSubType)
    ) {
      throw new Error(
        `Column "${key}" has subtype "${column.subtype}" - this is not supported.`
      )
    }

    if (column.type === FieldType.DATETIME) {
      const oldColumn = oldTable?.schema[key] as typeof column

      if (oldColumn && column.timeOnly !== oldColumn.timeOnly) {
        throw new Error(

View on GitHub (pinned to a81a902e9a)

When it happens

Trigger: Thrown at packages/server/src/sdk/workspace/tables/external/index.ts:68 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of Budibase/budibase@a81a902e9a (2026-08-29). Data as JSON: /api/errors/810ba553f371c657. Report an issue: GitHub.