Bug 433057 - Error 1050 when writing SQL-Database
Summary: Error 1050 when writing SQL-Database
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: database (show other bugs)
Version: 5.0.6
Platform: Microsoft Windows Other
: NOR major
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-17 09:11 UTC by Thomas_C
Modified: 2021-02-17 09:12 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Details Error Description and settings (626.00 KB, application/pdf)
2021-02-17 09:11 UTC, Thomas_C 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas_C 2021-02-17 09:11:12 UTC 
Created attachment 135753 [details]
Details Error Description and settings

SUMMARY

When writing the Database into an SQL MariaDB DB, subject error occurs. 
The complete message is:
In die aktuelle Datenbank kann nicht geschrieben werden: Error in function void MyMoneyStorageSqlPrivate::createTable(const MyMoneyDbTable&, int) : creating table/index kmmAccounts
Driver = QODBC, Host = 192.168.2.39, User = _kmy_db_test, Database = _kmy_db_test
Driver Error: 
Database Error No -1: 
Text: 
Error type 0
Executed: 
Query error No 1050: [ma-3.1.11][10.3.21-MariaDB-log]Table 'kmmAccounts' already exists QODBC3: Unable to execute statement
Error type 2 /home/abuild/rpmbuild/BUILD/kmymoney-5.0.6/kmymoney/plugins/sql/mymoneystoragesql_p.h:2582

The database "_kmy_db_test" on the MariaDB server exists. I was able to create the tables with KMyMoney, which is an indication to me, that the connection to the database is successfully established (see Details in the Attachment) and the user "_kmy_db_test" has sufficient rights.

STEPS TO REPRODUCE
1. Menue File - Save as - Format = "SQL" - Databasetype ="Open Database Connectivity"


OBSERVED RESULT
Subject error message, no record is written into the database.
Writing the data into a SQLite Format is succfussful as well writing into XML.

EXPECTED RESULT
Data should be written into the MariaDB database.

SOFTWARE/OS VERSIONS
Windows: 10, 64bit
macOS:  na
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: KDE Frameworks 5.47.0
Qt Version: Qt 5.9.1 (kompiliert gegen 5.9.1)

ADDITIONAL INFORMATION
MariaDB is running on a remote Linux NAS (Synology DS).
Port 3307