"Error Code: 1364 - Field 'info_str' doesn't have a default value"
What should the default be? 0?
Printable View
"Error Code: 1364 - Field 'info_str' doesn't have a default value"
What should the default be? 0?
Code:UPDATE creature_names set info_str="";
It's usually 0 as its default.
Hey mate could you plz make a demon trainer ( the one that gives you the demons ) for warlocks and a shapeshift trainer for druids or add the spells to the class trainers.I used the rev 8 u made and its great , there is a warrior stance trainer ,just those two things missing though :/.Or if you know any sql update files that add the upon to the database plz link it here. -Thanks :)
Please leave out the mouseFlags, it generates issues across different NCDB versions.
For the rest I just love it once I edited all the mouseFlags out of the SQL
If that works :-)Quote:
Originally Posted by Shambala
Waiting for Ascent to release 2.5 stable, or 2.5 release. We will see what happens.
As for the new vendors, slowly working on them, will get to more of it on Sunday and Monday. Thanks for the feedback!
The class trainer should have the warlock spells, shouldnt be a warrior class trainer in there anymore :-0, ill add druid shapeshift in there in the next revision.Quote:
Originally Posted by Mikylol
I don't think you realized that you didn't add in a Fishing trainer... Its another trainer that starts with an "F"
I did add a fishing trainer in the Pet, Weapon, Mount, and Proffession folder.Quote:
Originally Posted by xSLaYaHx
Yeah, but in-game, its another letherworking trainer...
Hmm, try reloading it, it should come up as fishing trainer :-)Quote:
Originally Posted by xSLaYaHx
In other news, I added the Druid Shapeshift forms into the Class Neutral Trainer, also, reorganized a little bit. Let me know other mistakes I would have made.
.... ill check the profession trainers...
Version .9
Ackhole's Projects Download Page
Nice Ackhole.
very well done bro!
some adjustments: on my server people are ask me about the following missing:
Warriors: intercept (highest ranks)
rogues: dual wield, gouge rank 1, backstab rank 1, and even stealth rank 1 (prolly something went with the server or is it a big in the trainers?? xD)
paladins: the summon charger spell (100% mount)
Mage: Flamestrike rank 2, and ice barrier rank 6.
Not sure if there really all missing, but this is what the players told me. so im sorry if im wrong :)
i think its something in the core :P we got 2473
and keep up the good work man! i really love your trainers!
Thanks for the help Shockzz, ill make an SQL with those in it and add it into revision 1.
Ill name it: Possible Core/NCDB Flaws?
O and BTW, didn't see anything wrong with the naming of the profession trainers :-)
Sigh... Here's proof:
http://i8.tinypic.com/8gg94zo.jpg
got a new one: redemption for paladins was missing.
but really, the one with the most buggs at my core, seems the rogue for now
they missed like the main rogue skills out here :(
stealth, backstab, gouge etc. almost all ranks 1 missing :'(
and at the weapontrainer fistweapons for rogues seem to be missing also.
hope its an easy fix, so i wont bring to much much trouble...
Does not work for me, using SQLyog and i have a ascent rev.2554 server.. I get this error when trying to execute (like some other people up here). Would be nice having this "mall" on Gm island tho.. I have tried some of your other files, some vendors and such, none of them works for me..
A question.. your files on your "ackhole's projects download page", there are a lot of them.. wich do i execute first and second and third (and so on) and last.. ?
or is it just to execute them one by one no matter the ones first or last..? and where do i execute em, in my world database right? <This i've tried, didnt work with my latest rev ascent server and SQLyog (my server)
Ok, I have said this a couple times. Until a new Stable or Release branch comes out, I don't update my database, thus my SQL's. So there may be conflicts!. As of now, I will update my db when ascent hits 2700.
Slayah: That was a double Spawn.
Revision 1 is Released!
Ive added a couple things, including a bunch of Recipe and Book Vendors. Also, a totem vendor for those who need it. Combined my other project, the Custom Weapons Vendors, into this project, just for better organization. Also, did a couple fixes for the sql's.
Post any problems please!
Dont forget to backup first!
Revision 1!!!
Ackhole's Projects Download Page
wooo nice nice nice
A nice release. Thanks Ackhole.
the bonus fix worked ineed!! the spells were added to the missing spell trainers! ty for that ackhole!
ive done some investigation myself, and played all classes. and made a list of spells that are still missing.
maybe you can add those in the next update, like you did with the other one.
here we go (this is whats still missing after the fixsql in version 1.):
warrior:
mortal strike rank 2 (rank 1 is a talent spell, but rank 2 is missing in the trainer)
paladin:
summon charger (it so is in the missing spell trainer, ut it requires devo aura 1. even with that devo1, the spell still keeps red)
summon warhorse
redemption rank 1
hunter = ok!
priest:
shadowprotection rank 2
devouring plague rank 1
shaman:
searing totem rank 1
stoneskin totem rank 1
healing stream totem rank 1
mage:
no spells missing anymore, but something else: factions can buy eachothers teleports/portals.
so hordie can buy stormwind ports, and allies org ports etc.
both all teleports and portal of the other faction
druid = ok!
rogue: still missing pretty much:
eviscerate rank 2
slice and dice rank 1
sinister strike rank 2
sprint rank 1
evasion rank 1
sap rank 1
instant poison rank1
deadly poison rank 1
mind-numbering poison rank 1
crip poison rank 1
and wound poison rank 1
and warlock: ritual of doom
if these spells are in, i can confirm that all spells between ncdb milestone 0.2.3 and ncdb 713 are included/working in the trainers.
and maybe you can add them in the normal trainer ackhole? specially with rogue? because when this is in, the missing spell trainers sells almost more spells then the rogue trainer XD
That would be a possibility, but, I would rather try to go through official channels before I try it my way. What would be extremly helpful would be a list of all the rogue trainers with there ID's, so if the official don't work, ill make up a fix for rogues. Thanks for the list though!
mehh,, ill just wait for your new versions :)
ive placed a level 60 roguetrainer (blizzards one), which sells most skills :)
hoping for a new release on a higher DB prolly :)