• Resolved jrinnc

    (@jrinnc)


    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

    (@brandtoss)

    Hello @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 1 year ago by brandtoss. Reason: provided more context
    Thread Starter jrinnc

    (@jrinnc)

    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

    (@brandtoss)

    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.