search

celguar / spp-classics-cmangos

SPP Classics repack with ike3 playerbots. Based on cmangos. Supports 1.12, 2.4.3, 3.3.5. Check "Releases" for installer
200 stars 54 forks source link

Server doesnt start (maybe: Unknown database 'wotlkplayerbots') #255

Open JuicyPPP opened 2 months ago

JuicyPPP commented 2 months ago

After the fresh installation, which went without any errors, the server cannot be started. The website is accessible, but the realm remains offline. The only error I see in the three consoles is "Unknown database 'wotlkplayerbots'"

The realmd.exe starts but stops at "realmd process priority class set to HIGH" without any errors.

Ive tried Server_Fix, Update and wipe the databases.

nugsforthugs commented 2 months ago

After the fresh installation, which went without any errors, the server cannot be started. The website is accessible, but the realm remains offline. The only error I see in the three consoles is "Unknown database 'wotlkplayerbots'"

The realmd.exe starts but stops at "realmd process priority class set to HIGH" without any errors.

Ive tried Server_Fix, Update and wipe the databases.

I had to manually go in and put all the files from SQL folder "playerbot" and execute them all manually to the database wotlkplayerbots which I created with the sql script

DROP DATABASE IF EXISTSwotlkplayerbots`;

CREATE DATABASE wotlkplayerbots DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;`

the install for WOTLK is broken, when it goes through fresh install and tries to install the database for playerbot, you'll see it say something about "System Error cannot find file" or something of that nature when it reaches the playerbot section where it has to execute the sql scripts to create the pb db, it creates all the other databases for realmd, worldserver, etc.

Execute all the scripts in sql/wotlk/playerbot yourself into the database (connect to your DB using heidisql or Keira with your mysql login info) and it will start up fine.

Be warned, WOTLK is working but crashes when you try to do a dungeon with or without bots. Not sure if they have a fix lined up for it yet, hopefully they do.

JuicyPPP commented 2 months ago

Thank you very much for this valuable information.

Be warned, WOTLK is working but crashes when you try to do a dungeon with or without bots. Not sure if they have a fix lined up for it yet, hopefully they do.

Thanks for the info. Does it mean the burning crusade run more stable? If so, I will probably use that instead.

sarge816 commented 2 months ago

@JuicyPPP I've run all 3 from SPP Classics fairly extensively over the last year, and TBC seems to be the most stable of them all. Vanilla is normally pretty good, but it's had hiccups lately, and the client software is just not nearly as polished on newer hardware. Unfortunately, WotLK had more problems than just stability, as many of the end game reputation grinds didn't work, quests were bugged in Northrend, etc. TBC runs great, the addons are mature, and the server is normally pretty stable. It will crash, but sometimes I've gotten several days out of it before that happens. We've done all the BGs, Arena. and some dungeons/raids and TBC works great for the most part. If you want more stability and aren't interested in PVP, make sure you disable bots from joining BGs. If you like BGs, the bots do a decent job and it's a load of fun but less stable.

nugsforthugs commented 2 months ago

@JuicyPPP I've run all 3 from SPP Classics fairly extensively over the last year, and TBC seems to be the most stable of them all. Vanilla is normally pretty good, but it's had hiccups lately, and the client software is just not nearly as polished on newer hardware. Unfortunately, WotLK had more problems than just stability, as many of the end game reputation grinds didn't work, quests were bugged in Northrend, etc. TBC runs great, the addons are mature, and the server is normally pretty stable. It will crash, but sometimes I've gotten several days out of it before that happens. We've done all the BGs, Arena. and some dungeons/raids and TBC works great for the most part. If you want more stability and aren't interested in PVP, make sure you disable bots from joining BGs. If you like BGs, the bots do a decent job and it's a load of fun but less stable.

Adding to this also, if you want a stable core for wotlk with bots, your best bet is https://github.com/trickerer/AzerothCore-wotlk-with-NPCBots/ - i just played for 3 hours on this, granted you gotta gear up all your bots and this and that but its easy if you enable the ahbot, put 40k items in there, then just .additem greens for them to start with and keep upgrading them as you go through leveling and dungeons.

JuicyPPP commented 2 months ago

Wow, Thank you two.

@sarge816 Okay, I see. I think I'll use then TBC. @nugsforthugs Sounds interesting. Maybe I give it a try first and check if this runs stable enough.

moxpearlnz commented 2 months ago

Yep same issue here when trying.

Would be nice to have a stable build of wotlk somewhere with playerbots (Not a big fan of NPC bots)

sarge816 commented 2 months ago

@moxpearlnz It's just seems to be the current state of CMangos and WotLK, it's not just this project. But I agree, SPP Classics has a terrific implementation of pretty much all the things I like (ease of install, customization, player bots, great working AH bot, etc.) Hopefully one day WotLK will catch up with the rest. I run a 24/7 LAN server for family and it's been a lot of fun.