ibrahimyaacob Posts - Convex Community

ibrahimyaacob

Posts Comments

CCConvex Community

•Created by ibrahimyaacob on 3/21/2025 in #support-community

Multiple deletion issue

1 replies

CCConvex Community

•Created by ibrahimyaacob on 3/14/2025 in #support-community

ents getX() throws .unique() query returned more than one result error

Im getting the error in the snapshot below

5 replies

CCConvex Community

•Created by ibrahimyaacob on 3/11/2025 in #support-community

unable to delete many

This is my action's handler

    const commentIds = duplicateComments.map((comment) => comment._id);
    // Delete comments in batches of 20
    for (let i = 0; i < commentIds.length; i += 20) {
      const batch = commentIds.slice(i, i + 20);
      if (batch.length > 0) {
        try {
          await ctx.runMutation(
            api.functions.socialPostCommentsAdmin.deleteFromTableComments,
            {
              commentIds: batch,
            },
          );
        } catch (error) {
          console.error(`Error deleting comments ${batch}:`, error);
        }
      }
    }

    const commentIds = duplicateComments.map((comment) => comment._id);
    // Delete comments in batches of 20
    for (let i = 0; i < commentIds.length; i += 20) {
      const batch = commentIds.slice(i, i + 20);
      if (batch.length > 0) {
        try {
          await ctx.runMutation(
            api.functions.socialPostCommentsAdmin.deleteFromTableComments,
            {
              commentIds: batch,
            },
          );
        } catch (error) {
          console.error(`Error deleting comments ${batch}:`, error);
        }
      }
    }

and the mutation

export const deleteFromTableComments = mutation({
  args: {
    commentIds: v.array(v.id("socialPostComments")),
  },
  handler: async (ctx, args) => {
    const { commentIds } = args;
    const deleteCommentPromise = commentIds.map(async (id) => {
      try {
        await ctx.table("socialPostComments").getX(id).delete();
      } catch (error) {
        console.error(`Error deleting comments ${id}:`, error);
      }
    });
    const deletedComments = await Promise.all(deleteCommentPromise);

    return deletedComments;
  },
});

export const deleteFromTableComments = mutation({
  args: {
    commentIds: v.array(v.id("socialPostComments")),
  },
  handler: async (ctx, args) => {
    const { commentIds } = args;
    const deleteCommentPromise = commentIds.map(async (id) => {
      try {
        await ctx.table("socialPostComments").getX(id).delete();
      } catch (error) {
        console.error(`Error deleting comments ${id}:`, error);
      }
    });
    const deletedComments = await Promise.all(deleteCommentPromise);

    return deletedComments;
  },
});

` and apparently im getting this error.

Uncaught Error: undefined is not a valid Convex value (present at path [0] in original object

Uncaught Error: undefined is not a valid Convex value (present at path [0] in original object

complete error log below

4 replies

CCConvex Community

•Created by ibrahimyaacob on 3/10/2025 in #support-community

middleware is slowing down NextJS page render

20 replies

CCConvex Community

•Created by ibrahimyaacob on 3/6/2025 in #support-community

optimistic updates with view transition

2 replies

CCConvex Community

•Created by ibrahimyaacob on 2/10/2025 in #support-community

best way to build ai chat with infinite memory with vector search ?

Hi, need some advice here. i just want a simple infinite memory group chat, no file/image or pdf upload needed. there'll be tables like 1. sessions 2. sessionUsers 3. messages im thinking to create a vectorIndex on the message table. looking at api, it have search the table by embedding which will return me list matching record (id & score) right now I'm struggling to connect the dots here. How do I perform the vector search so that it would able to identify that which message belongs to who & when it is sent.

3 replies

CCConvex Community

•Created by ibrahimyaacob on 2/7/2025 in #support-community

how do i skip indexed query field

it seems like i am forced to follow the order of the defined index in schema. I dont want to use filter because some of the query are hitting too many bytes read error. please help schema.ts

    .index("organizationId_postedAt_experiment", [
      "organizationId",
      "isOwner",
      "statusLabel",
      "postedAt",
    ])

    .index("organizationId_postedAt_experiment", [
      "organizationId",
      "isOwner",
      "statusLabel",
      "postedAt",
    ])

function.ts

let query = ctx
      .table(
        "socialPostComments",
        "organizationId_postedAt_experiment",
        (q) => {
          let indexedQuery = q
            .eq("organizationId", args.organizationId)
            .eq("isOwner", false) // i want to skip this, make it optional
            .eq("statusLabel", "LIVE");

          if (args.date) {
            return indexedQuery
              .gte("postedAt", args.date.from)
              .lte("postedAt", args.date.to);
          }

          return indexedQuery;
        },
      )
      .order("desc");

let query = ctx
      .table(
        "socialPostComments",
        "organizationId_postedAt_experiment",
        (q) => {
          let indexedQuery = q
            .eq("organizationId", args.organizationId)
            .eq("isOwner", false) // i want to skip this, make it optional
            .eq("statusLabel", "LIVE");

          if (args.date) {
            return indexedQuery
              .gte("postedAt", args.date.from)
              .lte("postedAt", args.date.to);
          }

          return indexedQuery;
        },
      )
      .order("desc");

7 replies

CCConvex Community

•Created by ibrahimyaacob on 1/23/2025 in #support-community

aggregate component query is using a lot of bandwidth (exceeding 300gb after first week implement)

i need support on this one. i admit that i have many fields/metric that im currently aggregating (just to get count). but i dont expect that it'd be this much

5 replies

CCConvex Community

•Created by ibrahimyaacob on 1/23/2025 in #support-community

i need username + password sign up with convex auth

as what it said in the title. how do i do this ?

4 replies

CCConvex Community

•Created by ibrahimyaacob on 1/22/2025 in #support-community

Convex Auth catching different type of error on sign in/sign up

I want to be able to display the right message to user for example. on sign up - user already sign in - password is not secure enough on sign in - email & password does not match etc..

5 replies

CCConvex Community

•Created by ibrahimyaacob on 1/17/2025 in #support-community

DELETE_MISSING_KEY error on aggregate.trigger() on trigger (convex helper)

32 replies

CCConvex Community

•Created by ibrahimyaacob on 1/17/2025 in #support-community

Uncaught ConvexError: InvalidCursor: Tried to run a query starting from a cursor, but it looks like

1 replies

CCConvex Community

•Created by ibrahimyaacob on 1/16/2025 in #support-community

How to catch too many bytes read in a single function execution error ?

i have a query function that performs multiple queries below.

export const queryfunction = query({

// expensive query 1
const result1 = await ctx.db("..")

// expensive query 2
const result2 = await ctx.db("..")

})

export const queryfunction = query({

// expensive query 1
const result1 = await ctx.db("..")

// expensive query 2
const result2 = await ctx.db("..")

})

right now im trying to understand if the the too many bytes read in a single function is caused by a single db query or is it triggered by sum of that multiple queries? if its the later, how do i catch it in serverside ?

8 replies

CCConvex Community

•Created by ibrahimyaacob on 1/11/2025 in #support-community

npx convex dev doesnt download generated code from another repo

19 replies

CCConvex Community

•Created by ibrahimyaacob on 1/10/2025 in #support-community

with convex auth, how do i sign in as user. its for the usecase where admins need to debug what is happening to user's account.

6 replies

CCConvex Community

•Created by ibrahimyaacob on 1/9/2025 in #support-community

I need help with this one. How do i merge the two sign up method so that it detects its the same email

4 replies

CCConvex Community

•Created by ibrahimyaacob on 1/6/2025 in #support-community

how to query all rows (recursively) ?

i need to pull all the between two dates but i need to query an estimate of 1mil++ rows. I know convex doesnt like big queries, so im guessing i need to run in recursively untill it is exhausted.

4 replies

CCConvex Community

•Created by ibrahimyaacob on 1/2/2025 in #support-community

convex auth on expo password provider error

9 replies

CCConvex Community

•Created by ibrahimyaacob on 12/2/2024 in #support-community

adding react native (expo) to existing Next + Convex app (with Convex Auth)

I'm pretty new with Mobile and prefeably wouldnt want to use Turborepo to avoid major refactor (and i have skill issue). how would i achieve this? any advice ?

14 replies

CCConvex Community

•Created by ibrahimyaacob on 11/29/2024 in #support-community

how to get client timezone

my app is sending email action (convex action + react email), I've rendered a date time using date.now() on the email body and when the email is sent to the client, they got the server date time, how do i compensate this ? I'm guessing that I'll need to get the request's time zone, but how ?

5 replies