BotServer
BotServer copied to clipboard
Error during bot creation
Fixed.
- Turned .env STORAGE_LOGGING=true
- Analysed Log para obtenção do SQL: IF OBJECT_ID('[GuaribasConversation]', 'U') IS NULL CREATE TABLE [GuaribasConversation] ([conversationId] INTEGER IDENTITY(1,1) , [instanceId] INTEGER NULL, [startSubjectId] INTEGER NULL, [channelId] INTEGER NULL, [rateDate] DATETIMEOFFSET NULL, [rate] FLOAT NULL, [feedback] NVARCHAR(512) NULL, [createdAt] DATETIMEOFFSET NULL, [text] NVARCHAR(255) NULL, [startedByUserId] NVARCHAR(255) NULL, [updatedAt] DATETIMEOFFSET NOT NULL, PRIMARY KEY ([conversationId]), FOREIGN KEY ([startSubjectId]) REFERENCES [GuaribasSubject] ([subjectId]) ON DELETE NO ACTION, FOREIGN KEY ([startedByUserId]) REFERENCES [GuaribasUser] ([userId]) ON DELETE NO ACTION);
- Executed mensagem: SQL Error [1778] [S0000]: Column 'GuaribasUser.userId' is not the same data type as referencing column 'GuaribasConversation.startedByUserId' in foreign key 'FK__GuaribasC__start__503BEA1C'.
- Fixed data type:
@ForeignKey(() => GuaribasUser)
@Column(DataType.INTEGER)
public startedByUserId: number;