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

no such table: pixiv_master_member #607

Closed
2 tasks done
arbrog opened this issue Dec 29, 2019 · 0 comments
Closed
2 tasks done

no such table: pixiv_master_member #607

arbrog opened this issue Dec 29, 2019 · 0 comments
Labels

Comments

@arbrog
Copy link

arbrog commented Dec 29, 2019

Prerequisites

  • Did you read FAQ section?
  • Did you test with the latest releases or commit ?

Description

When using a custom dbpath and 5. Download from bookmarked artists PixivUtil defaults back to the default database location when going to actually download the images and errors (I assume) since my db.sqlite was never initialized (I was using strictly custom dbpaths so my original db.sqlite was 0 KB).

Steps to Reproduce

  1. set config to a custom dbPath
  2. run 5. Download from bookmarked artists
  3. error

Expected behavior: Download images by bookmarked artists

Actual behavior:

Include Private bookmarks [y/n/o]: o
Start Page (default=1):
End Page (default=0, 0 for no limit):
Importing Private Bookmarks...
Exporting page 1
Source URL: https://www.pixiv.net/bookmark.php?type=user&p=1&rest=hide
Using default DB Path: D:\pixiv\PixivUtil2\db.sqlite
Error at selectMemberByMemberId(): (<class 'sqlite3.OperationalError'>, OperationalError('no such table: pixiv_master_member'), <traceback object at 0x0BB46BA8>)
failed
Error at process_bookmark(): (<class 'sqlite3.OperationalError'>, OperationalError('no such table: pixiv_master_member'), <traceback object at 0x0BB46C08>)
Traceback (most recent call last):
  File "PixivUtil2.py", line 2382, in main
  File "PixivUtil2.py", line 2104, in main_loop
  File "PixivUtil2.py", line 1703, in menu_download_from_online_user_bookmark
  File "PixivUtil2.py", line 1206, in process_bookmark
  File "PixivUtil2.py", line 1184, in get_bookmarks
  File "PixivBookmark.pyc", line 33, in parseBookmark
  File "PixivDBManager.pyc", line 382, in selectMemberByMemberId2
sqlite3.OperationalError: no such table: pixiv_master_member
press enter to exit.```

`Using default DB Path: D:\pixiv\PixivUtil2\db.sqlite` despite `Using custom DB Path: ./dbPrivateArtists.sqlite` earlier on


### Versions

20191221

You can get this information from executing `PixivUtil2.py --help`.
@Nandaka Nandaka added the Bug label Jan 1, 2020
@Nandaka Nandaka closed this as completed in 85b9313 Jan 1, 2020
35122 pushed a commit to 35122/PixivUtil2 that referenced this issue Oct 30, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants