<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Sun, Feb 25, 2018 at 2:31 AM, Thomas Baumgart <span dir="ltr"><<a href="mailto:thb@net-bembel.de" target="_blank">thb@net-bembel.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Having the DB on a separate server should not make a difference. All<br>
communication (incl. structure updates etc) between KMyMoney and the SQL DB is<br>
via a communication link.<br>
<br>
I am not sure, if bringing in 5.0 at this point is a good alternative. You<br>
might have a trouble to go back to 4.8 unless you want to stick with 5.0.<br>
Since you're building from source also, use the 5.0 branch, not master. It<br>
already contains a couple of bug-fixes over the released 5.0 version.<br></blockquote><div> </div><div>The reason I was using Kubuntu 18.04/KMM 5.0 was because 18.04 is scheduled to be released in April and if this fixed my problem I would just going to completely upgrade my system to 18.04/5.0 ahead of scheduled.<br></div><div><br></div></div><div><div><div><div><div>So while using Kubuntu 18.04/KMM 5.0 I was getting a database user error so I
just temporarily granted the username I am using for KMM all privileges.
I created an empty test account and proceeded to save as DB. I put in
the required information and when I clicked on Ok. Got the error below.<br><br>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) : opening new database</b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Driver = QMYSQL, Host = X.X.X.X, User = kmymoney, Database = /newkmymoney</b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Driver Error: QMYSQL: Unable to connect</b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Database Error No 1049: Unknown database '/newkmymoney'</b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Text: Unknown database '/newkmymoney' QMYSQL: Unable to connect</b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Error type 1</b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Executed: </b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Query error No -1: </b></p><b>
</b><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><b>Error type 0</b></p><br></div>I checked the DB server and the Database was created but it was empty.<br><br></div>So
I went back to Kubuntu 17.10/KMM 4.8.1.1 (from source) and repeated the
same process. This time the test database was created and the tables
were created. I decided to attempt to open my original database and got
the same error I reported in my first email.<br><br></div>As for difference between 4.8.1.1 vs 4.6.6 I found the following<br></div><br>4.6 has 24 tables vs 23 tables on 4.8: <b>kmmtmpfileinfo</b><br><br>And the following tables have extra columns<br>Version tablename field name type Null? Default Value<br>4.8 <b><code class="m_-5265699080982236330gmail-sql"><span class="m_-5265699080982236330gmail-cm-variable-2">kmmfileinfo</span></code></b> hiOnlineJobId bigint(20) unsigned YES NULL <br>4.8 <b><code class="m_-5265699080982236330gmail-sql"><span class="m_-5265699080982236330gmail-cm-variable-2">kmmfileinfo</span></code></b> hiPayeeIdentifierId bigint(20) unsigned YES NULL<br>4.8 <b><code class="m_-5265699080982236330gmail-sql"><span class="m_-5265699080982236330gmail-cm-variable-2">kmmschedules</span></code></b> lastDayInMonth char(1) NO NULL <br>4.8 <b><code class="m_-5265699080982236330gmail-sql"><span class="m_-5265699080982236330gmail-cm-variable-2">kmmsplits</span></code></b> costCenterId varchar(32) YES NULL<br><br></div><div>I made a back up of my current DB and added the missing fields to the corresponding tables and I was able to open the Database. It proceeded load and when it reached 97% it began to do <b>testing fileFixVersion</b>. During the 0 < 4 run it performed several <b>Fixed interest action in XXXX</b> actions. It then ran <b>testing fileFixVersion</b> <b>1 < 4 and 2 <4 </b>has<b> </b>been running for a long time (almost 2hr as of this email). I don't know how long the testing normally takes but I will let it continue running and see how long it takes to finish.<br><br></div><div>I am going to check on it when I wake up. I will report any progress, or lack there off.<br></div></div></div>