I Broke my database

[BetterRed]

Or installing every plugin known to mankind.

[kovidgoyal]

Embedding metadata is not required use Library Mainteneance->Resore database. I would recommend removing all third party plugins first, you have rahter a lot of them installed.

[mike.katina]

ok, first off I'm sorry to have left last night I got called in.

But I did (before I left) start a "restore database" from an older (previous) backup and it went through.

Drag and drop works again and I'm able to delete the previously undeletable items however now I have empty lines in my library that I cannot delete, here is the message I get...
[
calibre, version 7.24.0
ERROR: Failed to delete: Failed to delete some books, click the "Show details" button for details.

==> id:207273
Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 51, in delete_one
File "calibre\db\legacy.py", line 873, in func
File "calibre\db\view.py", line 174, in get_property
File "calibre\db\view.py", line 246, in _get
IndexError: No book with id 207273 present


==> id:216916
Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 51, in delete_one
File "calibre\db\legacy.py", line 873, in func
File "calibre\db\view.py", line 174, in get_property
File "calibre\db\view.py", line 246, in _get
IndexError: No book with id 216916 present


==> id:216917
Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 51, in delete_one
File "calibre\db\legacy.py", line 873, in func
File "calibre\db\view.py", line 174, in get_property
File "calibre\db\view.py", line 246, in _get
IndexError: No book with id 216917 present


==> id:117728
Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 51, in delete_one
File "calibre\db\legacy.py", line 873, in func
File "calibre\db\view.py", line 174, in get_property
File "calibre\db\view.py", line 246, in _get
IndexError: No book with id 117728 present


==> id:232395
Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 51, in delete_one
File "calibre\db\legacy.py", line 873, in func
File "calibre\db\view.py", line 174, in get_property
File "calibre\db\view.py", line 246, in _get
IndexError: No book with id 232395 present


==> id:117730
Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 51, in delete_one
File "calibre\db\legacy.py", line 873, in func
File "calibre\db\view.py", line 174, in get_property
File "calibre\db\view.py", line 246, in _get
IndexError: No book with id 117730 present
]

[theducks]

That can happen when the DB does not match the BOOK folders.
That kind of corruption happen when most of the things listed by others were done.
The DB MUST remain in lockstep with the folders. CaLIBRE MUST BE THE ONLY THING THAT MAKES CHANGES.

ANYTHING that breaks that, leads to the results you see.
In the case of those 'No Book with ID..." you just remove the entry since it does not point to a book (folder) Was the a case in the report where there were similar books found but no DB entry . That could be from a rename that was done by something NOT Calibre.

[mike.katina]

I strongly agree with you however do not know how this happened. I did transfer the library to a nas drive and calibre to my laptop from the main pc.

but I copy paste everything without making any change.

a fluke maybe ...

[theducks]

Originally Posted by mike.katina

I strongly agree with you however do not know how this happened. I did transfer the library to a nas drive and calibre to my laptop from the main pc.

but I copy paste everything without making any change.

a fluke maybe ...

(OS) Copy does not remove stale files, it only can Overwrite or add files.

OTOH Freefilesync will do that. but only use it in Mirror mode (that will remove now stale folder/files on the target)

:bulb) You could set mirrors for direction, but I really think that is a recipe for ERROR. Only MANAGE (Add, change or Delete) from a single place

[Sirtel]

A NAS could do it. Another major reason is adding/deleting files directly from the library folder, without going through Calibre. That's a big NO and will mess up the database immediately. All changes must be made through Calibre.

[mike.katina]

I want to take a minute and thank everyone who tried to help. Much appreciated.