Mozzy Posts - Answer Overflow

Mozzy

Explore posts from servers

DIAdiscord.js - Imagine an app CDCloudflare Developers RRailway DTDrizzle Team

•Created by Mozzy on 10/8/2024 in #help

Changing the Postgres serial/autoincrement behavior

In short, I don't want the serial to fill the empty gaps. I want it to always default to max(id) + 1 unless I specify the id myself. How can I achieve this with minimum jank? I've heard of generated columns, but couldn't get it all working together. I believe MySQL works like this, so I might have to switch to that.

2 replies

DTDrizzle Team

•Created by Mozzy on 10/3/2024 in #help

`Error: no such column: unboxes.rarity` with `findMany()`

Hello. I am getting the error Error: no such column: unboxes.rarity despite not using unboxes.rarity The error comes fron the where in the query below. Is this a bug? Code:

export const getFilteredUnboxes = async (onlyCoverts?: boolean) =>
  db.query.unboxes.findMany({
    with: {
      item: true,
      case: true,
    },
    where: onlyCoverts
      ? inArray(items.rarity, ["Covert", "Extraordinary"])
      : undefined,
  });

export const getFilteredUnboxes = async (onlyCoverts?: boolean) =>
  db.query.unboxes.findMany({
    with: {
      item: true,
      case: true,
    },
    where: onlyCoverts
      ? inArray(items.rarity, ["Covert", "Extraordinary"])
      : undefined,
  });

My items schema:

export const items = sqliteTable(
  "items",
  {
    id: text("id").primaryKey().notNull(),
    name: text("name").notNull(),
    description: text("description"),
    image: text("image").notNull(),
    rarity: text("rarity").notNull(),
    phase: text("phase"),
  },
  table => {
    return {
      idxRarity: index("idx_rarity").on(table.rarity),
    };
  },
);

export const items = sqliteTable(
  "items",
  {
    id: text("id").primaryKey().notNull(),
    name: text("name").notNull(),
    description: text("description"),
    image: text("image").notNull(),
    rarity: text("rarity").notNull(),
    phase: text("phase"),
  },
  table => {
    return {
      idxRarity: index("idx_rarity").on(table.rarity),
    };
  },
);

32 replies

RRailway

•Created by Mozzy on 8/12/2024 in #✋｜help

tls: failed to verify certificate: x509: certificate signed by unknown authority

I am learning Go by building a Discord bot and an API service. I am getting the following error when deploying commands to Discord from the built container:

tls: failed to verify certificate: x509: certificate signed by unknown authority

tls: failed to verify certificate: x509: certificate signed by unknown authority

I know very little about networking. Any pointers? Repo: https://github.com/leonlarsson/bfstats-bot-go

8 replies

RRailway

•Created by Mozzy on 8/3/2024 in #✋｜help

Skill issue with `railway run`

Having a skill issue. I want to run a .js script remotely on Railway. railway run npm run script works, but this is a node command that uses --env-file, and the .env file is not present after building the app. Can I just run any remote file directly?

23 replies

DIAdiscord.js - Imagine an app

•Created by Mozzy on 2/10/2024 in #djs-questions

Issues with discord.js errors in Bun

23 replies

RRailway

•Created by Mozzy on 7/20/2023 in #✋｜help

Having an issue with the first deploy from a commit

Hello. I am trying to run a discord.js app on Railway. It works great, most times. However, when a deploy gets triggered on the production branch and the app deploys, some code stops working as expected. In my app, I have the following code:

import { some_http_header_value } from "../config.js";
fetch(url, { headers: { "some-header": some_http_header_value } });

import { some_http_header_value } from "../config.js";
fetch(url, { headers: { "some-header": some_http_header_value } });

some_http_header_value is either empty or not there at all, causing the fetch to fail. However, if I just redeploy the build on Railway, it works as expected. Might there be some weird caching issue? config.js exists and works in other areas of the app. Still investigating on my side, but any obvious ideas as to what's happening?

35 replies

CDCloudflare Developers

•Created by Mozzy on 4/25/2023 in #workers-help

What is the difference between `CF-Connecting-IP` and `X-Real-IP` and can they ever be empty?

Using it for a simple rate-limiting purpose and was wondering :)

8 replies

DIAdiscord.js - Imagine an app

•Created by Mozzy on 7/29/2022 in #djs-questions

(known issue on v14.1.0) messageLink is not a function

Trying the "new" Message.url leads to getting this error.

TypeError: messageLink is not a function
    at Message.get url [as url] (...\node_modules\discord.js\src\structures\Message.js:443:29)

TypeError: messageLink is not a function
    at Message.get url [as url] (...\node_modules\discord.js\src\structures\Message.js:443:29)

It's thrown from https://github.com/discordjs/discord.js/blob/main/packages/discord.js/src/structures/Message.js#L443. Does this just mean that @discordjs/builders hasn't been updated yet? discord.js v14.1.0 Node v16.13.1

9 replies

DIAdiscord.js - Imagine an app

•Created by Mozzy on 7/18/2022 in #djs-questions

Change in ActionRow stuff

Feeling a bit stupid, what change in v14 is related to this being needed? row is an ActionRowBuilder, not a received row.

- const content = { components: [row.setComponents(row.components.filter(x => !x.customId))] };
+ const content = { components: [row.setComponents(row.components.filter(x => !x.data.custom_id))] };

- const content = { components: [row.setComponents(row.components.filter(x => !x.customId))] };
+ const content = { components: [row.setComponents(row.components.filter(x => !x.data.custom_id))] };

42 replies

Gaming

Programming