For Workes & Pages, what is the name of the domain?
stawl.app
What is the error number?
7500
What is the error message?
Migration 0013_add_conditions.sql failed with the following errors: ✘ [ERROR] incomplete input: SQLITE_ERROR [code: 7500]
What is the issue or error you’re encountering
When trying to apply migrations with create trigger
statements, it always fails. Running the statements as a regular query works fine.
What steps have you taken to resolve the issue?
I remove the create trigger
statements from the migration, run the migraton, re-add the statements, and run the migration file again.
What are the steps to reproduce the issue?
Add a migration with a create trigger
statement:
create trigger if not exists update_myTable_updatedAt
after update
on myTable
begin
update myTable set updatedAt = (date() || 'T' || time() || 'Z') where id = old.id;
end;