Does group name not kept in database?
Posted: Tue Dec 28, 2021 7:48 am
FIles used for issue reproducing: https://disk.yandex.ru/d/gADou4TkNbvVCw
Restore backup from Pure1.bak (pass: pure)
Observe 2 vpn groups: PureVPN and purevpn
Copy database files (from /data/data/it.colucciweb.vpnclientpro/databases) to computer and open file "database" (I used DB Browser for SQLite Version 3.12.2)
Execute update:
Commit changes (save changes to database)
At this point i got files "database" and "database-val" and "database"
Close VPN Client Pro on android
Replace files in /data/data/it.colucciweb.vpnclientpro/databases with files you got after update
Open VPN Client Pro and you see only one group - "PureVPN". Correct
Now perform new backup (VPNClientPro_2021-12-28_10-28-27.bak pure)
Restore this backup without adding it to current data.
Expected to see 1 group: "PureVPN".
Observed 2 vpn groups: "PureVPN" and "purevpn"
Why?
Database had only "PureVPN" group.
Where did it get "purevpn" from?
Restore backup from Pure1.bak (pass: pure)
Observe 2 vpn groups: PureVPN and purevpn
Copy database files (from /data/data/it.colucciweb.vpnclientpro/databases) to computer and open file "database" (I used DB Browser for SQLite Version 3.12.2)
Execute update:
Code: Select all
update vpn_profiles
set "group" = 'PureVPN'
where upper ("group") = upper ("PureVPN")
At this point i got files "database" and "database-val" and "database"
Close VPN Client Pro on android
Replace files in /data/data/it.colucciweb.vpnclientpro/databases with files you got after update
Open VPN Client Pro and you see only one group - "PureVPN". Correct
Now perform new backup (VPNClientPro_2021-12-28_10-28-27.bak pure)
Restore this backup without adding it to current data.
Expected to see 1 group: "PureVPN".
Observed 2 vpn groups: "PureVPN" and "purevpn"
Why?
Database had only "PureVPN" group.
Where did it get "purevpn" from?