MSSQL Error on migration to 0.91.1 [May 31]

Discord-Discussions
1

:man_raising_hand: LatinoFlayva asked

```pp 6007 output: Mon, 30 May 2022 04:51:43 GMT tedious deprecated The default value for config.options.enableArithAbort will change from false to true in the next major version of tedious. Set the value to true or false explicitly to silence this message. at node_modules/mssql/lib/tedious/connection-pool.js:61:23

App 6007 output: migration file “nc_013_sync_source” failed

App 6007 output: migration failed with error: CREATE TABLE [nc_sync_source_v2] ([id] nvarchar(20) not null, [title] nvarchar(255), [type] nvarchar(255), [details] nvarchar(max), [deleted] bit, [enabled] bit default ‘1’, [order] float, [project_id] nvarchar(128), [fk_user_id] nvarchar(128), [created_at] datetime2 not null default CURRENT_TIMESTAMP, [updated_at] datetime2 not null default CURRENT_TIMESTAMP, CONSTRAINT [nc_sync_source_v2_pkey] PRIMARY KEY ([id]), CONSTRAINT [nc_sync_source_v2_project_id_foreign] FOREIGN KEY ([project_id]) REFERENCES [nc_projects_v2] ([id]), CONSTRAINT [nc_sync_source_v2_fk_user_id_foreign] FOREIGN KEY ([fk_user_id]) REFERENCES [nc_users_v2] ([id])) - Could not create constraint or index. See previous errors.

App 6007 output: originalError: RequestError: CREATE TABLE [nc_sync_source_v2] ([id] nvarchar(20) not null, [title] nvarchar(255), [type] nvarchar(255), [details] nvarchar(max), [deleted] bit, [enabled] bit default ‘1’, [order] float, [project_id] nvarchar(128), [fk_user_id] nvarchar(128), [created_at] datetime2 not null default CURRENT_TIMESTAMP, [updated_at] datetime2 not null default CURRENT_TIMESTAMP, CONSTRAINT [nc_sync_source_v2_pkey] PRIMARY KEY ([id]), CONSTRAINT [nc_sync_source_v2_project_id_foreign] FOREIGN KEY ([project_id]) REFERENCES [nc_projects_v2] ([id]), CONSTRAINT [nc_sync_source_v2_fk_user_id_foreign] FOREIGN KEY ([fk_user_id]) REFERENCES [nc_users_v2] ([id])) - Could not create constraint or index. See previous errors.

```

2

:man_bald: dstala replied

<@186479783092289537>

Help us by raising a issut on github with relevant details please. GitHub · Where software is built

3

:man_raising_hand: LatinoFlayva replied

I have done this and they have put a fix in, is there any way i can edit the install to get it happening now, i can’t see the source anywhre on my server, thye must pull the db definitions remotely

4

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs