[DiscordArchive] Where will that show up if it's a mail sent from the server, such as an auction expiring or leaching
[DiscordArchive] Where will that show up if it's a mail sent from the server, such as an auction expiring or leaching
Original source
What happens to the server-side cache of the item_instance count if I insert a line into item_instance, while the server is running, with the ID being max ID + 1? It seems to work just fine, and subsequent items are created just fine so I'm not sure why I'm seeing this issue
rektbyfaith
02-23-2025, 10:19 AM #11Archived author: metallinos • Posted: 2025-02-23T10:19:05.995000+00:00
Original source
What happens to the server-side cache of the item_instance count if I insert a line into item_instance, while the server is running, with the ID being max ID + 1? It seems to work just fine, and subsequent items are created just fine so I'm not sure why I'm seeing this issue
Original source
it is only incremented on CreateItem
rektbyfaith
02-23-2025, 10:20 AM #12Archived author: Kitzunu • Posted: 2025-02-23T10:20:35.042000+00:00
Original source
it is only incremented on CreateItem
Original source
that would be very wrong - and bad
rektbyfaith
02-23-2025, 10:21 AM #13Archived author: Takenbacon • Posted: 2025-02-23T10:21:53.425000+00:00
Original source
that would be very wrong - and bad
Original source
I might understand you wrong. But you shouldnt touch that table manually at all
rektbyfaith
02-23-2025, 10:22 AM #14Archived author: Kitzunu • Posted: 2025-02-23T10:22:58.273000+00:00
Original source
I might understand you wrong. But you shouldnt touch that table manually at all
Original source
But why is it wrong and how is it bad? As subsequent items are created fine and I'm not getting any primary key errors in item_instance
rektbyfaith
02-23-2025, 10:23 AM #15Archived author: metallinos • Posted: 2025-02-23T10:23:06.214000+00:00
Original source
But why is it wrong and how is it bad? As subsequent items are created fine and I'm not getting any primary key errors in item_instance
Original source
You understand me right
rektbyfaith
02-23-2025, 10:23 AM #16Archived author: metallinos • Posted: 2025-02-23T10:23:35.088000+00:00
Original source
You understand me right
Original source
you can't say everything is fine when just a few messages ago you were saying you're having odd issues with item_instance lmao
rektbyfaith
02-23-2025, 10:23 AM #17Archived author: Takenbacon • Posted: 2025-02-23T10:23:51.120000+00:00
Original source
you can't say everything is fine when just a few messages ago you were saying you're having odd issues with item_instance lmao
Original source
I'm not really saying that everything is fine, but item_instance isn't throwing any error, mail_item is
rektbyfaith
02-23-2025, 10:24 AM #18Archived author: metallinos • Posted: 2025-02-23T10:24:32.459000+00:00
Original source
I'm not really saying that everything is fine, but item_instance isn't throwing any error, mail_item is
Original source
Basically you should only allow CreateItem to insert into it, because on startup it calculates the guid counter. And it is never recalculated during runtime. So if you insert manually, it will create issues when the core is using CreateItem
rektbyfaith
02-23-2025, 10:24 AM #19Archived author: Kitzunu • Posted: 2025-02-23T10:24:36.328000+00:00
Original source
Basically you should only allow CreateItem to insert into it, because on startup it calculates the guid counter. And it is never recalculated during runtime. So if you insert manually, it will create issues when the core is using CreateItem
Original source
Okay these are good pointers to go find out how much I can jank up my database, wish me luck
rektbyfaith
02-23-2025, 10:25 AM #20Archived author: metallinos • Posted: 2025-02-23T10:25:16.756000+00:00
Original source
Okay these are good pointers to go find out how much I can jank up my database, wish me luck
1 Guest(s)
1 Guest(s)