10-30-2020, 09:11 PM | #1426 |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Sorry, I don't know what you mean. The "Sync from shelf" and "Download tags from shelves" already pull information from GR. Is there something else you want?
|
10-31-2020, 01:52 PM | #1427 |
Library Breeder (She/Her)
Posts: 1,156
Karma: 1900479
Join Date: Apr 2015
Location: Fullerton, California
Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)
|
Hey, could you pretty please check out this bug report and see if you can identify why it takes so long to sync.
DEBUG: 15.4 sync_shelves - start DEBUG: 18.4 HttpHelper::get_goodreads_books_on_shelves: user_name=Scarlett Rue DEBUG: 18.4 HttpHelper::get_goodreads_books_on_shelves: shelf='currently-reading', page=1 DEBUG: 18.4 _oauth_request_get: url=https://www.goodreads.com/review/list.xml?v=2&shelf=currently-reading&page=1&per_page=200 DEBUG: 20.7 sync_shelves - returned from ChooseShelvesToSyncDialog DEBUG: 20.7 sync_shelves - About to open DoShelfSyncDialog DEBUG: 27.7 CalibreDbHelper::apply_actions_to_calibre - actions: [{u'action': u'ADD', u'value': u'Currently Reading', u'column': u'#exclusiveshelf'}, {u'action': u'ADD', u'value': u'date_added', u'column': u'#grdateadded'}, {u'action': u'ADD', u'value': u'Currently Reading', u'column': u'#readstatus'}, {u'action': u'ADD', u'value': u'date_updated', u'column': u'#gr_updateded'}, {u'action': u'ADD', u'value': u'1.Current', u'column': u'#calibrelibrary'}, {u'action': u'ADD', u'value': u'Y', u'column': u'#ingr'}, {u'action': u'REMOVE', u'value': u'Placeholder.Maybe', u'column': u'#book_style'}, {u'action': u'REMOVE', u'value': u'Placeholder.Pre-Ordered', u'column': u'#book_style'}, {u'action': u'REMOVE', u'value': u'Placeholder.Waiting for it', u'column': u'#book_style'}, {u'action': u'REMOVE', u'value': u'Placeholder.Want to Read', u'column': u'#book_style'}] DEBUG: 28.0 sync_shelves - returned from DoShelfSyncDialog DEBUG: 28.0 sync_shelves - About to _update_goodreads_ids DEBUG: 41.3 sync_shelves - finished _update_goodreads_ids DEBUG: 47.6 sync_shelves - start DEBUG: 50.7 HttpHelper::get_goodreads_books_on_shelves: user_name=Scarlett Rue DEBUG: 50.7 HttpHelper::get_goodreads_books_on_shelves: shelf='dnf', page=1 DEBUG: 50.7 _oauth_request_get: url=https://www.goodreads.com/review/list.xml?v=2&shelf=dnf&page=1&per_page=200 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 181 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 193 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 300 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 299 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 299 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 310 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 300 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 310 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 299 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 310 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 230 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 54 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 310 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 320 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 320 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 310 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 260 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 228 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 154 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 300 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 319 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 34 DEBUG: 61.9 _convert_review_xml_node_to_book: length of review_text= 300 DEBUG: 62.0 _convert_review_xml_node_to_book: length of review_text= 310 DEBUG: 62.0 _convert_review_xml_node_to_book: length of review_text= 160 DEBUG: 62.0 _convert_review_xml_node_to_book: length of review_text= 236 DEBUG: 62.0 _convert_review_xml_node_to_book: length of review_text= 315 DEBUG: 62.0 _convert_review_xml_node_to_book: length of review_text= 300 DEBUG: 62.0 sync_shelves - returned from ChooseShelvesToSyncDialog DEBUG: 62.0 sync_shelves - About to open DoShelfSyncDialog DEBUG: 64.6 CalibreDbHelper::apply_actions_to_calibre - actions: [{u'action': u'ADD', u'value': u'DNF', u'column': u'#exclusiveshelf'}, {u'action': u'ADD', u'value': u'date_updated', u'column': u'#gr_updateded'}, {u'action': u'ADD', u'value': u'date_added', u'column': u'#grdateadded'}, {u'action': u'ADD', u'value': u'Y', u'column': u'#ingr'}, {u'action': u'ADD', u'value': u'DNF', u'column': u'#readstatus'}, {u'action': u'ADD', u'value': u'1.Archived', u'column': u'#calibrelibrary'}, {u'action': u'ADD', u'value': u'none', u'column': u'#dr1'}, {u'action': u'ADD', u'value': u'none', u'column': u'#dr1'}, {u'action': u'ADD', u'value': u'none', u'column': u'#grdateread'}, {u'action': u'REMOVE', u'value': u'1.Current', u'column': u'#calibrelibrary'}, {u'action': u'REMOVE', u'value': u'1.Erotic', u'column': u'#calibrelibrary'}, {u'action': u'REMOVE', u'value': u'1.Erotica', u'column': u'#calibrelibrary'}, {u'action': u'REMOVE', u'value': u'1.Re-reads', u'column': u'#calibrelibrary'}, {u'action': u'REMOVE', u'value': u'1.Unread', u'column': u'#calibrelibrary'}, {u'action': u'REMOVE', u'value': u'1/aNext up tbr', u'column': u'#details'}, {u'action': u'REMOVE', u'value': u'Amazon.On Deck', u'column': u'#details'}, {u'action': u'REMOVE', u'value': u'in1221', u'column': u'#details'}] DEBUG: 67.4 sync_shelves - returned from DoShelfSyncDialog DEBUG: 67.4 sync_shelves - About to _update_goodreads_ids DEBUG: 157.5 sync_shelves - finished _update_goodreads_ids Actually, it is running a bit faster, but I am trying it on different shelves that either have a lot of reviews, or no review but both have no additional sync rules beyond updating two shelves. I will post the results Last edited by Rellwood; 10-31-2020 at 01:59 PM. |
11-07-2020, 04:27 AM | #1428 | |
Wizard
Posts: 1,775
Karma: 2694823
Join Date: Dec 2011
Location: The Netherlands
Device: Kobo Touch, Glo, Clara HD
|
Quote:
Is there a setting somewhere I need to toggle? I can't find it... |
|
11-07-2020, 05:03 AM | #1429 | ||
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Quote:
The attached beta should solve this. And it also has a lot of debugging output in between those last two lines that should give me a better idea of what is going on. Last edited by davidfor; 12-25-2020 at 11:36 PM. Reason: Removed beta as it has been released. |
||
11-07-2020, 05:11 AM | #1430 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
No, because there isn't an option for it. When you set progress, it should have caused the book to be put on the "Currently Reading" shelf. But, it didn't always happen. And, I've never worked out why. The "Yes" is because someone convinced me to add an option to do it. The recent betas have this. There is an option on the update progress dialog to put the book on the "Currently Reading" shelf when setting the progress. It actually does this each time the progress is updated (until finished) but it doesn't seem to harm anything. Try the beta I just posted and tell me if it is OK. |
|
11-07-2020, 09:39 AM | #1431 | |
Wizard
Posts: 1,775
Karma: 2694823
Join Date: Dec 2011
Location: The Netherlands
Device: Kobo Touch, Glo, Clara HD
|
Quote:
Thank you! |
|
11-11-2020, 12:46 PM | #1432 |
Junior Member
Posts: 3
Karma: 10
Join Date: Nov 2020
Device: Kindle
|
Unable to Authorize Plugin with Goodreads
Hello,
When I try to authorzie Plugin with Goodreads I get the below error. Can you please suggest what might be the problem ? Thanks in advance, Lewapq Code:
calibre, version 5.4.2 ERROR: Unhandled exception: <b>SSLHandshakeError</b>:[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get issuer certificate (_ssl.c:1123) calibre 5.4.2 embedded-python: True is64bit: False Windows-10-10.0.18362 Windows ('32bit', 'WindowsPE') 32bit process running on 64bit windows ('Windows', '10', '10.0.18362') Python 3.8.5 Windows: ('10', '10.0.18362', '', 'Multiprocessor Free') Interface language: None Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (1, 35, 0) && Package KFX (from KFX Input) (1, 35, 0) && Amazon.com Multiple Countries (1, 0, 0) && Author Book Count (2, 1, 9) && Barnes & Noble (1, 2, 16) && Find Duplicates (1, 8, 3) && Goodreads (1, 5, 1) && Goodreads Sync (1, 14, 3) && Goodreads_Rating (3, 1, 0) && KFX metadata reader (from KFX Input) (1, 35, 0) && KFX Input (1, 35, 0) && Kindle Collections (1, 7, 29) && LubimyCzytac (2, 0, 46) Traceback (most recent call last): File "calibre_plugins.goodreads_sync.httplib2.__init__", line 1096, in connect File "calibre_plugins.goodreads_sync.httplib2.__init__", line 117, in _ssl_wrap_socket File "ssl.py", line 500, in wrap_socket File "ssl.py", line 1040, in _create File "ssl.py", line 1309, in do_handshake ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get issuer certificate (_ssl.c:1123) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "calibre_plugins.goodreads_sync.config", line 1118, in authorize_plugin File "calibre_plugins.goodreads_sync.core", line 215, in get_request_token_secret File "calibre_plugins.goodreads_sync.core", line 131, in _oauth_request_get File "calibre_plugins.goodreads_sync.oauth2.__init__", line 689, in request File "calibre_plugins.goodreads_sync.httplib2.__init__", line 1689, in request File "calibre_plugins.goodreads_sync.httplib2.__init__", line 1429, in _request File "calibre_plugins.goodreads_sync.httplib2.__init__", line 1349, in _conn_request File "calibre_plugins.goodreads_sync.httplib2.__init__", line 1122, in connect calibre_plugins.goodreads_sync.httplib2.SSLHandshakeError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get issuer certificate (_ssl.c:1123) |
11-11-2020, 09:48 PM | #1433 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
I have checked that it is working from here. One of the above reasons is the most likely cause. |
|
11-12-2020, 04:04 PM | #1434 | |
Junior Member
Posts: 3
Karma: 10
Join Date: Nov 2020
Device: Kindle
|
Quote:
|
|
11-13-2020, 10:06 PM | #1435 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Looking at the certificate, it is issued by Amazon with themselves as the CA. Though there seems to be "Starfire" involved as well. Looking at discussion about the error on the web, it does look like how the certificates are handled has changed with Python 3.6 or thereabout. I'll have to think about what can be done. |
|
11-14-2020, 01:15 PM | #1436 |
Junior Member
Posts: 4
Karma: 10
Join Date: Mar 2017
Device: Kindle
|
I tried the last attached Beta to see if it would solve my performance problem. I have a large database both at Goodreads and locally and Sync used to need about 1 second per book as it slowly updated them (there was a progress bar).
With the beta version I did a dummy sync and the final phase that used to take half an hour was fast enough for me to not notice. I hope that means that your fix works. Also, thanks a lot for your work on these plugins. I really appreciate it! |
11-14-2020, 03:07 PM | #1437 |
Junior Member
Posts: 3
Karma: 10
Join Date: Nov 2020
Device: Kindle
|
OK thanks.
|
11-21-2020, 11:35 AM | #1438 |
Connoisseur
Posts: 97
Karma: 1940
Join Date: Apr 2009
Location: Denver, CO
Device: Libra H2O
|
Hopefully this belongs here When plugging my Kobo Clara in and letting the reading percentage update. I get an error on the "Upload to Goodreads" portion.
calibre, version 5.5.0 ERROR: Unhandled exception: <b>TypeError</b>:can only concatenate str (not "bytes") to str calibre 5.5 embedded-python: True is64bit: True macOS-10.16-x86_64-i386-64bit Darwin ('64bit', '') ('Darwin', '20.1.0', 'Darwin Kernel Version 20.1.0: Sat Oct 31 00:07:11 PDT 2020; root:xnu-7195.50.7~2/RELEASE_X86_64') Python 3.8.5 OSX: ('10.16', ('', '', ''), 'x86_64') Interface language: None Successfully initialized third party plugins: Goodreads Sync (1, 14, 3) && KePub Output (3, 4, 1) && Kobo Books (1, 8, 0) && Kobo Utilities (2, 11, 8) && KoboTouchExtended (3, 4, 1) && Prettify Cover (1, 5, 0) Traceback (most recent call last): File "calibre_plugins.goodreads_sync.dialogs", line 713, in action_button_clicked self.grhttp.update_status(client, goodreads_id, progress, self.progress_is_percent, review_text) File "calibre_plugins.goodreads_sync.core", line 386, in update_status response, _content = self._oauth_request_post(oauth_client, url, body, success_status) File "calibre_plugins.goodreads_sync.core", line 151, in _oauth_request_post return self._handle_failure(response, content, url) File "calibre_plugins.goodreads_sync.core", line 195, in _handle_failure detail = 'URL: ' + url + '\nResponse Code: ' + response['status'] +'\n' + content TypeError: can only concatenate str (not "bytes") to str I also get this error when manually running the sync from shelf function. |
11-21-2020, 10:30 PM | #1439 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
|
|
11-22-2020, 10:29 AM | #1440 |
Connoisseur
Posts: 97
Karma: 1940
Join Date: Apr 2009
Location: Denver, CO
Device: Libra H2O
|
Awesome, that seemed to have solved it. Synced right away (well after I re-authorized, LOL).
Can keep an eye on it and report back, is there anything you need me to pay special attention to? Happy to send along any logs ya need. |
Tags |
calibre, goodreads |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Clipboard Search | kiwidude | Plugins | 29 | 04-02-2024 10:05 PM |
[GUI Plugin] Search the Internet | kiwidude | Plugins | 433 | 04-01-2024 05:48 PM |
[GUI Plugin] Open With | kiwidude | Plugins | 403 | 04-01-2024 08:39 AM |
[GUI Plugin] Quick Preferences | kiwidude | Plugins | 62 | 03-16-2024 11:47 PM |
[GUI Plugin] Book Sync **Deprecated** | kiwidude | Plugins | 111 | 06-07-2011 07:47 PM |