Skip to content

Clean installation fails: missing classiccharacters.ai_playerbot_db_store table during characters DB updates #443

Description

@puRe991

Bug Report: Missing ai_playerbot_db_store table after clean installation

Description

After performing a clean new installation, the Classic server fails to start while applying the characters database updates.

The startup process stops with the following error:

Applying characters db updates...
ERROR 1146 (42S02) at line 1: Table 'classiccharacters.ai_playerbot_db_store' doesn't exist

It looks like one of the characters database update scripts expects the table ai_playerbot_db_store to already exist, but the table is missing after a fresh installation.

Steps to reproduce

  1. Perform a clean installation of the Classic server.
  2. Set up the databases from scratch.
  3. Start the Classic server.
  4. Wait until the characters database updates are applied.

Actual result

The server fails to start during the characters DB update process with:

ERROR 1146 (42S02) at line 1: Table 'classiccharacters.ai_playerbot_db_store' doesn't exist

Expected result

The server should apply all required database updates successfully after a clean installation and start normally.

Database

  • Database: classiccharacters
  • Missing table: ai_playerbot_db_store

Additional context

This happens after a clean installation, not after an update from an older existing database.

It seems possible that either:

  • the table creation script for ai_playerbot_db_store is missing,
  • the database update order is incorrect,
  • or the playerbot-related characters DB update assumes an existing table that is not created during a fresh install.

Log output

Applying characters db updates...
ERROR 1146 (42S02) at line 1: Table 'classiccharacters.ai_playerbot_db_store' doesn't exist

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions