search

mikegioia / libremail

IMAP ➝ SQL syncing engine, JavaScript-free email client, and a Kanban-style email client
Other
120 stars 12 forks source link

Sync update DB option may be failing on empty database #116

Closed netandreus closed 4 years ago

netandreus commented 4 years ago

Describe the bug There is sql error, during run ./sync --updatedb on clear database for 006_meta.sql

To Reproduce Steps to reproduce the behavior:

  1. Clear database
  2. Run ./sync --updatedb

Expected behavior Fulfilled database structure.

Screenshots updatedb-bug

Desktop (please complete the following information):

mikegioia commented 4 years ago

@netandreus I can't reproduce this one. I tried on a clean database and with a newly cloned repo. Do you happen to have any more info here? Like what version of MySQL you're using etc. The fix you sent looks to be no different than this, just that the INSERT statement is in a separate file.

netandreus commented 4 years ago

Ok, I will reproduce this case this evening collecting all logs and write here.

mikegioia commented 4 years ago

I forgot to update this issue, sorry @netandreus. I merged this branch in over the weekend, and it should be in master now!