Error loading database since v 3.1.2 (build 744) upgrade

MMEX4Android 5.1 and above upon SAF

Moderator: Renato

Colourqueen
New MMEX User
Posts: 15
Joined: Mon Nov 09, 2015 7:24 pm
Are you a spam bot?: No

Error loading database since v 3.1.2 (build 744) upgrade

Post by Colourqueen »

Hi

I've been happily using Moneymanager and syncing via Dropbox for about 9 months now.

However the latest Android upgrade has caused problems for me.
When I try to open my database from Dropbox, I get a stream of SQL errors. They whiz past on the screen - if someone can tell me how to catch them in a log, I will gladly do that.
The database seems to be OK after the errors but I find it all a bit disconcerting and wonder if everything is ok with the database.

The errors are to do with "Error executing Raw SWL, Error creating Asset Classes....

They happen each time I load an amended database from Dropbox.

I also noticed that the new version reset the number of transactions to view back to 'last 7 days'

Can anyone offer any advice please?

Thanks
Colourqueen
New MMEX User
Posts: 15
Joined: Mon Nov 09, 2015 7:24 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by Colourqueen »

Guys - any ideas?

I've updated to version 2015.11.13 (Build 745) and it is still happening.
I've deleted the database on the android and it still happens with no database present.
The message concerns Error executing Raw SQL and  error creating assetclass. Several sql statements flash past.

If I go into "Asset Allocation" in the menu, I get the message "error loading data in cursor loader" then it asks for a new database.

Thanks
User avatar
MisterY
Super MMEX User
Posts: 137
Joined: Sat Jan 24, 2015 8:11 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by MisterY »

Hi,

One thing you can try is to check the Logcat from the About screen. There are two options - one will open the message log in a separate screen while the other will open the log in an email, ready to be sent to us for analysis. The first option is better if you just want to check what is going on.
It is interesting that the messages still pop up even after you delete the database. Can you check the database file path in the Database settings?

Also, while I understand that this is the "Support Forum", I would still recommend using email should you need a faster response. Please have in mind that this is a hobby Open Source project to which everyone contributes as much of their free time as they can.
Colourqueen
New MMEX User
Posts: 15
Joined: Mon Nov 09, 2015 7:24 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by Colourqueen »

Thanks I've finally got back to this.

When I check db schema, I get an error - tables missing: CURRENCYHISTORY_V1

I've checked the database file path, deleted the database named there, and re-synced from dropbox and still get the error.

I've captured in on the logcat and emailed it off.

I hope this helps get to the bottom of the issue.

Thanks again
Braik
New MMEX User
Posts: 4
Joined: Tue Feb 17, 2015 5:42 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by Braik »

Hi guys

Does somebody found the solution to this problem?

It's happening to me since 3 months, I am unable to open my database from my android device.

This problem happened first in my old Phone, after that it happenend on my tablet and now in new phone.

Please help

Braik
User avatar
MisterY
Super MMEX User
Posts: 137
Joined: Sat Jan 24, 2015 8:11 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by MisterY »

Hi,

What exactly is the problem?
Colourqueen
New MMEX User
Posts: 15
Joined: Mon Nov 09, 2015 7:24 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by Colourqueen »

Thanks for your interest.
My error stopped happening a couple of versions back.

The latest version (version 2016.05.03(build 839) is fine.

I was getting errors about tables not being present -  missing: CURRENCYHISTORY_V1. I did have a response when I sent in the logcat.
You said "It seems that the database upgrade script is triggeredalthough you already have the correct version of db".
Maybe this will help pin it down for Braik?
User avatar
MisterY
Super MMEX User
Posts: 137
Joined: Sat Jan 24, 2015 8:11 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by MisterY »

Right. That's what I mean. There might be some edge cases that prevent the database from loading. So, some more details would be useful in troubleshooting.
One can always create a new database file for comparison.
Braik
New MMEX User
Posts: 4
Joined: Tue Feb 17, 2015 5:42 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by Braik »

It tells me "error loading data in cursor loader" and then "error your database file is corrupt !"

When it does not break my file and I loose my file even in the PC.

Any ideas ?

Braik
User avatar
MisterY
Super MMEX User
Posts: 137
Joined: Sat Jan 24, 2015 8:11 pm
Are you a spam bot?: No

Re: Error loading database since v 3.1.2 (build 744) upgrade

Post by MisterY »

You can try opening the file in DbBrowser for SQLite on desktop, or something like aSQLiteManager (https://play.google.com/store/apps/deta ... ager&hl=en) on Android and see if the file is a valid database.
In general, try to restart the app after switching databases.

I'm sorry but I can't offer any more meaningful assistance without knowing the details of your setup.
I have never had any issues opening the synchronized database on Android but I've seen other users run into different issues.
Post Reply