Only have one database (See screenshot below) [image: image.png]
I changed the password to my user for that DB and I got bad username *Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) : opening database* *Driver = QMYSQL, Host = 192.168.0.4, User = kmymoney, Database = kmymoney* *Driver Error: QMYSQL: Unable to connect* *Database Error No 1045: Access denied for user 'kmymoney'@'MobileThingy.hsd1.co.comcast.net <http://MobileThingy.hsd1.co.comcast.net>' (using password: YES)* *Text: Access denied for user 'kmymoney'@'XXXXXXXXX' (using password: YES) QMYSQL: Unable to connect* *Error type 1* *Executed: * *Query error No -1: * *Error type 0* On Sun, Aug 26, 2018 at 2:08 PM Jack <ostrof...@users.sourceforge.net> wrote: > Is there any chance you actually have two different databases? I know it > doesn't seem likely, but so is not finding a column you know is present. > Perhaps you can change the password on the database you see, and then see > if you get the same error, or one about bad password? > On 8/26/18 3:39 PM, El Cas wrote: > > I pulled the latest code and rebuild KMM with Build Type "*Debugfull*" > and I enableld Debug trace. When I tried to load my DB I still got the same > error and I did not see any extra information in the stdout. I copied the > entire message just in case it helps narrow down why I may be getting this > error and what I can do to help find the cause and fix for it. > > *QXcbConnection: XCB error: 3 (BadWindow), sequence: 2179, resource id: > 35920248, major code: 40 (TranslateCoords), minor code: 0 **Error in > function QMap<QString, MyMoneySecurity> > MyMoneyStorageSql::fetchCurrencies(const QStringList&, bool) const : > reading Currencies* > > *Driver = QMYSQL, Host = 192.168.x.x, User = kmymoney, Database = kmymoney* > > *Driver Error: * > > *Database Error No -1: * > > *Text: * > > *Error type 0* > > *Executed: SELECT ISOcode, name, type, typeString, symbol1, symbol2, > symbol3, symbolString, smallestCashFraction, smallestAccountFraction, > pricePrecision FROM kmmCurrencies ORDER BY ISOcode;* > > *Query error No 1054: Unknown column 'pricePrecision' in 'field list' > QMYSQL: Unable to execute query* > > *Error type 2 ...**/kmymoney/plugins/sql/mymoneystoragesql.cpp:2491* > > > On Sun, Aug 26, 2018 at 12:31 PM Thomas Baumgart <t...@net-bembel.de> > wrote: > >> Some update from my end as well: I added some logic which allows me to >> create e.g. a Version 8 set of tables. Once I open it, all updates are >> applied and the final state is a Version 12 database. Very strange that it >> does not work for you. >> >> Regards >> >> Thomas >> >> p.s. at some point I might add that to the repo. >> >> On Sonntag, 26. August 2018 20:25:03 CEST El Cas wrote: >> >> > Just an update. I looked at the kmmsecurities and the table already had >> > the pricePrecision column ( pricePrecision smallint(5) UNSIGNED Null: >> No >> > Default: None ). >> > >> > I am build KMM again with debug enabled and I will see if I can get more >> > info on my it's saying the column is missing when it is not. >> > >> > On Sun, Aug 26, 2018 at 8:27 AM Thomas Baumgart <t...@net-bembel.de> >> wrote: >> > >> > > Hi, >> > > >> > > I am by far not a DB expert and can't really tell you what was >> happening. >> > > Since you mention you are at DB version 12, the missing column >> > > pricePrecision was introduced with DB version 11. >> > > >> > > The MYSQL DDL statement for the securities table is as follows: >> > > >> > > CREATE TABLE kmmSecurities (id varchar(32) NOT NULL, name text NOT >> NULL, >> > > symbol mediumtext, type smallint unsigned NOT NULL, typeString >> mediumtext, >> > > smallestAccountFraction varchar(24), pricePrecision smallint unsigned >> NOT >> > > NULL, tradingMarket mediumtext, tradingCurrency char(3), >> roundingMethod >> > > smallint unsigned NOT NULL DEFAULT 7, PRIMARY KEY (id)) ENGINE = >> InnoDB; >> > > >> > > >> > > I am not sure, how you can add a column on the fly. Make sure to >> assign a >> > > value of 4 for existing entries but don't supply a default for new >> values. >> > > >> > > Tony is right in what he mentioned. I am just not sure if that part my >> > > have been hit and is broken. As I don't use the DB backend I can't >> tell. >> > > Anyone else has ideas? >> > > >> > > Regards >> > > >> > > Thomas >> > > >> > > >> > > On Freitag, 24. August 2018 23:25:03 CEST El Cas wrote: >> > > >> > > > I just installed KMM from source (pull from *master* branch on >> > > *8/24/2018 @ >> > > > 11:06 MDT*) and when I tried to log on to my DB I am get >> > > > >> > > > >> > > > >> > > > *Executed: SELECT ISOcode, name, type, typeString, symbol1, symbol2, >> > > > symbol3, symbolString, smallestCashFraction, >> smallestAccountFraction, >> > > > pricePrecision FROM kmmCurrencies ORDER BY ISOcode; Query error No >> 1054: >> > > > Unknown column 'pricePrecision' in 'field list' QMYSQL: Unable to >> execute >> > > > query* >> > > > In a previous email thread, Tony Bloomfield had mentioned that when >> KMM >> > > > opened a Database the Database Manager should detect the change in >> > > version >> > > > and create/delete/alter any table/columns as required, but as you >> can see >> > > > from the error above it's not doing it. Is there an update SQL >> script I >> > > can >> > > > run to update the schema for my 4.8 DB to work with 5.0? >> > > > >> > > > According to the the kmmfileinfo table it says I am using DB version >> > > *12* if >> > > > that helps determine what script(s) I need to run. >> > > > >> > > >> > > -- >> > > >> > > Regards >> > > >> > > Thomas Baumgart >> > > >> > > https://www.signal.org/ Signal, the better WhatsApp >> > > ------------------------------------------------------------- >> > > Mankind makes a lot of things wrong, but if you really want to >> > > screw up, you need to use a computer! (Juergen von der Lippe) >> > > ------------------------------------------------------------- >> > > >> > >> >> -- >> >> Regards >> >> Thomas Baumgart >> >> https://www.signal.org/ Signal, the better WhatsApp >> ------------------------------------------------------------- >> Programming is like sex: One mistake and you have to >> support it for the rest of your life. (Michael Sinz) >> ------------------------------------------------------------- >> >
