[Digikam-devel] [Bug 276052] Failed to update the database schema from version 5 to version 6

[Frederic Grelot]

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





--- Comment #1 from Frederic Grelot <fredericg_99 yahoo fr>  2011-06-19 15:49:17 ---
I suspected that the problem was related with my database, which is using
MySQL.
Actually this proves to be true, since I activated the query log of the server,
and watched it. I used the "Database migration" tool, source and target are on
the mysql server, source tables are "digikam" and "thumbnails-digikam", while
target tables are "digikam2" and "thumbnails-digikam2". This is what I get in
the query log :
110619 15:37:01       92 Connect    digikam at laptop on digikam
           92 Init DB    digikam
           92 Query    SET NAMES utf8
           93 Connect    digikam at laptop on digikam2
           93 Init DB    digikam2
           93 Query    SET NAMES utf8
           93 Query    DROP TABLE IF EXISTS AlbumRoots, Albums,
DownloadHistory, FilePaths, ImageComments, ImageCopyright, ImageHaarMatrix,
ImageInformation, ImageMetadata, ImagePositions, ImageProperties, ImageTags,
Images, Searches, Settings, Tags, TagsTree, Thumbnails, UniqueHashes
           94 Connect    digikam at laptop on digikam2
           94 Init DB    digikam2
           94 Query    SET NAMES utf8
           94 Query    CREATE TABLE IF NOT EXISTS PrivCheck
                (
                    id   INT,
                   name VARCHAR(35)
                )
           94 Query    ALTER TABLE PrivCheck DROP COLUMN name
110619 15:37:02       94 Query    CREATE TRIGGER privcheck_trigger AFTER DELETE
ON PrivCheck
                  FOR EACH ROW BEGIN
                  END
           94 Query    DROP TRIGGER privcheck_trigger
           94 Query    DROP TABLE PrivCheck
           94 Query    DROP TABLE IF EXISTS PrivCheck
           94 Quit    
           93 Query    select table_name from information_schema.tables where
table_type = 'BASE TABLE'
           93 Query    SELECT value FROM Settings WHERE keyword='DBVersion'
           93 Query    SELECT value FROM Settings WHERE
keyword='DBVersionRequired'
           92 Quit    
           93 Quit    

If you run those manually (beware of the 3 parrallel connections), the last two
queries fail, which is logical : the Settings table does not exist in
"digikam2"...

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