[DiscordArchive] Maybe a better place to start looking is, what do the crash logs say cause the crash?
[DiscordArchive] Maybe a better place to start looking is, what do the crash logs say cause the crash?
Original source
Maybe a better place to start looking is, what do the crash logs say cause the crash?
rektbyfaith
08-08-2025, 09:07 PM #1Archived author: metallinos • Posted: 2025-08-08T21:07:45.623000+00:00
Original source
Maybe a better place to start looking is, what do the crash logs say cause the crash?
Original source
this is the only thing the console stated before closing
rektbyfaith
08-08-2025, 09:09 PM #2Archived author: Ahuramazda • Posted: 2025-08-08T21:09:22.200000+00:00
Original source
this is the only thing the console stated before closing
Original source
[1054] Unknown column 'totalTalentPoints' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
rektbyfaith
08-08-2025, 09:09 PM #3Archived author: Ahuramazda • Posted: 2025-08-08T21:09:29.058000+00:00
Original source
[1054] Unknown column 'totalTalentPoints' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Original source
pretty much what I said about the fact the column doesn't exist, but the more confounding part is the fact that removing that line that caused it makes the code no longer save the extra point
rektbyfaith
08-08-2025, 09:10 PM #4Archived author: Ahuramazda • Posted: 2025-08-08T21:10:35.216000+00:00
Original source
pretty much what I said about the fact the column doesn't exist, but the more confounding part is the fact that removing that line that caused it makes the code no longer save the extra point
Original source
If you have CharDBExecute(string.format("UPDATE characters SET totalTalentPoints = totalTalentPoints + 1 WHERE guid = %i", PUID)) in there, it will not execute CharDBExecute(string.format("UPDATE characters SET extraBonusTalentCount = COALESCE(extraBonusTalentCount, 0) + 1 WHERE guid = %i", PUID)) afaik
rektbyfaith
08-08-2025, 09:29 PM #5Archived author: metallinos • Posted: 2025-08-08T21:29:06.900000+00:00
Original source
If you have CharDBExecute(string.format("UPDATE characters SET totalTalentPoints = totalTalentPoints + 1 WHERE guid = %i", PUID)) in there, it will not execute CharDBExecute(string.format("UPDATE characters SET extraBonusTalentCount = COALESCE(extraBonusTalentCount, 0) + 1 WHERE guid = %i", PUID)) afaik
Original source
I don't think these issues are related
rektbyfaith
08-08-2025, 09:29 PM #6Archived author: metallinos • Posted: 2025-08-08T21:29:13.359000+00:00
Original source
I don't think these issues are related
Original source
I really wish I had a way to show this to someone, cause its literally only adding the +1 to the database value when it crashes when you would expect nothing, lol
no crash: no bonus points
crashes: +1 max talents
rektbyfaith
08-08-2025, 09:32 PM #7Archived author: Ahuramazda • Posted: 2025-08-08T21:32:02.792000+00:00
Original source
I really wish I had a way to show this to someone, cause its literally only adding the +1 to the database value when it crashes when you would expect nothing, lol
no crash: no bonus points
crashes: +1 max talents
Original source
Maybe show what the table contains before and after for each scenario?
rektbyfaith
08-08-2025, 09:35 PM #8Archived author: metallinos • Posted: 2025-08-08T21:35:13.042000+00:00
Original source
Maybe show what the table contains before and after for each scenario?
Original source
I think I know what issue you're referring to
rektbyfaith
08-08-2025, 09:36 PM #9Archived author: metallinos • Posted: 2025-08-08T21:36:09.429000+00:00
Original source
I think I know what issue you're referring to
Original source
Just jamming the bonus talent point into the database will lead to it being overwritten by periodical player saves as the runtime cache has no idea what you're forcing into the database, it only loads database values when the server starts (world stuff) or a player logs in (character stuff)
rektbyfaith
08-08-2025, 09:36 PM #10Archived author: metallinos • Posted: 2025-08-08T21:36:51.825000+00:00
Original source
Just jamming the bonus talent point into the database will lead to it being overwritten by periodical player saves as the runtime cache has no idea what you're forcing into the database, it only loads database values when the server starts (world stuff) or a player logs in (character stuff)
1 Guest(s)
1 Guest(s)