Hi,<br><br>I had the same problems as well. Today evening I took the time to perform the upgrade manually. For those who have the problems not solved, yet, here is what I did:<br><br>- Use an Editor and a Mysql Client of your choice (e.g. Kate and MySQL Query Browser).<br>
- Execute the following in the Query Browser:<br>
DELIMITER //;<br>
CREATE PROCEDURE
create_index_if_not_exists(table_name_vc varchar(50), index_name_vc
varchar(50), field_list_vc varchar(1024))<br>
SQL SECURITY INVOKER<br>
BEGIN<br>
<br>
set @Index_cnt = (<br>
SELECT COUNT(1) cnt<br>
FROM INFORMATION_SCHEMA.STATISTICS<br>
WHERE CONVERT(DATABASE() USING latin1) = CONVERT(TABLE_SCHEMA USING latin1)<br>
AND CONVERT(table_name USING latin1) = CONVERT(table_name_vc USING latin1)<br>
AND CONVERT(index_name USING latin1) = CONVERT(index_name_vc USING latin1)<br>
);<br>
<br>
IF IFNULL(@Index_cnt, 0) = 0 THEN<br>
set @index_sql = CONCAT( <br>
CONVERT( 'ALTER TABLE ' USING latin1),<br>
CONVERT( table_name_vc USING latin1),<br>
CONVERT( ' ADD INDEX ' USING latin1),<br>
CONVERT( index_name_vc USING latin1),<br>
CONVERT( '(' USING latin1),<br>
CONVERT( field_list_vc USING latin1),<br>
CONVERT( ');' USING latin1)<br>
);<br>
PREPARE stmt FROM @index_sql;<br>
EXECUTE stmt;<br>
DEALLOCATE PREPARE stmt;<br>
END IF;<br>
END //<br>
DELIMITER;<br>
<br>
- Open core/data/database/dbconfig.xml.cmake in an editor<br>- Scroll to line 1462: "<!-- Migration from DB Version 5 (0.10 - 1.4) to Version 6 (1.5-) -->"<br>"<br>- For each <statement> tag within the <dbaction> tag: Copy the SQL statement to e.g. Mysql Query Browser and execute the statement.<br>
- If you get an error (usually happens if triggers are created), enclose the SQL statement in between:<br>DELIMITER //;<br><SQL-Statement><br>DELIMITER;<br>And remove tha last ";" from the <SQL-Statement>.<br>
<br>- Afterwards one has to ensure that the Settings table is correct. Execute the following:<br>UPDATE Settings SET value=2 WHERE keyword = 'DBThumbnailsVersion';<br>UPDATE Settings SET value=6 WHERE keyword = 'DBVersion';<br>
<br>- Tell digikam to use MySQL again, and enjoy.<br><br><br>No warranty whether this is correct and works for everyone.<br><br>Please backup your database before making any changes.<br><br>Good luck.<br><br>Sven<br><br>
<div class="gmail_quote">2011/8/3 Ignatius Reilly <span dir="ltr"><<a href="mailto:ignatius.reilly@free.fr">ignatius.reilly@free.fr</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,<br>
<br>
I just upgraded a DK 1.9 installation with MySQL on Natty<br>
<br>
Got the following error at DK startup:<br>
<<br>
Failed to update the database schema from version 5 to version 6. Please<br>
read the error messages printed on the console and report this error as<br>
a bug at <a href="http://bugs.kde.org" target="_blank">bugs.kde.org</a>.<br>
><br>
<br>
Any idea where I can find the MySQL schema upgrade script?<br>
<br>
Thx<br>
Ignatius<br>
_______________________________________________<br>
Digikam-users mailing list<br>
<a href="mailto:Digikam-users@kde.org">Digikam-users@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/digikam-users" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Sven Flossmann<br>Friedensstr. 13B<br>85622 Feldkirchen<br>Germany<br><br>Tel: +49 89 17998529<br>Mobile: +49 173 2016002<br><br>PGP available<br>