[Digikam-devel] [Bug 276052] Failed to update the database schema from version 5 to version 6
Frederic Grelot
fredericg_99 at yahoo.fr
Sun Jun 19 14:49:18 BST 2011
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.
More information about the Digikam-devel
mailing list