Title: Doesn’t Install Correctly
Last modified: August 16, 2023

---

# Doesn’t Install Correctly

 *  Resolved [jrinnc](https://wordpress.org/support/users/jrinnc/)
 * (@jrinnc)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/doesnt-install-correctly/)
 * After installing and activating the plugin then going to Mailster in the dashboard,
   it gives these errors:
 * **WordPress database error:** [Unknown column ‘published’ in ‘where clause’]
   `
   SELECT count( * ) AS unpublishedLists FROM wpbt_mailster_lists WHERE published
   ='0'`
 * **WordPress database error:** [Unknown column ‘active’ in ‘where clause’]
   `SELECT
   count( * ) AS inactiveLists FROM wpbt_mailster_lists WHERE active ='0'`
 * **WordPress database error:** [Unknown column ‘cstate’ in ‘field list’]
   `SELECT
   cstate FROM wpbt_mailster_lists WHERE id =''`
 * **WordPress database error:** [Unknown column ‘l.active’ in ‘where clause’]
   `
   SELECT l.*, inbox.server_host AS mail_in_host, inbox.server_port AS mail_in_port,
   inbox.secure_protocol AS mail_in_use_secure, inbox.secure_authentication AS mail_in_use_sec_auth,
   inbox.protocol AS mail_in_protocol, inbox.connection_parameter AS mail_in_params,
   outbox.server_host AS mail_out_host, outbox.server_port AS mail_out_port, outbox.
   secure_protocol AS mail_out_use_secure, outbox.secure_authentication AS mail_out_use_sec_auth
   FROM wpbt_mailster_lists l LEFT JOIN wpbt_mailster_servers inbox ON (l.server_inb_id
   = inbox.id) LEFT JOIN wpbt_mailster_servers outbox ON (l.server_out_id = outbox.
   id) WHERE l.active ='1' ORDER BY l.last_check ASC`
 * I had similar issues a couple years ago with installing Mailster and your response
   was that for some reason it didn’t correctly install the databases correctly 
   and that you could not recreate the issue on your end. Well, I gave up then but
   now nearly 2 years later I thought I’d try again, only to receive these errors.
   I have installed a lot of plugins and never had an issue with database tables
   not being able to be created. I’d likely be a paying customer if it would just
   install correctly!

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

 *  Plugin Author [brandtoss](https://wordpress.org/support/users/brandtoss/)
 * (@brandtoss)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/doesnt-install-correctly/#post-16983089)
 * Hello [@jrinnc](https://wordpress.org/support/users/jrinnc/),
 * we have finally identified one of the problems you had (the first DB error mentions
   a column published that in fact does no longer exist in our database schema).
 * Very sorry that this caused you trouble twice.
 * Please try again with version 1.8.9 we just released.
 * I don’t know why that other problems would show, so I hope they are coming because
   that first popped up. The weird thing is that we did not have any other reports
   in that direction with hundreds of free and pro users…
 * Thanks!
    -  This reply was modified 2 years, 9 months ago by [brandtoss](https://wordpress.org/support/users/brandtoss/).
      Reason: provided more context
 *  Thread Starter [jrinnc](https://wordpress.org/support/users/jrinnc/)
 * (@jrinnc)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/doesnt-install-correctly/#post-17007432)
 * Just an FYI update about how I was finally able to fix this… I finally realized
   that when deleting this plugin it leaves tables intact, but an old install of
   it had failed so did not create all necessary columns in the tables. When adding
   the plugin back, it does not right over those faulty tables. So, I had to manually
   delete the tables from my database. After deleting them, the plugin now installed
   without errors.
 *  Plugin Author [brandtoss](https://wordpress.org/support/users/brandtoss/)
 * (@brandtoss)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/doesnt-install-correctly/#post-17016464)
 * Aaaah, that makes sense!
 * Thanks for reporting back and happy to you can finally try it out.

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

The topic ‘Doesn’t Install Correctly’ is closed to new replies.

 * ![](https://ps.w.org/wp-mailster/assets/icon-128x128.png?rev=1580666)
 * [WP Mailster](https://wordpress.org/plugins/wp-mailster/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-mailster/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-mailster/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-mailster/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-mailster/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-mailster/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [brandtoss](https://wordpress.org/support/users/brandtoss/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/doesnt-install-correctly/#post-17016464)
 * Status: resolved