Error Connecting to MySQL DB 126.96.36.199
eaglexboy at gmail.com
Sun Feb 25 06:53:18 UTC 2018
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:
> 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
> 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
> know. Make sure to send answers to the list and not to individuals only.
> 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
> > 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)
> > 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
> > shared library libkmm_settings.so file missing error.
> > I uninstalled 4.8.1 and proceed to to download the source code and I
> > off the build for tag 188.8.131.52 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
> > 4.6.6) to resolve this issue?
> 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...
More information about the KMyMoney-devel