Conversation

Notices

1. Embed this notice
   tio (tio@social.trom.tf)'s status on Sunday, 20-Aug-2023 23:36:27 JST tio

   in reply to

   • hypolite
   • tio
   @hypolite Thank you so much for the input and the comment you left on github. I will ask the ynh devs to look closely into what you have asked. I love Friendica and YNH allows people to easily install it. I hope we can fix it 😀.
   • clacke likes this.
   • Embed this notice
     hypolite (hypolite@friendica.mrpetovan.com)'s status on Sunday, 20-Aug-2023 23:36:29 JST hypolite

     in reply to

     @tio After reviewing the CI log: ci-apps-dev.yunohost.org/ci/jo…

     I see that the database.sql SQL script is imported in the friendica database first before the following line that fails:
     

     ynh_mysql_connect_as --user="$db_user" --password="$db_pwd" --database="$db_name" <<< "INSERT INTO addon (id, name, version, installed, hidden, timestamp, plugin_admin) VALUES (NULL, 'ldapauth', '', '1', '0', UNIX_TIMESTAMP(), '0');"
     However the addon table should be created by the following statement in database.sql:
     CREATE TABLE IF NOT EXISTS `addon` ( `id` int unsigned NOT NULL auto_increment COMMENT '', `name` varchar(50) NOT NULL DEFAULT '' COMMENT 'addon base (file)name', `version` varchar(50) NOT NULL DEFAULT '' COMMENT 'currently unused', `installed` boolean NOT NULL DEFAULT '0' COMMENT 'currently always 1', `hidden` boolean NOT NULL DEFAULT '0' COMMENT 'currently unused', `timestamp` int unsigned NOT NULL DEFAULT 0 COMMENT 'file timestamp to check for reloads', `plugin_admin` boolean NOT NULL DEFAULT '0' COMMENT '1 = has admin config, 0 = has no admin config', PRIMARY KEY(`id`), INDEX `installed_name` (`installed`,`name`), UNIQUE INDEX `name` (`name`) ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='registered addons';

     So I'm even more puzzled after seeing the context.

   • Embed this notice
     hypolite (hypolite@friendica.mrpetovan.com)'s status on Sunday, 20-Aug-2023 23:36:30 JST hypolite

     in reply to
     @tio I'm not sure what this error is about. More context is needed. The addon table is part of Friendica Core and should be created during the regular install.
   • Embed this notice
     tio (tio@social.trom.tf)'s status on Sunday, 20-Aug-2023 23:36:32 JST tio

     • heluecht
     • hypolite
     • YunoHost
     • tobias
     The @yunohost package for Friendica has not been updated in many months github.com/YunoHost-Apps/frien… - we are trying to figure out but personally I am lost. If anyone can please help out? I think it is a must to give some love to Friendica and fix the update issue.
     
     If @heluecht @tobias or @hypolite have any time to quickly look why it fails, could be awesome 😁 - but if you are busy totally understood.
     
     I suspect something changed about the Addons github.com/YunoHost-Apps/frien…
     
     I see 140125 WARNING ERROR 1146 (42S02) at line 1: Table 'friendica.addon' doesn't exist
     
     In any case we must find a way to update the package. I pinged some friends, let's see 😁
     
     Soon I will do a presentation in Prague about our TROM project and a good part of the presentation is about the Fediverse and Friendica, so I'd like our instance to be up to date of course, and showcase to people a new social network basically. Any help is also a sort of help to push more people to migrate from FB and the like, to Friendica and the fediverse overall.
     pull requests · yunohost-apps/friendica_ynh