toteph42 / identy_switch

This plugin allows users to switch between different accounts (and check for new mails) in a single Roundcube session.
GNU General Public License v3.0
6 stars 3 forks source link

Errors in SQL migration script #10

Closed CodeShakingSheep closed 2 months ago

CodeShakingSheep commented 3 months ago

When running the INSERT statement from https://github.com/toteph42/identy_switch/blob/master/SQL/migrate.sql I get errors for the columns notify_timeout and newmail_check which don't exist in the old ident_switch table. So, in order to run the migration I had to adopt the insert statement as follows

INSERT INTO identy_switch(
    `id`,
    `user_id`,
    `iid`,
    `label`,
    `flags`,
    `imap_user`,
    `imap_pwd`,
    `imap_host`,
    `imap_port`,
    `imap_delim`,
    `smtp_host`,
    `smtp_port`,
    `drafts`,
    `sent`,
    `junk`,
    `trash`
)
SELECT
    `id`,
    `user_id`,
    `iid`,
    `label`,
    `flags`,
    `username`,
    `password`,
    `imap_host`,
    `imap_port`,
    `imap_delimiter`,
    `smtp_host`,
    `smtp_port`,
    `drafts_mbox`,
    `sent_mbox`,
    `junk_mbox`,
    `trash_mbox`
FROM
    ident_switch;