Closed GoogleCodeExporter closed 9 years ago
Could you install the attached gphotoframe debug version (1.4-b2.1) and run
this in command line?
This version shows debug messeages.
What type of photo source do you set (flickr, folder...) in photo source tab?
Could you try your photo source (or other one) one by one?
Original comment by yendo0206
on 15 Jun 2011 at 5:34
Attachments:
OK, I'll install debug version.
GPhotoFrame stops changing photo on any kind of source. I have turned on
folder, flickr and facebook source of pictures.
Original comment by qki...@gmail.com
on 15 Jun 2011 at 4:49
[deleted comment]
[deleted comment]
> File "/usr/lib/python2.7/dist-packages/gphotoframe/utils/sqldb.py", line 26,
in fetchone
> data = self.db.execute(sql).fetchone()[0]
> sqlite3.OperationalError: near "5": syntax error
sqlite error?
Could you install the attached gphotoframe debug version (1.4-b2.2) and run
this in command line?
This version shows sql debug messeages.
Original comment by yendo0206
on 19 Jun 2011 at 10:35
Attachments:
Debug messages from command line:
<gphotoframe.plugins.folder.DirPhotoList object at 0xacc5e6c>
file:///home/zdjęcia/2006/07/bloom/koncert/IMG_1328.JPG
fetchone: SELECT count(*) FROM ban WHERE
url='file:///home/zdjęcia/2006/07/bloom/koncert/IMG_1328.JPG';
SELECT id, url FROM photoframe ORDER BY id DESC LIMIT 1;
INSERT INTO photoframe VALUES (2823,
'file:///home/zdjęcia/2006/07/bloom/koncert/IMG_1328.JPG', '', 'IMG_1328.JPG',
'', 1153245954.0, 'Folder', '');
INSERT INTO photoframe VALUES (2823,
'file:///home/zdjęcia/2006/07/bloom/koncert/IMG_1328.JPG', '', 'IMG_1328.JPG',
'', 1153245954.0, 'Folder', '');
fetchone: SELECT count(*) FROM photoframe
DELETE FROM photoframe WHERE id < (select id FROM photoframe ORDER BY id DESC
LIMIT 1) - 100
DELETE FROM photoframe WHERE id < (select id FROM photoframe ORDER BY id DESC
LIMIT 1) - 100
4102 10 True
<gphotoframe.plugins.folder.DirPhotoList object at 0xacc5e6c>
file:///home/zdjęcia/2006/07/Barry's Open Air Festival 2/P1080113.JPG
fetchone: SELECT count(*) FROM ban WHERE
url='file:///home/zdjęcia/2006/07/Barry's Open Air Festival 2/P1080113.JPG';
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/gphotoframe/liststore.py", line 79, in _start_timer
updated = self._change_photo()
File "/usr/lib/python2.7/dist-packages/gphotoframe/liststore.py", line 105, in _change_photo
photo_list.get_photo(self._show_photo_cb)
File "/usr/lib/python2.7/dist-packages/gphotoframe/plugins/folder.py", line 47, in get_photo
cb(None, self.photo)
File "/usr/lib/python2.7/dist-packages/gphotoframe/liststore.py", line 116, in _show_photo_cb
if self.ban_db.check_banned_for(photo.get('url')):
File "/usr/lib/python2.7/dist-packages/gphotoframe/liststore.py", line 228, in check_banned_for
return self.con.fetchone(sql)
File "/usr/lib/python2.7/dist-packages/gphotoframe/utils/sqldb.py", line 29, in fetchone
data = self.db.execute(sql).fetchone()[0]
sqlite3.OperationalError: near "s": syntax error
Original comment by qki...@gmail.com
on 23 Jun 2011 at 8:25
Thanks for your reporting.
I fixed this bug in revision 902f43226ecc.
Original comment by yendo0206
on 23 Jun 2011 at 12:24
Original issue reported on code.google.com by
qki...@gmail.com
on 14 Jun 2011 at 6:55