[Release] Mangos WotLK Core 3.0.2.8905

[Freakzor]

Theres a couple of sql files u should execute in a folder called updates, one called APPLY_ME_mangos_string.sql and mangos_string.sql, should solve your problem

EDIT: well there should be some strings anyways, something must have gone wrong when u applied the main db or i'm really tired and should just be quiet......

you was right xD i didnt see that the first time lol :P

now i get something else thou,

ERROR:Error in item_template table, probably sql file format was updated (there should be 142 fields in sql).

there isnt any more sql files i can execute, any ideas?

EDIT: nvm, i was so stupid and forgott to read the last post.


EDIT2: i got hell lots of not existing, and entry was wrong, and items not listed. is this bcuz something went from in the main database execute? i can post the hole list i f that helps.

[Allithus]

game crshes i get this
i got different error

SQL: SELECT count(*) AS r FROM character_tutorial WHERE account = '6' AND realmid = '1'
2008-10-06 14:32:58 query ERROR: Unknown column 'account' in 'where clause'
2008-10-06 14:32:58 SQL: INSERT INTO character_tutorial (account,realmid,tut0,tut1,tut2,tut3,tut4,tut5,tut6,tut7) VALUES ('6', '1', '4294967295', '4294967295', '4294967295', '4294967295', '4294967295', '4294967295', '4294967295', '4294967295')
2008-10-06 14:32:58 SQL ERROR: Unknown column 'account' in 'field list'

I had pretty much the same thing, when i used the "saveall command" apparently my dk's sword, and talents aren't saved.

[zackorion15]

Oh joy 9061 is out now. They sure do not waste time on making patch after patch do they?

[stevamirkovic]

Guys, do you known SVN for Mangos Source patch file for WotLK, or public SVN there is no ?

[Freakzor]

Oh joy 9061 is out now. They sure do not waste time on making patch after patch do they?

its just to edit the mangosd file thou.....?

[gasly]

When I want to install MySQL at the execute part it Stops on Start Service.
What can I do?

[Silentnvd]

ALTER TABLE `item_template` ADD COLUMN `unk_flag1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_value10;
ALTER TABLE `item_template` ADD COLUMN `unk_flag2` mediumint(10) unsigned NOT NULL default '0' AFTER unk_flag1;


Execute these 2 lines into mangos database

thanks +Rep

[zackorion15]

I did "DELETE FROM `creature_equip_template` WHERE (`entry`=1);" in the mangos database and the checkered boxes still show on the npc's hand.

[Razorspine]

Been trying since the first 9000+ patches came to make a semi workin BETA server, self compiled mangos with the 19.1 patch...it works with all the clients up to 9061 patch...but the server error file seems to get larger and larger , and the checkered boxes remain no matter what i try. Char saving has to be done manually and the "assertion failure" when trying to use the transports at the DK start area.
Also tried using yours Death but the errors remain, so....any1 have a db that has a slightly lower amount of errors or should i just downgrade my server to an earlier build ?

[zackorion15]

@razorspine : I am getting the exact same issues. Even the mangos server wont show the command line for me so I have to edit the database manually to add accounts >.<

[Allithus]

alright if you had that save character problem just add the account and realmid column into mysql.
Alter table character_tutorial add acount int;
Alter table character_tutorial add acount realmid;

To anyone else who gets errors, this is sql, if something's wrong just check the data base and see if you can correct it.

[Razorspine]

alright if you had that save character problem just add the account and realmid column into mysql.
Alter table character_tutorial add acount int;
Alter table character_tutorial add acount realmid;

To anyone else who gets errors, this is sql, if something's wrong just check the data base and see if you can correct it.

Thanx, didnt help me but a valiant effort , and a LARGE amount of errors are core based so sql handling doesnt really work, all u can do is ignore the error outputs in sql, but i kinda like to know whats goin on and not to hide it

[looker]

getting the following error when running worldd:


User thread created.
pollPendingThreads()
1 user-thread added.
Thread starting...
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.45
MySQL server ver: 5.0.41
AUTOCOMMIT SUCCESSFULLY SET TO 1
[1 ms] SQL: SELECT `version`FROM `sd2_db_version`

SD2: Database version is: ACID 0.0.2 - Update Pack r18

[7 ms] SQL: SELECT `id`,`locale_0`,`locale_1`,`locale_2`,`locale_3`,`locale_4`,`locale_5`,`locale_6 `,`locale_7`FROM `localized_texts`
SD2: Loading Localized_Texts...
[**************************************************] 100%
SD2: >> Loaded 325 Localized_Texts

[5 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`
[1 ms] SQL: SELECT `id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`FROM `eventai_summons`
SD2: Loading EventAI_Summons...
[**************************************************] 100%
SD2: >> Loaded 7 EventAI_Summons

[5 ms] SQL: SELECT `id`,`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event _param1`,`event_param2`,`event_param3`,`action1_type`,`action1_param1`,`action1_ param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`actio n2_param3`,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`FROM `eventai_scripts`
SD2: Loading EventAI_Scripts...
[SD2: Event 1555101 Action 0 uses non-existant SpellID 18812.
Spell Store Size = 3801024.
SD2: Event 1797605 Action 0 uses non-existant SpellID 34799.
Spell Store Size = 3801024.
SD2: Event 1833102 Action 0 uses non-existant SpellID 34942.
Spell Store Size = 3801024.
SD2: Event 1831702 Action 0 uses non-existant SpellID 35944.
Spell Store Size = 3801024.
[SD2: Event 1780202 Action 0 uses non-existant SpellID 35105.
Spell Store Size = 3801024.
[SD2: Event 1797806 Action 0 uses non-existant SpellID 34661.
Spell Store Size = 3801024.
[SD2: Event 1647202 Action 0 uses non-existant SpellID 29673.
Spell Store Size = 3801024.
[SD2: Event 1603601 Action 0 uses non-existant SpellID 56.
Spell Store Size = 3801024.
[SD2: Event 2239303 Action 0 uses non-existant SpellID 37579.
Spell Store Size = 3801024.
[SD2: Event 403501 Action 0 uses non-existant SpellID 18812.
Spell Store Size = 3801024.
[SD2: Event 31404 Action 0 uses non-existant SpellID 8427.
Spell Store Size = 3801024.
[SD2: Event 2333903 Action 0 uses non-existant SpellID 41171.
Spell Store Size = 3801024.
SD2: Event 2331802 Action 0 uses non-existant SpellID 41177.
Spell Store Size = 3801024.
[SD2: Event 1134001 Action 0 uses non-existant SpellID 24617.
Spell Store Size = 3801024.
[SD2: Event 1439802 Action 0 uses non-existant SpellID 35944.
Spell Store Size = 3801024.
SD2: Event 1741601 Action 0 uses non-existant SpellID 34942.
Spell Store Size = 3801024.
[SD2: Event 171701 Action 0 uses non-existant SpellID 45299.
Spell Store Size = 3801024.
[SD2: Event 1730903 Action 0 uses non-existant SpellID 34942.
Spell Store Size = 3801024.
[SD2: Event 1943402 Action 0 uses non-existant SpellID 32666.
Spell Store Size = 3801024.
[SD2: Event 1659406 Action 0 uses non-existant SpellID 35944.
Spell Store Size = 3801024.
[SD2: Event 1846503 Action 0 uses non-existant SpellID 32939.
Spell Store Size = 3801024.
SD2: Event 1846504 Action 0 uses non-existant SpellID 32939.
Spell Store Size = 3801024.
SD2: Event 1846403 Action 0 uses non-existant SpellID 32939.
Spell Store Size = 3801024.
SD2: Event 1846404 Action 0 uses non-existant SpellID 32939.
Spell Store Size = 3801024.
[SD2: Event 2004301 Action 0 uses non-existant SpellID 40424.
Spell Store Size = 3801024.
[SD2: Event 326802 Action 0 uses non-existant SpellID 467.
Spell Store Size = 3801024.
SD2: Event 1942201 Action 0 uses non-existant SpellID 34019.
Spell Store Size = 3801024.
[SD2: Event 112103 Action 0 uses non-existant SpellID 467.
Spell Store Size = 3801024.
SD2: Event 126001 Action 0 uses non-existant SpellID 465.
Spell Store Size = 3801024.
[**************************************************] 100%
SD2: >> Loaded 3752 EventAI_Events

Thread joining...
Thread exiting...
insertPendingThread()
1 pending-thread added.
Segmentation fault
logout

[ash21us]

Just downloaded it, unpacked it, applied applicable fixes, ran the "item fix" and it works great.

Yup, even on 9061.

Thanks

[ash21us]

its just to edit the mangosd file thou.....?

Yup, that is all I did.