ike3 / mangosbot

This is a modification of MaNGOS (Zero, One, R2, Trinity) server which brings a number of bots online and available for any player. Also allows you to use your account/guild characters as bots.
http://ike3.github.io/mangosbot-docs/
GNU General Public License v2.0
182 stars 77 forks source link

Database #60

Open Ashlon1 opened 8 years ago

Ashlon1 commented 8 years ago

Everything work now but the only problem I have is the database. I used the 3.3.5 database from Trinity and it update the world database automatic and I used the all the character_ai.sql files from the aiplayerbot.

But I can`t play it. I get everytime the message that I must update the database.

This is the error: Loading Script Names... [1054] Unknown column 'ScriptName' in 'field list' Your database structure is not up to date. Please make sure you've executed all

queries in the sql/updates folders.

I used all the slq updates from Ike3 wotlk-ai-playerbot but still the same error. Any solution for this? I really want to play wow met the random bots.

Which database are most of you using?

Ashlon1 commented 8 years ago

sorry for the caps. I don`t know how that get in to this message

Kittnz commented 8 years ago

Disable the auto updater?

Ashlon1 commented 8 years ago

Ok..I try that.

Ashlon1 commented 8 years ago

Still the same error.

This is the error: Loading Script Names... [1054] Unknown column 'ScriptName' in 'field list' Your database structure is not up to date. Please make sure you've executed all

I install the Trinity TDB 335.60 relleased this on 7 Nov 2015 · 5332 commits to 6.x since this release.

Use the .sql updates from Ike3 mangsbot folder. Disable auto update.

Can anybody tell which database they use? And how I can fix this.

ghost commented 8 years ago

Not sure if ike3 has upgraded to TDB 335.60 yet. You may want to test using TDB 335.59 still.

Ashlon1 commented 8 years ago

I tried and none are working. I get this error:

[1146] Table 'world_aiplayerbot3.3.5.creature_template_locale' doesn't exist

Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

Can someone guide me to a working database? YTDB, UDB, Project Silvermoon. Trinity????

I really want to play the game with bots.

ghost commented 8 years ago

Oh. Look at the name of your database. it is not world, but world_aiplayerbot3.3.5. Maybe you should try naming it just world instead, maybe then it will work as intended?