Version: 1.2.0 (using 4.4.1 (KDE 4.4.1), compiled sources) Compiler: gcc.exe OS: Microsoft Windows (i686) release 5.1 (XP Professional) I tried to compile the Databaseext-branch on Windows XP using mingw4. It did not work. There will be more reports in the near future when I actually tries to use it. So far it has not shown me a single picture from my collection.
Created attachment 42275 [details] Patch fixing compilation on Windows The attached patch shows what I had to do to make it work. I don't know if removing the DIGIKAM_EXPORT statements is the correct way to do it, but at least it works.
Holger, This entry is for you (:=))) Gilles Caulier
Are the files where the EXPORT macro is removed linked into the main binary? Then the patch can be applied as is and will fix the problem (Windows is very picky with these macros, only classes linked into libdigikam may use the DIGIKAM_EXPORT macro)
Created attachment 42299 [details] Second version of patch This version changes DIGIKAM_EXPORT to DIGIKAM_DATABASE_EXPORT for the classes which are linked to libdigikamdatabase and removes it for classes linked to digikam main binary and digikamdatabaseserver binary. I hope this is the correct way.
Many thanks for your patch! I don't compile digikam on windows, so I didn't noticed this kind of bugs. I applied this patch and tried it out. It compiles and digikam has started. I committed this patched version on SVN, rev 1108109. >So far it has not shown me a single picture from my collection. Can you please check, when you start with a clean DB, so we can check if it's only a settings migration problem or not. Maybe you can enable the debug output and attach this to this bug report.
Some observations after some more tests: It failed to load the database on first startup after switching branch and also fails to load it after running the First run wizard if database is removed. If I go to Database-settings and chooses the directory where I have my database it finds it and it gets loaded properly. The same procedure works after First run wizard is run. No pictures are shown initially. Nothing happens when I select different albums. I can get pictures shown by doing the following: 1. Select an album in album-view. 2. Switch to another view, like time-view or tag-view. 3. Switch back to album-view. 4. Now the album selected in 1 is selected and the pictures are shown. The same procedure works for the time-view but not for tag-view. I have no debug-output to attach at this moment. It is not that easy to get it properly under Windows, but I will try to see if I can get it work.
I merged the branch into trunk last evening. >It failed to load the database on first startup after switching branch and also >fails to load it after running the First run wizard if database is removed. >If I go to Database-settings and chooses the directory where I have my >database it finds it and it gets loaded properly. The same procedure works >after First run wizard is run. I think this has to do with the database settings migration. >No pictures are shown initially. Nothing happens when I select different >albums. I can get pictures shown by doing the following: >1. Select an album in album-view. >2. Switch to another view, like time-view or tag-view. >3. Switch back to album-view. >4. Now the album selected in 1 is selected and the pictures are shown. >The same procedure works for the time-view but not for tag-view. I had also before some issues with selecting the album. Now it seems, that it is working. >I have no debug-output to attach at this moment. It is not that easy to get it >properly under Windows, but I will try to see if I can get it work. Thanks!
I can confirm the setting migration problem. It seems that the path of the db is lost. Julien
I confirm too, no migration is done from sqlite to mysql Gilles
With current code from svn trunk including last fix from Holger, migration tool work fine now. David, Julien can you confirm ? Gilles
Holger, In databaseserverstarter.cpp::line 92, i can see : const QString dbServerMgrPath("/usr/bin/digikamdatabaseserver"); This is definitively not portable. I will never work under windows... Path must be set by cmake at pre-compilation, accordingly with options set with cmake script to get install path. Gilles Caulier
Yes, you are right. I have forgotten this startpath :-/ -- Holger Am 31.03.2010 15:53, schrieb Gilles Caulier: > https://bugs.kde.org/show_bug.cgi?id=232233 > > > > > > --- Comment #11 from Gilles Caulier<caulier gilles gmail com> 2010-03-31 15:48:52 --- > Holger, > > In databaseserverstarter.cpp::line 92, i can see : > > const QString dbServerMgrPath("/usr/bin/digikamdatabaseserver"); > > This is definitively not portable. I will never work under windows... > > Path must be set by cmake at pre-compilation, accordingly with options set with > cmake script to get install path. > > Gilles Caulier > >
Now after recompiling everything with debug-output active the album-view and date-view works but not tag-view or search. In the debug output below I first selected some albums which showed me pictures. Secondly I selected tag-view and tried a few tags, none worked. Last I tried a saved search and that did not work. [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "/" [3472] Debug:digikam(3472)/digikam (core) Digikam::FuzzySearchSideBarWidget::setActive: active = false [3472] Debug:digikam(3472) KUrl::path: "/2009/" [3472] Debug:digikam(3472)/kio (Slave) KIO::Slave::createSlave: createSlave "digikamalbums" for KUrl("digikamalbums:/2009/?albumRoot=d:/Bilder&albumRootId=6&databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [3472] Debug:digikam(3472)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on "tcp://127.0.0.1:3457" [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::requestSlave: KLauncher: launching new slave "D:/KDE2/bin/kioslave.exe" with protocol= "digikamalbums" args= ("kio_digikamalbums", "digikamalbums", "tcp://127.0.0.1:1410", "tcp://127.0.0.1:3457") [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::processRequestReturn: "D:/KDE2/bin/kioslave.exe" (pid 4140) up and running. [3472] Debug:digikam(3472) KUrl::path: "/2009/" [3472] Debug:digikam(3472)/kio (Slave) KIO::Slave::timeout: slave failed to connect to application pid= 4140 protocol= "digikamalbums" [3472] Debug:digikam(3472)/kio (Slave) KIO::Slave::timeout: Houston, we lost our slave, pid= 4140 [3472] Debug:digikam(3472)/kio (Slave) KIO::Slave::timeout: slave died pid = 4140 [3472] Debug:digikam(3472)/digikam (core) Digikam::ImageAlbumModel::slotResult: Failed to list url: "Processen för protokollet digikamalbums dog oväntat." [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [4140] Debug:trying to load 'kio_digikamalbums' [4140] Debug:kio_digikamalbums(4140)/kio (kioslave) KIO::SlaveBase::connectSlave: SlaveBase: failed to connect to "tcp://127.0.0.1:3457" [4140] Debug:Reason: "" [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::slotFinished: process finished exitcode= 255 exitStatus= 0 [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "/" [3472] Debug:digikam(3472) KUrl::path: "/2009/2009_12_19/" [3472] Debug:digikam(3472)/kio (Slave) KIO::Slave::createSlave: createSlave "digikamalbums" for KUrl("digikamalbums:/2009/2009_12_19/?albumRoot=d:/Bilder&albumRootId=6&databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [3472] Debug:digikam(3472)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on "tcp://127.0.0.1:3460" [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::requestSlave: KLauncher: launching new slave "D:/KDE2/bin/kioslave.exe" with protocol= "digikamalbums" args= ("kio_digikamalbums", "digikamalbums", "tcp://127.0.0.1:1410", "tcp://127.0.0.1:3460") [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::processRequestReturn: "D:/KDE2/bin/kioslave.exe" (pid 3776) up and running. [3472] Debug:digikam(3472) KUrl::path: "/2009/2009_12_19/" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3776] Debug:trying to load 'kio_digikamalbums' [3776] Debug:kio_digikamalbums(3776) KUrl::path: "/2009/2009_12_19/" [3776] Debug:kio_digikamalbums(3776)/digikam (kio-slave) kio_digikamalbums::special: kio_digikamalbums::special KUrl("digikamalbums:/2009/2009_12_19/?albumRoot=d:/Bilder&albumRootId=6&databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [3776] Debug:kio_digikamalbums(3776) KUrl::path: "/2009/2009_12_19/" [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FDavid%2FMina%20dokument%2FMina%20bilder" [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FKristina%2FMina%20dokument%2FMina%20bilder" [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FAll%20Users%2FDokument%2FMina%20bilder" [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=d%3A%2FMorrowind" [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=d%3A%2FBilder" [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/David/Mina dokument/Mina bilder" is available true [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/Kristina/Mina dokument/Mina bilder" is available true [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/All Users/Dokument/Mina bilder" is available true [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::CollectionManager::updateLocations: location for "d:/Morrowind" is available true [3776] Debug:kio_digikamalbums(3776)/digikam (core) Digikam::CollectionManager::updateLocations: location for "d:/Bilder" is available true [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_19/IMG_4719.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_19/IMG_4719.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_19/IMG_4719.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_19/IMG_4719.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_19/IMG_4719.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_19/IMG_4719.JPG" [3472] Debug:digikam(3472)/KEXIV2 KExiv2Iface::KExiv2::getImageOrientation: Orientation => Exif.Image.Orientation => 6 [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_19/IMG_4719.JPG" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "/" [3472] Debug:digikam(3472) KUrl::path: "/2009/2009_12_26/" [3776] Debug:kio_digikamalbums(3776) KUrl::path: "/2009/2009_12_26/" [3776] Debug:kio_digikamalbums(3776)/digikam (kio-slave) kio_digikamalbums::special: kio_digikamalbums::special KUrl("digikamalbums:/2009/2009_12_26/?albumRoot=d:/Bilder&albumRootId=6&databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [3776] Debug:kio_digikamalbums(3776) KUrl::path: "/2009/2009_12_26/" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_26/IMG_4780.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_26/IMG_4780.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_26/IMG_4780.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_26/IMG_4780.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_26/IMG_4780.JPG" [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_26/IMG_4780.JPG" [3472] Debug:digikam(3472)/KEXIV2 KExiv2Iface::KExiv2::getImageOrientation: Orientation => Exif.Image.Orientation => 1 [3472] Debug:digikam(3472) KUrl::path: converted to local file - the related call should be converted to toLocalFile() "/d:/Bilder/2009/2009_12_26/IMG_4780.JPG" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "/141" [3472] Debug:digikam(3472) KUrl::path: "/141/4" [3472] Debug:digikam(3472)/digikam (core) Digikam::FuzzySearchSideBarWidget::setActive: active = false [3472] Debug:digikam(3472) KUrl::path: "/141/4/2" [3472] Debug:digikam(3472)/kio (Slave) KIO::Slave::createSlave: createSlave "digikamtags" for KUrl("digikamtags:/141/4/2?databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [3472] Debug:digikam(3472)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on "tcp://127.0.0.1:3464" [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::requestSlave: KLauncher: launching new slave "D:/KDE2/bin/kioslave.exe" with protocol= "digikamtags" args= ("kio_digikamtags", "digikamtags", "tcp://127.0.0.1:1410", "tcp://127.0.0.1:3464") [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::processRequestReturn: "D:/KDE2/bin/kioslave.exe" (pid 5996) up and running. [3472] Debug:digikam(3472) KUrl::path: "/141/4/2" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [5996] Debug:trying to load 'kio_digikamtags' [5996] Debug:kio_digikamtags(5996)/digikam (kio-slave) kdemain: *** kio_digikamtag started *** [5996] Debug:kio_digikamtags(5996) KUrl::path: "/141/4/2" [5996] Debug:kio_digikamtags(5996) KUrl::path: "/141/4/2" [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FDavid%2FMina%20dokument%2FMina%20bilder" [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FKristina%2FMina%20dokument%2FMina%20bilder" [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FAll%20Users%2FDokument%2FMina%20bilder" [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=d%3A%2FMorrowind" [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=d%3A%2FBilder" [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/David/Mina dokument/Mina bilder" is available true [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/Kristina/Mina dokument/Mina bilder" is available true [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/All Users/Dokument/Mina bilder" is available true [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::CollectionManager::updateLocations: location for "d:/Morrowind" is available true [5996] Debug:kio_digikamtags(5996)/digikam (core) Digikam::CollectionManager::updateLocations: location for "d:/Bilder" is available true [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "/141" [3472] Debug:digikam(3472) KUrl::path: "/141/4" [3472] Debug:digikam(3472) KUrl::path: "/141/4/5" [5996] Debug:kio_digikamtags(5996) KUrl::path: "/141/4/5" [5996] Debug:kio_digikamtags(5996) KUrl::path: "/141/4/5" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "/141" [3472] Debug:digikam(3472) KUrl::path: "/141/4" [3472] Debug:digikam(3472) KUrl::path: "/141/4/2" [5996] Debug:kio_digikamtags(5996) KUrl::path: "/141/4/2" [5996] Debug:kio_digikamtags(5996) KUrl::path: "/141/4/2" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472)/digikam (core) Digikam::FuzzySearchSideBarWidget::setActive: active = false [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472)/kio (Slave) KIO::Slave::createSlave: createSlave "digikamsearch" for KUrl("digikamsearch:?searchId=4&databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [3472] Debug:digikam(3472)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on "tcp://127.0.0.1:3470" [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::requestSlave: KLauncher: launching new slave "D:/KDE2/bin/kioslave.exe" with protocol= "digikamsearch" args= ("kio_digikamsearch", "digikamsearch", "tcp://127.0.0.1:1410", "tcp://127.0.0.1:3470") [4724] Debug:klauncher(4724)/kio (KLauncher) KLauncher::processRequestReturn: "D:/KDE2/bin/kioslave.exe" (pid 5292) up and running. [3472] Debug:digikam(3472) KUrl::path: "" [5292] Debug:trying to load 'kio_digikamsearch' [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [5292] Debug:kio_digikamsearch(5292) KUrl::path: "" [5292] Debug:kio_digikamsearch(5292)/digikam (kio-slave) kio_digikamsearch::special: kio_digikamsearch::special KUrl("digikamsearch:?searchId=4&databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FDavid%2FMina%20dokument%2FMina%20bilder" [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FKristina%2FMina%20dokument%2FMina%20bilder" [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=C%3A%2FDocuments%20and%20Settings%2FAll%20Users%2FDokument%2FMina%20bilder" [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=d%3A%2FMorrowind" [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "volumeid:?path=d%3A%2FBilder" [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/David/Mina dokument/Mina bilder" is available true [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/Kristina/Mina dokument/Mina bilder" is available true [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::CollectionManager::updateLocations: location for "C:/Documents and Settings/All Users/Dokument/Mina bilder" is available true [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::CollectionManager::updateLocations: location for "d:/Morrowind" is available true [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::CollectionManager::updateLocations: location for "d:/Bilder" is available true [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::ImageQueryBuilder::buildQueryFromXml: " ( ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) AND ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) ) " [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::ImageLister::listSearch: Search query: [5292] "SELECT DISTINCT Images.id, Images.name, Images.album, Albums.albumRoot, ImageInformation.rating, Images.category, ImageInformation.format, ImageInformation.creationDate, Images.modificationDate, Images.fileSize, ImageInformation.width, ImageInformation.height, ImagePositions.latitudeNumber, ImagePositions.longitudeNumber FROM Images LEFT JOIN ImageInformation ON Images.id=ImageInformation.imageid LEFT JOIN ImageMetadata ON Images.id=ImageMetadata.imageid LEFT JOIN ImagePositions ON Images.id=ImagePositions.imageid LEFT JOIN Albums ON Albums.id=Images.album WHERE Images.status=1 AND ( ( ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) AND ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) ) );" [5292] (QVariant(QString, "%david%") , QVariant(QString, "%david%") , QVariant(QString, "%david%") , QVariant(QString, "%david%") , QVariant(QString, "%david%") , QVariant(int, 1) , QVariant(QString, "%david%") , QVariant(QString, "%kristina%") , QVariant(QString, "%kristina%") , QVariant(QString, "%kristina%") , QVariant(QString, "%kristina%") , QVariant(QString, "%kristina%") , QVariant(int, 1) , QVariant(QString, "%kristina%") ) [3472] Debug:digikam(3472)/kio (KIOJob) KIO::SlaveInterface::dispatch: error 104 " " [5292] Debug:kio_digikamsearch(5292)/kio (kioslave) KIO::SlaveBase::finished: finished() called after error()! Please fix the KIO slave. [3472] Debug:digikam(3472)/digikam (core) Digikam::ImageAlbumModel::slotResult: Failed to list url: "Internt fel. [3472] Skicka in en fullständig felrapport på http://bugs.kde.org [3472] " [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472)/digikam (core) Digikam::SearchTabHeader::selectedSearchChanged: changing to SAlbum 0x1b4adca0 [3472] Debug:digikam(3472)/digikam (core) Digikam::SearchTabHeader::selectedSearchChanged: changing to SAlbum 0x1b4adca0 [3472] Debug:digikam(3472) KUrl::path: "" [5292] Debug:kio_digikamsearch(5292) KUrl::path: "" [5292] Debug:kio_digikamsearch(5292)/digikam (kio-slave) kio_digikamsearch::special: kio_digikamsearch::special KUrl("digikamsearch:?searchId=10&databaseType=QSQLITE&databaseName=C:/Documents and Settings/David/Mina dokument/Mina bilder/digikam4.db&connectOptions=&hostName=&userName=&password=") [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::ImageQueryBuilder::buildQueryFromXml: " ( ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) AND ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) ) " [5292] Debug:kio_digikamsearch(5292)/digikam (core) Digikam::ImageLister::listSearch: Search query: [5292] "SELECT DISTINCT Images.id, Images.name, Images.album, Albums.albumRoot, ImageInformation.rating, Images.category, ImageInformation.format, ImageInformation.creationDate, Images.modificationDate, Images.fileSize, ImageInformation.width, ImageInformation.height, ImagePositions.latitudeNumber, ImagePositions.longitudeNumber FROM Images LEFT JOIN ImageInformation ON Images.id=ImageInformation.imageid LEFT JOIN ImageMetadata ON Images.id=ImageMetadata.imageid LEFT JOIN ImagePositions ON Images.id=ImagePositions.imageid LEFT JOIN Albums ON Albums.id=Images.album WHERE Images.status=1 AND ( ( ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) AND ( (Albums.relativePath LIKE ?) OR (Images.name LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageTags WHERE tagid IN (SELECT id FROM Tags WHERE name LIKE ?))) OR (Albums.caption LIKE ?) OR (Albums.collection LIKE ?) OR (Images.id IN (SELECT imageid FROM ImageComments WHERE type=? AND comment LIKE ?)) ) ) );" [5292] (QVariant(QString, "%teodor%") , QVariant(QString, "%teodor%") , QVariant(QString, "%teodor%") , QVariant(QString, "%teodor%") , QVariant(QString, "%teodor%") , QVariant(int, 1) , QVariant(QString, "%teodor%") , QVariant(QString, "%edvard%") , QVariant(QString, "%edvard%") , QVariant(QString, "%edvard%") , QVariant(QString, "%edvard%") , QVariant(QString, "%edvard%") , QVariant(int, 1) , QVariant(QString, "%edvard%") ) [5292] Debug:kio_digikamsearch(5292)/kio (kioslave) KIO::SlaveBase::finished: finished() called after error()! Please fix the KIO slave. [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472) KUrl::path: "" [3472] Debug:digikam(3472)/kio (KIOJob) KIO::SlaveInterface::dispatch: error 104 " " [3472] Debug:digikam(3472)/digikam (core) Digikam::ImageAlbumModel::slotResult: Failed to list url: "Internt fel. [3472] Skicka in en fullständig felrapport på http://bugs.kde.org [3472] "
I can confirm that now the fields in the mysql settings are filled with some default value. If I try to use the internal database, I get an error message. But I think I shouldn't report this issue in this bug report. Julien
yes, as the original subject of this entry is fixed, please open a new file. Gilles Caulier
As you can see in this screenshot : http://farm5.static.flickr.com/4038/4687715958_5787840367_b.jpg digiKam compile fine under windows. I close this file now. Gilles Caulier
Created attachment 49724 [details] Modified xml to reduce index string to 254 This is the modified xml file used, each instruction entered manually works on the mysql server. none of the trigger works at this moment. syntax trouble.
just delete my comment, bugzilla put the next bug and so it's wrong here.