TerroX

Australia, Sun, 19 Mar 2023 14:13:57 +1100 last edited: Sun, 19 Mar 2023 14:23:07 +1100

How do I clean the Item & term tables? both are nearly a gig of other channel's stuff from years ago and my own hub only have a few megs of actual content. @Hubzilla Support Forum

Australia, Thu, 16 Mar 2023 09:45:11 +1100

hubzilla stopped importing RSS feeds after upgrade. @Hubzilla Support Forum

Sun, 19 Mar 2023 14:02:41 +1100

fixed it, Dreamhost uses PHP 7.4 for CRON and CLI so you need to specify the $PATH variable or it wont work even when you call php directly from the right version binary. Hubzilla needs 8.x +

PATH=/usr/local/php82/bin:$PATH; cd /home/YOURUSER/example.com; /usr/local/php82/bin/php -f Zotlabs/Daemon/Master.php Cron > /dev/null 2>&1

Australia, Mon, 13 Mar 2023 07:52:22 +1100

how do I clear massive photo cache? my local channels only have about 40 images and my database is up to 700mb with 22000 profile photos. I tried

util/config system.filesystem_storage_thumbnails 1
util/storageconv fs

but database is the same.

should photo_cache_grid be 1 or 0? @Hubzilla Support Forum

hubzilla

Sun, 19 Mar 2023 14:04:53 +1100

I gave up it doesn't work by default, delete from database using SQL.

DELETE FROM photo WHERE photo.album = 'Contact Photos';

recently updated huzilla from a very old version, got an error on channel

Australia, Tue, 22 Feb 2022 18:11:08 +1100

Fatal error: Uncaught Error: Class 'Zotlabs\Lib\Keyutils' not found in /..snip../extend/addon/hzaddons/diaspora/diaspora.php:1180 Stack trace: #0 /..snip../include/plugin.php(497): diaspora_profile_sidebar(Array) #1 /..snip../include/channel.php(1596): call_hooks('profile_sidebar', Array) #2 /..snip../Zotlabs/Widget/Fullprofile.php(14): profile_sidebar(Array, false) #3 /..snip../Zotlabs/Render/Comanche.php(561): Zotlabs\Widget\Fullprofile->widget(Array) #4 /..snip../Zotlabs/Render/Comanche.php(640): Zotlabs\Render\Comanche->widget('fullprofile', '') #5 /..snip../Zotlabs/Render/Comanche.php(151): Zotlabs\Render\Comanche->region('\n[widget=fullpr...', 'aside') #6 /..snip../Zotlabs/Render/Comanche.php(101): Zotlabs\Render\Comanche->parse_pass1('[region=banner]...') #7 /..snip../boot.php(2177): Zotlabs\Render\Coma in /..snip../extend/addon/hzaddons/diaspora/diaspora.php on line 1180

Must need to disable Diaspora addon??

hubzilla error

Tue, 22 Feb 2022 18:13:20 +1100

yep, disabling Diaspora Addons fixed it. now to get from 4.6 to 7...

Update hubzilla database schema command?

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

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

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 6 Comments

El Dorado

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.

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?

El Dorado

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

I think that is your best option here.

El Dorado

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)

El Dorado

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.

El Dorado

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

You're right.