• Resolved Dono12

    (@dono12)


    The plugin install omitted some database creations. deactivating and reactivating doesn’t resolve the issue. Plugin “Tools” page under Database shows:

    wp_bm_bulk_jobsMissing

    wp_bm_bulk_job_threadsMissing

    wp_bm_ai_usageMissing

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Andrij Tkachenko

    (@andrijtkachenko)

    Hi there!

    Try to reset database in Tools button, will they be created then?

    Thanks!

    Thread Starter Dono12

    (@dono12)

    Awesome thanks for the quick response. It stated:

    Reset Database

    Delete all messages and reinstall database tables. This cannot be undone.

    I don’t want all the messages to get deleted.

    Thread Starter Dono12

    (@dono12)

    Is there a work around where I get to keep the messages, such as run a sequel query on the database to create the tables manually? If so, please advise.

    Plugin Support Andrij Tkachenko

    (@andrijtkachenko)

    No idea why not worked automatically, you need to run this mysql query then:

    CREATE TABLE wp_bm_bulk_jobs (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    sender_id bigint(20) NOT NULL,
    subject varchar(255) NOT NULL DEFAULT '',
    message longtext NOT NULL,
    selectors longtext NOT NULL,
    attachment_ids text NOT NULL,
    status varchar(20) NOT NULL DEFAULT 'pending',
    disable_reply tinyint(1) NOT NULL DEFAULT 0,
    use_existing_thread tinyint(1) NOT NULL DEFAULT 0,
    hide_thread tinyint(1) NOT NULL DEFAULT 0,
    single_thread tinyint(1) NOT NULL DEFAULT 0,
    parent_job_id bigint(20) NOT NULL DEFAULT 0,
    total_users int(11) NOT NULL DEFAULT 0,
    processed_count int(11) NOT NULL DEFAULT 0,
    error_count int(11) NOT NULL DEFAULT 0,
    current_page int(11) NOT NULL DEFAULT 1,
    scheduled_at datetime DEFAULT NULL,
    batch_size int(11) NOT NULL DEFAULT 0,
    error_log longtext DEFAULT NULL,
    created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    started_at datetime DEFAULT NULL,
    completed_at datetime DEFAULT NULL,
    PRIMARY KEY (id),
    KEY status_index (status)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

    CREATE TABLE wp_bm_bulk_job_threads (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    job_id bigint(20) NOT NULL,
    thread_id bigint(20) NOT NULL,
    message_id bigint(20) NOT NULL DEFAULT 0,
    user_id bigint(20) NOT NULL DEFAULT 0,
    PRIMARY KEY (id),
    KEY job_id_index (job_id),
    KEY thread_id_index (thread_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

    CREATE TABLE wp_bm_ai_usage (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    bot_id bigint(20) NOT NULL,
    message_id bigint(20) NOT NULL DEFAULT 0,
    thread_id bigint(20) NOT NULL DEFAULT 0,
    user_id bigint(20) NOT NULL DEFAULT 0,
    is_summary tinyint(1) NOT NULL DEFAULT 0,
    points_charged int(11) NOT NULL DEFAULT 0,
    cost_data longtext NOT NULL,
    created_at bigint(20) NOT NULL DEFAULT 0,
    PRIMARY KEY (id),
    KEY bot_id_index (bot_id),
    KEY bot_id_created_at (bot_id, created_at),
    KEY message_id_index (message_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
    Thread Starter Dono12

    (@dono12)

    Great!

    That worked, tables are now created. Thanks for the assist and the prompt replies.

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.