Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://friendica.mrpetovan.com/objects/735a2029-7564-e17a-e8ac-d15733719677">hypolite (hypolite@friendica.mrpetovan.com)'s status on Sunday, 20-Aug-2023 23:36:29 JST</a><a href="https://friendica.mrpetovan.com/profile/hypolite" title="hypolite@friendica.mrpetovan.com"><img src="https://gnusocial.jp/theme/gnusocialjp/default-avatar-stream.png" width="48" height="48" alt="hypolite" style="position: absolute; left: 0; top: 0;">hypolite</a><div><a href="https://friendica.mrpetovan.com/display/735a2029-7464-e178-490e-338417950301" rel="in-reply-to">in reply to</a><ul><li></ul></div></section><article><p><a href="https://social.trom.tf/profile/tio">@tio</a> After reviewing the CI log: <a href="https://ci-apps-dev.yunohost.org/ci/job/7691" rel="noreferrer">ci-apps-dev.yunohost.org/ci/jo…</a></p><p>I see that the database.sql SQL script is imported in the friendica database first before the following line that fails:<br></p>ynh_mysql_connect_as --user="$db_user" --password="$db_pwd" --database="$db_name" &lt;&lt;&lt; "INSERT INTO addon (id, name, version, installed, hidden, timestamp, plugin_admin) VALUES (NULL, 'ldapauth', '', '1', '0', UNIX_TIMESTAMP(), '0');"<br>However the addon table should be created by the following statement in database.sql:<br>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';<p>So I'm even more puzzled after seeing the context.</p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/1969893#notice-3867854">In conversation</a><time datetime="2023-08-20T23:36:29+09:00" title="Sunday, 20-Aug-2023 23:36:29 JST">Sunday, 20-Aug-2023 23:36:29 JST</time> <span>from <span><a href="https://friendica.mrpetovan.com/display/735a2029-7564-e17a-e8ac-d15733719677" rel="external" title="Sent from friendica.mrpetovan.com via ActivityPub">friendica.mrpetovan.com</a></span></span><a href="https://friendica.mrpetovan.com/display/735a2029-7564-e17a-e8ac-d15733719677">permalink</a><h4>Attachments</h4><ol><li><label><a rel="external" href="https://gnusocial.jp/attachment/1430372">Untitled attachment</a></label><br><div>Invalid filename.</div></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
hypolite (hypolite@friendica.mrpetovan.com)'s status on Sunday, 20-Aug-2023 23:36:29 JSThypolite
in reply to
- tio
@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.
In conversationSunday, 20-Aug-2023 23:36:29 JST from friendica.mrpetovan.compermalink
Attachments
1. Untitled attachment
  Invalid filename.

Public

Embed Notice

HTML Code

Corresponding Notice