[DiscordArchive] I'm new to this and installed some modules which required running some SQL queries. This error mess
[DiscordArchive] I'm new to this and installed some modules which required running some SQL queries. This error mess
Original source
I'm new to this and installed some modules which required running some SQL queries. This error message makes it sound like I shouldn't have run the queries through HeidiSQL. Is that what borked it? I've searched for this error on the discord and people said to dump the world DB and that didn't work, came back with the same error.
Looks like I will have to reload a backup. What's the proper way to apply a SQL query to the database without this happening?
![[Image: image.png?ex=690bd366&is=690a81e6&hm=69e...c78d4332f&]](https://cdn.discordapp.com/attachments/1255602330431127753/1331756510635626536/image.png?ex=690bd366&is=690a81e6&hm=69e743badf9696c713a9ec2069de36485a34c8f4d06d958df1b7793c78d4332f&)
rektbyfaith
01-22-2025, 10:44 PM #1Archived author: Bancho Mike • Posted: 2025-01-22T22:44:55.017000+00:00
Original source
I'm new to this and installed some modules which required running some SQL queries. This error message makes it sound like I shouldn't have run the queries through HeidiSQL. Is that what borked it? I've searched for this error on the discord and people said to dump the world DB and that didn't work, came back with the same error.
Looks like I will have to reload a backup. What's the proper way to apply a SQL query to the database without this happening?
Original source
You almost never have to run any SQL files manually, and you shouldn't. If you're having issues with some file not being imported from a module you do it but that's it.
rektbyfaith
01-22-2025, 10:45 PM #2Archived author: Revision • Posted: 2025-01-22T22:45:48.867000+00:00
Original source
You almost never have to run any SQL files manually, and you shouldn't. If you're having issues with some file not being imported from a module you do it but that's it.
Original source
Worldserver is responsible for importing the tables and updates, as well as module files if the module is set up correctly, to all 3 databases and authserver is responsible for the auth database as well
rektbyfaith
01-22-2025, 10:46 PM #3Archived author: Revision • Posted: 2025-01-22T22:46:33.559000+00:00
Original source
Worldserver is responsible for importing the tables and updates, as well as module files if the module is set up correctly, to all 3 databases and authserver is responsible for the auth database as well
Original source
i think it was trying to apply ARAC that did it
rektbyfaith
01-22-2025, 10:46 PM #4Archived author: Bancho Mike • Posted: 2025-01-22T22:46:40.878000+00:00
Original source
i think it was trying to apply ARAC that did it
Original source
which, if i understand correctly, is basically just a SQL query
rektbyfaith
01-22-2025, 10:47 PM #5Archived author: Bancho Mike • Posted: 2025-01-22T22:47:25.410000+00:00
Original source
which, if i understand correctly, is basically just a SQL query
Original source
it may have been AHBot since it specifically says to manually import SQL into the database
rektbyfaith
01-22-2025, 10:52 PM #6Archived author: Bancho Mike • Posted: 2025-01-22T22:52:25.577000+00:00
Original source
it may have been AHBot since it specifically says to manually import SQL into the database
Original source
It wouldn't cause an archive update to be re-imported and it'll fail since it's an old update
rektbyfaith
01-22-2025, 11:00 PM #7Archived author: Revision • Posted: 2025-01-22T23:00:35.240000+00:00
Original source
It wouldn't cause an archive update to be re-imported and it'll fail since it's an old update
Original source
THX§
rektbyfaith
01-22-2025, 11:43 PM #8Archived author: Adrien • Posted: 2025-01-22T23:43:29.977000+00:00
Original source
THX§
Original source
someone mind explaining what i did wrong here i was adding the indiviual progession module. i imported all the sql files and the server crashes with this
![[Image: image.png?ex=690be262&is=690a90e2&hm=e13...01c929e68&]](https://cdn.discordapp.com/attachments/1255602330431127753/1331772599201693837/image.png?ex=690be262&is=690a90e2&hm=e133e0d777339c21d14d962efdf799f8ce2340168ff6e42fbfc05ad01c929e68&)
rektbyfaith
01-22-2025, 11:48 PM #9Archived author: Spicy Water • Posted: 2025-01-22T23:48:50.851000+00:00
Original source
someone mind explaining what i did wrong here i was adding the indiviual progession module. i imported all the sql files and the server crashes with this