Hmm, thats strange, i cannot help you with that, reexecute the database then :O
Hmm, thats strange, i cannot help you with that, reexecute the database then :O
... ok hopefully it will work, if you read my first post on this thread it said that there was an error or something like that and i diddnt know what to do, but i had the executed file in SQLyog before that happened so i dont know what will happen now, but its worth a try, and doesnt work in Navicat cause i get an error. On page 8 BTW the wall of read text.
Last edited by bobberty; 08-26-2008 at 04:34 PM.
OKey....first I want to thank you Moffeman for this great repack..went through all this thread and got the same "loading group" error.I deleted the group tables and then all works fine until I get stuck at "connected".I did as grey69 suggested is his "Connected-- Fix" reply.I deleted the accounts table.The problem is that I don't know how to add these files to the database(Filebeam - Free Fast File Hosting someone please help me with this?(it's the same link that grey98 gave us):confused:
Or can someone please upload a working account.sql somewhere??Thank You
When can I expect a 8820 repack? What is required to make it?
Does anyone know how to fix this error?
[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!
Last edited by bobberty; 08-26-2008 at 09:34 PM.
I have seen 4 posts on the ad.exe and no one responds to them and out of all the people who get it to work even moffeman no one links a ad.exe that works for patch 8788 FTL. if someone gets one I would like it.
Emupedia.com - Term of use there you can find an ad.exe for 8770. Because you need the DBC and maps from 8770.
this server sucks big, unstable unfriendly unfninished spawns.
Hank
Make it better yourself then... noob... get higher than leecher before flaming >.<this server sucks big, unstable unfriendly unfninished spawns.
Hank
And ofc its unfinished, its not 100% spawned, we're working on more spawns everytime...
So try yourself, make it better, then i consider myself as owned.
sorry to post here but i tried all the advice on how ot fix the group crash but it didint mork for me still crashes on 0% loaded groups.
i also get a few errors within the executing of other files within mangos but it still carrys on just wondered if anyone ould give soem advice thanx
Fixed from help of pervious poster,
my second issue that i also find is the stuck on connected. ive tried various ways to fix it buy changing ports etc. just dont work![]()
Last edited by forthehorde13; 08-27-2008 at 11:04 AM.
whats the link for the 8820 or w/e version moffeman?? i'd like to know so i can make a up-to-date server
update: BTW moffeman, do you know when hollywood wow will go to UPDATE:8820
Last edited by cornboi; 08-27-2008 at 11:28 AM.
wow sweat man its gonna be nice