digiKam › digikam-users

failed to update database to new version error

Classic

List

Threaded

8 messages Options

jc-21

failed to update database to new version error

I have just updated to the latest version of digikam 0.8.1 using the
kubuntu rep of Achim Bohnet. When I try to run it I get the following msg

"Failed to update old Database to new Database format"

How do I solve this? I hadn't done anymore than explore the previous
version of digikam I had so if I need to delete the old db and build a new
one that would be fine.

I did rename digikam.db hoping it might force it to build new but still
get the same error.

thanks

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

___________________________________________________________
NEW Yahoo! Cars - sell your car and browse thousands of new and used cars online! http://uk.cars.yahoo.com/

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Bugzilla from ach@mpe.mpg.de

Re: failed to update database to new version error

On Thursday 16 February 2006 08:43, [hidden email] wrote:

> I have just updated to the latest version of digikam 0.8.1 using the
> kubuntu rep of Achim Bohnet. When I try to run it I get the following msg
>
> "Failed to update old Database to new Database format"
>
> How do I solve this? I hadn't done anymore than explore the previous
> version of digikam I had so if I need to delete the old db and build a new
> one that would be fine.
>
> I did rename digikam.db hoping it might force it to build new but still
> get the same error.

With rename digikam.db you still get the error? Is your picture
tree on a NFS or sambafs ? (or on local hard disk?)

df ~/Pictures

Is you picture tree (default is ~/Pictures) directory writeable?

ls -ld ~/Pictures

Can you start digikam from the command line and send us the output.

Achim

>
> thanks
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>
>
> ___________________________________________________________
> NEW Yahoo! Cars - sell your car and browse thousands of new and used cars online! http://uk.cars.yahoo.com/
>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>

--
To me vi is Zen. To use vi is to practice zen. Every command is
a koan. Profound to the user, unintelligible to the uninitiated.
You discover truth everytime you use it.
-- [hidden email]
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

jc-21

Re: failed to update database to new version error

Hi Achim
thanks for your reply.

I am running kubuntu breezy on a multi os local hd. the ~Pictures is on
the default location on my kubuntu partition. The pictures I had imported
into the previous version of digikam are on a fat32 partition on the same
hd.

df ~/Pictures/ gave
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda4 16492536 4166376 11488372 27% /

ls -ld ~/Pictures/ gave
drwxr-xr-x 2 me me 4096 2006-02-16 07:32 /home/me/Pictures/

running digikam from console gave
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq
lite_compile error: unable to open database file on query: SELECT name
FROM sqli
te_master WHERE type='table' ORDER BY name;
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq
lite_compile error: unable to open database file on query: SELECT value
FROM Set
tings WHERE keyword='Locale';
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq
lite_compile error: unable to open database file on query: REPLACE into
Settings
VALUES ('Locale','UTF-8');
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq
lite_compile error: unable to open database file on query: SELECT name
FROM sqli
te_master WHERE type='table' ORDER BY name;
digikam: WARNING: Failed to open new Album Database

thanks for your help

Martin
On Thu, 16 Feb 2006 19:43:48 -0000, Achim Bohnet <[hidden email]> wrote:

> On Thursday 16 February 2006 08:43, [hidden email] wrote:
>> I have just updated to the latest version of digikam 0.8.1 using the
>> kubuntu rep of Achim Bohnet. When I try to run it I get the following
>> msg
>>
>> "Failed to update old Database to new Database format"
>>
>> How do I solve this? I hadn't done anymore than explore the previous
>> version of digikam I had so if I need to delete the old db and build a
>> new
>> one that would be fine.
>>
>> I did rename digikam.db hoping it might force it to build new but still
>> get the same error.
>
> With rename digikam.db you still get the error? Is your picture
> tree on a NFS or sambafs ? (or on local hard disk?)
>
> df ~/Pictures
>
> Is you picture tree (default is ~/Pictures) directory writeable?
>
> ls -ld ~/Pictures
>
> Can you start digikam from the command line and send us the output.
>
> Achim
>>
>> thanks
>>
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>>
>>
>> ___________________________________________________________
>> NEW Yahoo! Cars - sell your car and browse thousands of new and used
>> cars online! http://uk.cars.yahoo.com/
>>
>> _______________________________________________
>> Digikam-users mailing list
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
>>
>

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

jc-21

Re: failed to update database to new version error

In reply to this post by jc-21

Hi Achim

thanks for your reply.

I am running kubuntu breezy on a multi os local hd. the ~Pictures is on
the default location on my kubuntu partition. The pictures I had imported
into the previous version of digikam are on a fat32 partition on the same
hd.

df ~/Pictures/ gave
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda4 16492536 4166376 11488372 27% /

ls -ld ~/Pictures/ gave
drwxr-xr-x 2 me me 4096 2006-02-16 07:32 /home/me/Pictures/

running digikam from console gave
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq lite_compile error: unable to open
database file on query: SELECT name FROM sqli
te_master WHERE type='table' ORDER BY name;
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq lite_compile error: unable to open
database file on query: SELECT value FROM Set tings
WHERE keyword='Locale';
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq lite_compile error: unable to open
database file on query: REPLACE into Settings
VALUES ('Locale','UTF-8');
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sq lite_compile error: unable to open
database file on query: SELECT name FROM sqli
te_master WHERE type='table' ORDER BY name;
digikam: WARNING: Failed to open new Album Database

thanks for your help

Martin

On Thu, 16 Feb 2006 07:43:38 -0000, <[hidden email]> wrote:

> I have just updated to the latest version of digikam 0.8.1 using the
> kubuntu rep of Achim Bohnet. When I try to run it I get the following msg
>
> "Failed to update old Database to new Database format"
>
> How do I solve this? I hadn't done anymore than explore the previous
> version of digikam I had so if I need to delete the old db and build a
> new
> one that would be fine.
>
> I did rename digikam.db hoping it might force it to build new but still
> get the same error.
>
> thanks
>

jc-21

Re: failed to update database to new version error

Problem solved. I uninstalled it and then searched for any left over files
and reinstalled and it now works.

On Fri, 17 Feb 2006 07:56:57 -0000, <[hidden email]> wrote:

> Hi Achim
>
> thanks for your reply.
>
> I am running kubuntu breezy on a multi os local hd. the ~Pictures is on
> the default location on my kubuntu partition. The pictures I had imported
> into the previous version of digikam are on a fat32 partition on the same
> hd.
>
> df ~/Pictures/ gave
> Filesystem 1K-blocks Used Available Use% Mounted on
> /dev/hda4 16492536 4166376 11488372 27% /
>
> ls -ld ~/Pictures/ gave
> drwxr-xr-x 2 me me 4096 2006-02-16 07:32 /home/me/Pictures/
>
> running digikam from console gave
> digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
> bool)] sq lite_compile error: unable to open
> database file on query: SELECT name FROM sqli
> te_master WHERE type='table' ORDER BY name;
> digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
> bool)] sq lite_compile error: unable to open
> database file on query: SELECT value FROM Set tings
> WHERE keyword='Locale';
> digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
> bool)] sq lite_compile error: unable to open
> database file on query: REPLACE into Settings
> VALUES ('Locale','UTF-8');
> digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
> bool)] sq lite_compile error: unable to open
> database file on query: SELECT name FROM sqli
> te_master WHERE type='table' ORDER BY name;
> digikam: WARNING: Failed to open new Album Database
>
> thanks for your help
>
> Martin
>
>
> On Thu, 16 Feb 2006 07:43:38 -0000, <[hidden email]> wrote:
>
>> I have just updated to the latest version of digikam 0.8.1 using the
>> kubuntu rep of Achim Bohnet. When I try to run it I get the following
>> msg
>>
>> "Failed to update old Database to new Database format"
>>
>> How do I solve this? I hadn't done anymore than explore the previous
>> version of digikam I had so if I need to delete the old db and build a
>> new
>> one that would be fine.
>>
>> I did rename digikam.db hoping it might force it to build new but still
>> get the same error.
>>
>> thanks
>>
>
>
>

Wayne-8

Re: failed to update database to new version error

On Saturday 18 February 2006 03:08 pm, [hidden email] wrote:

> Problem solved. I uninstalled it and then searched for any left over
> files and reinstalled and it now works.

Could you elaborate on this? I have the same problem (Mandriva 2006,
digikam 0.8) and can't get back into digikam anymore. I uninstalled, then
re-installed, but still can't open digikam. I even tried an older version
of digikam without success. The last thing I remember doing was renaming
or adding some Albums within digikam. Once I got out, I could no longer go
back in with the "failed to update database.." error appearing on the
screen. I'm able to open showphoto though.

Thanks,
Wayne
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

jc-21

Re: failed to update database to new version error

Sorry for not replying sooner but I just noticed your message.

I am running kubuntu which uses debian apt-get package management rather
than mandriva's rpm. I uninstalled digikam through apt and then ran
"locate digikam". I delted any serious files left ie files ending in .db
or similar - there may be icons etc that don't matter. I then just
reinstalled 0.8.1 and it worked.

Sorry if this is a bit unspecific, I didn't note the exact files I deleted.

Hope this helps

On Mon, 20 Feb 2006 18:49:09 -0000, wayne <[hidden email]> wrote:

> On Saturday 18 February 2006 03:08 pm, [hidden email] wrote:
>
>> Problem solved. I uninstalled it and then searched for any left over
>> files and reinstalled and it now works.
>
> Could you elaborate on this? I have the same problem (Mandriva 2006,
> digikam 0.8) and can't get back into digikam anymore. I uninstalled, then
> re-installed, but still can't open digikam. I even tried an older version
> of digikam without success. The last thing I remember doing was renaming
> or adding some Albums within digikam. Once I got out, I could no longer
> go
> back in with the "failed to update database.." error appearing on the
> screen. I'm able to open showphoto though.
>
> Thanks,
> Wayne
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 267.15.11/264 - Release Date:
> 17/02/2006
>
>

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

___________________________________________________________
Yahoo! Photos NEW, now offering a quality print service from just 8p a photo http://uk.photos.yahoo.com
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Wayne-8

Re: failed to update database to new version error

On Thursday 23 February 2006 08:39 am, [hidden email] wrote:

> Sorry for not replying sooner but I just noticed your message.
>
> I am running kubuntu which uses debian apt-get package management rather
> than mandriva's rpm. I uninstalled digikam through apt and then ran
> "locate digikam". I delted any serious files left ie files ending in
> .db or similar - there may be icons etc that don't matter. I then just
> reinstalled 0.8.1 and it worked.
>
> Sorry if this is a bit unspecific, I didn't note the exact files I
> deleted.
>
> Hope this helps

Thanks. I kinda remember doing something like that before without success
but try it again just to be sure.

Wayne
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users