Bug #1935

If you before invoking "Mark All As Seen..." from page menu, manually set "Mark as seen" on some items - you get SQL error

Added by rick diskon about 7 years ago. Updated about 7 years ago.

Status:FixedStart date:02/07/2014
Priority:NormalDue date:
Assignee:Andreas Smas% Done:

100%

Category:Metadata
Target version:4.6
Found in version:4.5.57 Platform:PS3

Associated revisions

Revision ab6c0830
Added by Andreas Smas about 7 years ago

Fix broken "Mark all as seen"

Only happened when we needed to insert new items in DB

Fixes #1935

Change included in version 4.5.60

History

#1 Updated by rick diskon about 7 years ago

If one or more files in a folder have been marked as "Seen", the Mark all as seen... command does not work, whether the currently selected item is a folder, a "seen" file, or an "unseen" file.

Conversely, the "Mark all as unseen..." command does not exhibit the issue, and succeeds whenever one or more files is marked as "seen", and no matter what type of item is currently selected.

#2 Updated by Leonid Protasov about 7 years ago

  • Subject changed from "Mark All As Seen..." fails in folders with mixed "seen" status to If you before invoking "Mark All As Seen..." from page menu, manually set "Mark as seen" on some items - you get SQL error
  • Category changed from General to Metadata
  • Assignee set to Andreas Smas
  • Target version set to 4.6

All platforms. When you "Mark all as seen..." you get in log:

SQLITE [ERROR]: near "1": syntax error (code: 1)
SQLITE [ERROR]: SQL Error 1 at /root/showtime/src/metadata/metadb.c:2853

#3 Updated by Andreas Smas about 7 years ago

  • Status changed from New to Fixed
  • % Done changed from 0 to 100

Applied in changeset git|commit:ab6c083052b2c7d0432b11b452df2315e1ec1db0.

Also available in: Atom PDF