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 ♡ Diamond on 7/16/2023 in #community-help

couldnt start error when trying to open val

80 replies

VVALORANT

•Created by HypnoNubXD on 2/8/2024 in #community-help

what kind of error is this

274 replies

VVALORANT

•Created by jmg!? on 11/17/2022 in #community-help

Unable to play VALORANT

6 replies

VVALORANT

•Created by ALPHA on 1/12/2024 in #community-help

Couldn't Start Error

10 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

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

DTDrizzle Team

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

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

3 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 Elite <$🔥 on 3/1/2024 in #community-help

I NEED HELP GAME NOT STARTING

It shows something like this Couldn't start:

180 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

VVALORANT

•Created by vtx on 3/3/2024 in #community-help

Error

156 replies

VVALORANT

•Created by nick on 2/17/2024 in #community-help

Unblocking people

How do i unblock someone? my friends brother blocked me and we cant find out how to unblock

20 replies

PMPUBG MOBILE

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

about the ultimate royal timing

7 replies

VVALORANT

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

secure boot verification failure

219 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

VVALORANT

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

unable to enable HVCI

43 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

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

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 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

CSNCreate: Steam 'n' Rails

•Created by Chris | TehRevenge on 4/17/2024 in #support

Recipe Help