Recent Posts

Pages: [1] 2 3
1
Windows / Extended Bot Patch Drama
« Last post by Akaitatsu on November 01, 2017, 06:37:42 pm »
Just kind of dumping some notes at this point. I'm getting error after error...

Added these two settings:
Code: [Select]
LogsDir = "logs"
PacketLogFile = "logs"

New error:
Missing name PrepatchGI.Added in config file aiplayerbot.conf, add "PrepatchGI.Added = 0" to this file
Received that eight times then World Server crashed. Added the config option even though it was already in the worldserver.conf.

Next errors:
[1146] Table 'characters.ai_playerbot_guild_names' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

Not sure how I missed that before but I added it using the supplied script. The script ran fine but returned the following warning.

641 row(s) affected, 1 warning(s): 1406 Data too long for column 'name' at row 441 Records: 641  Duplicates: 0  Warnings: 1

`name` varchar(24) NOT NULL UNIQUE - "The Daughters of the Elite" is 26 characters.

Newest error:
Player::_LoadSkills: Player 'Rastruivincu' (GUID Full: 0x00000000000000e2 Type: Player Low: 226, Race: 4, Class: 4) has forbidden skill 55 for his race/class combination
Player::_LoadSkills: Player 'Rastruivincu' (GUID Full: 0x00000000000000e2 Type: Player Low: 226, Race: 4, Class: 4) has forbidden skill 136 for his race/class combination
Player::_LoadSkills: Player 'Rastruivincu' (GUID Full: 0x00000000000000e2 Type: Player Low: 226, Race: 4, Class: 4) has forbidden skill 160 for his race/class combination
Player::_LoadSkills: Player 'Rastruivincu' (GUID Full: 0x00000000000000e2 Type: Player Low: 226, Race: 4, Class: 4) has forbidden skill 172 for his race/class combination
Player::_LoadSkills: Player 'Rastruivincu' (GUID Full: 0x00000000000000e2 Type: Player Low: 226, Race: 4, Class: 4) has forbidden skill 228 for his race/class combination
Player::_LoadSkills: Player 'Rastruivincu' (GUID Full: 0x00000000000000e2 Type: Player Low: 226, Race: 4, Class: 4) has forbidden skill 229 for his race/class combination


Client hangs on "Connected" screen. worldserver.exe does not respond to Ctrl+C.

I used the command character erase and it removed the offending character. I stopped the worldserver; well, tried to. During shutdown, it crashed. I started it back up and got the following error.

Error creating guild Last Ptesanwi

This is getting pretty ridiculous. Every time I try to look up an error or other message, Google refers me to the old git documentation or code or something else that isn't there anymore. I don't know how much further I can go with this. I am a DBA with a background in C# but that is all in a business setting. I have done some game programming tutorials for Unity but I have never done anything on the scale of a MMORPG. I will try to fix the stuff in the database but I probably won't be in a big hurry. This is starting to be too much like work.

OK, I am pretty much done with this, at least for a while. I deleted the guild that had the above error. When I started the world server back up, I got over 500 errors. Some examples follow.
  • Player::_LoadSkills: Player 'Astui' (GUID Full: 0x000000000000003a Type: Player Low: 58, Race: 10, Class: 8) has forbidden skill 44 for his race/class combination
  • Error creating guild The Legion of Death
  • No trade items available for bot Otuaoau (3 level)
  • No pets available for bot Otuaoau (3 level)
  • No trade items available for bot Iistawoi (9 level)
I am going to blow away this test database and re-import from my live TC server but it may be a while before I get back to it. Right now it's just a hot mess, IMO.
2
Windows / [Fixed] No more names left for random bots
« Last post by Akaitatsu on October 30, 2017, 08:23:15 pm »
I slept a few times and played some more WoW on my server. Then I got to Googling this some more and found a script to properly create and populate the ai_playerbot_names table: https://github.com/ike3/mangosbot/blob/trinity-wotlk-ai/sql/characters_ai_playerbot_real_names.zip.

No more "No more names left for random bots" messages!

Unfortunately, running the rndbot init command still has the same results.

I went ahead and logged into my server and tried summoning a bot. The command appears to have worked but I don't see my player bot anywhere. Again, when I walk around a little bit the server crashes. I got the following in the console window so will fix those before I try again, maybe in a couple days.

Missing name LogsDir in config file aiplayerbot.conf, add "LogsDir = " to this file
Missing name PacketLogFile in config file aiplayerbot.conf, add "PacketLogFile = " to this file
3
Windows / [Fixed] Missing name AiPlayerbot.XyZ in config file
« Last post by Akaitatsu on October 28, 2017, 09:15:46 pm »
I got a bunch of messages similar to Missing name AiPlayerbot.GlobalCooldown in config file aiplayerbot.conf, add "AiPlayerbot.GlobalCooldown = 500" to this file. Some of the settings existed in the aiplayerbot.conf but were commented out. I removed the comment symbol and that took care of a majority of the these items. The ones listed below were not in the conf file so I added them.
Code: [Select]
AiPlayerbot.RandomClassSpecProbability.0.0 = 33
AiPlayerbot.RandomClassSpecProbability.0.1 = 33
AiPlayerbot.RandomClassSpecProbability.0.2 = 33
AiPlayerbot.RandomClassSpecProbability.6.0 = 33
AiPlayerbot.RandomClassSpecProbability.6.1 = 33
AiPlayerbot.RandomClassSpecProbability.6.2 = 33
AiPlayerbot.RandomClassSpecProbability.10.0 = 33
AiPlayerbot.RandomClassSpecProbability.10.1 = 33
AiPlayerbot.RandomClassSpecProbability.10.2 = 33
AiPlayerbot.MinRandomBotReviveTime = 60
AiPlayerbot.MaxRandomReviveTime = 300
Ra.Enable = 0
SOAP.Enabled = 0
BindIP = 0.0.0.0
Network.Threads = 1
Network.TcpNodelay = 1
Network.OutKBuff = -1
Network.OutUBuff = 65536
Console.Enable = 1
BeepAtStart = 1
MaxCoreStuckTime = 0
DataDir = .

There were also a ton of No more names left for random bots messages. I thought that might need to be initialized so I ran the rndbot init command. The world server spat out the following to the console:
Table `command` contains an unexpected subcommand 'items' in command 'ahbot items', skipped.
Table `command` contains an unexpected subcommand 'items gray' in command 'ahbot items gray', skipped.
Table `command` contains an unexpected subcommand 'items white' in command 'ahbot items white', skipped.
Table `command` contains an unexpected subcommand 'items green' in command 'ahbot items green', skipped.
Table `command` contains an unexpected subcommand 'items blue' in command 'ahbot items blue', skipped.
Table `command` contains an unexpected subcommand 'items purple' in command 'ahbot items purple', skipped.
Table `command` contains an unexpected subcommand 'items orange' in command 'ahbot items orange', skipped.
Table `command` contains an unexpected subcommand 'items yellow' in command 'ahbot items yellow', skipped.
Table `command` contains an unexpected subcommand 'ratio' in command 'ahbot ratio', skipped.
Table `command` contains an unexpected subcommand 'ratio alliance' in command 'ahbot ratio alliance', skipped.
Table `command` contains an unexpected subcommand 'ratio horde' in command 'ahbot ratio horde', skipped.
Table `command` contains an unexpected subcommand 'ratio neutral' in command 'ahbot ratio neutral', skipped.
Table `command` contains an unexpected subcommand 'rebuild' in command 'ahbot rebuild', skipped.
Table `command` contains an unexpected subcommand 'reload' in command 'ahbot reload', skipped.
Table `command` contains an unexpected subcommand 'status' in command 'ahbot status', skipped.


It's possible that the No more names thing is caused by the missing ai_playerbot_names table. I suspect that there are some scripts that go with that table and just creating the table empty isn't enough.
4
Windows / [Fixed] [1146] Table 'characters.ai_playerbot_names' doesn't exist
« Last post by Akaitatsu on October 28, 2017, 06:34:42 pm »
I added the ai_playerbot_names table using the script below (based on the Magos docs linked previously). That got me past the [1146] Table 'characters.ai_playerbot_names' doesn't exist error.
Code: [Select]
DROP TABLE IF EXISTS `ai_playerbot_names`;
CREATE TABLE `ai_playerbot_names` (
  `name_id` mediumint(8) NOT NULL AUTO_INCREMENT UNIQUE,
  `name` varchar(24) NOT NULL UNIQUE,
  `gender` TINYINT(3) UNSIGNED NOT NULL,
  `race` SMALLINT(5) UNSIGNED NOT NULL,
  `class` SMALLINT(5) UNSIGNED NOT NULL,
  `purpose` INT(11) UNSIGNED NOT NULL,
  `priority` BIT(1) NOT NULL,
  `in_use` BIT(1) NOT NULL,
  PRIMARY KEY (`name_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='PlayerbotAI names';

I am getting some other errors and the server crashes after adding a Player Bot and moving around for a little bit. There are also some warnings/errors in the WorldServer console output. I will see if I can work through those. Some of them look obvious and I will post any fixes or further information if I get stuck.
5
Windows / Errors after applying 2017_10_19-LordPsyanBots.patch
« Last post by Akaitatsu on October 28, 2017, 11:57:35 am »
After applying 2017_10_19-LordPsyanBots.patch my WorlServer fails to start with the error [1146] Table 'characters.ai_playerbot_names' doesn't exist.

Here is what I was running successfully before I applied the Bots patch:
  • TrinityCore rev. 3eb0cfc687da 2017-10-20 23:34:45 +0200 (3.3.5 branch) (Win64, RelWithDebInfo, Static)
  • 335a_prepatch.patch
  • 2017_10_20-Cheats-FastFishing-AttackAndRespawnSpeed.patch

I searched through the code after applying the patch and couldn't find any reference to the table.

There wasn't much about this table on Google but I did find a link to an old issue reported on GitHub: https://github.com/LordPsyan/LordPsyanBots/issues/13. Whoever reported it figured out that the problem was but the link to their solution is out of date.

There is a reference to the table at https://www.getmangos.eu/wiki/referenceinfo/dbinfo/characterdb/mangoszerochardb/ai_playerbot_names-r1504/ but I can't tell if it's sufficient to just add the table based on the specs from this page or not. I'll give that a shot on my test instance tonight or tomorrow.

If anyone has any other ideas before I get to adding the table myself, please share!
6
General Discussion / New git server for lordpsyanbots and patches
« Last post by LordPsyan on August 10, 2017, 04:50:33 am »
No longer using bitbucket or github. I have switched to http://git.realmsofwarcraft.com
7
General Discussion / Re: Blah
« Last post by Amelthia on February 01, 2017, 12:22:00 pm »
changed combatability mode and got in.
8
General Discussion / Re: Blah
« Last post by Amelthia on February 01, 2017, 08:58:11 am »
well i can get in, but i get DC as soon as i get into the world
9
General Discussion / Re: Blah
« Last post by Amelthia on January 31, 2017, 11:32:49 am »
ruled out a firewall problem ( turned it off) , still get the "login server down" error. Realm list is set, check to make sure i was on the right version of wow. any ideas?
10
General Discussion / Re: Blah
« Last post by Amelthia on January 31, 2017, 08:50:58 am »
On the fun server, im on 3.3.5. atm says login server down now so idk
Pages: [1] 2 3