YunoHost-Apps / mautrix_telegram_ynh

Matrix Telegram pupetting bridge for YunoHost
https://github.com/mautrix/telegram
GNU General Public License v3.0
14 stars 4 forks source link

ERROR: column "telegrambot" does not exist #8

Closed kuba-orlik closed 2 years ago

kuba-orlik commented 2 years ago

When installing the app via the CLI, an error appears:

...
Info: [###################.] > Starting a systemd service...
Warning: ERROR:  column "telegrambot" does not exist
Warning: LINE 1: UPDATE users SET admin = 1 WHERE name = telegrambot;
Warning:                                                 ^
Info: [####################] > Installation of mautrix_telegram completed
Success! Installation completed

Even though the script says that the installation is sucessful, I can't view the app in the web panel:

image

Context

benneti commented 2 years ago

you can ignore the column error, I will fix it soon. At somepoint one could set the admin like that but it had no functionality anyway and I think the column to set it was removed. What do you expect there, the app is only a backend and you can only use it from your matrix instance. I.e. you should now be able to write the telegram bot.

kuba-orlik commented 2 years ago

I'd expect there to be for example a button to uninstall or otherwise manage the app, as with all other apps. And to see its version etc

benneti commented 2 years ago

Ah ok, I have no Idea how to do this and I thought it should already be there as it is in the manifest... Maybe restart the yunohost-api serivce via ssh and see whether it shows then?

benneti commented 2 years ago

@Gredin67 do you have an Idea about the warning, I think mautrix_whatsapp_ynh does the exact same thing, does it work there reliably?

kuba-orlik commented 2 years ago

Restarting the yunohost-api service does not fix for me the issue of the app metadata not appearing after choosing it in the admin panel

benneti commented 2 years ago

ok, I don't use the webinterface, so I cannot really help out there

Gredin67 commented 2 years ago

which warning are you talking about?

benneti commented 2 years ago

ah sorry, I am talking about

Warning: ERROR:  column "telegrambot" does not exist
Warning: LINE 1: UPDATE users SET admin = 1 WHERE name = telegrambot;

which I think is due to https://github.com/YunoHost-Apps/mautrix_telegram_ynh/blob/78e25377746ff6a488614c6ea00b8ce7c7e6d88a/scripts/install#L262 which in turn should be basically the same as in whatsapp and signal,