BotServer icon indicating copy to clipboard operation
BotServer copied to clipboard

Error during bot creation

Open rodrigorodriguez opened this issue 1 year ago • 0 comments

Fixed.

  1. Turned .env STORAGE_LOGGING=true
  2. 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);
  3. 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'.
  4. Fixed data type:

  @ForeignKey(() => GuaribasUser)
  @Column(DataType.INTEGER)
  public startedByUserId: number;

rodrigorodriguez avatar Jul 05 '22 11:07 rodrigorodriguez