sql

  • How to solve database errors?

    If you see an error about missing Mailster tables, visit your update page at https://yourdomain.com/wp-admin/admin.php?page=mailster_update (replace with your domain) to fix it. Alternatively, deactivate and reactivate the plugin to run a database check and create any missing campaigns.

  • Mailster Database Structure

    Mailster stores subscribers, lists, forms, queues, logs, and interaction events in custom tables using the InnoDB engine and utf8mb4_unicode_520_ci collation. The prefix adapts to your WordPress installation (shown below as wp_). 💡 Tip: Interact with this data via Mailster’s APIs and hooks. Direct SQL edits are rarely necessary. Action Tables (Events) These tables record sends, opens, clicks, bounces, unsubscribes, and errors for analytics and deliverability tracking. wp_mailster_action_bounces Stores bounce events. hard = 1 indicates a hard bounce; text contains the raw message from the mail server. wp_mailster_action_clicks Logs click events inside email campaigns. Each record represents a unique click instance.…