WoW Wotlk private servers (Client 8391 Mangos)

[kanttouchthis]

Loading Creature templates...
Error in creature_template table, probably sql file format was updates (there should be 63 fields in sql).

Any help would be greatly appreciated :] .
This happens during Mangosd loading

[whoisfrost]

sounds like you'll need to update the core also. just copy everything but the config files from the update over your existing install

[blueeyedtimothy]

Hi,new member here....I'm am very thankful for the time you put into this project. Only problem I seem to be having is that after I load mangosd.exe and realmd.exe and then try to log in with the account I made I get stuck at handshaking :lipsrsealed:.

Now my client is 8391 so its the highest patch that the launcher will give me. I can't really think of anything else...oh and I have that 3.5 frame thingy.....help would be much thanked.

[Zilver]

Loading Creature templates...
Error in creature_template table, probably sql file format was updates
(there should be 63 fields in sql).

Any help would be greatly appreciated :] .
This happens during Mangosd loading

Read the first post You need a minimum of MaNGOS Core 6040
like posted in here:

What's new in v1.7:
*Updated to latest MaNGOS Core (6040)

Hi,new member here....I'm am very thankful for the time you put into this project.
Only problem I seem to be having is that after I load mangosd.exe and realmd.exe and then try to log in with the account I made I get stuck at handshaking :lipsrsealed:.

Now my client is 8391 so its the highest patch that the launcher will give me.
I can't really think of anything else...oh and I have that 3.5 frame thingy.....help would be much thanked.

Did you remember to make account in MaNGOS Console? ( create accountname passwordof your choise )
Did you set TBC enabled? ( setbc accountname 1 )
Did you set account security level? ( setgm accountname 3 )

[blueeyedtimothy]

Read the first post You need a minimum of MaNGOS Core 6040
like posted in here:



Did you remember to make account in MaNGOS Console? ( create accountname passwordof your choise )
Did you set TBC enabled? ( setbc accountname 1 )
Did you set account security level? ( setgm accountname 3 )

Yes,Yes,and Yes.
Still nothing.....and the game works just fine I've actually just got off from the server I got from d4scene the kick ass wow one.... :/

[Zilver]

Yes,Yes,and Yes.
Still nothing.....and the game works just fine I've actually just got off from the server I got from d4scene the kick ass wow one.... :/

Hmm sounds like some setting's you need to modify:
1) SQL-Database --> Realmd --> realmlist --> address edit table:
your ip goes here

2) realmd.conf edit line:
LoginDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;realmd

3) mangosd.conf edit lines:
LoginDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;realmd"

WorldDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;mangos"

CharacterDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;characters"

4) ..\Wrath of the Lich King Friends and Family Alpha\realmlist.wtf edit line:
set realmlist your ip goes here

5) ..\Wrath of the Lich King Friends and Family Alpha\WTF\Config.wtf edit line:
SET realmList "your ip goes here"

Notes:
your ip goes here --> your IP
SQL-logon --> the logon used by MySQL
SQL-password --> the password used by MySQL

This will let me connect to my server, hope this helps you out.

[blueeyedtimothy]

Hmm sounds like some setting's you need to modify:
1) SQL-Database --> Realmd --> realmlist --> address edit table:
your ip goes here

2) realmd.conf edit line:
LoginDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;realmd

3) mangosd.conf edit lines:
LoginDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;realmd"

WorldDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;mangos"

CharacterDatabaseInfo = "you ip goes here;3306;SQL-logon;SQL-password;characters"

4) ..\Wrath of the Lich King Friends and Family Alpha\realmlist.wtf edit line:
set realmlist your ip goes here

5) ..\Wrath of the Lich King Friends and Family Alpha\WTF\Config.wtf edit line:
SET realmList "your ip goes here"

Notes:
your ip goes here --> your IP
SQL-logon --> the logon used by MySQL
SQL-password --> the password used by MySQL

This will let me connect to my server, hope this helps you out.

Ahhh ok now its working thank you very much.
I don't know if I can rep but if I can I'll do it haha.

[GodOfWar]

lol you can rep >.>

[madjosh]

hey ive folowed the plan step by step every thing works done every thing when i try to log in it says unable to connect i havent updated to 1.7 yet but every time i try to i run execute batch file i select the i click start and i gt this error message


[Err] 1062 - Duplicate entry '100048' for key 1
[Err] insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('100048','100042','571','1','0','0','4554.7 6','6072.11','80.7573','2.84826','25','0','0','710 00','0','0','1');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

does any one have any idea whts gone wrong

[Zilver]

hey ive folowed the plan step by step every thing works done every thing when i try to log in it says unable to connect i havent updated to 1.7 yet but every time i try to i run execute batch file i select the i click start and i gt this error message


[Err] 1062 - Duplicate entry '100048' for key 1
[Err] insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('100048','100042','571','1','0','0','4554.7 6','6072.11','80.7573','2.84826','25','0','0','710 00','0','0','1');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

does any one have any idea whts gone wrong

Edit the SQL-file and replace this:

insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('100048','100042','571','1','0','0','4554.7 6','6072.11','80.7573','2.84826','25','0','0','710 00','0','0','1');
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`) values('100042','17216','0','17216','0','George Mepan','Weapon Master',NULL,'80','80','71000','71000','0','0','20 ','35','35','17','1.125','1','0','141','182','0',' 565','1500','0','4608','0','0','2','0','0','0','0' ,'0','100','7','1','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','','1','3','0','1 ','0','0','');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','196','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','197','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','198','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','199','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','200','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','201','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','202','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','227','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','264','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','266','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','1180','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','2567','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','5011','1','0','0','0');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('100042','15590','1','0','0','0');

with this:

replace into `creature` values('100048','100042','571','1','0',
'0','4554.76','6072.11','80.7573','2.84826','25',' 0','0','71000',
'0','0','1');
replace into `creature_template` values('100042','17216','0',
'17216','0','George Mepan','Weapon Master',NULL,'80','80','71000',
'71000','0','0','20','35','35','17','1.125','1','0 ','141','182','0','565',
'1500','0','4608','0','0','2','0','0','0','0','0', '100','7','1','0','0','0','0','0',
'0','0','0','0','0','0','0','0','0','0','0','','1' ,'3','0','1','0','0','');
replace into `npc_trainer` values('100042','196','1','0','0','0');
replace into `npc_trainer` values('100042','197','1','0','0','0');
replace into `npc_trainer` values('100042','198','1','0','0','0');
replace into `npc_trainer` values('100042','199','1','0','0','0');
replace into `npc_trainer` values('100042','200','1','0','0','0');
replace into `npc_trainer` values('100042','201','1','0','0','0');
replace into `npc_trainer` values('100042','202','1','0','0','0');
replace into `npc_trainer` values('100042','227','1','0','0','0');
replace into `npc_trainer` values('100042','264','1','0','0','0');
replace into `npc_trainer` values('100042','266','1','0','0','0');
replace into `npc_trainer` values('100042','1180','1','0','0','0');
replace into `npc_trainer` values('100042','2567','1','0','0','0');
replace into `npc_trainer` values('100042','5011','1','0','0','0');
replace into `npc_trainer` values('100042','15590','1','0','0','0');

or download this pre-edited v1.6 to v1.7.sql: Edited v1.6 to v1.7.rar]
That should do the trick.

I made this NPC, it's the Weapon Master in the Mall (the one that will train you in any weapon skill) kind of my mistake since i used a incorrect syntax,
I should have used `replace` instead of `insert` in my original script, then Mike would have had the correct syntax from the start.

Edit forgot the last piece of the script in first post.