Error with ABD

[metehan]

When running the changesets. I get an error on changeset 2 using latest NCDB.
It says "Feild "learn_spell" does not have default value."

PLZ help I really want to get my server 2.4 content.
+Rep+Rep+Rep to anyone that fixes this.

[SectorSeven]

The latest NCDB (which was like 3 weeks ago) doesn't have the latest SQL structure like ABD does.

[metehan]

What do you suggest I do without deleting all my custom content?

[Knife]

You should create a backup of your custom content, then wipe the database and after you imported ABD, run the backup. If you have any errors, then look what errors you have, and correct the structure, if it is something changed.

[metehan]

Well I fixed this no thanks to ABD or any of their staff. They refuse to acknoledge this error even if their are 5 errors on their forums.

alter table trainer_spells alter column learn_spell set default 0

Run that query and changeset two after that and it willw work.

[Ickybad]

What you don't understand is Sectorseven THE OWNER of ABD did acknowledge this post..

[SectorSeven]

Hahahahahahhahahhahaha. Your always complaining :P

[Clain]

That error was on your own part....We don't care if 5 threads were made on it. Thats their problem. Not ours.

CREATE TABLE `trainer_spells` (
`entry` int(11) unsigned NOT NULL default '0',
`cast_spell` int(11) unsigned NOT NULL default '0',
`learn_spell` int(11) unsigned NOT NULL default '0',
`spellcost` int(11) unsigned NOT NULL default '0',
`reqspell` int(11) unsigned NOT NULL default '0',
`reqskill` int(11) unsigned NOT NULL default '0',
`reqskillvalue` int(11) unsigned NOT NULL default '0',
`reqlevel` int(11) unsigned NOT NULL default '0',
`deletespell` int(11) unsigned NOT NULL default '0',
`is_prof` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`cast_spell`,`learn_spell`),
KEY `entry` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trainer System';

Is the correct structure.

[metehan]

The changesets are upgrades from the last revision of NCDB, if you did not change the structure through the changesets, then it the problem is on your side, not the users.

I was told by ABD members to upgrade using the ABD.

[Ickybad]

Less QQ more pew pew Sectorseven knows what he is doing and so does the ABD team listen to them... Or just use a different database easy as pie.

[metehan]

Less QQ more pew pew Sectorseven knows what he is doing and so does the ABD team listen to them... Or just use a different database easy as pie.

If sectorseven knew what he was doing, he would be able to fix this simple error. I really doubt he has done anything so far in ABD.'

Out of the last 189 commits , S7 has only done 12. Which were really minor changes, that even I could do.

No offense.

[SectorSeven]

True that. You make a good case. I've made 43 actually (look up the records). For the most part, I make alot of it and send it to my devs and if it passes testing its applied by them because its easier. I rarely apply my own material because I don't have the patience for testing. Most of my commits are patches that I apply. So whats your point? You like flaming me? Why the heck are you flaming me lol I did answer your question:

The latest NCDB (which was like 3 weeks ago) doesn't have the latest SQL structure like ABD does.

I said that you don't have the latest SQL structure. If you could do my job then you could run 2 or 3 quieries that are in the Ascent folder and not need us to post the table format for ya.

Jealousy is a virtue. One that you posses greatly. Don't take your anger out on me or my staff. If you don't like us switch to another database.

And to be honest... Nobody likes you your lucky you even have 24 reputation when you get to higher ranks (which I doubt will EVER happen) then you will have no friends and people will never want to work with a lousy, complaining, know-it-all SOB.

[DevGod]

I get the following....

[3/8] Items/Quests
ERROR 2006 (HY000) at line 136: MySQL server has gone away

none of the sunwell items seem to have loaded.

I have no idea whats going on or if anything is working. I'd love to get loot tables for 2.4 installed and some ports to sunwell and stuff. thx.

[SectorSeven]

Appears your MySQL Client shut-off after you starting importing the database

[DevGod]

i can import .sql files all day long but when i use ur batch file which i desperately want to it dies.. is there a chance for a non batch file sql import?