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

sqlite3.OperationalError: no such table: Documents #3

Open
anaknaga opened this issue Jun 2, 2016 · 1 comment
Open

sqlite3.OperationalError: no such table: Documents #3

anaknaga opened this issue Jun 2, 2016 · 1 comment

Comments

@anaknaga
Copy link

anaknaga commented Jun 2, 2016

First, thanks for all the hard work. I'm moving to Zotero from Mendeley and I hope your program will be very helpful. However when using it I run into the following error:

`python menotexport.py -pmns ~/.local/share/data/Mendeley\ Ltd./Mendeley\ Desktop/[email protected] ~/Downloads/Mendeley_export/

: Connected to database:

/home/XXXXX/.local/share/data/Mendeley Ltd./Mendeley
Desktop/[email protected]
Traceback (most recent call last):
File "menotexport.py", line 910, in
args.separate,args.verbose)
File "menotexport.py", line 785, in main
folderlist=getFolderList(db,folder)
File "menotexport.py", line 596, in getFolderList
ret=db.execute(query)
sqlite3.OperationalError: no such table: Documents`

# uname -a Linux T450s-tumbleweed 4.5.4-1-default #1 SMP PREEMPT Wed May 11 15:23:21 UTC 2016 (db90c25) x86_64 x86_64 x86_64 GNU/Linux

mendeley version: 1.16.1

(formatting is messed up, not sure exactly why, sorry!)

@Xunius
Copy link
Owner

Xunius commented Jun 11, 2016

Hi anaknaga,
Thanks for checking out this software, and sorry for the late reply: I've been on travelling recently.

I cannot reproduce your error, even after upgrading mendeley to 1.16.1. The error occurred when trying to fetch data from the Mendeley database (in sqlite format), and somehow failed to find a table named "Documents" in the dataset. Considering you are using Mendeley already, the database can't be empty.

Could you check out the sqlite version for me, by launching into a python session python, and then

import sqlite3
sqlite3.sqlite_version
sqlite3.version

Mine are 3.9.2 and 2.6.0, respectively.
If yours are older, please try give them an upgrade, and let me know it works or not.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants