fix: slice title when longer than max chars during import

packages/api/src/routers/card.ts

@@ -27,7 +27,7 @@ export const cardRouter = createTRPCRouter({
     })
     .input(
       z.object({
-        title: z.string().min(1),
+        title: z.string().min(1).max(2000),
         description: z.string().max(10000),
         listPublicId: z.string().min(12),
         labelPublicIds: z.array(z.string().min(12)),
@@ -760,7 +760,7 @@ export const cardRouter = createTRPCRouter({
     .input(
       z.object({
         cardPublicId: z.string().min(12),
-        title: z.string().min(1).optional(),
+        title: z.string().min(1).max(2000).optional(),
         description: z.string().optional(),
         index: z.number().optional(),
         listPublicId: z.string().min(12).optional(),

packages/api/src/routers/import.ts

@@ -52,7 +52,7 @@ interface TrelloCheckItem {
 
 interface TrelloCard {
   id: string;
-  name: string;
+  name: string | null;
   desc: string;
   idList: string;
   labels: TrelloLabel[];
@@ -290,7 +290,7 @@ export const importRouter = createTRPCRouter({
             if (list.cards.length && newListId) {
               const cardsInsert = list.cards.map((card, index) => ({
                 publicId: generateUID(),
-                title: card.name,
+                title: (card.name?.trim() ?? "Untitled Card").slice(0, 2000),
                 description: card.description,
                 createdBy: userId,
                 listId: newListId,

packages/db/migrations/20251229220153_UpdateCardTitleFromVarcharToText.sql

@@ -0,0 +1,3 @@
+ALTER TABLE "card_activity" ALTER COLUMN "fromTitle" SET DATA TYPE text;--> statement-breakpoint
+ALTER TABLE "card_activity" ALTER COLUMN "toTitle" SET DATA TYPE text;--> statement-breakpoint
+ALTER TABLE "card" ALTER COLUMN "title" SET DATA TYPE text;

packages/db/migrations/meta/_journal.json

@@ -148,6 +148,13 @@
       "when": 1764621815672,
       "tag": "20251201204335_AddCardDueDates",
       "breakpoints": true
+    },
+    {
+      "idx": 21,
+      "version": "7",
+      "when": 1767045713686,
+      "tag": "20251229220153_UpdateCardTitleFromVarcharToText",
+      "breakpoints": true
     }
   ]
 }

packages/db/src/schema/cards.ts

@@ -57,7 +57,7 @@ export const activityTypeEnum = pgEnum("card_activity_type", activityTypes);
 export const cards = pgTable("card", {
   id: bigserial("id", { mode: "number" }).primaryKey(),
   publicId: varchar("publicId", { length: 12 }).notNull().unique(),
-  title: varchar("title", { length: 255 }).notNull(),
+  title: text("title").notNull(),
   description: text("description"),
   index: integer("index").notNull(),
   createdBy: uuid("createdBy").references(() => users.id, {
@@ -127,8 +127,8 @@ export const cardActivities = pgTable("card_activity", {
   workspaceMemberId: bigint("workspaceMemberId", {
     mode: "number",
   }).references(() => workspaceMembers.id, { onDelete: "set null" }),
-  fromTitle: varchar("fromTitle", { length: 255 }),
+  fromTitle: text("fromTitle"),
-  toTitle: varchar("toTitle", { length: 255 }),
+  toTitle: text("toTitle"),
   fromDescription: text("fromDescription"),
   toDescription: text("toDescription"),
   createdBy: uuid("createdBy").references(() => users.id, {