Bug 381790

Summary:	No mysql support in installer and portable package
Product:	[Applications] kmymoney	Reporter:	Ralf Habacker <ralf.habacker>
Component:	database	Assignee:	KMyMoney Devel Mailing List <kmymoney-devel>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	Other
OS:	Microsoft Windows
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Bug Depends on:
Bug Blocks:	381786

Description Ralf Habacker 2017-06-29 09:11:43 UTC

On trying to open a mysql database with a snapshot from 

https://software.opensuse.org/package/mingw32-kmymoney-portable?search_term=mingw32-kmymoney-portable or 
https://software.opensuse.org/package/mingw64-kmymoney-portable?search_term=mingw64-kmymoney-portable

a dialog box comes up and says: No Qt SQL driver.

How to reproduce:
1. Download and unpack portable package on Windows
2. start kmymoney from bin dir of unpacked package
3. Select File->Open database

Comment 1 Ralf Habacker 2017-06-29 18:50:33 UTC

This is caused by two issues: 

1. The Qt4 mysql and sqlite driver dll's are not included in the installation 
2. There is a qt.conf missing in bin dir to specify that qt4 plugins are located at <root>/lib/qt4/plugins

Comment 2 Ralf Habacker 2017-07-10 13:26:07 UTC

(In reply to Ralf Habacker from comment #1)
> This is caused by two issues: 
> 
> 1. The Qt4 mysql and sqlite driver dll's are not included in the
> installation 
fixed

> 2. There is a qt.conf missing in bin dir to specify that qt4 plugins are
> located at <root>/lib/qt4/plugins

The problem here is that qt is normally be compiled with an absolute path to the plugin (and other dirs) 
see http://doc.qt.io/qt-4.8/qt-conf.html for details and https://build.opensuse.org/package/view_file/windows:mingw:win32/mingw32-libqt4/mingw32-qt4.spec?expand=1 line 316 for the cross compiled package
-plugindir %{_mingw32_libdir}/qt4/plugins \

With a qt.conf in the bin dir this could be corrected by using a relative path. Unfortunally adding qt.conf unconditional to the mingw32|64-libqt4 package will interference with the related qt.conf for mingw32|64-libqt5 if installed in parallel which is possible.

Comment 3 Ralf Habacker 2017-08-01 11:53:29 UTC

(In reply to Ralf Habacker from comment #2)

> With a qt.conf in the bin dir this could be corrected by using a relative
> path. Unfortunally adding qt.conf unconditional to the mingw32|64-libqt4
> package will interference with the related qt.conf for mingw32|64-libqt5 if
> installed in parallel which is possible.

fixed at https://build.opensuse.org/package/rdiff/windows:mingw:win32/mingw32-libqt4?linkrev=base&rev=110