TerroX

terrox@cy.borganism.com

code n gfx <a href="#">link test</a> http://example.com test

Location:: NSW Australia

Gender:: Male

Update hubzilla database schema command?

TerroX

Australia, Sat, 30 May 2020 14:18:54 +1000

Is there an easy way to update hubzilla database schema? I just did an upgrade and it didn't happen because I used git pull and now util/udall thinks it's all fine and wont do it?

I can see item.llink and item.plink are using CHAR instead of TEXT in structure, I know this isn't major but I would like to add this to my list of updating steps so I don't forget and relearn updating hubzilla every few months.

!Hubzilla Support Forum

Mario Vavti

Sun, 31 May 2020 06:48:22 +1000

Hi there, this change to the schema has been done without updating existing installations because its consequences are really minor and the update would take ages to complete for most installations. You can do the update manualy if you like...

TerroX

Sun, 31 May 2020 12:37:17 +1000

I had to remove the index on llink, does that mean llink doesn't use an index anymore? i can't add one to TEXT column
#1170 - BLOB/TEXT column 'llink' used in key specification without a key length

Mario Vavti

Sun, 31 May 2020 15:53:49 +1000

llink and plink do not need an index because we never look for them. You can safely remove the index...

Mass Delete or Bulk Delete?

TerroX

Australia, Wed, 27 Nov 2019 07:19:15 +1100

!Hubzilla Support Forum Is there a way to mass delete posts from a particular source or user? I have a RSS feed which ran amok and created 7000 post duplicates.

delete

TerroX

Australia, Sun, 08 Sep 2019 10:57:18 +1000 last edited: Sun, 08 Sep 2019 11:01:41 +1000

!Hubzilla Support Forum I'm trying to work out how to post to diaspora public stream via an RSS feed Channel Source. When I post to a wall of a Forum Channel the post shows up in diaspora (or posting from the channel itself), but if my RSS Feed connection posts to the wall then it wont appear in diaspora. I've tried repost as author and various other settings but diaspora seems to ignore it or the RSS process just doesn't quite go through the same process as a real post from a human.

Here is a post from a Forum Channel that shows up in diaspora public stream - https://diasp.org/posts/d3e06b1e-58f7-4318-a6c6-1adfe9aaa060
Here are other posts on the Forum Channel that aren't showing up, the only difference is that they are sourced from an RSS feed https://cy.borganism.com/channel/alternity-rpg

Is there are particular addon? Is this a feature or bug specific to RSS feeds?

show all 9 comments

Mike Macgirvin

Mon, 09 Sep 2019 14:00:06 +1000

Repost as author should do it. If you can inspect one of these suckers in the DB, see if it has an item.uuid. If it doesn't that could be the problem. Not all message sources provide a uuid and I think we need one of these for the Diaspora protocol to work. Otherwise crank up the loglevel and see what's happening to the message when it processes a Diaspora delivery.

TerroX

Tue, 10 Sep 2019 08:14:48 +1000

@Mike Macgirvin yep missing uuid, some of your posts are missing them too. Can I just generate a new random uuid and add it for atom/rss sources?

Mike Macgirvin

Tue, 10 Sep 2019 09:15:11 +1000

I think that is your best option here.

TerroX

Tue, 10 Sep 2019 10:01:42 +1000

I'm not sure where the code is but I'm trying /Zotlabs/Lib/Activity.php line 1896, though it seems it should be $item not $s and same for line below it.

Mike Macgirvin

Tue, 10 Sep 2019 10:43:34 +1000

That's only for messages coming via Zot6.

include/feedutils.php

Line 1114:
    if(! $datarray[.mid'])
        continue;

+ if(! $datarray['uuid'])
+      $datarray['uuid'] = random_string(32);

Do the same at line 1373 (will be line ~1375-1376 after you make the above change)

TerroX

Tue, 10 Sep 2019 20:29:35 +1000

@Mike Macgirvin Yep that works. So republished sources will now show up in Diaspora connections. Diaspora seems to ignore the hashtags attached to posts (not embedded into the posts) but I'm not sure I mind.

Mike Macgirvin

Tue, 10 Sep 2019 20:46:56 +1000

Cool. I'll see if there's anything I can find out about the hashtags though there's a lot going on at the moment.

TerroX

Tue, 10 Sep 2019 20:50:38 +1000

It'd be that diaspora expects the hashtags to be inside the post content rather than attached to the items as Hubzilla can do I assume.

Mike Macgirvin

Tue, 10 Sep 2019 21:13:07 +1000

You're right.

Experiments with Hubzilla Channel Sources

TerroX

Australia, Fri, 06 Sep 2019 14:59:20 +1000

This is my testing for Connections with Channel Source and trying to get content to show up across various networks.

I am trying to get content into relevant hashtag space across networks.

I have a channel, it has an RSS connection, the channel source is not set as "Resend posts with this channel as author". It doesn't seem to show up in diaspora network and I have a connection from Diaspora network to the main channel so I should see all their public posts. I guess diaspora treats this as content originating from somewhere else and doesn't consider it to be a valid connection or just doesn't show "wall" posts from other people, I guess that makes sense.

My option would be to set "resend" as true, but I don't like how this shows in the feed by replacing the author name and icon - I want the main channel to be a community forum of sorts so it needs to show the origins of any pulled in feeds. Some RSS feeds don't link back to their author directly so apart from the article link they'd lose any obvious info that the post is coming from an external source.

Does this mean I need to set up a channel for each of these RSS sources and set "resend" true, put in an avatar and link back to appropriate URL, apply tagging. Maybe that works? It was what was originally suggested way back when I started testing. But then what is it, a private RSS feed, a public RSS feed that doesn't accept new connections? At least the good news is that updating the avatar and renaming the channel is convenient compared to messing with RSS feed supplied connection name and usually missing feed icon.

#hubzilla #channel-sources

TerroX

Australia, Tue, 03 Sep 2019 08:42:22 +1000

!Hubzilla Support Forum Is there an auto-hashtag option for Posts in a Forum or for Sources similar to the "add category" option?

show all 6 comments

Mike Macgirvin

Tue, 03 Sep 2019 19:00:26 +1000

Not currently. It would not be technically difficult since one could copy/paste the category code and change TERM_CATEGORY to TERM_HASHTAG. It's a wee bit harder than that, as you'd also need to change the form text. Still no biggy,

TerroX

Wed, 04 Sep 2019 12:08:51 +1000 last edited: Wed, 04 Sep 2019 12:18:35 +1000

Is harder than I thought. Adding the extra field to the source edit page and saving is easy but I don't know where the TERM_CATEGORY code is, I tried duplicating the bit in start_delivery_chain() but it doesn't seem to be the right function for this.

Mike Macgirvin

Wed, 04 Sep 2019 12:37:33 +1000

This is a lazy way to do it, but should work. In this case this would be the only thing that needs changing (start_delivery_chain()).
Then when you enter a category on the sources page put a '#' in front of it to make a hashtag instead of a category.

The only changed lines below all have $hashtag in them so 4 lines.


                    foreach($tags as $tt) {
                        $tt = trim($tt);
                        $hashtag = ((substr($tt,0,1) === '#[zrl=https://z.macgirvin.com/search?tag=%27]'[/zrl]) ? true : false);
                        if($tt) {
                            q("insert into term (uid,oid,otype,ttype,term,url)
                                values(%d,%d,%d,%d,'%s','%s') ",
                                intval($channel['channel_id']),
                                intval($item_id),
                                intval(TERM_OBJ_POST),
                                intval(($hashtag) ? TERM_HASHTAG : TERM_CATEGORY),
                                dbesc(($hashtag) ? substr($tt,1) : $tt),
                                dbesc(($hashtag) ? z_root() . '/search?tag=' . urlencode($tt) : z_root() . '/channel/' . $channel['channel_address'] . '?f=&cat=' . urlencode($tt))
                            );
                        }
                    }

TerroX

Wed, 04 Sep 2019 16:01:07 +1000 last edited: Wed, 04 Sep 2019 16:16:32 +1000

That function doesn't seem to be used for this (channel sources), unless I'm doing something wrong. I put a ton of debug everywhere and I can't find exactly where this stuff happens for Sourced posts. The start_delivery_chain happens but the $sourced part is never true.

Mike Macgirvin

Wed, 04 Sep 2019 16:39:09 +1000

check_item_source() looks at a number of things but logs every possible return. If you look for 'source:' in the logfile you should see what decision was made and why as to whether it is a sourced post.

TerroX

Thu, 05 Sep 2019 09:01:28 +1000

Hrm my original way does seem to work once I reset my server. Something weird is going on with my server caching compiled code or something I don't understand what is going on here.

What does "Sign and forward posts and comments with no existing Diaspora signature" do?

TerroX

Australia, Mon, 02 Sep 2019 12:24:55 +1000

!Hubzilla Support Forum In Diaspora app, what does this option do?
- Sign and forward posts and comments with no existing Diaspora signature

show all 4 comments

Mike Macgirvin

Mon, 02 Sep 2019 14:02:35 +1000

Zot allows messages that were created using any protocol to exist in a conversation. ActivityPub and Diaspora require everybody involved in a conversation to support their protocol.

Let's say that you have the Diaspora Protocol enabled for your channel or site and I do not. If I comment on your post, that comment will not show up on Diaspora sites. The same happens for "wall-to-wall" posts. This leads to Diaspora members not seeing the entire conversation.

By enabling that option, these posts and comments will be turned essentially into "reshares" of the original author by the conversation owner who sends it as if they shared it. This doesn't look great, but it allows all these messages to appear on Diaspora sites and Diaspora members can at least see the entire conversation - even though it is an ugly hack.

We've basically forged the post/comment by somebody using that protocol and indicated the true author inside the post/comment. Unsigned "Likes" and "dislikes" are not forwarded because there is no way to indicate who the original author was.

ActivityPub complicates things. This setting allows ActivityPub comments to show up on Diaspora, but there is no way for Diaspora commenters to show up on ActivityPub. Ever. The protocol does not allow it. ActivityPub folks will never see the entire conversation if it includes people using other protocols and this cannot be fixed until all the protocols stop requiring posts/comments to be created by somebody using the same protocol.

TerroX

Mon, 02 Sep 2019 14:25:51 +1000 last edited: Mon, 02 Sep 2019 14:35:42 +1000

Wow that is quite a mess. I was trying to see if I could get my channel's posts, which is a forum, to appear on the public stream of diaspora but I'm not sure if it's possible now and maybe I should not have ActivityPub and Diaspora enabled for a Forum Channel?. Or would I have to set up a repeater profile on Diaspora maybe? here's the channel in question - https://cy.borganism.com/channel/paranoia-rpg

Mike Macgirvin

Mon, 02 Sep 2019 14:58:28 +1000

This should accomplish the first part - which is to show all the posts/comments on Diaspora. Comments by Diaspora folks won't be seen on the ActivityPub side and there is no realistic way to make that happen. I spent several years trying to make forums work across all the major protocols and gave up. It can only happen if Diaspora and ActivityPub learn to work together and I frankly don't see that happening.

TerroX

Mon, 02 Sep 2019 15:34:57 +1000 last edited: Mon, 02 Sep 2019 18:00:09 +1000

Okay it seems to work nicely and doesn't make the posts look weird. It also handles the delete as I posted two and removed them and they aren't on Diaspora any more. Here's the public posts on Diaspora. https://diasp.org/tags/paranoia-rpg

edit: actually my test comment came back after a short time so I guess not.. weird.