<div dir="ltr"><div><div><div><div>Hi Simon,<br><br></div>I'm not sure I really get it, may you explain that in a different way?<br><br></div>Thanks for you support.<br><br></div>BR,<br><br><br></div>d.<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On 3 April 2017 at 21:18, Simon Frei <span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Cool, I remembered the first issue correctly :)<br>
The error you get now I do seldomly get as well, when I manage to
damage the database (outside of digikam). So as you said you are
migrating, I would suggest removing everything related to the new
mysql database and start a new clean migration from sqlite.<div><div class="h5"><br>
<br>
<div class="m_4533405178786748195moz-cite-prefix">On 03/04/17 21:05, daniel bip wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi Simon,<br>
<br>
</div>
I installed DK from Philip Johnsson's PPA.<br>
<br>
</div>
If I try lo locate libqt5sql5-mysql I get this:<br>
<br>
/usr/share/doc/libqt5sql5-<wbr>mysql<br>
/var/cache/apt/archives/<wbr>libqt5sql5-mysql_5.5.1+dfsg-<wbr>16ubuntu7.2_amd64.deb<br>
/var/lib/dpkg/info/libqt5sql5-<wbr>mysql:amd64.list<br>
/var/lib/dpkg/info/libqt5sql5-<wbr>mysql:amd64.md5sums<br>
<br>
</div>
So, I tried apt-get install libqt5sql5-mysql and it did
install something but it continues to crash, in a different
way:<br>
<br>
digikam.general: scan mode: ScanDeferredFiles<br>
digikam.general: Testing "mysql_install_db" ...<br>
digikam.general: Found "mysql_install_db"<br>
digikam.general: Testing "mysqld" ...<br>
digikam.general: Found "mysqld"<br>
digikam.general: Testing "mysql_install_db" ...<br>
digikam.general: Found "mysql_install_db"<br>
digikam.general: Testing "mysqld" ...<br>
digikam.general: Found "mysqld"<br>
digikam.dbengine: ConnectOptions
"UNIX_SOCKET=/home/daniel/.<wbr>local/share/digikam/db_misc/<wbr>mysql.socket"<br>
digikam.dbengine: Error while opening the database. Error was
QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect
to local MySQL server through socket
'/home/daniel/.local/share/<wbr>digikam/db_misc/mysql.socket' (2)")<br>
digikam.general: total scan value : 97076<br>
<br>
</div>
<br>
<div class="gmail_extra">Thanks for helping!<br>
<br>
</div>
<div class="gmail_extra">BR,<br>
<br>
</div>
<div class="gmail_extra"><br>
</div>
<div class="gmail_extra">d.<br>
<br>
<br>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On 3 April 2017 at 20:43, Simon Frei
<span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
Do you have the libqt5sql5-mysql package installed?<br>
Or more generally, where do you install digiKam from?<br>
<br>
Cheers,<br>
Simon<br>
<div class="m_4533405178786748195HOEnZb">
<div class="m_4533405178786748195h5"><br>
<br>
On 03/04/17 19:11, daniel bip wrote:<br>
> Hi there,<br>
><br>
> May someone assist me in moving from sqlite to
mysql internal?<br>
><br>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also
installed<br>
> mysql-server-5.7. I did nothing else (mysql is
not setup in any way, I<br>
> mean).<br>
><br>
> In the migration windows mysql_install_db is
shown as a green tick,<br>
> and also is mysqld. But when I click on Migrate I
get a pop up warning<br>
> stating "Error while opening the target database"
and command line says<br>
><br>
> "digikam.dbengine: Error while opening the
database. Error was<br>
> QSqlError("", "Driver not loaded", "Driver not
loaded")"<br>
><br>
> mysql is up and running so I guess I am just
missing something<br>
> important, may someone give me a clue?<br>
><br>
> Thx.<br>
><br>
> BR,<br>
><br>
><br>
> d.<br>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br></div>