[v5] Update date with error "Unknown column '_zone' in 'field list'"

[jairochaves2]

I am creating an event calendar.
When the store method is executed, it builds as expected, however, when it should perform an update, the following error is returned:

{
  "message": "update `calendar_events` set `id_calendar` = 1, `event_name` = 'Provas 2', `start_event` = 2021-09-28 00:00:00.000 -03:00, `end_event` = 2021-09-30 00:00:00.000 -03:00 where `id` = '1' - Unknown column '_zone' in 'field list'",
  "stack": "Error: update `calendar_events` set `id_calendar` = 1, `event_name` = 'Provas 2', `start_event` = 2021-09-28 00:00:00.000 -03:00, `end_event` = 2021-09-30 00:00:00.000 -03:00 where `id` = '1' - Unknown column '_zone' in 'field list'\n

Validator:

import { schema, rules } from '@ioc:Adonis/Core/Validator'
import { HttpContextContract } from '@ioc:Adonis/Core/HttpContext'

export default class UpdateValidator {
  constructor(protected ctx: HttpContextContract) {}
  public schema = schema.create({
    idLevelOfEducation: schema.number.optional([
      rules.exists({ column: 'id', table: 'level_of_educations' }),
    ]),
    year: schema.number.optional([rules.unsigned()]),
    period: schema.number.optional([rules.unsigned()]),
    startPeriod: schema.date.optional(),
    endPeriod: schema.date.optional(),
    notation: schema.string.optional({ trim: true }),
    eventCalendarUrl: schema.string.optional({ trim: true }, [rules.url()]),
  })
  public messages = {}
}

Model

import { DateTime } from 'luxon'
import { BaseModel, column } from '@ioc:Adonis/Lucid/Orm'

export default class CalendarEvent extends BaseModel {
  @column({ isPrimary: true })
  public id: number

  @column()
  public idCalendar: number

  @column()
  public eventName: string

  @column.date()
  public startEvent: DateTime

  @column.date()
  public endEvent: DateTime

  @column.dateTime({ autoCreate: true })
  public createdAt: DateTime

  @column.dateTime({ autoCreate: true, autoUpdate: true })
  public updatedAt: DateTime
}

Controller

import { HttpContextContract } from '@ioc:Adonis/Core/HttpContext'
import CalendarEvent from 'App/Models/CalendarEvent'
import CalendarEventStore from 'App/Validators/CalendarEvent/StoreValidator'
import CalendarEventUpdate from 'App/Validators/CalendarEvent/StoreValidator'
export default class CalendarEventsController {

  public async store({ request }: HttpContextContract) {
    const data = await request.validate(CalendarEventStore)
    return await CalendarEvent.create(data)
  }


  public async update({ request, params }: HttpContextContract) {
    const data = await request.validate(CalendarEventStore)
    await CalendarEvent.query().where({ id: params.id }).update(data)
  }

}

Object of validate

{
  idCalendar: 1,
  eventName: 'Provas 2',
  startEvent: DateTime {
    ts: 1632798000000,
    _zone: SystemZone {},
    loc: Locale {
      locale: 'pt-BR',
      numberingSystem: null,
      outputCalendar: null,
      intl: 'pt-BR',
      weekdaysCache: [Object],
      monthsCache: [Object],
      meridiemCache: null,
      eraCache: {},
      specifiedLocale: null,
      fastNumbersCached: null
    },
    invalid: null,
    weekData: null,
    c: {
      year: 2021,
      month: 9,
      day: 28,
      hour: 0,
      minute: 0,
      second: 0,
      millisecond: 0
    },
    o: -180,
    isLuxonDateTime: true
  },
  endEvent: DateTime {
    ts: 1632970800000,
    _zone: SystemZone {},
    loc: Locale {
      locale: 'pt-BR',
      numberingSystem: null,
      outputCalendar: null,
      intl: 'pt-BR',
      weekdaysCache: [Object],
      monthsCache: [Object],
      meridiemCache: null,
      eraCache: {},
      specifiedLocale: null,
      fastNumbersCached: null
    },
    invalid: null,
    weekData: null,
    c: {
      year: 2021,
      month: 9,
      day: 30,
      hour: 0,
      minute: 0,
      second: 0,
      millisecond: 0
    },
    o: -180,
    isLuxonDateTime: true
  }
}

[jairochaves2]

I believe the contents of start_event should be string when saving, but it is being passed without the ' character
'start_period' = 2021-09-30 00:00:00.000 -03:00,

[thetutlage]

The update should be performed as follows. The update section in docs talks about it too. https://docs.adonisjs.com/guides/models/crud-operations#update

const data = await request.validate(CalendarEventStore)
const event = await CalendarEvent.findOrFail(params.id)

event.merge(data)
await event.save()

[jairochaves2]

Thanks.