Hello,

I have an issue while I'm trying to save my existing data, loaded from a file *.kmy, as database using MySQL. I'm getting an error as below. I use version 4.7.1 and tried both Linux and Windows with the same result.

------------------- kmymoney error -----------------------------
"Cannot save to current database: Error in function void __thiscall MyMoneyStorageSql::writeInstitutionList(const class QList<class MyMoneyInstitution> &,class QSqlQuery &) : writing Institution
Driver = QMYSQL, Host = 192.168.178.54, User = kmymoney, Database = kmymoney
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed: INSERT INTO kmmInstitutions (id, name, manager, routingCode, addressStreet, addressCity, addressZipcode, telephone) VALUES (:id, :name, :manager, :routingCode, :addressStreet, :addressCity, :addressZipcode, :telephone);
Query error No 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':id, :name, :manager, :routingCode, :addressStreet, :addressCity, :addressZipcod' at line 1 QMYSQL: Unable to execute query
Error type 2"
-----------------------------------------------------------------

On MySQL server side, I see following logs:

------------------- MySQL logs-----------------------------

...
9 Query BEGIN WORK
9 Prepare SELECT id FROM kmmInstitutions
9 Reset stmt
9 Execute SELECT id FROM kmmInstitutions
9 Close stmt
9 Prepare UPDATE kmmInstitutions SET name = ?, manager = ?, routingCode = ?, addressStreet = ?, addressCity = ?, addressZipcode = ?, telephone = ? WHERE id = ?
9 Query INSERT INTO kmmInstitutions (id, name, manager, routingCode, addressStreet, addressCity, addressZipcode, telephone) VALUES (:id, :name, :manager, :routingCode, :addressStreet, :addressCity, :addressZipcode, :telephone)
9 Query ROLLBACK
9 Close stmt
------------------------------------------------------------------

I would be glad for any help! Thank you.

BR,
Aleksey.

Can you check if the institutions table has been created correctly?

Hei Ku wrote:Can you check if the institutions table has been created correctly?

It seems that the table is all right:

MariaDB [kmymoney]> show columns from kmmInstitutions;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id | varchar(32) | NO | PRI | NULL | |
| name | text | NO | | NULL | |
| manager | mediumtext | YES | | NULL | |
| routingCode | mediumtext | YES | | NULL | |
| addressStreet | mediumtext | YES | | NULL | |
| addressCity | mediumtext | YES | | NULL | |
| addressZipcode | mediumtext | YES | | NULL | |
| telephone | mediumtext | YES | | NULL | |
+----------------+-------------+------+-----+---------+-------+
8 rows in set (0.07 sec)

ok, closed. It works now. The reason is unknown.