Project

General

Profile

Bug #11388

SQL Syntax Error in _lib_filmstrip_imgid_in_collection()

Added by David Schaefer over 2 years ago. Updated over 2 years ago.

Status:
New
Priority:
Low
Assignee:
-
Category:
-
Target version:
-
Start date:
12/25/2016
Due date:
% Done:

0%

Affected Version:
git master branch
System:
Ubuntu
bitness:
64-bit
hardware architecture:
amd64/x86

Description

I often see these issues:

(darktable:24355): Gtk-WARNING **: Allocating size to main_window 0x564f5f930370 without calling gtk_widget_get_preferred_width/height(). How does the code know the size to allocate?
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:523, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:527, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:528, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:530, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error

I tracked them down: This always happens when
- I am in darkroom
- I reject the active image with 'r'

file3 (413 KB) David Schaefer, 12/25/2016 10:19 PM

Bildschirmfoto vom 2016-12-26 12-16-09.png (2.04 MB) David Schaefer, 12/28/2016 12:04 AM

Bildschirmfoto vom 2016-12-26 12-15-51.png (2.04 MB) David Schaefer, 12/28/2016 12:04 AM

Bildschirmfoto vom 2016-12-26 12-15-33.png (155 KB) David Schaefer, 12/28/2016 12:04 AM

History

#1 Updated by Roman Lebedev over 2 years ago

  • Subject changed from SQL Syntax Error to SQL Syntax Error in _lib_filmstrip_imgid_in_collection()

#2 Updated by Roman Lebedev over 2 years ago

So the query is:

"SELECT COUNT(*) FROM main.images WHERE id=?3 AND   (flags & 256) != 256 and (flags & 7) >= 1 AND (flags & 7) != 6 AND ((film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '/home/david/Desktop/doo'))) AND (group_id = id OR group_id = -1)) JOIN (SELECT id AS film_rolls_id, folder FROM main.film_rolls) ON film_id = film_rolls_id ORDER BY folder, filename, version LIMIT ?1, ?2" 

The (group_id = id OR group_id = -1)) is particularly interesting, i do not see which brace should than last brace terminate, i.e. it was never opened.

#3 Updated by Tobias Ellinghaus over 2 years ago

Please show a screenshot of the collection module and the filter settings in the top.

#4 Updated by David Schaefer over 2 years ago

I assume the issue is related to Bug #11385.

The collection module shows: view >= 1 star sort by full path UP

Attached are 3 screenshots:
1) dt open in lighttable view.
2) darkroom open with first image
Interaction: Mouse moved over first image, r is pressed
3) still image of 2) is shown, collection reports still 2 images with 1 selection but the filmstrip shows only 1 image.

Meanwhile on the console I can read:

david@UX32VD ~> env LC_ALL=C ~/unstable/darktable/bin/darktable

(darktable:18386): Gtk-WARNING **: Allocating size to main_window 0x56519b9ee350 without calling gtk_widget_get_preferred_width/height(). How does the code know the size to allocate?
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:523, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:527, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:528, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error
sqlite3 error: /home/david/workspace/darktable.git/src/libs/tools/filmstrip.c:530, function _lib_filmstrip_imgid_in_collection(): near ")": syntax error

Also available in: Atom PDF