Bug 207698 - slq db probably damaged
Summary: slq db probably damaged
Status: CLOSED UNMAINTAINED
Alias: None
Product: kphotoalbum
Classification: Applications
Component: SQL backend (other bugs)
Version First Reported In: 4.0 (KDE4)
Platform: Compiled Sources Linux
: NOR major
Target Milestone: ---
Assignee: KPhotoAlbum Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-17 18:24 UTC by Jørn Erik
Modified: 2022-10-30 13:36 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jørn Erik 2009-09-17 18:24:28 UTC
Hi, I've contacted you before regarding this bug. Everytime I open the program I get the welcome screen, and I have to select what folder to have images in. Now, I think the reson why I didn't mention this the last time was because I hooked off "Do not show this message again" in the window giving the reason for the error. Here's the text I get, it's in norwegian - but I know one of you are danish?? The message comes everytime the program finds a new picture in my folder. It seemes the database gets broken. I will also add the text from the database, and you may see if you find any errors in there.

Anyway, I think the error lies here:
INSERT into exif values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>

I should probably be something else than questionmarks?

******************************************************
Det oppsto en feil under kjøring av kommandoen i SQL-motoren. Dette skyldes antakelig en ødelagt databasefil.
Rett opp dette ved å kjøre «Vedlikehold→Bygg EXIF-database på nytt».

Til hjelp i feilsøking er dette kommandoen som ble forsøkt kjørt:
INSERT into exif values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>
Dette er feilmeldingen som kom tilbake:
constraint failed Unable to fetch row
*******************************************************

THE DATABASE - it has a lot of weird characters in it, not sure if it's suposed to be like that
*******************************************************
SQLite format 3   @                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      G!i i n d e x s q l i t e _ a u t o i n d e x _ e x i f _ 1 e x i f       �    ���)�o � q (        Gb

/home/jerik/Images/# Portretter/profil2.png������������BX

/home/jerik/Images/# Portretter/p2.jpg������������[
�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 013.jpg������������[	�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 016.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 004.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 015.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 018.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 011.jpg������������Hd

/home/jerik/Images/# Portretter/jerik[1].png������������F`

/home/jerik/Images/# Portretter/jerik.jpeg������������BX

/home/jerik/Images/# Portretter/p3.jpg������������E^

/home/jerik/Images/# Portretter/Joern.gif�������      �    �7�{��"x jG � ���T            1f/home/jerik/Images/# Portretter/Picture 5.jpg-^/home/jerik/Images/# Portretter/jerik.png2h/home/jerik/Images/# Portretter/2 aug 2005.jpg+Z/home/jerik/Images/# Portretter/msn.png*X/home/jerik/Images/# Portretter/p1.jpg1f/home/jerik/Images/# Portretter/Uten navn.JPG
/b/home/jerik/Images/# Portretter/profil2.png*X/home/jerik/Images/# Portretter/p2.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 013.jpg
C�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 016.jpg	C�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 004.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 015.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 018.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 011.jpg0d/home/jerik/Images/# Portretter/jerik[1].png.`/home/jerik/Images/# Portretter/jerik.jpeg*X/home/jerik/I   C�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 018.jpg
    (  (�                            �!�at a b l e e x i f e x i f C R E A T E   T A B L E   e x i f   ( f i l e n a m e   s t r i n g   P R I M A R Y   K E Y ,   E x i f _ P h o t o _ F o c a l L e n g t h   f l o a t ,   E x i f _ P h o t o _ E x p o s u r e T i m e   f l o a t ,   E x i f _ P h o t o _ A p e r t u r e V a l u e   f l o a t ,   E x i f _ P h o t o _ F N u m b e r   f l o a t ,   E x i f _ P h o t o _ F l a s h   i n t ,   E x i f _ P h o t o _ C o n t r a s t   i n t ,   E x i f _ P h o t o _ S h a r p n e s s   i n t ,   E x i f _ P h o t o _ S a t u r a t i o n   i n t ,   E x i f _ I m a g e _ O r i e n t a t i o n   i n t ,   E x i f _ P h o t o _ M e t e r i n g M o d e   i n t ,   E x i f _ P h o t o _ I S O S p e e d R a t i n g s   i n t ,   E x i f _ P h o t o _ E x p o s u r e P r o g r a m   i n t ,   E x i f _ I m a g e _ M a k e   s t r i n g ,   E x i f _ I m a g e _ M o d e l   s t r i n g   ) G!i i n d e x s q l i t e _ a u t o i n d e x _ e x i f _ 1 e x i f 
    ( �u-��)�o � q (        Gb

/home/jerik/Images/# Portretter/profil2.png������������BX

/home/jerik/Images/# Portretter/p2.jpg������������[
�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 013.jpg������������[	�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 016.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 004.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 015.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 018.jpg������������[�

/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 011.jpg������������Hd

/home/jerik/Images/# Portretter/jerik[1].png������������F`

/home/jerik/Images/# Portretter/jerik.jpeg������������BX

/home/jerik/Images/# Portretter/p3.jpg������������E^

/home/jerik/Images/# Portretter/Joern.gif������������
    @ �q,��N	�x � @                                  �di)/home/jerik/Images/# Portretter/CIMG2907.JPG@������?��������@�����������C A S I O   C O M P U T E R   C O . , L T D . E X - S 5 0 0 �di)/home/jerik/Images/# Portretter/CIMG2903.JPG@������?�z�G�{�@�����������C A S I O   C O M P U T E R   C O . , L T D . E X - S 5 0 0 If

/home/jerik/Images/# Portretter/Picture 1.jpg������������D\

/home/jerik/Images/# Portretter/msn2.png������������CZ

/home/jerik/Images/# Portretter/eye.jpg������������If

/home/jerik/Images/# Portretter/Picture 5.jpg������������E^

/home/jerik/Images/# Portretter/jerik.png������������Jh

/home/jerik/Images/# Portretter/2 aug 2005.jpg������������CZ

/home/jerik/Images/# Portretter/msn.png������������BX

/home/jerik/Images/# Portretter/p1.jpg������������I
f

/home/jerik/Images/# Portretter/Uten navn.JPG������������
   � ��L�z��4x� jG � ���T            1f/home/jerik/Images/# Portretter/Picture 5.jpg-^/home/jerik/Images/# Portretter/jerik.png2h/home/jerik/Images/# Portretter/2 aug 2005.jpg+Z/home/jerik/Images/# Portretter/msn.png*X/home/jerik/Images/# Portretter/p1.jpg1f/home/jerik/Images/# Portretter/Uten navn.JPG
/b/home/jerik/Images/# Portretter/profil2.png*0d/home/jerik/Images/# Portretter/CIMG2907.JPG0d/home/jerik/Images/# Portretter/CIMG2903.JPG1f/home/jerik/Images/# Portretter/Picture 1.jpg2h/home/jerik/Images/# Portretter/2 aug 2005.jpg-^/home/jerik/Images/# Portretter/Joern.gif1f/home/jerik/Images/# Portretter/Picture 5.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 004.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 011.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 013.jpg
C�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 015.jpgC�/home/jerik/Images/# Portretter/Russekort Bilder/Bilde 016.jpg	
   
 7i���#
Oz��                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            ,\/home/jerik/Images/# Portretter/msn2.png1f/home/jerik/Images/# Portretter/Uten navn.JPG
+Z/home/jerik/Images/# Portretter/eye.jpg.`/home/jerik/Images/# Portretter/jerik.jpeg-^/home/jerik/Images/# Portretter/jerik.png0d/home/jerik/Images/# Portretter/jerik[1].png+Z/home/jerik/Images/# Portretter/msn.png*X/home/jerik/Images/# Portretter/p1.jpg*X/home/jerik/Images/# Portretter/p2.jpg*X/home/jerik/Images/# Portretter/p3.jpg/b/home/jerik/Images/# Portretter/profil2.png
******************************************************
Comment 1 Jørn Erik 2009-09-17 18:25:53 UTC
You see there's a lot of questionmarks in the database too...
Comment 2 Jørn Erik 2009-10-24 22:24:50 UTC
Hi again, now I have PCLinuxOS on one of my computers, and it's still acting the same. So it has to be something with how I set my computers. Maby locales? I do not think it can be my files, because I've tried many different folders.
Comment 3 Miika Turkia 2012-07-31 04:14:39 UTC
SQL backend has been dropped