[Release] Moffeman's WotLK Beta Repack 8788

[Moffeman]

Well, its big but its awesome

[OMGPWN]

It is really awesome but for me navicat took forever! <--on meh old comp
But download SQLyog works fast no matter how your comp is,get the trial (google it)
Execute database (wait about 2 hours maby shorter or longer)
Then delete SQLyog,lol

[niklashokke]

Hello moffeman! I have problems! Big problems! You see when i click on the database and clicks on the execute script thingy in mysql... It takes like 200 years to load anything, I dont got a bad comp.. ANd i just wounder if it shall take this long? /Hokke

[branza]

Thank You grey69 and thank you again Moffeman for this great repack.First I created in the mangos windows a account with create branza branza.Then I tried to use setbc branza 1 to upgrade to The Burning Crusade.That didn't work.My question is how do I upgrade a account so It can support Lich King beta??(I so can make dk's)

[Shao111]

Thank You grey69 and thank you again Moffeman for this great repack.First I created in the mangos windows a account with create branza branza.Then I tried to use setbc branza 1 to upgrade to The Burning Crusade.That didn't work.My question is how do I upgrade a account so It can support Lich King beta??(I so can make dk's)

Go into Navicat/SQLyog and find your accounts table, go into it and find the "tbc" field. Set it to 2 for the account your using.

[branza]

already did that but still it isn't working

[grey69]

Try restart the server.

If it still ain't working, type this in mangos.exe window

setbc accountname 2

[bobberty]

Does anyone know how in the heck fix this error?, no one answers im wonderin if no one is reading it or if just they wont answer


[Err] 1074 - Column length too big for column 'email' (max = 255); use BLOB or TEXT instead
[Err] CREATE TABLE `account` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
`username` varchar(32) NOT NULL default '',
`sha_pass_hash` varchar(40) NOT NULL default '',
`gmlevel` tinyint(3) unsigned NOT NULL default '0',
`sessionkey` longtext,
`v` longtext,
`s` longtext,
`email` varchar(320) NOT NULL default '',
`joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`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',
`mutetime` bigint(40) unsigned NOT NULL default '0',
`locale` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`),
KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=6373 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';
[Err] 1074 - Column length too big for column 'TabText' (max = 255); use BLOB or TEXT instead
[Err] CREATE TABLE `guild_bank_tab` (
`guildid` int(11) unsigned NOT NULL default '0',
`TabId` tinyint(1) unsigned NOT NULL default '0',
`TabName` varchar(100) NOT NULL default '',
`TabIcon` varchar(100) NOT NULL default '',
`TabText` varchar(500) NOT NULL default '',
PRIMARY KEY (`guildid`,`TabId`),
KEY `guildid_key` (`guildid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Err] 1146 - Table 'wotlk.account' doesn't exist
[Err] -- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `account` VALUES ('6371', 'SPEKKIEJ', '519d808ff17f3fddc6671386c19ae924e3f15ef9', '0', null, null, null, '[email protected]', '2008-08-23 15:58:41', '217.120.12.60', '0', '0', '0000-00-00 00:00:00', '0', '2', '0', '0');
[Err] 1146 - Table 'wotlk.account' doesn't exist
[Err] INSERT INTO `account` VALUES ('6372', 'HUSI12', '049bcdcd33ca9f02aea46a6073f50953d5a6e48b', '0', null, null, null, '[email protected]', '2008-08-23 15:58:45', '79.115.194.149', '0', '0', '0000-00-00 00:00:00', '0', '2', '0', '0');
[Err] 1146 - Table 'wotlk.account' doesn't exist
[Err] INSERT INTO `account` VALUES ('6373', 'MI6OBG', 'ad54efdd6376c10f7bd38fbbd7a9ef08f7ba28ee', '0', null, null, null, '[email protected]', '2008-08-23 15:59:17', '212.50.64.28', '0', '0', '0000-00-00 00:00:00', '0', '2', '0', '0');

By the way this was what I copied from Navicat when trying to execute the database.sql even if I try to redownload the Repack, also I get this problem with SQLyog but in Navicat I can skip the error but I havent let it completly execute because it was making my computer really slow but if anyone knows the problem please reply!

PLEASE HELP MOFFEMAN! YOUR MY ONLY HOPE

Oh and im still waitin to Plus rep u cause I havent gotten past the database part, I think i got this error from executing to SQLyog but I dont know, so for now I cannot execute in either Navicate or SQLyog, unless i press ignore errors or something. But from what people say it sounds like you have done a good job on this and i believe so also!

[Moffeman]

Well, the only thing YOU can do now is download a 2.4.3 MaNGOS repack and use the realmd from it, it will be the same so dont worry, download a 2.4.3 mangos repack, use the realmd.sql from it and you're ready to go.

[niklashokke]

My Heidisql seem to be stuck on " Waiting for query to complete " When i execute the database script, Is that something bugged?? Cus it have been that a whole night :P

[S1L3N7]

Can't get Death Knight unlocked. How do I fix this? I already made my gm level 3 account expansion so it should work shouldn't it?

Edit : I fixed this. I did not see that you can setbc [account] "2" and also is there anyway to make this server in English instead of German? Oh and +rep

[Moffeman]

Can't get Death Knight unlocked. How do I fix this? I already made my gm level 3 account expansion so it should work shouldn't it?

Expansion should set to 2.

[S1L3N7]

O.o you're the admin of hollywood wotlk? nice. I was just playing on that server lol. thats why it seemed so similar xD
and thanks for the help. i figured it out right before you told me but i still appreciate it
and anyway to make it english instead of german?
and all the mobs are neutral and everytime i attack i disengage in combat right away

[Moffeman]

eh, mobs are only neutral if you got .gm on

[predattak]

Hello , i have a problem... a big problem ... i set up all the things and when i enter the game i can't see the realm!!!!! plz help!!!!!omg!!