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

Calibre/Goodreader Error #75

Closed
athfrith opened this Issue Apr 12, 2014 · 11 comments

Comments

Projects
None yet
2 participants
@athfrith

athfrith commented Apr 12, 2014

When copying PDFs to either iPod Touch (5th Gen) or iPad Mini Retina using Calibre 1.32 and iOS Reader plugin (1.3.7) to Goodreader (v3.20.0) on iOS I get this error:

"Error Communicating with Device"

Detail:

calibre, version 1.32.0
ERROR: Error: Error communicating with device

near "Race": syntax error

Traceback (most recent call last):
File "site-packages/calibre/gui2/device.py", line 86, in run
File "site-packages/calibre/gui2/device.py", line 520, in _sync_booklists
File "/var/folders/1w/qxym__c536ldv5bqf_kfcqr40000gn/T/calibre_1.32.0_tmp_z_eLSR/xtiLmp_ios_local_db/GoodReader_overlays.py", line 684, in sync_booklists
OperationalError: near "Race": syntax error


The PDF copies totally fine but something regarding the metadata is erroring out? I get the same error whenever I use "update cached metadata on device" from the device dropdown menu.

Suggestions? Need more detail?

@GRiker

This comment has been minimized.

Collaborator

GRiker commented Apr 12, 2014

I've built a test version of the plugin with a patch that should resolve the issue.

  • Please download the pre-release version of 1.3.8 from this link to your desktop
  • Follow the directions at this link to install the plugin manually, referring to the section To install a plugin using the calibre GUI or To install a plugin using the command line.

Please report back if that resolves the problem for you.

@athfrith

This comment has been minimized.

athfrith commented Apr 12, 2014

Thanks for the quick reply!

I grabbed the pre-release and installed it.  Verified that it was 1.3.8.

Same situation - it copies the PDF but gives the error “Error communicating with Device” but this time the DETAIL is different:

Detail:


near "On": syntax error

Traceback (most recent call last):
File "site-packages/calibre/gui2/device.py", line 86, in run
File "site-packages/calibre/gui2/device.py", line 520, in _sync_booklists
File "/var/folders/1w/qxym__c536ldv5bqf_kfcqr40000gn/T/calibre_1.32.0_tmp_nO5Jp7/WIBMeQ_ios_local_db/GoodReader_overlays.py", line 684, in sync_booklists
OperationalError: near "On": syntax error

————

Need any more detail?  Need me to do anything different?

Kevin

On April 12, 2014 at 12:47:44 PM, GRiker (notifications@github.com) wrote:

I've built a test version of the plugin with a patch that should resolve the issue.

Please download the pre-release version of 1.3.8 from this link to your desktop
Follow the directions at this link to install the plugin manually, referring to the section To install a plugin using the calibre GUI or To install a plugin using the command line.
Please report back if that resolves the problem for you.


Reply to this email directly or view it on GitHub.

@GRiker

This comment has been minimized.

Collaborator

GRiker commented Apr 12, 2014

Hmm.

Ok, please try downloading another build from this link, reinstall, and try again.

@athfrith

This comment has been minimized.

athfrith commented Apr 12, 2014

This time it completely bombed out when I exited and went back into Calibre with “Error Communicating with Device” without even syncing the PDFs.

DETAIL:

—————————

Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

Traceback (most recent call last):
File "site-packages/calibre/gui2/device.py", line 86, in run
File "site-packages/calibre/gui2/device.py", line 490, in _books
File "/var/folders/1w/qxym__c536ldv5bqf_kfcqr40000gn/T/calibre_1.32.0_tmp_VCuEFT/G6COJo_ios_local_db/GoodReader_overlays.py", line 126, in books
File "/var/folders/1w/qxym__c536ldv5bqf_kfcqr40000gn/T/calibre_1.32.0_tmp_VCuEFT/G6COJo_ios_local_db/GoodReader_overlays.py", line 882, in _get_cached_metadata
ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.


On April 12, 2014 at 1:04:50 PM, GRiker (notifications@github.com) wrote:

Hmm.

Ok, please try downloading another build from this link, reinstall, and try again.


Reply to this email directly or view it on GitHub.

@GRiker

This comment has been minimized.

Collaborator

GRiker commented Apr 12, 2014

Sigh. One more try.

Download and install from this link.

@athfrith

This comment has been minimized.

athfrith commented Apr 12, 2014

Went back to the original error that I reported on (it seems) - Error Communicating with Device:

DETAIL:

near "Race": syntax error

Traceback (most recent call last):
File "site-packages/calibre/gui2/device.py", line 86, in run
File "site-packages/calibre/gui2/device.py", line 520, in _sync_booklists
File "/var/folders/1w/qxym__c536ldv5bqf_kfcqr40000gn/T/calibre_1.32.0_tmp_YfYHDk/l3nOqK_ios_local_db/GoodReader_overlays.py", line 684, in sync_booklists
OperationalError: near "Race": syntax error

On April 12, 2014 at 1:14:26 PM, GRiker (notifications@github.com) wrote:

Sigh. One more try.

Download and install from this link.


Reply to this email directly or view it on GitHub.

@GRiker

This comment has been minimized.

Collaborator

GRiker commented Apr 12, 2014

Please follow the instructions in issue #1, Creating a new issue, to set up your environment to run in debug mode. After you've done that, download and install from this link, then run calibre in debug mode and capture the debug log, pasting it into a new comment.

@athfrith

This comment has been minimized.

athfrith commented Apr 12, 2014

Done.

I hope sending it to you via an attachment is okay?

Kevin

On April 12, 2014 at 12:47:44 PM, GRiker (notifications@github.com) wrote:

I've built a test version of the plugin with a patch that should resolve the issue.

Please download the pre-release version of 1.3.8 from this link to your desktop
Follow the directions at this link to install the plugin manually, referring to the section To install a plugin using the calibre GUI or To install a plugin using the command line.
Please report back if that resolves the problem for you.


Reply to this email directly or view it on GitHub.
calibre 1.32 isfrozen: True is64bit: True
Darwin-13.1.0-x86_64-i386-64bit Darwin ('64bit', '')
('Darwin', '13.1.0', 'Darwin Kernel Version 13.1.0: Thu Jan 16 19:40:37 PST 2014; root:xnu-2422.90.20~2/RELEASE_X86_64')
Python 2.7.5
OSX: ('10.9.2', ('', '', ''), 'x86_64')
DEBUG: 0.0 iOSReaderApp:initialize(v1.3.8)

DEBUG: 21.1 *** fetching metadata for u"The Complete Idiot's Guide to Aquaponic Gardening (Idiot's Guides).pdf"
DEBUG: 21.1 *** fetching metadata for u'"Race" and Racism: The Development of Modern Racism in America.pdf'
DeviceJob: 4 Send metadata to device done, calling callback
DeviceJob: 4 Send metadata to device callback returned
DEBUG: 21.2 libiMobileDevice:get_device_list()
DEBUG: 21.2 libiMobileDevice:_idevice_get_device_list()
Job: 3 Upload 1 books to device:Mein Kampf finished
No details available.
Job: 4 Send metadata to device finished
near "Race": syntax error

Traceback (most recent call last):
  File "site-packages/calibre/gui2/device.py", line 86, in run
  File "site-packages/calibre/gui2/device.py", line 520, in _sync_booklists
  File "/var/folders/1w/qxym__c536ldv5bqf_kfcqr40000gn/T/calibre_1.32.0_tmp_KPVjBa/ESH505_ios_local_db/GoodReader_overlays.py", line 685, in sync_booklists
OperationalError: near "Race": syntax error

(edited to isolate problem area)

@athfrith

This comment has been minimized.

athfrith commented Apr 12, 2014

Ah, wait - could it be that the metasync is bombing because one of the PDFs has “race” (with the quotes) in the filename?  That might be doing it.

Gonna do a quick test.

On April 12, 2014 at 12:47:44 PM, GRiker (notifications@github.com) wrote:

I've built a test version of the plugin with a patch that should resolve the issue.

Please download the pre-release version of 1.3.8 from this link to your desktop
Follow the directions at this link to install the plugin manually, referring to the section To install a plugin using the calibre GUI or To install a plugin using the command line.
Please report back if that resolves the problem for you.


Reply to this email directly or view it on GitHub.

@GRiker

This comment has been minimized.

Collaborator

GRiker commented Apr 13, 2014

@athfrith, I was unable to access this issue for the last 24 hours or so. I'm not sure what happened, but I created another issue just in case you checked back. I'll delete that one.

You are correct that the book with the double quotes "Race" and Racism was causing the problem. I did figure that out and put a patch in place which you can download and install from this link. Even if you solved the problem on your own, I'd appreciate it if you would restore the name of the book with the double quotes (straight, not curly) and tried the latest build, since that's the version I'll be planning on releasing.

If there's an error (pretty sure there won't be), please disable debugging for libimobile device before posting another debug log.

Let me know what you find.

GRiker added a commit that referenced this issue Apr 14, 2014

GRiker added a commit that referenced this issue Apr 14, 2014

GitHub issue #75 lost, this should be a fix for properly escaping emb…
…edded double quotes in sqlite identifiers. Recreated in #76.
@GRiker

This comment has been minimized.

Collaborator

GRiker commented Apr 14, 2014

Update released. Thanks for your help.

@GRiker GRiker closed this Apr 14, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment