search

VirtusLab-Open-Source / strapi-plugin-comments

A plugin for Strapi Headless CMS that provides end to end comments feature with their moderation panel, bad words filtering, abuse reporting and more.
MIT License
414 stars 65 forks source link

error: alter table "comments" add column "content" text not null #91

Closed Flowko closed 3 years ago

Flowko commented 3 years ago

hey there, im not able to run strapi after installing strapi-plugin-comments plugin! i get this error message, im using postgres instead of sqlite db, not sure if thats the problem, would mean alot if anyone can help me with this.

strapi: 3.6.8 node: 14.16.0 strapi-plugin-comments: 1.0.4

[2021-11-28T00:01:06.246Z] debug ⛔️ Server wasn't able to start properly. [2021-11-28T00:01:06.247Z] error error: alter table "comments" add column "content" text not null, add column "blocked" boolean null, add column "blockedThread" boolean null, add column "blockReason" varchar(255) null, add column "points" integer null, add column "authorUser" integer null, add column "authorType" varchar(255) null, add column "authorId" varchar(255) null, add column "authorName" varchar(255) null, add column "authorEmail" varchar(255) null, add column "authorAvatar" varchar(255) null, add column "removed" boolean null, add column "relatedSlug" varchar(255) null, add column "threadOf" integer null, add column "approvalStatus" varchar(255) null - column "content" of relation "comments" contains null values

Flowko commented 3 years ago

so it was kinda a db issue, since ive already had a comment table, i thought when u remove it inside Strapi, it gets dropped in the db, but that didnt happend, it was still there, so i just had to drop it from the db and its working