profession trainer and non-learning spell , ignore"

[stan84]

Hi

i created own profession, by this tutorial: viewtopic.php?f=26&t=2261&hilit=profession, it works, but only when i do command ".learn #spell". When i try add a new tranier in sql, core gives error: "Table `npc_trainer` for trainer (Entry: 1215) has non-learning spell 25229, ignore"

tried many ways, edit working trainers, switching spell #, adding new npc. Always same issuse.
Maybe you guys can suggest me how to fix it ?

here are stings from sql, and dbc:

spell.dbc v.1.12.1

25229,0,0,0,0,0,0x10010,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0,0,0,0x0,1,0,0,0,0,0,0x0,101,0,0,0,0,0,0,0,0,0,,1,0.0,0,0,0,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x0,0,-1,-1,0x0,47,118,0,0,1,0,0,0x1,0,0,,,0.0,0.0,0.0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.0,0.0,0.0,0,0,0,0,0,0,0,755,0,0,0,0,0.0,,,0,0,1768,0,0x0,"new prof",,,,,,,,2031662,"Apprentice",,,,,,,,2031662,"Allows a bla bla bla.",,,,,,,,2031662,"",,,,,,,,2031628,0,0x0,0,0,0,0x0,0x0,0,0,0x0,-1,1.0,1.0,1.0,0,0x0,0,

sql table:
                 npc_trainer                      '1215', '25229', '10', '0', '0', '5'
                 creature_template         '1215', '0', '0', '3237', '0', 'trainer Mallory', 'Journeyman bla bla', '0', '26', '26', '1309', '1309', '0', '0', '0', '12', '12', '19', '1', '1.14286', '0', '0', '34', '43', '0', '18', '1', '1750', '1925', '0', '0', '0', '0', '2', '0', '0', '0', '40.04', '55.055', '100', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '0', '0', '1', '22', '0', '0', '0', '2', ''

thanks Stan

[XxXGenesisXxX]

Proffessions have 2 spells per level, for example at level 150 Blacksmithing there are 2 spells, "Blacksmithing" and "Journeyman Blacksmithing", the first is the spell you use in your spellbook. The second however is the spell you give to a trainer a.k.a a learning spell, it is a spell that actually teaches the player the spell and modifies their skill level. I guess Trinity has updated to the point it now requires you to use a spell flagged for learning.

Edit: Just realized that tutorial was my one on ArcEmu... So doubt that cores been updated. Still, should be the same issue.

[stan84]

you have right XxXGenesisXxX, it works

proof shows in trainer menu, cant learn it at this moment (button is inactive)- probably did small mistake somwhere, but i think i can handle wit this.

Thank you  XxXGenesisXxX