[DiscordArchive] Found the reason for my earlier errors with the change of trying to do Sprocs instead of direct call
[DiscordArchive] Found the reason for my earlier errors with the change of trying to do Sprocs instead of direct call
Original source
Found the reason for my earlier errors with the change of trying to do Sprocs instead of direct calls. Has to do with the result set not getting cleared it seems. I'm trying to test a fix, but running into an issue. I've read through the database handlers, but again I'm not a huge cpp guy. I'm trying to clear the result set after a query and before it starts another. It looks like there is a Cleanup() method, but that isn't accessible from the PreparedQueryResult variable type. Anyone familiar with this know what code line I need to just clear the result set easily?
rektbyfaith
11-29-2020, 07:47 PM #1Archived author: DrtyByt • Posted: 2020-11-29T19:47:36.719000+00:00
Original source
Found the reason for my earlier errors with the change of trying to do Sprocs instead of direct calls. Has to do with the result set not getting cleared it seems. I'm trying to test a fix, but running into an issue. I've read through the database handlers, but again I'm not a huge cpp guy. I'm trying to clear the result set after a query and before it starts another. It looks like there is a Cleanup() method, but that isn't accessible from the PreparedQueryResult variable type. Anyone familiar with this know what code line I need to just clear the result set easily?
Original source
Specifically looking at the WorldSocket.cpp around like 790, between when it does the LOGIN_SEL_ACCOUNT_INFO_BY_NAME and then trys to call the LOGIN_UPD_LAST_ATTEMPT_IP I need to clear the result from the first query before it trys to run the second.
rektbyfaith
11-29-2020, 07:48 PM #2Archived author: DrtyByt • Posted: 2020-11-29T19:48:46.688000+00:00
Original source
Specifically looking at the WorldSocket.cpp around like 790, between when it does the LOGIN_SEL_ACCOUNT_INFO_BY_NAME and then trys to call the LOGIN_UPD_LAST_ATTEMPT_IP I need to clear the result from the first query before it trys to run the second.
Original source
<@&262883768300208129>
rektbyfaith
11-29-2020, 08:11 PM #3Archived author: Barbz • Posted: 2020-11-29T20:11:53.134000+00:00
Original source
<@&262883768300208129>
1 Guest(s)
1 Guest(s)