Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLITE_ERROR on sync to local directory #3234

Closed
gnp opened this issue May 19, 2020 · 0 comments
Closed

SQLITE_ERROR on sync to local directory #3234

gnp opened this issue May 19, 2020 · 0 comments
Labels
bug It's a bug desktop All desktop platforms high High priority issues

Comments

@gnp
Copy link

gnp commented May 19, 2020

I set up sync to write to the absolute path corresponding to $HOME/Documents/Joplin Notes.

Then, I triggered a sync and got this message on the bottom left of the window:

Created remote items: 895.
Completed: 2020-05-19 11:05
Last error: Error: Error: SQLITE_ERROR: no such column: items.type_: SELECT items.`id`,items.`title`,items.`created_time`,items.`updated_time`,items.`user_created_time`,items.`user_updated_time`,items.`encryption_cipher_text`,items.`encryption_applied`,items.`parent_id`,items.`is_shared`,items.`type_` FROM `folders` items WHERE id NOT IN ( SELECT item_id FROM sync_items WHERE sync_target = 2 ) AND encryption_applied = 0 ORDER BY items.updated_time DESC LIMIT 100 :

image

I noticed a bunch of files did get created in the directory.

I created a new note to track info on this problem and later the message changed to indicate a similar problem after noting it created one item.

Later, the same message again but this time no bit about new notes (I had not created any).

Environment

I'm running this version on Mac OS X 10.15.4:

Joplin 1.0.201 (prod, darwin)

Client ID: f9ddf69c17b44c16b6aaa61bcbca4ac6
Sync Version: 1
Profile Version: 28

Revision: e65af8c (master)

Steps to reproduce

  1. Set up sync to local directory
  2. Run sync
  3. Get error message

Describe what you expected to happen

I expected sync to run without errors.

Logfile

I added the flags.txt file and restarted the app. There were warnings in console about deprecations on startup that didn't seem related.

I was unable to reproduce the issue after restarting with the flags on. I'm wondering if the state of the app after first setting up the local sync has a problem that does not appear once the app is restarted...

@gnp gnp added the bug It's a bug label May 19, 2020
@laurent22 laurent22 added desktop All desktop platforms high High priority issues labels May 19, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug It's a bug desktop All desktop platforms high High priority issues
Projects
None yet
Development

No branches or pull requests

2 participants