Update issue from custom package

[murgero]

@yusf Try disabling then re-enabling auto updates??

[girish]

I suspect the appStoreId is not set correctly in the database (since @yusf is coming from a custom app).

can you check what this provides (you have to substitute the theappid` below (this is the id in the url bar when you go the configure view of the app):

mysql -uroot -ppassword -e "SELECT appStoreId FROM apps WHERE id='theappid'"

[yusf]

@murgero Did try that, yes.
@girish ERROR 1046 (3D000) at line 1: No database selected.

[girish]

@girish said in Update issue from custom package:

Missed the database name in the command line:

mysql -uroot -ppassword -e "SELECT appStoreId FROM box.apps WHERE id='theappid'"

[yusf]

@girish said in Update issue from custom package:

mysql -uroot -ppassword -e "SELECT appStoreId FROM box.apps WHERE id='theappid'"

+--------------------+
| appStoreId         |
+--------------------+
| org.matrix.synapse |
+--------------------+

[yusf]

Think I found the culprit:

Let's see if it triggers the update tonight.

[yusf]

Alas it did not. It's still prompting me to manually update.

[girish]

@yusf I think I know what might be the problem. IIRC, the custom synapse package used very high version numbers. When I published to App Store, I reset it back to 0.1.0.

Can you get the output of this:

    mysql -uroot -ppassword -e "SELECT manifestJson FROM box.apps WHERE id='theappid'"

[yusf]

{"id":"org.matrix.synapse","title":"Matrix Synapse","author":"Matrix synapse authors","description":"This app packages Synapse <upstream>1.14.0</upstream>.\n\n**This package only provides the Matrix backend. A variety of clients are available\n[here](https://matrix.org/clients/). Riot is a popular web frontend for Matrix and\nis available as a separate app.**\n\nMatrix is an ambitious new ecosystem for open federated Instant Messaging and VoIP.\n\n## Matrix\n\nMatrix specifies a set of pragmatic RESTful HTTP JSON APIs as an open standard, which handle:\n\n* Creating and managing fully distributed chat rooms with no single points of control or failure\n* Eventually-consistent cryptographically secure synchronisation of room state across a global open network of federated servers and services\n* Sending and receiving extensible messages in a room with (optional) end-to-end encryption[1]\n* Inviting, joining, leaving, kicking, banning room members\n* Managing user accounts (registration, login, logout)\n* Using 3rd Party IDs (3PIDs) such as email addresses, phone numbers, Facebook accounts to authenticate, identify and discover users on Matrix.\n* Placing 1:1 VoIP and Video calls\n\n## Synapse\n\nSynapse is a reference \"homeserver\" implementation of Matrix from the core development\nteam at matrix.org, written in Python/Twisted.\n\n","changelog":"* Update Synapse to 1.14.0\n* [Full changelog](https://github.com/matrix-org/synapse/releases/tag/v1.14.0)\n","tagline":"Secure & decentralized communication","version":"1.2.0","healthCheckPath":"/","httpPort":8008,"memoryLimit":536870912,"addons":{"localstorage":{},"ldap":{},"postgresql":{},"sendmail":{},"turn":{}},"manifestVersion":2,"website":"https://matrix.org","contactEmail":"support@cloudron.io","icon":"logo.png","tags":["im","collaboration","voip","videochat","chat"],"mediaLinks":["https://cloudron-app-screenshots.s3.amazonaws.com/org.matrix.synapse/606cd9d4ccc3bee11a49f91444a2dad8947cbc7c/1.png","https://cloudron-app-screenshots.s3.amazonaws.com/org.matrix.synapse/606cd9d4ccc3bee11a49f91444a2dad8947cbc7c/2.png","https://cloudron-app-screenshots.s3.amazonaws.com/org.matrix.synapse/606cd9d4ccc3bee11a49f91444a2dad8947cbc7c/3.png"],"postInstallMessage":"<sso>\nThis app integrates with the Cloudron User Management. Cloudron users can register\nthemselves using any client and use Matrix Synapse.\n</sso>\n\n**IMPORTANT: See the [docs](https://cloudron.io/documentation/apps/synapse/) on\nhow to complete setup and start using this app.**\n\n","minBoxVersion":"5.1.4","documentationUrl":"https://cloudron.io/documentation/apps/synapse/","dockerImage":"cloudron/org.matrix.synapse:20200529-132808-991e95e3b"}

[nebulon]

@yusf said in Update issue from custom package:

"version":"1.2.0"

Looks like @girish suspicion was correct. I think the best way to migrate this would be to follow https://cloudron.io/documentation/backups/#import-app-backup by installing a new fresh app and importing there the backup of the old one. (until the new one works, do not uninstall the old one)

We used to have a way in the command line tool to override an app with a specific app package version, but that seems to have gone missing with the move from cloudron install to cloudron update. Have to see if this is worth bringing back.

[yusf]

@nebulon Thanks. Will try it.