#development
1 messages · Page 6 of 1
aight thanks, this did it
hum
i will stay with the outdated one
and switch to the native fetch when released on lts
All that does it make it so it doesn't transpile to require and wraps it in a function call that will get ran and import your module
You would have to switch your module resolution and compile module target to nodenext to use ESM in TS
Hummm
const usr = { name: "burbur", status: "qt" }
if (usr.status === "qt") {
console.log("omg qt");
} else {
console.log("stinky");
}
fixed 👍
const burbur = "me"
if (burbur == "qt") {
console.log("stinky");
} else {
console.log("omg qt");
}
how dare you not add a semicolon at the end of line 1
😱
Cause they aren't required
First thing I do in my linting rules: turn off semicolons

okay ty 👀
Inbv he makes a anonymous async func and wonders why his code is broken

(Not inserting semicolons in your JavaScript code is actually a bad idea, because they're optionally excluded, meaning the interpreter inserts them automatically)
And can cause unexpected behaviors
Voltrex just cause you said that I'll never use em again
Got to save that bundle size (ikik, its a joke)
If you don't use semicolons in your code again then you went from Misty to a Mistyerious person for me
That's fine
I'll make a prettier github action that removes semi colons
So no matter how hard you try
They will be removed
do you guys know how to change the attachment image size ( not the resolution nor a crop of the image but how large its displayed ) so that it doesn't take up too much embed space?
What Misty said, though if you're using a host that allows you to set the size (such as Discord's under cdn.discord.com/...?size=...), you could do that.
Keep in mind that (iirc) the size might not upscale all the way to what you give it for discord, it depends on the resolution/quality of the original uploaded image
just build waifu2x on ur vps and get infinite image size
E, it's still a good practice, like switching from js to java
you are used to semicolons
Semicolons just stop confusion
Tbf, the majority of my projects does use semicolons
Not to mention it’s also a lot of work saved for the person writing the parser 😭
I used sharp library. while I can resize the image by width and height, the resolution of the image will be really poor
is this supposed to be like this? or am I able to resize the image while keeping the resolution
not really
the computer has to "guess" pixels when u resize raster images
so you either get loss of detail or jaggedness
That's mostly how it works, you lose the original resolution since the width and height are the ones that determine the resolution of the image, so you'll at any point lose some detail or "sharpness" of the image
can I make it lossless or dunno
not with raster images
the closest you'll get to lossless resizing is using waifu2x
but u need to build it yourself and it requires an nvidia gpu
well idk if thats good practice for low resolution images lol
already have smthing like that
it isn't, but nothing I ever saw came even close to it
btw, is that command nsfw-only?
no
-booru sites are known to return nsfw sometimes
yeah
even with safe filter
I filter them
thats rare
hi
not as much as u might think
also, depends what u consider nsfw
Not really, you can however use down-stepping to achieve better results, which you can use Canvas to do so
yes as much as I think because I compare the tags/results from various boorus with each other
and you think that's enough?
x to doubt that you made a 100% accurate filter for anything nsfw
what if it's missing an important tag?
and third layer I can manually verify them if one of the tags dont match
you trying to torture yourself or something?
I don’t care about it
find me one example and compare 6 boorus with the tags then apply nsfw filter on it then talk
I’m saying that no filter is 100% accurate
You can never really get rid of NSFW content 100%, there are ways to bypass a ton of this stuff
ok we get it, why even bring it up ?
So you should probably lock it to nsfw channels
yeah no shit
but whats the point of this discussion now
sure, gimme the tool and I'll get u a nsfw result
why bring it up
everyone knows u can bypass decals on roblox using bypass methods on paint with patterns etc
because it'll cause u legal issues later on
no
It likely won’t cause legal issues but it might cause your bot to be taken down by discord
ur talking too much
no
there are various booru bots VERIFIED by discord, it'd hit them first and yet I havent seen any bot be hit for that reason
lmao
in fact
one of the booru bots that are verified promote content that violate tos
oh smh, why people never accept advices
This type of thing is not something you cannot risk when you are managing an application on a service that contains many underage users
I mean consider the advice?
would it make sense if discord doesnt really care at all
and even if my bot gets taken down ( which is unlikely ), I can just learn from it and apply more filters. but then again, I haven't seen any incident in years unless it involved stuff like loli
I wouldn’t ever be taking the slightest risk of accidentally shoveling out nsfw content to minors, just saying
Regardless of your intentions, it’s a bad idea
I dont know about you but I dont let minors into nsfw channels let alone into NSFW related servers that might even require age verification
discord is getting stricter every year, "not caring" might just be luck for those cases
lying on age exists but it's their issue
We’re saying to lock the command to nsfw channels :p
then go report them
make yourself clear
lmao
they still wont care
why would I?
I think you’re being purposefully ignorant here
to prove ur point ( I refuse to believe )
I don't need to prove any point
no
actually, I didn't even make a point
The point is that you might give out nsfw content to minors. That is not something you want to fuck with. At all.
so stop talking about me facing legal issues or letting minors face nsfw
when this isnt the case at all
I'm just saying having a potentially nsfw command not locked to nsfw channels might cause you legal issues
dude
stop bringing up ridiculous examples like this
as it has (and I saw) happened before
if u wanna brag about how nsfw discord is considered in various places
then dont make me start why u or various other people should be banned from top.gg right now considering that minors see NOT SAFE FOR WORK content let alone comments or indicators to adult content
There’s a thing called plausible deniability but when you acknowledge the risks and then refuse to facilitate them, then that becomes a problem
What?
We’re saying that you should not take a risk because you have the power to control it
I don't acknowledge jackshit because "risks" is not proven until I see somebody face consequences
Lmfao
the fact that the discord support refuses to cooperate with u says much about them
check out BooruBot, verified and in various servers. violates the tos
there's no hope in this case, some people only learn that fire burns when they get a third degree
??? I’m confused by this entire sentence
so let it be, don't say we havent warned u
We are trying to prevent potential future conflict for you, but if you’re going to be a dick about it and refuse to believe what we’re saying, then by all means go ahead
I am taking "the risk" because I am confident unlike you guys who dont have the smallest clue about how boorus or discord moderation works
ok I did not ask though
this was unnecessary
so you have all the clues on how boorus and moderation works?
Have you ever heard "Two wrongs don't make a right" before? Because that's the exact flawed logic you're using right now
bruh discord openly says "cub art" is ok even though its just child porn drawn as anthropomorphic animals
do you seriously want me to go over it
yes please
wanna start an argument right here
also wtf did i just walk in on
you said we dont have a clue about those two things
then show me what clue you have
yeah because you bring up worst case scenario stuff while ignoring my argument
I didn't bring the worst case, I brought THE case
don't ignore the worst case scenario
there's no better or worst case for exposing to nsfw
Okay. Fun fact. You can lose your discord account just by clicking an invite link, and you won't have a clue of it.
what about it?
I feel that this argument is gonna devolve into something way more obscure and weird 
and btw, discord does actively ban scam link people
we used to see a shitton of botALERTAs here
Another fun fact. Discord doesn't intend to read through your reports, this is common considering how many times I've tried to report the same verified bot over its ToS violation yet got automated responses. It is ridiculous, don't even question this
^^^^^
fr
they don't have the support staff
I dont think anyone expects an actual person to read every report
yup
its impossible at the scale of discord
no but it would be nice to think that they did
meh
that's true, they're more likely to see the average rate of reports instead of the actual comments
i mean bots will never be good enough to analise context
getting not ignored would be nice though
nobody literally cares about phishing links lmao that shit is hilarious
idiots fall for it
when they see a report with a huge amount of incidences THEN they go reading the reasons
well discord cares
no. u dont know their system
its hilarious that ppl actually fall 4 that shit
one could mass send reports using different proxies and mails, etc
how can u say I dont?
🍿
I'm sure I believe the person that believes potentially showing nsfw to minors is not a "risk" :^)
discord's fault for not bringing up this faulty shit to surface before people click random urls in first place
you see, there's an entire topic at university on how data sampling works
what discord gon do about ppl sending links?
it should have been a common knowledge
because you are not an employee
Without me?
neither you
potentially
Yo do you guys like js or python more?
Js for me
neither did I claim this smartass sherlock nor is that my argument
lets get involved!
ITS A FUCKİNG RISK
so you do think that I need to work at a bakery to know how to make a cake?
shut up turk
you want to lock it to nsfw channels
there is a think called 🌈 standards 🌈
I really do think so especially if you dont know which ingredients they use. nice try doe
so do you
You can't risk it? That's kind of the point here. Any potential risk with this is not one worth taking
bruh this is devolving rapidly
If you view all things on this world as a risk, then you shouldn't be around the internet in first place.
Let alone talk in here
You might be a groomer
discord follow almost the same standards as every other big enterprise
Mods might be a groomer
Lmfao
lets be honest, every kid has seen some kind of nsfw voluntarily
This guy
Don't take the risk!!!!
they collect data and process it for later review
Just because it happens does not mean that you should not try to prevent it
#development just became #drama
sadly
or involuntary
voluntarily most of the time 💀
💀💀💀💀
They make worst case scenarios over a potentially false tag that might disclose them to potential anime nipples
pov: you're 8 and looking up "sex" on google, no incognito window, while parents downstairs
just lock it to nsfw channels to be safe
LOOL
What is the discussion even about?
already doing this
aight
🤷♂️
Can’t be android or I would be involved
You know there's very hefty legal penalties (Not sure where you live, but I'm sure there is wherever you're located) for showing anything like that to minors? That's why discord wants you to lock anything that could potentially be nsfw to nsfw-only channels
Big tiddy women
turkey perhaps
when u tryna go on pornhub but it doesnt show up, and then realize ur parents enabled "safe search" and removed clearing history perms
or considder this: dont be a degenerate and have nsfw commands in your bot at all
Okay, and you know what intentions are?
Have you read the terms and conditions yet?
Good that you brought this up. Shows how vulnerable discord is after all when it comes to MESSENGERS
ez
💀
My god you're ignorant.
Gotta love how this went from resizing an image to this 
anime nipples lmao, boy/girl you really don't know how fckin huge are minor exposure reports on the internet
and it was at this moment, he knew, he fucked up
there's a whole global law regarding that
issoke volty no cri
someone has the name? I forgor
bruh is that how this started? damn
quite the tangent
i don't think it is legal to adults here
This guy is saying that people are "groomers" while actively promoting the idea that it's ok to risk showing nsfw to minors
Nice
ah, found it: Children's Internet Protection Act
or CIPA
other contries have it under a different name
CIA tho :lipbite:
dont let children on the internet
wth happened
no idea
lots of stuff
help
this is still dev channel
thank god im no longer a minor as im 16
suposed to be
Okay. Name me the exposure reports that were reported through potential false tags on boorus ( e.g. through my bots that use several layers of filters )
On top of that, name me a minor that would INTENTIONALLY click a NSFW channel and then claim to see NSFW by accident just to get me into legal troubles that easy.
bruh
I think its time to change topics ^_^
You know that we're telling you to make the command accessible in an nsfw-only channel... right?
TL;DR: a dev that shrugs to -booru api potentially returning a nsfw image in a normal chat
You know that I have already done this sherlock, right? In fact, I mentioned it previously already. Maybe open your eyes, dunno....
#memes-and-media please
related to Convo
i meant to send the popcorn eating one
🧢

fr ong no cap?
man people intentionally turned this into unecessary drama by going into how I handle NSFW through my bot
just dont add nsfw to your bot?
based
they kinda didn't
but are using -booru api (which is infamous to return nsfw even with safe filter)
idk maybe just dont use social media anymore?
?
just dont use the internet
why use discord bot to watch porn
Reddit is better than ph change my mind
when u got the real stuff 😎
was answering loom
readit is a dumpster fire
I'm going to start muting 
dude you dont have a single clue about what you're talking of....
Maybe we should just get back to what they were asking help for, this argument isn't gonna go anywhere
dont u dare
big funny
fr
ur using a booru api, gelbooru
moot me for 1 minute pls
best solution
but well anyway
not related to my comment
remove nsfw from bot
yes
i wanna see what it's like
you should inform yourself about the various laws, legal issues and filters possible nowadays especially as someone who doesn't manage an entire database
:)
-m @earnest phoenix
Hulkzz_YT#2935 was successfully muted
okay I drop this argument now
was that perm?
Finally
poor dude
no
I do, both on my bot and work (as probably 75% of the people in this server with bot dev role). just wanted to make this clear.
Make clear about what? perhaps make yourself more clear
that I do manage entire databases?
he wants it so badly after I already dropped it, hilarious
@solemn latch
you lasted exactly two minutes
me?
that was fast, which is what she said
guys let's restart the dev talk. no more drama
k
anyway, my original reason coming here was to ask:
is there a way to relog a discord bot without killing the entire script and restarting it?
yes
relog a discord bot huh
what lang?
he means reloading
i wanna disconnect from discord and then reconnect
js
u can host the bot somewhere ig
why tho
lets say if he makes changes to a command
instead of having to restart the bot
he can reload the commands
only
They don't mean reloading
u don't need to disconnect from discord to reload commands
do you use more number 1 or number 2?
import { thing1, thing2, thing3 } from "module"
console.log(thing1);
import AllThings from "module"
console.log(AllThings.thing1);
ah, relogin
depends, both are valid but are different kinda meaning they cant be used the same
oh
What library are you using?
Not the entire app as it’s pain in the ass and you can’t really pass the connection handles to a child process but anything you load into your index can be reloaded in theory
i got commands to reload but my net is shit and vc brakes after a while so i wana relog the bot withough having to end the entile program
d.js
aka what i said above?
You can just call the <Client>.destroy() method and then call <Client>.login()
I don’t think that requires a full relog
oooo nice
But at the same time, since if you destroy the client, it won't be able to respond back
wtf <Client>.destroy() is a thing???
Yes
never heard of that
there's always a close method on clients
Just close all voice connections, unsubscribe the events and reinitiate the bot
but that aint gonna reload the commands (as hes asking 4)
They're not mainly asking for that in theory
what do you mean, just like i cant do a "finnished relog" message
no i mean relog as in re-login
@wooden ember, making the bot re-login wont update anything
i don't need it to
They mean that their internet connection is pretty slow, so relogging into the gateway would help keep the connection stable
yeah
A long-running connection without any reconnects on a slow internet connection can make it unstable
cuz once vc gtst disconnected it wont come back and at the moment i have to restart the entire bot
to fix it
would be nice to just go /reconnect and the bot the relogs
You’re sure that’s an issue with the gateway?
I meant like if you're doing it through an eval command for example, once you destroy the client in one command usage, and then try to call next on the next eval command usage the bot won't be able to respond back since it's destroyed
ah cool
you can perhaps make it respond through webhooks
But doing it through a command dedicated to it can help you restart the connection without you forgetting about that
shouldnt be an issue
since they dont require a client at all
or u can set a variable to make the bot respond on that channels as soon as it connects
i dont need it its an admin only commands on a small bot
like, pseudocode```
let reconChannel = null;
...
on("ready", => {
if (reconChannel) {
reconChannel.send("Reconnected successfully!");
reconChannel = null;
}
...
})
...
/restart -> reconChannel = message.channel;
thats what i was thinking
will just make it send a message before it kills the connection and will probably be enough
ooooo
that looks interesting
what if something goes wrong
nope, else u don't know if it failed
true
eh not using a db just for that
if so, onready, say it works
Or you can set the channel ID of the command that restarted occurred in to an environment variable in the process, and pick it up on ready
yeah
Remember to null it after sending
yeah
Ah
Instead of over complicating things just run the command which executes a script to kill the app process and restart your app
Instead of just a relog
Yes
love, voltrex.

thought of that but wanted something cleaner
That is probably the cleanest method
FakE with their FakE news strikes once again!
Initiating a simple node script killing your process and retorting it
tf
retorting
Thanks auto correct
Aye
i mean i could just use child_prosses and start another bot instance and kill the existing one
dont want to use external means
Yeah that’s pretty much what I said
indeed
If you don’t initiate a database or reading stuff taking a while to start up you can go with that
Sure if it’s just the connection then just do a relog
yeah thats basically it
i dont have any other issues atm
got my commands to reload
and my event too
now for the entire bot
lol
bruh whilst testing my bots ive booted it up and shut it off easily over 100 times in on day

and i only need this to fix vc stuff
connection limit is 1000 per 24h
I remember a lot of people who got banned for 24h already
They all must write/edit one character in their code than quickly pressing run to test it

TypeScript is pure genius!
data is an array,
What is the type of i in for(const i in data) {}; according to TS?
A; : a number (going from 0 to data.length - 1 according to what I know)
B; : a string
C; : any
D; : unknown
send your answer below!
Not hard to happen
Fckin cloudflare with no warning shot
don't be shy and pick an answer!
Use of
in is for keys/values
So option A?
exactly what I need
according to TS, it's B !
A string?
I mean, in js arrays are just objects with number keys
Maybe those numbers are stored as string instead of actual number
but how can I check if i == 0 then
of
of will give me values of the array
Can't u just use an indexed loop?
U can also use Object.entries() no?
yeah I thought you were trying to get the value
why would you use a for of there
just use indexed
I need the index and the value
then use a normal for loop
^ does this exist in js?
The reason i is a string in this case is because the in keyword casts the keys to strings, you can call the keys() method on the array to get the indexes as numbers
And use the of keyword to iterate through the indexes
Or you can use a traditional for loop
Am I able to store some sort of string/'key' inside an message embed object that isn't seen in the embed?
would be cool, but infortunately no
You mean it isn't visible when logging the object or something?
nono
visible in the embed visual
You can put it inside the footer icon
the footer is visible to players
Icon
wait, does it work?
Yeah I can try that
oh my
😏
Doesn't error, just sends nothing as the icon
same
discord have to add variables to messages
Then again, http://key.value also works if it requires a "valid" url now
at least to command replies
Just remove the http and split by .
If u want to go even hackier, use querystring to hold a json encoded in base64
lmao
How do I make an animated background on my bot page? Use a long description
We're not going to spoonfeed you. Mac gave you a pretty good hint by saying you can use CSS and they gave you resources to start. Look into that
It does support css animation
He said I should go here to help me I think it's okay
Yes but did you look into the resources they gave you?
Maybe you could start with that
There is no information on this topic on the Internet?
Nice
Very big doubt
There is.
Animations on a web page is not a new concept
Several books
Fill a library
There is a long way to find this
Does a long description have a word limit?
Don't think so
No.
Imagine it was discords char limit 
/🚭🌪️
@solemn latch my guy is in every channel lmao
Where do i get the auth token to connect my server to topgg and check its votes?
what?
The whole docs is orientated around having a bot deployed onto top.gg not a server
ah wait, u mean the rest api?
I though u meant the webhooks
it's in its edit page, last item in sidebar
how can i make a translation in and out when the visible property is off in React?
had to go do other stuff but came back and got the reconnect command to work
works perfectly so as usual thanks for the help guys
did try to make it so that if it was in a vc it would reconnect after but somehow that aborts the disconnect and means theres now two instances of the bot running
idk how i did that but its fine the way it is
also odly the reconnect doent trigger the ready event
that effectively doesn't do anything
the library is already automatically reconnecting behind the curtains
because discord tells you to force a reconnect with a RECONNECT opcode through the gateway
to put it in lays terms
you're closing an open door and then opening it again just to walk through the door
If I want to use multiple things from it I'll use 1 as option 2 is not really correct imo if you're using barrel files that is. That would defeat the purpose (late response but I saw this and decided to respond). Option 2 is still feasible but I usually don't do so unless there is a default export that I can use
What do you mean by this?
Also fun fact loom, you can mix the two in the same import
:p
import Discord, { Client } from 'discord.js' is perfectly valid which a lot of people probably already know but for those who don't it's possible
Seems a bit redundant to import the main class and a sub class
Since you usually only use the client once to initiate it
But there's a lot of other things you'll want from express when using it so
It was an example
Not specific to discordjs
Yeah just replied to this case 
I was highlighting it is possible to do it in one line rather than importing from that same package twice
Which is useless
Does Topgg accept mod-logs?
Wdym
What do you mean accept tho?
Like from your bot?
forget it
Mk
mk
mk?
Hi loom
hi misty!!
🤔 
Did you install it
yes
reboot
Is it in your package.json
yes
yeah
Try deleting your node modules and running npm i again
supported v16?
It could be it wasn't added to node modules
🤔
@zinc dawn did the package name shows up in your intellisense btw
I'm still thinking it's not properly being added to node modules
delete package-lock.json
ok i try
huh
you still use discordjs version 12
that shit is already deprecated
upgrade to discordjs ver 14
also it will introduce some breaking changes
Ok am Lost too tired 5:13 equal is already 6 o'clock in the morning .-.
refer to migration notes v12->13 and v13->14 for more info
go sleep then
come back when your mind's clear
but I thought interactions were harder :^)
Let's not go down that path again
yeah
here's my config
- monokai dimmed theme
Hmm looks a bit better but somehow too bright for me
I'm not even going to ask
you have a theme for your notepad
💀
Notepad++ dingus
Yes it has themes!!1!
that’s all of its features but still

I’m only using npp
For … idk more than 10y now
Probably even way longer
Tried some other editors like Atom and other stuff when it popped up but I don’t like anything of that
I like the very simple and minimalistic UI and the fact it let me code like I want
How do you not die without intellisense
Tbh I had to google what it means
I never had it before so I can’t miss it
I mean there’s some sort of autocomplete for vars and functions I used in the same file but that’s it
Like I said before I literally type any char of my code myself
Which probably means all takes longer than it would need to but.. who cares
intellisense reads ur code and helps u debug errors and auto complete some parts for you even
depending on what kind of u install tho
Yeah like I said some sort of autocomplete is available but only per file not in an entire project
Never heard of intellisense auto completing more than just what you're typing
using both 💀
Visual Studio and Visual Studio Code… love em. And the plug-ins you can get for VS Code… Devine.
i mainly use dedicated IDEs if favorable and VSC for other languages
Oh for Java and python ye… but I can use Vs and vsc for those if needed
uhhh
i use IntelliJ for kotlin
VS for C# .NET
Clion for C/C++
WS for web
then VSC as backup web + other languages
VS and VSC are very versatile as you can get almost all the languages you need as workloads for VS and then VSC obviously is just a lightweight code editor with extensions that can work with every language 😂
same thing for Jetbrains IDEs
despite the plugins i feel dedicated IDEs are better in terms of performance and functionality
since they are dedicated to that specific type of workflow
100%
But being able to just clone all repos to one folder and opening that folder as a workspace in vsc and being able to work on multiple apps at once… golden.
eg template intellisense and refactoring
that is also possible with ides
as well
Different languages.
same thing
in that case IntelliJ IDEA fits
i'm stuck with 1011 bs syntax error in VS on my typescript project 💀
Idk bout this, I just use my trust my ai coding assistant with the extension that adds debugging knowledge for the language I’m using to the workspace so it highlights syntax, errors and debugs. 😂
oh you don't know angular
alright that's fine
I just use my little ai helper and debugging tools
Ohhh… yeah no. I have used angular.js 😂
that's angular version 1
i'm using version 14
💀
but in other words vsc angular plugins sometimes loses intellisense in html templates
and that was kinda annoying to write
Yeah I bet…
webstorm?
omfg
why does discord make images in embeds larger on discord if they exceed 100 x 100 in height and width

I literally can't adjust the size of an image without suffering from resolution loss, has discord nothing implemented for scaling images by size?
that's dumb as fuck
yes
@lyric mountain i'm tempted to convert this into Promise<NullableJSONObject>
kekw
Why
because yes
why are the embeds this long on windows 10 client
same with my web
on mobile the embeds are lots shorter
I think it's because of the thumbnail as without the thumbnail the embed would be much shorter
but between embed and text there is so much unnecessary space
embed width is a current discord bug i guess
oh it's confirmed?
I remember this wasn't a bug until the snowflake ID issue few days ago
idk if its actually confirmed
MongoParseError: Value for compressors must be at least one of: snappy, zlib any know fix?
i have normal 127.0.0.1 connection string in my root sevrer
it explains
You know what… I love making GDPR compliance code… like a bot command that lets a user get their data in an embed to their DM… and a link to delete all their data from the system if they want to do so… like I thought it would be harder to do, only thing it did was tell me I need to restructure my database.
isn't JSONBasedObject the same as Object in js?
whats the diff?

here's the definition
actually Object has some built-in functions
and i don't want intellisense to include them in
since this is object with only key-value pairs
either nested string | number - string | number | null | boolean
no abitrary
how tf u managed to create something that doesn't extend object?
i said to prevent some methods popping up in intellisense

function is the first primitive tho
oh wait nvm
i'm dumb
are these fat embeds here to stay cus its been a couple days now i swear
Hey all, I recently migrated to a MySQL database and probably did some stuff wrong along the way. It seems that some messages that include emojis produce an error (either when I insert or select them in the DB): (1267, "Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='").
I believe the specific query that fails is SELECT reply FROM guildmessages WHERE message = %s AND guildid = %s.
I made sure all the columns in the tables are utfmb4. Also attaching the result of the command SHOW VARIABLES WHERE Variable_name LIKE ("character%") OR Variable_name LIKE ("Collation%"); if that helps.
Any idea what else I can do?
is mysql a must?
like, if ur doing a migration you could go postgres instead, mysql is way too buggy
and there's that collation thing
Well if you remember me I was previously using SQLite 😅
I moved to MySQL because it was free and provided the logic I needed (fuzzy searching)
already comes with my PythonAnywhere sub
Anyone see anything wrong with this code?
post is free too, and since it's open-source, it has many plugins
one being for fuzzy search
oh well PA wanted to charge more for hosting it, but I'll remember that for the future. I did just move to MySQL so I'd rather just fix that emoji crap thing 😦
what error ur getting?
really? that sucks
None lol
but oh well, regarding the emoji thing, you cannot have VARCHAR(255) on mysql
you need to use VARCHAR(191)
I have full error reporting and its showing nothing, but the stripe dash doesn't show the default payment method.
anything higher and it refuses to save text with emoji, and has a high risk of corrupting already existing data with emoji
You are joking right?
wtf
will it be enough to store a max length Discord message though?
u "can" have VARCHAR(255) columns, you just won't be able to save anything with an emoji
Discord messages are over 255 characters normally
not really, for that u need to use TEXT
Well no, a max length discord message can be 2000 characters
which in mysql, is WAY slower than varchar
(nitro)
Initially I wanted to use TEXT but couldn't because they cannot be indexes
so I could not use SOUNDEX on them IIRC
or I couldn't have another index in the same table, can't remember
there was some limitation with it
probably for sorting alphabetically
oh yeah I had to store 2 TEXT ones
Where is the table in question?
any column that'll make use of sorting can and must be indexes
it makes sorted selects a hella faster
Is this what we are referencing?
yep
the reason TEXT cant be an index in mysql is because it's technically not a text
it's a LOB type
it's saved as binary
can you show your full table structure?
Or paste the SQL to make the table.
yep, can't be
anything higher than VARCHAR(191) will error with emojis
What other index do you need other than your primary key on ID?
probably none, I probably misunderstood that I had to use an index for something
oh yeah
maybe for foreign key or somethign
you dont technically need that...
you can do what a foreign key does using your code...
index is just for telling your database that column will be sorted
I think it said that I had to make it a FULLTEXT index
I haven't spent the time needed to apply foreign keys creating a relational database, but my code links all tables together by discordID
or for payment base items... stripeCustomerID
set the message to text and don't index it and you should be fine... You don't need to sort the table by messages do you?
nope
My bot is being tested rn.
Im working on the database it uses and it just got a new entry lol
alright then, I will try to convert that into TEXT soon and will update you guys if I hit any problems again
worst case I'll get my Raspberry PI back running and run postgres on it @lyric mountain 😄
I just finished converting all my SQL queries and code to work with MySQL so it's a pain in the arse
I forgot to put that to enable welcomer you need to use the enable-welcome option (non-required) in the top.gg page... oops.
That sucks...
did you fix the admin thing?
Ye
what kind of choice it is if u only got 2 options?
damn not even MariaDB
XD
100% I added all the planned permission requirements that are coming up in the Kanban and its... basically all of them lol
which is mysql but better
Odd, it didn't provide a response for the commands...
mysql really doesn't like 255 with utf8mb4
omfg I have a typo in the commands!
careful changing your bot now
if it's being reviewed, that is
hmm wonder why it didnt respond... And it just got declined.
how did ur ide not show that syntax error?
I did those commands at 4 am at 48h awake lol
what ide ur using?
Yeah typos are annoying that’s why you test every feature multiple times
The typo is new... I checked and it wasnt my commit that broke it.
welp, that's why we said that about ur current team organization
there has to be a versioning standard
well
like, don't push to production without review, no code accumulating without commit, weekly code review, task designation, etc etc
if you use typescript
never let 2 people work on the same thing at the same time
that wouldn't be the case

no team projects?
I said the same thing, not same project
like 2 people working on the ban command
that's prone to tail-chasing
if the design is agreed beforehand
then it's possible
man forgor about communication
the top 1 priority is going to github and disabling push to master
also he should've added test workflow before even commiting
like "try compiling this code"
if it's typescript
set the box "pull requests require review" or something
then it would probably pop TS2304: Could not find name 'interacton'. at... -> error exit code 1
thus preventing it from commit
my guess is that they all committed at the same time and did an auto merge
without reviewing what was changed
gh actions run before commit
if u enable forced review on github this gets kinda fixed
they probably don't have gh actions
solution: just use a typed language
typos are stupid which is why we need typed langs or something that can detect em
install intellij in ur vps and use remote multiplayer coding 
isn't that supposed to be fleet
oh wait
"code with me"
clearly the chad language
i'm disagreeing with rider
is rider out of early release?
what

lol lesgo do a multiplayer session
pro gamer move
(jk)
if you do i will write kotlin in it
Nope vote approved merge request on the stripe command they still had my typos from test branch in, which I corrected in my next merge to branch. but they merged from feature branch to main like idiots.
disable push to master
you better add a test workflow
create a gh action to build
u get notified if it fails
and disable push to master
I can't highlight this enough
I have azure devops lol
git push origin KuuHaKu
They dont push...
who approved the pr then?
automatically?
yeah
after 12h if the votes are over half the team, merge approved and executed.
Don't worry I implemented this before you mentionned it. I am justt now worrying about the new errors.
well, you'll need to go sifting through the errors
Oh i did... Its a node module breaking...
add a linter check regardless of voting
and if I remove it, the module I use to get payment information from my payment provider breaks lol.

why is this still going




