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

10 months ago •

Tio
10 months ago •

The @YunoHost package for Friendica has not been updated in many months https://github.com/YunoHost-Apps/friendica_ynh/pulls - 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 😁 - but if you are busy totally understood.

I suspect something changed about the Addons

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 • 10 months 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 • 10 months ago • •

@Tio After reviewing the CI log: https://ci-apps-dev.yunohost.org/ci/job/7691

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

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 • 10 months 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 • 10 months ago • •

@Tio I asked a more precise question in the 2023.05 PR : https://github.com/YunoHost-Apps/friendica_ynh/pull/93#issuecomment-1685165211

@Tio

Tio likes this.

in reply to Hypolite Petovan

Tio

in reply to Hypolite Petovan • 10 months 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.

⇧