[GH-ISSUE #892] Shiori auto increasment not work currectly on sqlite database #407

New issue

Closed

opened 2026-02-25 23:34:09 +03:00 by kerem · 1 comment

kerem commented

2026-02-25 23:34:09 +03:00

Owner

Originally created by @Monirzadeh on GitHub (Apr 26, 2024).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/892

Data

Shiori version: 1.6.2
Database Engine: sqlite
Operating system: linux
CLI/Web interface/Web Extension: all of them

Describe the bug / actual behavior

if you add just first bookmark it will get ID 1
now if you remove that bookmark and add new bookmark it again get same ID number 1

Expected behavior

shiori always should create uniq id that not ever use.

To Reproduce

Steps to reproduce the behavior:

add bookmark a that you will get id 1 for that
delete that bookmark
add bookmark b
you will get id 1 again instead of 2 for bookmark b

Notes

it happen just in sqlite

Originally created by @Monirzadeh on GitHub (Apr 26, 2024). Original GitHub issue: https://github.com/go-shiori/shiori/issues/892 ## Data - **Shiori version**: 1.6.2 - **Database Engine**: sqlite - **Operating system**: linux - **CLI/Web interface/Web Extension**: all of them ## Describe the bug / actual behavior if you add just first bookmark it will get ID 1 now if you remove that bookmark and add new bookmark it again get same ID number 1 ## Expected behavior shiori always should create uniq id that not ever use. ## To Reproduce Steps to reproduce the behavior: 1. add bookmark a that you will get id 1 for that 2. delete that bookmark 3. add bookmark b 4. you will get id 1 again instead of 2 for bookmark b ## Notes it happen just in sqlite