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 Mevix on 1/26/2024 in #community-help
secure boot verification failure
No description
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
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
No description
43 replies
Mmfad
Created by donowits on 10/5/2024 in #questions-and-advice
Identify jacket
No description
3 replies
VVALORANT
Created by Job on 9/8/2024 in #community-help
hvci enabled
No description
3 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 luca12345nl on 10/17/2024 in #community-help
vgk.sys Blue screen FIX
I made a support ticket about this and got a fix for this problem (for me it works)
79 replies
TtRPC
Created by Alex_A on 6/18/2024 in #❓-help
File upload with formdata
I'm trying to upload a pdf file to R2 and save metadata to my postgres database (both through a trpc procedure). I followed the example in https://github.com/trpc/trpc/tree/next/examples/next-formdata but I get the error copied below. I have been stuck on this for hours and don't know what I'm doing wrong. Envrionment: Next.js 14.2.4 / pnpm Any help would be greatly appreciated!
❌ tRPC failed on presentation.create: [
{
"code": "invalid_type",
"expected": "string",
"received": "undefined",
"path": [
"userId"
],
"message": "Required"
},
{
"code": "custom",
"message": "Input not instance of File",
"fatal": true,
"path": [
"file"
]
}
]
❌ tRPC failed on presentation.create: [
{
"code": "invalid_type",
"expected": "string",
"received": "undefined",
"path": [
"userId"
],
"message": "Required"
},
{
"code": "custom",
"message": "Input not instance of File",
"fatal": true,
"path": [
"file"
]
}
]
My Form code https://github.com/ysqander/trpc_file_upload/blob/main/src/components/FileUploadForm.tsx My procedure: Presentation.create https://github.com/ysqander/trpc_file_upload/blob/main/src/server/api/routers/presentation.ts
5 replies
CWCombat Warriors
Created by adibzz on 9/17/2024 in #🛟・community-support
umm.. I just enter into combat warrior and then I got ban for a reason black-cat-red-eye/40
No description
59 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 rayans on 3/14/2024 in #community-help
BstShm
No description
23 replies
PMPUBG MOBILE
Created by S U N YT on 9/22/2024 in #questions
about the ultimate royal timing
No description
7 replies
VVALORANT
Created by derek on 12/16/2023 in #community-help
how do you check what you got banned for?
Help
15 replies
VVALORANT
Created by Kurdo on 6/29/2024 in #community-help
Riot Vanguard wont install on my pc
Idk why but vanguard wont install on my pc. i tried reinstalling val and riot but it wont help
7 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>
Is this something that's possible?
29 replies
CDCloudflare Developers
Created by DreamingInsanity on 9/16/2024 in #general-help
Turnstile error 400020
I have a 2 turnstiles on my website. One is an interactive one for logging in and it works fine. One is an invisible turnstile that emits its token globally and it used for a few different form inputs where an interactive turnstile would not be applicable. Originally, I should've set the turnstile up with the testing keys, but I didn't. Because of that eventually this turnstile considered me a bot and threw an error. I then decided to delete the turnstile completely, create a new one but this time make it managed so if an error were to occur I could display it to the user and make them interact with the widget, however now the widget itself doesn't even show up and it's giving me an error code of 400020 which I can't find any info on online. I'm writing this website in svelte, so I'm using svelte-turnstile but I don't think that should make a difference. Does anyone know what this error code means? And my other question is, is this the best way to protect inputs? I have a feeling I shouldn't use 1 global turnstile to protect more than 1 input however I didn't want to have to manage many different turnstiles and a lot of these inputs don't have anywhere for the turnstile to be so they have to be invisible. Will having 1 turnstile that thousands of people have to solve many times cause it to think all those people are bots?
4 replies
VVALORANT
Created by DeeKey on 8/7/2024 in #community-help
begin recertification?????
No description
64 replies