Answer Overflow - Discord Content Discovery

Topics

Welcome to Answer Overflow!

Answer Overflow is the best way to discover Discord content. Browse trending forum posts, explore popular servers, or view new content. Know of a Discord server that should show up on the site? Learn more about adding a server!

Trending past 30 days New

VVALORANT

•Created by Olivia on 9/13/2024 in #community-help

HVCI Enabled???

i need help, so i kept getting a wierd "HVCI enabled" messgage for some reason every time i would load up the game, then i got VAN 152 every time i loaded up the game. any fixes?

39 replies

VVALORANT

•Created by 0neTown on 11/27/2023 in #crosshairs

No crosshair

0;s;1;P;o;1;m;1;0t;10;0l;0;0o;0;0a;1;0f;0;1b;0;S;d;0;b;1

25 replies

DTDrizzle Team

•Created by Louistiti on 7/18/2023 in #help

Clear the whole database?

For my test environment I'd like to clear the whole db.. is there a way to achieve this using drizzle ?

59 replies

DHDistant Horizons

•Created by SAMJOBUT on 8/20/2024 in #help-me

DH Overloaded

Hello all, I'm getting this message when flying or sometimes just running through the world. Playing on a server (i have admin) but really know close to nothing about all the solutions the message gives. Could anyone please explain in other terms, or step by step how to deal with this, TBH the message is more inconvenient than the actual issue. Message in question: Distant horizons overloaded, too many chunks queued for updating. This may result in holes in your LODs. please move through the world slower, decrease your vanilla render distance, slow down your world pre-generator, or increase the DH CPU load config. Max queue count [500] ([500] per thread) Thanks in advance

25 replies

VVALORANT

•Created by Sayara on 7/14/2024 in #community-help

unable to enable HVCI

43 replies

VVALORANT

•Created by Mevix on 1/26/2024 in #community-help

secure boot verification failure

219 replies

DTDrizzle Team

•Created by kinsyu on 12/1/2023 in #help

There's not enough information to infer relation

I am trying to use drizzle studio but I'm running into the following issue, There is not enough information to infer relation "__public__.collectionsTable.tokens". Here's a simplified version of the schema.

export const tokensTable = mysqlTable(
    'tokens',
    {
        tokenId: varchar('token_id', { length: 255           }).notNull(),

        metadataName: varchar('metadata_name', {               length: 255 }),
        metadataDescription:         text('metadata_description'),
        collectionId: varbinary('collection_id', {
            length: 42,
        }).notNull(),

        createdAt: timestamp('created_at', {
            mode: 'string',
        }).defaultNow(),
        updatedAt: timestamp('updated_at', {
            mode: 'string',
        }).defaultNow(),
    }
)

export type Token = InferSelectModel<typeof tokensTable>
export type TokenInsert = InferInsertModel<typeof tokensTable>

export const tokensRelations = relations(tokensTable, ({ one }) => ({
    collection: one(collectionsTable, {
        fields: [tokensTable.collectionId],
        references: [collectionsTable.id],
    }),
}))

export const collectionsTable = mysqlTable(
    'collections',
    {
        id: varbinary('id', {
            length: 42,
        }).primaryKey(),

        name: varchar('name', {
            length: 255,
        }).notNull(),
        description: text('description'),
        createdAt: timestamp('created_at', {
            mode: 'string',
        }).defaultNow(),
        updatedAt: timestamp('updated_at', {
            mode: 'string',
        }).defaultNow(),
    }
)

export type Collection = InferSelectModel<typeof collectionsTable>
export type CollectionInsert = InferInsertModel<typeof collectionsTable>

export const collectionsRelations = relations(collectionsTable, ({ one, many }) => ({
    tokens: many(tokensTable, {
        relationName: 'collectionTokens',
    }),
}))

export const tokensTable = mysqlTable(
    'tokens',
    {
        tokenId: varchar('token_id', { length: 255           }).notNull(),

        metadataName: varchar('metadata_name', {               length: 255 }),
        metadataDescription:         text('metadata_description'),
        collectionId: varbinary('collection_id', {
            length: 42,
        }).notNull(),

        createdAt: timestamp('created_at', {
            mode: 'string',
        }).defaultNow(),
        updatedAt: timestamp('updated_at', {
            mode: 'string',
        }).defaultNow(),
    }
)

export type Token = InferSelectModel<typeof tokensTable>
export type TokenInsert = InferInsertModel<typeof tokensTable>

export const tokensRelations = relations(tokensTable, ({ one }) => ({
    collection: one(collectionsTable, {
        fields: [tokensTable.collectionId],
        references: [collectionsTable.id],
    }),
}))

export const collectionsTable = mysqlTable(
    'collections',
    {
        id: varbinary('id', {
            length: 42,
        }).primaryKey(),

        name: varchar('name', {
            length: 255,
        }).notNull(),
        description: text('description'),
        createdAt: timestamp('created_at', {
            mode: 'string',
        }).defaultNow(),
        updatedAt: timestamp('updated_at', {
            mode: 'string',
        }).defaultNow(),
    }
)

export type Collection = InferSelectModel<typeof collectionsTable>
export type CollectionInsert = InferInsertModel<typeof collectionsTable>

export const collectionsRelations = relations(collectionsTable, ({ one, many }) => ({
    tokens: many(tokensTable, {
        relationName: 'collectionTokens',
    }),
}))

In short, each collection can have multiple tokens, but each token can belong to only one collection. I haven't had any issues with this schema for around the 6 months that we've been using it, but we wanted to try out drizzle studio and ran into that issue. The database is running on Planetscale, not sure if that's relevant.

3 replies

VVALORANT

•Created by fabob on 2/11/2024 in #crosshairs

Temet crosshair

0;c;1;s;1;P;c;5;o;1;0t;1;0l;5;0v;3;0g;1;0a;1;0f;0;1b;0

3 replies

VVALORANT

•Created by Job on 9/8/2024 in #community-help

hvci enabled

3 replies

DTDrizzle Team

•Created by iqrow on 5/24/2023 in #help

How to delete with cascade?

I'm using postgres with the following schema (reduced to the important parts):

export const worlds = pgTable('worlds', {
  id: uuid('id').defaultRandom().primaryKey()
})
export const users_to_worlds = pgTable(
  'users_to_worlds',
  {
    userId: varchar('user_id', { length: 32 })
      .references(() => users.id)
      .notNull(),
    worldId: uuid('world_id')
      .references(() => worlds.id)
      .notNull(),
  },
  (table) => {
    return {
      pk: primaryKey(table.userId, table.worldId),
    }
  }
)

export const worlds = pgTable('worlds', {
  id: uuid('id').defaultRandom().primaryKey()
})
export const users_to_worlds = pgTable(
  'users_to_worlds',
  {
    userId: varchar('user_id', { length: 32 })
      .references(() => users.id)
      .notNull(),
    worldId: uuid('world_id')
      .references(() => worlds.id)
      .notNull(),
  },
  (table) => {
    return {
      pk: primaryKey(table.userId, table.worldId),
    }
  }
)

And I'm trying to implement an api call to delete a world. Due to the reference to the world in the users_to_worlds I get the error:

Error: update or delete on table "worlds" violates foreign key constraint "users_to_worlds_world_id_worlds_id_fk" on table "users_to_worlds"

I believe what I want to use is a CASCADE delete where everything referencing a world is deleted when I delete a world. Is this possible through Drizzle? I can't seem to find anything on this.

7 replies

PMPUBG MOBILE

•Created by S U N YT on 9/22/2024 in #questions

about the ultimate royal timing

7 replies

DTDrizzle Team

•Created by McLean 25 on 4/5/2023 in #help

Can't find meta/_journal.json file when running migrate

3 replies

VVALORANT

•Created by Techi09 on 1/26/2024 in #community-help

vgk.sys BSOD Error

236 replies

DTDrizzle Team

•Created by fermentfan on 7/30/2023 in #help

Mocking Drizzle instance

Hey there, I am currently trying to find a good way to mock our drizzle instance for our unit test suite, but the nature of the usage of it makes it kinda hard. Is there somebody who is running a code base with a mocked drizzle?

22 replies

VVALORANT

•Created by derek on 12/16/2023 in #community-help

how do you check what you got banned for?

Help

15 replies

DHDistant Horizons

•Created by Amm0 on 3/18/2024 in #help-me

This Pack Doesn't Have DH support

Apologies if this has been answered, but I can't seem to find it after searching for 20 minutes. I downloaded the fork of Complementary Shaders by EminGT (the one that says it has DH compatibility config), but every time I try to apply it in game I get a large red text box that says it won't work with DH. Is there an option somewhere that I can't find where I can turn that on? Any tips would be appreciated, thanks!

16 replies

VVALORANT

•Created by DeeKey on 8/7/2024 in #community-help

begin recertification?????

64 replies

TtRPC

•Created by PotatisMannen on 6/23/2023 in #❓-help

how do you consume trpc endpoints from postman?

I'm currently trying to set up testing for a full stack project while using trpc. but im unsure how i can test if the trpc endpoints are working without having to write FE code. This could be useful during QA etc. has anyone tried this before?

7 replies

VVALORANT

•Created by $ Rayan on 3/14/2024 in #community-help

BstShm

23 replies

TTCTheo's Typesafe Cult

•Created by Romain on 7/9/2023 in #questions

Zod enums vs Native enums

From what I understood from the documentation of Zod, enum should be use as followed :

const FishEnum = z.enum(["Salmon", "Tuna", "Trout"]);
type FishEnum = z.infer<typeof FishEnum>;

// to use it
const someFish = FishEnum.parse("Salmon");
// to validate 
const VALUES = ["Salmon", "Tuna", "Trout"] as const;
const FishEnum = z.enum(VALUES);

const FishEnum = z.enum(["Salmon", "Tuna", "Trout"]);
type FishEnum = z.infer<typeof FishEnum>;

// to use it
const someFish = FishEnum.parse("Salmon");
// to validate 
const VALUES = ["Salmon", "Tuna", "Trout"] as const;
const FishEnum = z.enum(VALUES);

But it is also possible to use native enums :

export enum Countries {
  Maroc = "Maroc",
  Tunisie = "Tunisie",
  Egypte = "Egypte",
}

// to use it
const someCountry = Countries.Maroc;
// to validate 
const country = z.nativeEnum(Countries);

export enum Countries {
  Maroc = "Maroc",
  Tunisie = "Tunisie",
  Egypte = "Egypte",
}

// to use it
const someCountry = Countries.Maroc;
// to validate 
const country = z.nativeEnum(Countries);

Using native enums seems more easy so, why would I use zod enums ? Have I missed something ?

6 replies

DTDrizzle Team

•Created by SteveS on 8/15/2023 in #help

How to debug Drizzle queries

I'm executing an insert on a table, I'm gettin no errors, and yet the data is not being saved to the database. Just curious how I am supposed to debug stuff like this since I have no idea why it isn't working.

45 replies

TtRPC

•Created by Avraj on 1/23/2024 in #❓-help

Is there a way to refetch a query with new parameters?

Hi I'm using tRPC in a Next.js app and I have a button that a user can click to get the latest data from the server. By default this data is cached in the server because the query is expensive. I've added an optional param/input in my query that looks like this:

guilds: privateProcedure
    .input(
        z
            .object({
                skipCache: z.boolean().optional(),
            })
            .optional()
    )
    .query(async ({ input, ctx }) => {
        // Get data
    });

guilds: privateProcedure
    .input(
        z
            .object({
                skipCache: z.boolean().optional(),
            })
            .optional()
    )
    .query(async ({ input, ctx }) => {
        // Get data
    });

So when { skipCache: true } is set, the user can bypass the cache and get the latest data. I'm feeling a bit lost however when it comes to the implementation itself. I can't find anything in the docs regarding refetching with new/updated params.

const trpcUtils = trpc.useUtils(); // This will return cached data from the server.

const { data: guilds, error } = trpc.private.guilds.useQuery();

const handleRefresh = () => {
    // The implementation to bypass cached data => { skipCache: true }
}

return <button onClick={handleRefresh}>Refresh</button>

const trpcUtils = trpc.useUtils(); // This will return cached data from the server.

const { data: guilds, error } = trpc.private.guilds.useQuery();

const handleRefresh = () => {
    // The implementation to bypass cached data => { skipCache: true }
}

return <button onClick={handleRefresh}>Refresh</button>