TROM Social | Tio @ TROM Social

Tio

tio@social.trom.tf

A bunch of atoms that are curious about the world, but furious about the society. We should help all humans to have a decent life without any strings attached, so that we can understand us, the atoms, and the rest of the universe. And create a smarter and saner society.

Since 2005 I make documentaries, write books, and enable many trade-free platforms for everyone.

Network Posts

Earth

@tio:matrix.trom.tf

https://www.tiotrom.com/

Tio

1 year ago •

Tio
1 year ago •

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 @Michael Vogel @Tobias or @Hypolite Petovan have any time to quickly look why it fails, could be awesome :D - 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 :D

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

Friendica package for YunoHost. Contribute to YunoHost-Apps/friendica_ynh development by creating an account on GitHub.

^GitHub

@Michael Vogel @Hypolite Petovan @YunoHost @Tobias

like this

reshared this

in reply to Tio

Hypolite Petovan

in reply to Tio • 1 year ago • •

@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.

@Tio

in reply to Hypolite Petovan

Hypolite Petovan

in reply to Hypolite Petovan • 1 year ago • •

@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 unuse

@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.

@Tio

Tio likes this.

in reply to Hypolite Petovan

Tio

in reply to Hypolite Petovan • 1 year ago •

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 :).

like this

in reply to Tio

Hypolite Petovan

in reply to Tio • 1 year ago • •

@Tio I asked a more precise question in the 2023.05 PR : github.com/YunoHost-Apps/frien…

@Tio

Tio likes this.

in reply to Hypolite Petovan

Tio

in reply to Hypolite Petovan • 1 year ago •

Yes that's what I meant when I mentioned your github comment. I pinged the YNH developers to make sure they are aware of it. I appreciate you taking time to look a bit into it.

Hypolite Petovan likes this.

⇧