I have the DB on a separate server so that might be the reason why it did not get upgraded. I am trying to login using Kubuntu 18.04 (2/24/18 Daily Image) and KMM 5.0 and I am now getting a permission denied error when I try to login with the correct password.
I will create a new test DB and compare the tables and see if I notice a difference in table structure. I will report back to this email. On Sun, Feb 25, 2018 at 6:46 AM, Thomas Baumgart <t...@net-bembel.de> wrote: > Hi, > > this sounds very strange. Obviously, one of the upgrade steps regarding > the DB > backend failed along the way (I am by far no expert at that point and it > is a > guess to some extent). > > Another wild guess is, that the cause could be some missing columns in > your DB > that are now used. I would suggest to make a backup of your DB (that's a > good > idea in any case), create a new empty database and compare the table > structures (using external SQL tools). I expect a difference to show up > somewhere. Then it would be a matter to correct the difference. > > @all: in case anyone has a better idea, please speak up. The OP is not > subscribed to the list, so please CC him. > > Hope that helps as a first step. If you have further questions, please let > us > know. Make sure to send answers to the list and not to individuals only. > > Regards > > Thomas > > > On Samstag, 24. Februar 2018 21:16:21 CET El Cas wrote: > > > I upgraded from Kubuntu 16.04 to 17.10. When I installed the 4.8.0 > version > > that came with 17.10 and tried to connect to the DB where kmm 4.6.6 was > > storing my information I got the following error. > > > > *Query error no 1064: you have an error in your sql syntax; check the > > manual that corresponds to your mysql server version for the right syntax > > to use near '"order" smallint unsigned not null, identifier varchar(32) > not > > null, primary k' at line 1 qmysql: unable to execute query.* > > > > I noticed that there was a 4.8.1 version so I added the repo for that > > version and uninstalled 4.8.0 and installed 4.8.1. I then got a cannot > open > > shared library libkmm_settings.so file missing error. > > > > I uninstalled 4.8.1 and proceed to to download the source code and I > fired > > off the build for tag 4.8.1.1 using the provided instructions in > > README.cmake and it all compiled correctly but when I ran it I got the > > following error. > > > > *Cannot open file as requested. Error was: Error in function void > > MyMoneyStorageSql::writeFileInfo() : writing FileInfo* > > > > *Driver = QMYSQL, Host = X.X.X.X, User = kmymoney, Database = kmymoney* > > > > *Driver Error: * > > > > *Database Error No -1: * > > > > *Text: * > > > > *Error type 0* > > > > *Executed: UPDATE kmmFileInfo SET version = ?, fixLevel = ?, created = ?, > > lastModified = ?, baseCurrency = ?, dateRangeStart = ?, dateRangeEnd = ?, > > hiInstitutionId = ?, hiPayeeId = ?, hiTagId = ?, hiAccountId = ?, > > hiTransactionId = ?, hiScheduleId = ?, hiSecurityId = ?, hiReportId = ?, > > hiBudgetId = ?, hiOnlineJobId = ?, hiPayeeIdentifierId = ?, encryptData = > > ?, updateInProgress = ?, logonUser = ?, logonAt = ?, institutions = ?, > > accounts = ?, payees = ?, tags = ?, transactions = ?, splits = ?, > > securities = ?, prices = ?, currencies = ?, schedules = ?, reports = ?, > > kvps = ?, budgets = ?; * > > > > *Query error No -1: * > > > > *Error type 0* > > > > Is there something I can do to (besides reverting back to Kubuntu > 16.04/KMM > > 4.6.6) to resolve this issue? > > -- > > Regards > > Thomas Baumgart > > https://www.telegram.org/ Telegram, the better WhatsApp > ------------------------------------------------------------- > Of all the computing resources available, the most valuable one is > programmers' time. Especially in open source where most of us have to > sneak in time to write and debug code. (Ace Jones) > ------------------------------------------------------------- >