PAdventures Comments - Answer Overflow

Topics

PAdventures

Explore posts from servers

DIAdiscord.js - Imagine an app DTDrizzle Team

DIAdiscord.js - Imagine an app

•Created by PAdventures on 1/7/2024 in #djs-questions

AutoModerationRuleUpdate -> OldRule is null on rule actions update

Ok thank you for the clarification

3 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Did the latest drizzle-kit update try to fix this issue? if not please ignore me. If so, I've updated my drizzle and nothing changed

15 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 12/27/2023 in #djs-questions

Event Emitter emits custom event twice

oki srry.

4 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

so all of those queries are not necessary

15 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

If you are making a fix for this. i just looked and all of these queries are being run when the table already is in those configuations

15 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Ok, thank you for the advice.

15 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Is there anything I can do to work around this, or is this a bug that must be fixed?

15 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Looks like the newest version may not have fixed the pk droping and creating for planetscale maybe? idk

15 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

^ those are my versions

15 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

[email protected] [email protected]

15 replies

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

also it keeps trying to do this when i dont change things and i can see that these have been done in my planetscale insights

ALTER TABLE `economy_profiles` DROP PRIMARY KEY;
ALTER TABLE `levels` DROP PRIMARY KEY;
ALTER TABLE `logs` DROP PRIMARY KEY;
ALTER TABLE `rolesToUsers` DROP PRIMARY KEY;
ALTER TABLE `tickets` DROP PRIMARY KEY;
ALTER TABLE `users` DROP PRIMARY KEY;
ALTER TABLE `economy_profiles` MODIFY COLUMN `bank_level` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` MODIFY COLUMN `safe_level` tinyint unsigned NOT NULL;
ALTER TABLE `shops` MODIFY COLUMN `items` tinyint unsigned NOT NULL;
ALTER TABLE `shops_config` MODIFY COLUMN `max_allowed` tinyint unsigned NOT NULL DEFAULT 2;
ALTER TABLE `shops_config` MODIFY COLUMN `max_items` tinyint unsigned NOT NULL DEFAULT 10;
ALTER TABLE `tickets` MODIFY COLUMN `rating` tinyint unsigned;
ALTER TABLE `tickets_config` MODIFY COLUMN `max_open` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `levels` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `logs` ADD PRIMARY KEY(`guild_id`,`channel_id`,`log_type`,`log_sub_type`);
ALTER TABLE `rolesToUsers` ADD PRIMARY KEY(`guild_id`,`role_id`,`user_id`);
ALTER TABLE `tickets` ADD PRIMARY KEY(`id`,`guild_id`);
ALTER TABLE `users` ADD PRIMARY KEY(`id`,`guild_id`);

ALTER TABLE `economy_profiles` DROP PRIMARY KEY;
ALTER TABLE `levels` DROP PRIMARY KEY;
ALTER TABLE `logs` DROP PRIMARY KEY;
ALTER TABLE `rolesToUsers` DROP PRIMARY KEY;
ALTER TABLE `tickets` DROP PRIMARY KEY;
ALTER TABLE `users` DROP PRIMARY KEY;
ALTER TABLE `economy_profiles` MODIFY COLUMN `bank_level` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` MODIFY COLUMN `safe_level` tinyint unsigned NOT NULL;
ALTER TABLE `shops` MODIFY COLUMN `items` tinyint unsigned NOT NULL;
ALTER TABLE `shops_config` MODIFY COLUMN `max_allowed` tinyint unsigned NOT NULL DEFAULT 2;
ALTER TABLE `shops_config` MODIFY COLUMN `max_items` tinyint unsigned NOT NULL DEFAULT 10;
ALTER TABLE `tickets` MODIFY COLUMN `rating` tinyint unsigned;
ALTER TABLE `tickets_config` MODIFY COLUMN `max_open` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `levels` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `logs` ADD PRIMARY KEY(`guild_id`,`channel_id`,`log_type`,`log_sub_type`);
ALTER TABLE `rolesToUsers` ADD PRIMARY KEY(`guild_id`,`role_id`,`user_id`);
ALTER TABLE `tickets` ADD PRIMARY KEY(`id`,`guild_id`);
ALTER TABLE `users` ADD PRIMARY KEY(`id`,`guild_id`);

15 replies

•Created by PAdventures on 12/10/2023 in #help

ExecutedQuery data question

i cant see anything about this in the docs

2 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 12/6/2023 in #djs-questions

ActionRowBuilder type error with EditReply

thank you very much 🙂

8 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 12/6/2023 in #djs-questions

ActionRowBuilder type error with EditReply

yeah that worked

8 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 12/6/2023 in #djs-questions

ActionRowBuilder type error with EditReply

ok ill try this

8 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 10/23/2023 in #djs-questions

@discordjs/opus not installing for macOS

sad times...

8 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 10/23/2023 in #djs-questions

@discordjs/opus not installing for macOS

so i can't do anything about this?

8 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 10/23/2023 in #djs-questions

@discordjs/opus not installing for macOS

same for node-gyp

8 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 10/23/2023 in #djs-questions

@discordjs/opus not installing for macOS

updating/downgrading node and npm

8 replies

DIAdiscord.js - Imagine an app

•Created by PAdventures on 10/23/2023 in #djs-questions

@discordjs/opus not installing for macOS

ive tried updating/downgrading node-pre-gyp

8 replies