thumbnails always rebuilt using mysql

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

thumbnails always rebuilt using mysql

Johannes Wienke-3
Hi,

I just tried to move my collection to mysql and noticed that something
must be broken with the thumbnail handling in the mysql backend. If I
switch to mysql using a separate schema for thumbnails, the thumbnails
are rebuilt each time I start digikam. Moreover, after restarting, the
thumbnails schema name field in the settings is empty. Can anyone
confirm this?

Regards,
Johannes


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

signature.asc (270 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: thumbnails always rebuilt using mysql

Gilles Caulier-4
You use a separate schema for thumbnails ?

Gilles

2010/7/17 Johannes Wienke <[hidden email]>:

> Hi,
>
> I just tried to move my collection to mysql and noticed that something
> must be broken with the thumbnail handling in the mysql backend. If I
> switch to mysql using a separate schema for thumbnails, the thumbnails
> are rebuilt each time I start digikam. Moreover, after restarting, the
> thumbnails schema name field in the settings is empty. Can anyone
> confirm this?
>
> Regards,
> Johannes
>
>
> _______________________________________________
> Digikam-devel mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-devel
>
>



2010/7/17 Johannes Wienke <[hidden email]>:

> Hi,
>
> I just tried to move my collection to mysql and noticed that something
> must be broken with the thumbnail handling in the mysql backend. If I
> switch to mysql using a separate schema for thumbnails, the thumbnails
> are rebuilt each time I start digikam. Moreover, after restarting, the
> thumbnails schema name field in the settings is empty. Can anyone
> confirm this?
>
> Regards,
> Johannes
>
>
> _______________________________________________
> Digikam-devel mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-devel
>
>
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

Re: thumbnails always rebuilt using mysql

Johannes Wienke-3
Am 18.07.2010 23:24 schrieb Gilles Caulier:
> You use a separate schema for thumbnails ?

Yes, but the settings problem also occured when using the same schema.

> 2010/7/17 Johannes Wienke <[hidden email]>:
>> Hi,
>>
>> I just tried to move my collection to mysql and noticed that something
>> must be broken with the thumbnail handling in the mysql backend. If I
>> switch to mysql using a separate schema for thumbnails, the thumbnails
>> are rebuilt each time I start digikam. Moreover, after restarting, the
>> thumbnails schema name field in the settings is empty. Can anyone
>> confirm this?


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

signature.asc (270 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: thumbnails always rebuilt using mysql

Bugzilla from Hamsi2k@freenet.de
In reply to this post by Johannes Wienke-3

Hi Johannes,

 

we  don't handled thumbnails database name on read/save config in the right manner.

So this value was always the same schema name. Fixes the the latest svn revision on the

stable svn tree your problem?

 

If it still exists, please check out the console output, maybe there is something interesting...

Try also to restart digikam after changing your settings.

 

Greetings,

Holger



freenetMail - Der zuverlässige E-Mail-Dienst von freenet.de
Jetzt kostenlose E-Mail-Adresse mit 1 GB Speicher und Profi-Spamschutz sichern!
Sofort anmelden!

_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

Re: thumbnails always rebuilt using mysql

Gilles Caulier-4
Holger,

You have miss to commit changes in schemaupdater.cpp. digiKam do not
compile anymore...

[ 23%] Building CXX object
digikam/digikam/CMakeFiles/digikamdatabase.dir/__/libs/database/schemaupdater.o
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:
In member function ‘bool Digikam::SchemaUpdater::makeUpdates()’:
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:258:
erreur: ‘updateV4toV5’ was not declared in this scope
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:
In member function ‘bool Digikam::SchemaUpdater::createDatabase()’:
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:365:
erreur: ‘createTablesV5’ was not declared in this scope
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:366:
erreur: ‘createIndicesV5’ was not declared in this scope
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:367:
erreur: ‘createTriggersV5’ was not declared in this scope
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:
At global scope:
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:385:
erreur: no ‘bool Digikam::SchemaUpdater::createTablesV5()’ member
function declared in class ‘Digikam::SchemaUpdater’
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:394:
erreur: no ‘bool Digikam::SchemaUpdater::createIndicesV5()’ member
function declared in class ‘Digikam::SchemaUpdater’
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:405:
erreur: no ‘bool Digikam::SchemaUpdater::createTriggersV5()’ member
function declared in class ‘Digikam::SchemaUpdater’
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:516:
erreur: no ‘bool Digikam::SchemaUpdater::updateV4toV5()’ member
function declared in class ‘Digikam::SchemaUpdater’
/home/gilles/Documents/devel/SVN/trunk/graphics/digikam/libs/database/schemaupdater.cpp:492:
attention : ‘QStringList Digikam::cleanUserFilterString(const
QString&)’ defined but not used
make[2]: *** [digikam/digikam/CMakeFiles/digikamdatabase.dir/__/libs/database/schemaupdater.o]
Erreur 1
make[1]: *** [digikam/digikam/CMakeFiles/digikamdatabase.dir/all] Erreur 2
make: *** [all] Erreur 2

Gilles Caulier

2010/7/19  <[hidden email]>:

> Hi Johannes,
>
>
>
> we  don't handled thumbnails database name on read/save config in the right
> manner.
>
> So this value was always the same schema name. Fixes the the latest svn
> revision on the
>
> stable svn tree your problem?
>
>
>
> If it still exists, please check out the console output, maybe there is
> something interesting...
>
> Try also to restart digikam after changing your settings.
>
>
>
> Greetings,
>
> Holger
>
> freenetMail - Der zuverlässige E-Mail-Dienst von freenet.de
> Jetzt kostenlose E-Mail-Adresse mit 1 GB Speicher und Profi-Spamschutz
> sichern!
> Sofort anmelden!
> _______________________________________________
> Digikam-devel mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-devel
>
>
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

Re: thumbnails always rebuilt using mysql

Marcel Wiesweg
In reply to this post by Johannes Wienke-3

> Hi,
>
> I just tried to move my collection to mysql and noticed that something
> must be broken with the thumbnail handling in the mysql backend. If I
> switch to mysql using a separate schema for thumbnails, the thumbnails
> are rebuilt each time I start digikam. Moreover, after restarting, the
> thumbnails schema name field in the settings is empty. Can anyone
> confirm this?

There was a bug in the MySQL thumbnails schema that the hashes were truncated.
This is fixed since we really activated the schema update in the branch
yesterday.

But normally, it should fallback to using lookup by filename.

If the problem is fixed in the branch, I can live with not knowing the exact
problem.
If it's still not fixed, we'll have to look into that further.

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