[DiscordArchive] Hi guys I´d like to ask ya something..
[DiscordArchive] Hi guys I´d like to ask ya something..
Archived author: cyberpro98 • Posted: 2025-01-01T19:59:29.431000+00:00
Original source
Hi guys I´d like to ask ya something..
Some players are like complaining that they lost their recipes of professions, so i unlearned them professions and learned them again by a prof npc ... So What are these errors what ?
```js
SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (906, 4036, 2
55)
[ERROR]: [1062] Duplicate entry '906-4036' for key 'character_spell.PRIMARY'
SQL(p): INSERT INTO character_action (guid, spec, button, action, type) VALUES (
906, 0, 39, 51306, 0)
[ERROR]: [1062] Duplicate entry '906-0-39' for key 'character_action.PRIMARY'
```
What´s the Character_action for ?
Archived author: Ryan Turner • Posted: 2025-01-01T20:03:57.135000+00:00
Original source
Last time I had a skill issue to the point the game kept telling me they had duplicates entries (even upon deleting the skill) and creating a sql error therefor not saving progression, I had to remove any spells they had (this case dual weld), remove their skills in the database, pdump their and restore the pdump to the same account. Not the same issue as you but could be the same solution
Archived author: Ryan Turner • Posted: 2025-01-01T20:08:02.043000+00:00
Original source
But for you case Maybe reseting the their keybinds I think is what the char actions is should fix it
Archived author: Revision • Posted: 2025-01-01T20:09:18.918000+00:00
Original source
character_action is for the action bars
Archived author: cyberpro98 • Posted: 2025-01-01T20:10:07.207000+00:00
Original source
seems to be the same ..
Archived author: cyberpro98 • Posted: 2025-01-01T20:10:38.957000+00:00
Original source
It should work fine, if you use the command .unlearn or if they use any trainer the game should save them automatically. So there won´t be problems
Archived author: Ryan Turner • Posted: 2025-01-01T20:12:18.476000+00:00
Original source
In my case even unlearn the spellb(or removing it from the database) and clearing the entry in database when they relog (even with their cache clear) they always load the ability, skill and create errors
Archived author: Revision • Posted: 2025-01-01T20:13:00.640000+00:00
Original source
I've had a similar thing happen. I tried to .unlearn a mount but relogging brought it back. Could very well be what screwed is saying.
Archived author: cyberpro98 • Posted: 2025-01-01T20:13:37.400000+00:00
Original source
yes
Archived author: cyberpro98 • Posted: 2025-01-01T20:13:45.816000+00:00
Original source
yes