Calibre/Goodreader Error #75

athfrith · 2014-04-12T19:41:34Z

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 · 2014-04-12T19:47:42Z

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 · 2014-04-12T19:58:48Z

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 · 2014-04-12T20:04:50Z

Hmm.

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

athfrith · 2014-04-12T20:10:26Z

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 · 2014-04-12T20:14:25Z

Sigh. One more try.

Download and install from this link.

athfrith · 2014-04-12T20:19:22Z

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 · 2014-04-12T20:26:52Z

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 · 2014-04-12T20:38:03Z

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 · 2014-04-12T20:40:29Z

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 · 2014-04-13T21:43:18Z

@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.

…edded double quotes in sqlite identifiers. Recreated in #76.

GRiker · 2014-04-14T11:26:53Z

Update released. Thanks for your help.

GRiker mentioned this issue Apr 12, 2014

Calibre/Goodreader Error (athfrith) #76

Closed

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

Fix for GitHub issue #75?

f709c49

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

GitHub issue #75 lost, this should be a fix for properly escaping emb…

4b29749

…edded double quotes in sqlite identifiers. Recreated in #76.

GRiker closed this as completed Apr 14, 2014

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Calibre/Goodreader Error #75

Calibre/Goodreader Error #75

athfrith commented Apr 12, 2014

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 13, 2014

GRiker commented Apr 14, 2014

Calibre/Goodreader Error #75

Calibre/Goodreader Error #75

Comments

athfrith commented Apr 12, 2014

Detail:

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 12, 2014

athfrith commented Apr 12, 2014

athfrith commented Apr 12, 2014

GRiker commented Apr 13, 2014

GRiker commented Apr 14, 2014