Error Connecting to MySQL DB 4.8.1.1

[El Cas]

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 <thb at 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)
> -------------------------------------------------------------
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20180225/3e6339cc/attachment-0001.html>