[Digikam-devel] [Bug 277242] After SQLite --> MySQL conversion, digikam reports error regarding DBThumbnailsVersion on start up.

[brad]

https://bugs.kde.org/show_bug.cgi?id=277242





--- Comment #4 from brad <bkn ithryn net>  2011-07-10 20:01:22 ---
I also did some testing and i will describe my findings in brief here in hopes
someone who is more familiar with the database code will understand the
problem.

Consider the line of code in core/libs/database/thumbnailschemaupdater.cpp:92

    QStringList tables = m_access->backend()->tables();                         

If one looks at the list returned, it is in fact a list of tables; however it
is a list of ALL tables in ALL databases that the particular mysql user can
read. So in that list there is a 'Settings' table for the 'digikam' database,
as well as a 'Settings' table for the 'digikam_thumbs' database. When the code
asks for the 'Settings' table (which i am assuming line 97 of the same file
does) is ambiguous, and probably returns the first Settings table that occurs
alphabetically; in the example above that would be 'digikam.settings' rather
than 'digikam_thumbs.settings'.

This explains the behavior in the above comment. I am still sifting through the
code to figure out why there is no database specified in this particular
database code. I am not familiar with this code; so perhaps someone familiar
with the code will find a fix first. 

Cheers, 
 -- brad

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.