DBError on Server Start

[It0w]

Getting following Error with the last update and the Server is Unable to start.

Server.log:

AzerothCore rev. 203f2ec7eb24+ 2022-09-27 08:40:27 -0600 (Playerbot branch) (Unix, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

   █████╗ ███████╗███████╗██████╗  ██████╗ ████████╗██╗  ██╗
  ██╔══██╗╚══███╔╝██╔════╝██╔══██╗██╔═══██╗╚══██╔══╝██║  ██║
  ███████║  ███╔╝ █████╗  ██████╔╝██║   ██║   ██║   ███████║
  ██╔══██║ ███╔╝  ██╔══╝  ██╔══██╗██║   ██║   ██║   ██╔══██║
  ██║  ██║███████╗███████╗██║  ██║╚██████╔╝   ██║   ██║  ██║
  ╚═╝  ╚═╝╚══════╝╚══════╝╚═╝  ╚═╝ ╚═════╝    ╚═╝   ╚═╝  ╚═╝
                                 ██████╗ ██████╗ ██████╗ ███████╗
                                ██╔════╝██╔═══██╗██╔══██╗██╔════╝
                                ██║     ██║   ██║██████╔╝█████╗
                                ██║     ██║   ██║██╔══██╗██╔══╝
                                ╚██████╗╚██████╔╝██║  ██║███████╗
                                 ╚═════╝ ╚═════╝ ╚═╝  ╚═╝╚══════╝

     AzerothCore 3.3.5a  -  www.azerothcore.org

> Using configuration file       /root/azeroth-server/etc/worldserver.conf
> Using SSL version:             OpenSSL 1.1.1n  15 Mar 2022 (library: OpenSSL 1.1.1n  15 Mar 2022)
> Using Boost version:           1.74.0

Daemon PID: 24075

Process priority class set to -15

Loading modules configuration...

Using modules configuration:
> mod_ahbot.conf
> AutoBalance.conf
> mod_customlogin.conf
> GainHonorGuard.conf
> mod_moneyforkills.conf
> npc_enchanter.conf
> playerbots.conf
> pocketportal.conf
> RandomEnchants.conf
> reagent_bank.conf
> mod-save-inventory.conf

Initializing Scripts...
> Loading C++ scripts

Opening DatabasePool 'acore_auth'. Asynchronous connections: 1, synchronous connections: 1.
DatabasePool 'acore_auth' opened successfully. 2 total connections running.

Opening DatabasePool 'acore_characters'. Asynchronous connections: 1, synchronous connections: 2.
DatabasePool 'acore_characters' opened successfully. 3 total connections running.

Opening DatabasePool 'acore_world'. Asynchronous connections: 1, synchronous connections: 1.
DatabasePool 'acore_world' opened successfully. 2 total connections running.

Updating Auth database...
>> Auth database is up-to-date! Containing 1 new and 34 archived updates.

Updating Character database...
>> Character database is up-to-date! Containing 1 new and 61 archived updates.

Updating World database...
>> World database is up-to-date! Containing 111 new and 3171 archived updates.

Opening DatabasePool 'acore_playerbots'. Asynchronous connections: 1, synchronous connections: 1.
DatabasePool 'acore_playerbots' opened successfully. 2 total connections running.

Updating Playerbots database...
DBUpdater: Given update include directory "/root/azerothcore-bots/modules/mod-playerbots/sql/playerbots/archive" does not exist, skipped!
>> Playerbots database is up-to-date! Containing 0 new and 0 archived updates.

Closing down DatabasePool 'acore_playerbots'.
Asynchronous connections on DatabasePool 'acore_playerbots' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_playerbots' closed.
Could not prepare statements of the Playerbots database, see log for details.
Closing down DatabasePool 'acore_playerbots'.
Asynchronous connections on DatabasePool 'acore_playerbots' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_playerbots' closed.

DBErrors.log

In mysql_stmt_prepare() id: 37, sql: "SELECT `name`, `text`, `say_type`, `reply_type`, `text_loc1`, `text_loc2`, `text_loc3`, `text_loc4`, `text_loc5`, `text_loc6`, `text_loc7`, `text_loc8` FROM `ai_playerbot_texts`"
Table 'acore_playerbots.ai_playerbot_texts' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "SELECT `name`, `text`, `say_type`, `reply_type`, `text_loc1`, `text_loc2`, `text_loc3`, `text_loc4`, `text_loc5`, `text_loc6`, `text_loc7`, `text_loc8` FROM `ai_playerbot_texts`"
Table 'acore_playerbots.ai_playerbot_texts' doesn't exist

Thanks

[htc16]

This has now been fixed, you need to update your playerbot database.

[It0w]

Oh alright. Will check quickly

Thanks

[It0w]

Sorry but i have already the newest update. Where said error occur.

-edit

How do i update the playerbot database manually ? Thanks in advance

[htc16]

delete your playerbot database and see if at boot time everything is created again, otherwise you can create a manual, or you can even update just the text of playerbots.

[It0w]

thanks for your time and advice will do as you say.

[It0w]

Okey it is working again :) thanks

For people with similar problem: use mysql-cmd

DROP DATABASE acore_playerbots;

at Server Boot recreate the Database and all done.