• Easy Guide --- Mangos 2.1.1-2.1.2 Server! •

[firestarterwtf]

No, you need 2.1.1 or 2.1.2 client.

[Brool]

hey one question: i want to add the tier 6 sets but always when i try to add the "T6" data to "realmd" in navicat, i get a error that something is unsuccesfully...

[edixxx]

No, you need 2.1.1 or 2.1.2 client.

i did it ^^ its working ^^
but the real question is ...
how can make my server to instant 70...
or u know a manage program for mangos database... quickly and easy

[weaselking1973]

hey one question: i want to add the tier 6 sets but always when i try to add the "T6" data to "realmd" in navicat, i get a error that something is unsuccesfully...

dont add it to the realmd

it is exicuted from the "mangos" database

edixxxQuote:
Originally Posted by firestarterwtf
No, you need 2.1.1 or 2.1.2 client.

i did it ^^ its working ^^
but the real question is ...
how can make my server to instant 70...
or u know a manage program for mangos database... quickly and easy

1st you can run this with version 2.2.3
2nd use the GM commands to change the player lvl ( .modify level 69 )

[Brool]

stillt cant add it.....

[edixxx]

whatever
i guess xprate can fix it
and the other question

i played a little at this server but a lot of bugs there... i entered black temple
but only bosses at right level...
all the other mobs lvl 1 o_O
can i find a better database ? or i must fix them manuel ?
tnx for guide btw ^^

[weaselking1973]

whatever
i guess xprate can fix it
and the other question

i played a little at this server but a lot of bugs there... i entered black temple
but only bosses at right level...
all the other mobs lvl 1 o_O
can i find a better database ? or i must fix them manuel ?
tnx for guide btw ^^

well this database is pretty much the worst on the site... sad to say.

but it works

I have switched to the AC repack 7.1

for all of outlands is the same.. no intances work for shit, no mobs spawned

but if you need help i can

as for adding in the T6 items do this

open navcat
connect to database
right click on the "mangos"
select "exicute batch file"

then selecet each file in the T6 folder you want to add, each has to be done indavidually.

and only one that is 100% complete without errors is the leather

[firestarterwtf]

Everything worked perfectly 'till few hrs ago. I got server up normally, but when I run wow and try to log in it says Unable to connect. I made server online, it worked online, but it stopped with this error.

[jonny405]

something is wrong with mine..... the restarter keeps saying "crashed...restarting" what do i do to fix it???

[jonny405]

[Err] 1050 - Table 'account' already exists
[Err] -- ----------------------------
-- Table structure for account
-- ----------------------------
CREATE TABLE `account` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
`username` varchar(16) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gmlevel` tinyint(3) unsigned NOT NULL default '0',
`sessionkey` longtext,
`v` longtext,
`s` longtext,
`email` varchar(255) NOT NULL default '',
`joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`banned` tinyint(3) unsigned NOT NULL default '0',
`last_ip` varchar(30) NOT NULL default '127.0.0.1',
`failed_logins` int(11) unsigned NOT NULL default '0',
`locked` tinyint(3) unsigned NOT NULL default '0',
`last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
`online` tinyint(4) NOT NULL default '0',
`tbc` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`),
KEY `idx_banned` (`banned`),
KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';
[Msg] Finished - Unsuccessfully
--------------------------------------------------



this and the restarter keeps saying "crashed... restarting... restarting"??? what did i do wrong????

[weaselking1973]

[Err] 1050 - Table 'account' already exists
[Err] -- ----------------------------
-- Table structure for account
-- ----------------------------
CREATE TABLE `account` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
`username` varchar(16) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gmlevel` tinyint(3) unsigned NOT NULL default '0',
`sessionkey` longtext,
`v` longtext,
`s` longtext,
`email` varchar(255) NOT NULL default '',
`joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`banned` tinyint(3) unsigned NOT NULL default '0',
`last_ip` varchar(30) NOT NULL default '127.0.0.1',
`failed_logins` int(11) unsigned NOT NULL default '0',
`locked` tinyint(3) unsigned NOT NULL default '0',
`last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
`online` tinyint(4) NOT NULL default '0',
`tbc` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`),
KEY `idx_banned` (`banned`),
KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';
[Msg] Finished - Unsuccessfully
--------------------------------------------------



this and the restarter keeps saying "crashed... restarting... restarting"??? what did i do wrong????

drop the database 'realmd" and rebuild it from scratch, your trying to run a SQL file that already has been run

firestarterwtfEverything worked perfectly 'till few hrs ago. I got server up normally, but when I run wow and try to log in it says Unable to connect. I made server online, it worked online, but it stopped with this error.

post the server file info again

[firestarterwtf]

This is Server.log on 127.0.0.1 realmlist. Does it need to have so much errors at the end ?

[firestarterwtf]

Wohooo, I made new no-ip host and it works now.

One more question, can someone tell me how to make new account ?

[Psamtik]

I got some weird problem too like johny405, when I run the Mangosrestarter, the cmd pops up, and some text comes, and then closes, and repeats, and after a while the restarter says that mangos.exe crashed. I tried to drop and make a new realmd database, but that didn't work.

Any help appriciated!

Also, why is the mangosd and realmd exe files in german? ._.

crash log btw

## Crash! 2007-10-28 04:43:39. .\mangosd.exe has crashed! Lines logged from Server.log

2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:38 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 119354301
2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:38
2007-10-28 04:43:38 >> Initialized 0 instances, deleted 0 old instances
2007-10-28 04:43:38 Packing instances...
2007-10-28 04:43:38 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` <> 0
2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-10-28 04:43:38
2007-10-28 04:43:38 >> Instance numbers remapped, next instance id is 1
2007-10-28 04:43:38 Loading Game Object Templates...
2007-10-28 04:43:38 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-10-28 04:43:38 ERROR:Error loading `gameobject_template` table (not exist?)



#############################

## Crash! 2007-10-28 04:43:49. .\mangosd.exe has crashed! Lines logged from Server.log

2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:40 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1193543020)
2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:40
2007-10-28 04:43:40 >> Initialized 0 instances, deleted 0 old instances
2007-10-28 04:43:40 Packing instances...
2007-10-28 04:43:40 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` <> 0
2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-10-28 04:43:40
2007-10-28 04:43:40 >> Instance numbers remapped, next instance id is 1
2007-10-28 04:43:40 Loading Game Object Templates...
2007-10-28 04:43:40 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-10-28 04:43:40 ERROR:Error loading `gameobject_template` table (not exist?)

EDIT: Now my account name and password is wrong, but I am 100% sure I write the wrong one.

[weaselking1973]

I got some weird problem too like johny405, when I run the Mangosrestarter, the cmd pops up, and some text comes, and then closes, and repeats, and after a while the restarter says that mangos.exe crashed. I tried to drop and make a new realmd database, but that didn't work.

Any help appriciated!

Also, why is the mangosd and realmd exe files in german? ._.

crash log btw

 
## Crash! 2007-10-28 04:43:39. .mangosd.exe has crashed! Lines logged from Server.log
 
2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:38 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1193543018)
2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:38 
2007-10-28 04:43:38 >> Initialized 0 instances, deleted 0 old instances
2007-10-28 04:43:38 Packing instances...
2007-10-28 04:43:38 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` <> 0
2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-10-28 04:43:38 
2007-10-28 04:43:38 >> Instance numbers remapped, next instance id is 1
2007-10-28 04:43:38 Loading Game Object Templates...
2007-10-28 04:43:38 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-10-28 04:43:38 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-10-28 04:43:38 ERROR:Error loading `gameobject_template` table (not exist?)
 
 
 
#############################
 
## Crash! 2007-10-28 04:43:49. .mangosd.exe has crashed! Lines logged from Server.log
 
2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:40 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1193543020)
2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-10-28 04:43:40 
2007-10-28 04:43:40 >> Initialized 0 instances, deleted 0 old instances
2007-10-28 04:43:40 Packing instances...
2007-10-28 04:43:40 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` <> 0
2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-10-28 04:43:40 
2007-10-28 04:43:40 >> Instance numbers remapped, next instance id is 1
2007-10-28 04:43:40 Loading Game Object Templates...
2007-10-28 04:43:40 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-10-28 04:43:40 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-10-28 04:43:40 ERROR:Error loading `gameobject_template` table (not exist?)

EDIT: Now my account name and password is wrong, but I am 100% sure I write the wrong one.

they are in german because the build was done by someone that is german

as for your errors, drop your database "mangos" and rebuild it and dont use the updates