Pocket Book Sync Koreader book progress with library

[llaumgui]

Yes, for the 2 questions.

[neil_swann80]

Does the book in question open with koreader as default when you click on it from the Pocketbook library?

If not, long-press on the book and choose:
Open With > koreader.app

Then reboot your device. Once rebooted select the book from the pocketbook library again and make sure it starts with koreader. Then see if progress bar is being updated.

If it still isn't working after this then I'm afraid I'm out of ideas.

[llaumgui]

Hum... Same issue... Perhaps, it's because I have renamed my Default profile on PocketBook ? database path is not the same ?

[neil_swann80]

Originally Posted by llaumgui

Hum... Same issue... Perhaps, it's because I have renamed my Default profile on PocketBook ? database path is not the same ?

If the database path has changed you'll need to correct line 14 of main.lua:

local pocketbookDbConn = SQ3.open("/mnt/ext1/system/explorer-3/explorer-3.db")

[llaumgui]

Hi,

I have /mnt/ext1/system/profiles/Guillaume/config/explorer-3... But no explorer-3.db inside...

In /mnt/ext1/system/explorer-3, I have a explorer-3.db and a explorer-3.db.lock...

[neil_swann80]

I'm happy to play around with profiles on my device at some point (something I've never set before) to see if I can figure it out.

Until then, does anybody here have a solution or idea how to proceed?

[llaumgui]

And remove .lock can be solution ?

[neil_swann80]

Originally Posted by llaumgui

And remove .lock can be solution ?

I'm not sure, might be an encrypted and profile specific part of the database.
How big is the .lock file compared to the standard .db?

You could try renaming this file and rebooting... but at your own peril as I have no idea what effect it will have on your database and read history/progress etc. (Renaming it again afterwards may not restore lost functionality).

Unless you're in a rush, wait for me to test and mess up my own device!

[jrw174]

I'm not able to check at the moment. But not having explorer db in the profiles folder leads me to be believe the db is global. Must be an identifier in the db that points to specific profile. My best guess.

The lock file shouldn't matter. But I could be wrong

[llaumgui]

Originally Posted by jrw174

Must be an identifier in the db that points to specific profile. My best guess.

Good remark ! If I check: https://github.com/ckilb/pocketbooks...#L90C14-L90C67

    local sql = [[
            REPLACE INTO books_settings
            (bookid, profileid, cpage, npage, completed, opentime)
            VALUES (?, 1, ?, ?, ?, ?)
        ]]

profileid is hardcoded... The question is now how to find my profileid...

[neil_swann80]

VALUES (?, 1, ?, ?, ?, ?)

The 1 here is the profile ID number. I've changed this on the plugin, restarted and confirmed sync no longer works. Set it back to 1, restarted koreader, sync works again.

Using the pbterm terminal emulator app on my device if I run:

id -un

I get username: reader
returned, which is the default profile.

id -u

returns: 101
(So just last character of that used?)

Perhaps try the above two commands on your device and try changing the koplugin file accordingly?

EDIT... NOPE... didn't work! - same values even in a different profile.

[llaumgui]

id return the unix user id ? Not the PocketBook profilId. For my all profil use same unix id.

[neil_swann80]

Originally Posted by llaumgui

id return the unix user id ? Not the PocketBook profilId. For my all profil use same unix id.

Yeah, I found the same. I updated my post you may have missed it.

Need a way to determine the reader profileid then...

[neil_swann80]

I've viewed the SQL for my explorer-3.db...

I have 3 profiles listed in there:

id   name
1    default
2    neil
3    test

I created the "neil" profile and deleted it, but it still shows in the database.

I set "test" as the active profile and modified the koplugin profileid to 3 and it works!!!

So, if you have only created one profile, yours should be 2.

If you want to view your own database I used the portable version from HERE
See attached - open the .db in the app, then: Browse data > Table: Profiles

The plugin will need updating to check the current active profile rather than assuming default.
/mnt/ext1/system/profiles/.current will direct to the active profile, so you can get the name easy enough. Will need an sql query to get the profileid number from the name I guess.

[llaumgui]

Originally Posted by neil_swann80

The plugin will need updating to check the current active profile rather than assuming default.

Like that:

function PocketbookSync:getProfilId()
    local file = io.open("/mnt/ext1/system/profiles/.current", "r")
    if file then
        local content = file:read("*all")
        file:close()
        local profileId = tonumber(content)
        if profileId then
            return profileId
        else
            return 1
        end
    else
        return 1
    end
end