Unable to sync db after update 2025.01.03?

[ivandaudt]

Hi guys. It's me again. Didn't give up yet (but close).

Looking further on the issue, I can confirm there's a problem updating the local database with its google drive equivalent on android.

I use linux and launch mmex via script, where rclone updates the local db before the app is lauched and immediately updates it after its closed.

I'm prety sure these are exact copies, as you can see on:

ivan@nbpositivo:~$ ls -l ~/Documentos/fin*
-rw-rw-r-- 1 ivan ivan 278528 jan 22 14:55 /home/ivan/Documentos/financas-ecovila.mmb
ivan@nbpositivo:~$ rclone lsf --format=pt drive:'ecovila olimpia' | grep fin
financas-ecovila.mmb;2025-01-22 14:55:55

On android, I get a "db is updated" msg, but it's clearly not, as you can see on categories screenshots on pc vs mobile.
This phone is not rooted, so I can't check further on the db.
Attached, db screenshot + logcat.

Hope it helps.

Don't know what else to do.
It's nice to think on a mobile + pc experience, but given the situation it's more like one OR other.

[guangong]

Thanks @ivandaudt, the sync is upon the database file's mtime.

seems your concern is why pc/desktop mmex modified the database itself. I think you can check the file's modified time before and after via -t
if the above is true, the android mmex behavior is expected.

[ivandaudt]

The following test process was executed to verify changes/updates passing from pc to mobile:
1- db updated fm gdrive to local desktop
2- changes on categories in mmex desktop app
3- app closed on desktop
4- db updated fm local desktop to gdrive (mtime shown above)
5- mobile app opened on android
6- db "reopened" on mobile to get latest changes

The result was: changes were not reflected on mobile.

[guangong]

I understand your issue now and I misread your categories screenshots.

what's your synchronization setting here as the 5&6 might not trigger the sync.

btw, i would like to split the thread into a different one.

[ivandaudt]

Ok. Go ahead and open a new thread so we can focus on the android synch problem.
I see an opportunity to improve UX, as the path to have your stuff in synch is not intuitive or clear.
Awaiting for yr return.

[ivandaudt]

Forgot to mention I started the whole thing on dropbox with same results.
After some attempts switched to gdrive, assuming dbox could be the problem.
And here we are...

[guangong]

To be clear, we are waiting for your synchronization settings

[ivandaudt]

Synch settings (screenshot in pt-br):
- Upd interval: 10min
- force download
- force upload
- synch on start: true
- only on wifi: false
- reset

FYI - I forced download and got the "X bytes copied"... old categories are still there... logcat attached

[guangong]

These settings and operations seem ok.

Can you try adding a transaction to verify whether it is a sync issue or a pure category behavior case?

[ivandaudt]

Did that already. And that was the critical point to raise the issue.
The following transaction (attached & using new categories) never showed up on mobile.
And considering the whole db is a single file, if one update goes, everything else goes as well, right?
So it's not a problem inside the db. It is THE db file itself that is never updated/replaced.

[guangong]

Just noticed you were still on v2024.12.31 (1057). Can you try the latest version?

[ivandaudt]

I'm running the latest version. Upgraded after screenshots. Problem remains.
Considering going back to 1057. It was a good one...

[ivandaudt]

Updated some stuff on desktop, synched and opened the mobile app (ver 1067) to check if changes were there.
When I hit "Synchronize", I get 2 errors "could not find provider" (no gdrive instance) and "cursor null or empty" (no db instance).
Screenshots attached.

[Renato]

Which desktop version do you use ?

[ivandaudt]

Money Manager Ex
• Versão: 1.8.1 64-bit
• Construído em: Dez 1 2024 16:09:57
• Versão do banco de dados: 19 (aes128cbc)
• Commit Git: d30879a (2024-11-29)
O MMEX está usando os seguintes produtos de suporte:
• wxWidgets 3.2.6 (wxGTK 3.24)
• wxSQLite3 4.9.1 (SQLite 3.40.0)
• RapidJSON 1.1.0
• Lua 5.3.5
• libcurl/8.11.1 OpenSSL/3.3.2 zlib/1.3.1 libidn2/2.3.7 libpsl/0.21.5 nghttp2/1.64.0
• gettext 0.22.5
• apexcharts.js
Construído com:
• CMake 3.31.0
• GNU Make 4.4.1
• GCC 14.2.0
Rodando em:
• GNOME.47 (Flatpak runtime)
• GNOME 47 (Flatpak runtime) ""
• Linux 5.15.0-130-generic x86_64
• PANTHEON (X11)
• Local do sistema: pt_BR.UTF-8
• Idioma da interface de usuário: pt_BR.UTF-8
• 1366x768 24-bit 96x96ppi

[ivandaudt]

I can't see how my desktop could generate a lack of gdrive instance or db instance on my android device...
Anything I'm missing here?

[guangong]

It might be due to networking issues if errors "could not find provider" and "cursor null or empty" just appear randomly and rarely.

Just to double-confirm
1. what's your Android App and OS version?
2. can you see the mmb file with the Files app on your phone?

[ivandaudt]

The issue can't be due to network issue because it never worked.
This thread is a child of another one: "Can't open or create db after upgrade", so it's a symptom of the same problem.
Running Android 10, on a moto hyper one.
This phone is not rooted, so I can't access this section of the filesystem (as it should be).

[guangong]

Did you open the Files app on your phone and explore your database location, it seems in Google Drive's Document folder.
NO ROOT here and can you follow https://moneymanagerex.org/blog/mmex-cl ... nextcloud/ if needed?

The last reply in the thread Unable to open or create db after update 2025.01.03 has an indicator that built-in/native Files app is required.

[ivandaudt]

Ok. My phone didn't came with a built in file manager.
I had to install one to browse the file system.

Based on your statement, I guess MMEX will never work with my phone... no matter what cloud stuff I pick.
In this case, I suggest indicating it as a requirement for the app and avoid frustrations.

Attached, you hv gdrive screenshots of file and its activity, with updates fm my desktop.

I think that's it for me. Need something that just works.
Thank you for your support and good luck.

[guangong]

thanks @ivandaudt , and will consider your suggestion in the future

Btw, does it work after you install the Files app on your phone? Just curious

[ivandaudt]

No. The mobile app never worked well on my phone.
I could only use it on my pc, where I hv full control of each step and can make things work by myself.
I need something that works on the go, and not only home/office.