jghauser / papis.nvim

Manage your bibliography from within your favourite editor
GNU General Public License v3.0
153 stars 8 forks source link

Importing database fails (non unique entries ?) #94

Closed apraga closed 3 weeks ago

apraga commented 3 weeks ago

Hi,

Trying to import the papis database with :Papis reload data fails with :

Error executing Lua callback: ...is/.local/share/nvim/lazy/sqlite.lua/lua/sqlite/stmt.lua:57: sqlite.l
ua: couldn't finalize statement, ERRMSG: UNIQUE constraint failed: data.ref stmt = (insert into data (
author, author_list, files, journal, papis_id, ref, tags, time_added, title, type, volume, year) value
s(:author, :author_list, :files, :journal, :papis_id, :ref, :tags, :time_added, :title, :type, :volume
, :year))                                                                                             
stack traceback:                                                                                      
        [C]: in function 'assert'                                                                     
        ...is/.local/share/nvim/lazy/sqlite.lua/lua/sqlite/stmt.lua:57: in function 'finalize'        
        ...exis/.local/share/nvim/lazy/sqlite.lua/lua/sqlite/db.lua:465: in function 'fn'             
        ...is/.local/share/nvim/lazy/sqlite.lua/lua/sqlite/defs.lua:665: in function 'wrap_stmts'     
        ...exis/.local/share/nvim/lazy/sqlite.lua/lua/sqlite/db.lua:459: in function 'insert'         
        ...xis/.local/share/nvim/lazy/sqlite.lua/lua/sqlite/tbl.lua:380: in function 'insert'         
        ...xis/.local/share/nvim/lazy/papis.nvim/lua/papis/data.lua:72: in function 'update_main_tbls'

        ...xis/.local/share/nvim/lazy/papis.nvim/lua/papis/data.lua:128: in function 'sync_storage_dat
a'                                                                                                    
        ...xis/.local/share/nvim/lazy/papis.nvim/lua/papis/data.lua:164: in function 'sync_db'        
        ...xis/.local/share/nvim/lazy/papis.nvim/lua/papis/data.lua:158: in function 'reset_db'       
        ....local/share/nvim/lazy/papis.nvim/lua/papis/commands.lua:20: in function 'impl'            
        ....local/share/nvim/lazy/papis.nvim/lua/papis/commands.lua:53: in function <....local/share/n
vim/lazy/papis.nvim/lua/papis/commands.lua:42>   

I don't think there are duplicated entries thouhg,

Thanks !

apraga commented 3 weeks ago

Update : there were duplicated entries found with papis doctor --all. Removing the duplicates solved it :)