[Kmymoney-devel] A bug in the current stable release

Tue Nov 12 02:13:08 UTC 2013

Hello,

I believe I may have found a bug in the current 4.6.4 release in regards to
SQL database feature.

I am currently using a .kmy file and tried to migrate to a remote MySQL
database.  The application is crashing severely when I hit the OK button of
the database creation window.

Steps to reproduce:
1- Close current kmy file
2-File -> Open database
3-Database type: QMYSQL - MYSQL
4-DB name: kmymoney (identical to the DB on the remote server)
5-hostname: IP of the remote server
6-username:  username that has full rights on dtaabase kmymoney on the
remote SQL server
7-password: password of the user above
8-Click OK

I get an error popup saying:

 Cannot open database sql://remoteuser@serverip
/kmymoney?driver=QMYSQL&secure=yes

Details:

Error in function int MyMoneyStorageSql::upgradeDb() : Error retrieving
file info(version)

Driver = QMYSQL, Host = serverip, User = remoteuser, Database = kmymoney

Driver Error:

Database Error No -1:

Text:

Error type 0

Executed: SELECT version FROM kmmFileInfo;

Query error No -1:

Error type 0

Then I click OK and it crashes.

Backtrace:

 Application: KMyMoney (kmymoney), signal: Segmentation fault

[Current thread is 1 (Thread 0x7f2150ba2780 (LWP 15838))]

Thread 2 (Thread 0x7f214268e700 (LWP 15839)):

#0 0x00007f214b3968b3 in poll () from /lib64/libc.so.6

#1 0x00007f214540ce34 in ?? () from /usr/lib64/libglib-2.0.so.0

#2 0x00007f214540d742 in g_main_loop_run () from /usr/lib64/libglib-2.0.so.0

#3 0x00007f2142bb7e64 in ?? () from /usr/lib64/libgio-2.0.so.0

#4 0x00007f2145434126 in ?? () from /usr/lib64/libglib-2.0.so.0

#5 0x00007f214dfe3d6b in start_thread () from /lib64/libpthread.so.0

#6 0x00007f214b3a0abd in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7f2150ba2780 (LWP 15838)):

[KCrash Handler]

#6 0x0000000000809d6a in MyMoneyStorageSql::writeFileInfo (this=0x1357b50)
at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.cpp:2356

#7 0x000000000080b8c7 in MyMoneyStorageSql::close (this=0x1357b50,
logoff=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.cpp:229

#8 0x000000000083da91 in ~MyMoneyStorageSql (this=<value optimized out>,
__in_chrg=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.h:141

#9 MyMoneyStorageSql::~MyMoneyStorageSql (this=<value optimized out>,
__in_chrg=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.h:142

#10 0x00000000004c798d in ~KSharedPtr (this=0xe26840, url=<value optimized
out>) at /usr/include/ksharedptr.h:90

#11 KMyMoneyView::openDatabase (this=0xe26840, url=<value optimized out>)
at /home/louis-philippe/kmymoney-4.6.4/kmymoney/views/kmymoneyview.cpp:884

#12 0x00000000004c81df in KMyMoneyView::readFile (this=0xe26840, url=<value
optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/views/kmymoneyview.cpp:643

#13 0x0000000000497b0e in KMyMoneyApp::slotFileOpenRecent (this=0xc8a690,
url=...) at /home/louis-philippe/kmymoney-4.6.4/kmymoney/kmymoney.cpp:1529

#14 0x000000000049851f in KMyMoneyApp::slotOpenDatabase (this=0xc8a690) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/kmymoney.cpp:1444

#15 0x00000000004a1dff in KMyMoneyApp::qt_metacall (this=0xc8a690,
_c=QMetaObject::InvokeMetaMethod, _id=112, _a=0x7fffbe2f8d40) at
/home/louis-philippe/kmymoney-4.6.4/build/kmymoney/kmymoney.moc:515

#16 0x00007f214cecf60f in QMetaObject::activate(QObject*, QMetaObject
const*, int, void**) () from /usr/lib64/qt/lib/libQtCore.so.4

#17 0x00007f214bfe9092 in QAction::triggered(bool) () from
/usr/lib64/qt/lib/libQtGui.so.4

#18 0x00007f214bfe928a in QAction::activate(QAction::ActionEvent) () from
/usr/lib64/qt/lib/libQtGui.so.4

#19 0x00007f214c41f423 in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#20 0x00007f214c4253ba in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#21 0x00007f214f2bb76d in KMenu::mouseReleaseEvent(QMouseEvent*) () from
/usr/lib64/libkdeui.so.5

#22 0x00007f214c040df8 in QWidget::event(QEvent*) () from
/usr/lib64/qt/lib/libQtGui.so.4

#23 0x00007f214c4265ab in QMenu::event(QEvent*) () from
/usr/lib64/qt/lib/libQtGui.so.4

#24 0x00007f214bfef724 in QApplicationPrivate::notify_helper(QObject*,
QEvent*) () from /usr/lib64/qt/lib/libQtGui.so.4

#25 0x00007f214bff4a3c in QApplication::notify(QObject*, QEvent*) () from
/usr/lib64/qt/lib/libQtGui.so.4

#26 0x00007f214f1eabf6 in KApplication::notify(QObject*, QEvent*) () from
/usr/lib64/libkdeui.so.5

#27 0x00007f214ceba1ac in QCoreApplication::notifyInternal(QObject*,
QEvent*) () from /usr/lib64/qt/lib/libQtCore.so.4

#28 0x00007f214bff0735 in QApplicationPrivate::sendMouseEvent(QWidget*,
QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) ()
from /usr/lib64/qt/lib/libQtGui.so.4

#29 0x00007f214c06e18c in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#30 0x00007f214c06c649 in QApplication::x11ProcessEvent(_XEvent*) () from
/usr/lib64/qt/lib/libQtGui.so.4

#31 0x00007f214c093af2 in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#32 0x00007f214540c8f3 in g_main_context_dispatch () from
/usr/lib64/libglib-2.0.so.0

#33 0x00007f214540d0d0 in ?? () from /usr/lib64/libglib-2.0.so.0

#34 0x00007f214540d36d in g_main_context_iteration () from
/usr/lib64/libglib-2.0.so.0

#35 0x00007f214cee51ff in
QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>)
() from /usr/lib64/qt/lib/libQtCore.so.4

#36 0x00007f214c09379e in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#37 0x00007f214ceb9562 in
QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib64/qt/lib/libQtCore.so.4

#38 0x00007f214ceb97ac in
QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib64/qt/lib/libQtCore.so.4

#39 0x00007f214cebdc4b in QCoreApplication::exec() () from
/usr/lib64/qt/lib/libQtCore.so.4

#40 0x000000000045948a in runKMyMoney (splash=<value optimized out>,
a=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/main.cpp:282

#41 0x000000000045b353 in main (argc=1, argv=0x7fffbe2fb298) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/main.cpp:181

I hope this helps...
Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20131111/18c36f29/attachment-0001.html>