SQL Error
!Hubzilla Support Forum

I'm seeing lots of SQL errors like:
ERROR: SELECT distinct parent AS item_id from item
left join abook on ( item.owner_xchan = abook.abook_xchan and abook.abook_channel = 3 )
WHERE uid = 3 and item.item_hidden = 0 and item.item_type = 0
and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
and item.item_blocked = 0 and item.obj_type != '[zrl=http://purl.org/zot/activity/file]http://purl.org/zot/activity/file[/zrl]'
AND item_wall = 1 AND (( item_unseen = 1 AND item.changed

followed by

Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 12: ORDER BY created DESC;

Any ideas? I'm using postgres 9.6
Yeah I do use postgres.

Cool. I saw your post about the RC. I will switch to it today.
Is that also a reason I cant see forum posts straight from my hub?
Mario Vavti
I guess so yes.
Brian Christensen
I am unable to reply to the original thread about the cert error but I see an error as well when visiting https://hubzilla.org:

hubzilla.org uses an invalid security certificate.

The certificate is only valid for demo.hubzilla.org


!Hubzilla Support Forum
Brian Christensen
I tried "refresh permissions" which didn't change anything.
h.ear.t | tobias
Brian Christensen
Works perfectly now.
giac hellvecio
 my house near the sea 
lightonelightone wrote the following post Sun, 22 Apr 2018 04:34:41 +0200
Cert error
Hello, #Hubzilla!

My browser shows a certificate error when I visit hubzilla.org via https (http nicely redirects).
I was thinking of creating some stickers for Hubzilla, "hubzilla.org" link is shorter than "project.hubzilla.org" and looks better on small promotional materials.
Could you please fix the cert? Thanks.

cc @Hubzilla Support Forum+
h.ear.t | tobias
Andrew Manning
I know this may seem convoluted, but I think it makes sense to keep the "hubzilla.org" domain abstracted from any individual hub or website hosted on a subdomain. I'm surprised an additional redirect was necessary since I already have a CNAME record in place linking hubzilla.org to project.hubzilla.org.
h.ear.t | tobias
Important: anonymous comment permission patch

Mike Macgirvin
 High Range, Australia last edited: Sat, 21 Apr 2018 23:26:08 +0200  
!Hubzilla Support Forum !Hubzilla Announcements

It was brought to our attention that some channels have been configured with anonymous (WordPress style) comment permissions which should not have been. This affects a number of newly created channels.

Step 1:

If you are a hub administrator and are running master (3.2.x), dev (3.5), or 3.4RC, please execute 'git pull' from the project root directory now. If you are running a prior release, this particular issue may not affect you; but you are encouraged to update in any event.

If you are running the dev branch on your site, no further action is necessary.

Step 2:

If your site is running a release or pre-release version such as master (3.2.x) or 3.4RC please change to your project root directory and create a new file using the following code snippet. This file should be named Zotlabs/Module/Fix20180421.php and the text '<?php' should be on the very first line of the file. The capitalisation in the filename is important.

namespace Zotlabs\Module;

class Fix20180421 extends \Zotlabs\Web\Controller {

    function get() {

        if(! is_site_admin())

        $r = q("select channel_id from channel where true");
        if($r) {
            foreach($r as $rv) {
                $role = get_pconfig($rv['channel_id'],'system','permissions_role');
                if($role !== 'custom') {
                    $role_permissions = \Zotlabs\Access\PermissionRoles::role_perms($role);
                    if(array_key_exists('limits',$role_permissions) && array_key_exists('post_comments',$role_permissions['limits'])) {

        return 'Update has been applied';



Step 3.

Visit https://zotadel.net/fix20180421 while logged into the hub administrator account. Note that you will use lowercase for the path here.

You should see the text 'Update has been applied'. When you see this text, from the command shell

% rm Zotlabs/Module/Fix20180421.php

Apologies for the inconvenience.
Brian Christensen
Rocky, did you originally install Hubzilla using git? If not, you won't be able to run git pull, in which case I would do what Mike recommends and make sure you grab that PermissionLimits.php file and upload it to your installation.
  last edited: Sun, 22 Apr 2018 18:11:11 +0200  
Thanks @Brian Christensen
so I uploaded the new PermissionLimits.php file to Zotlabs/Access/ ... thats all? I´m done?
Step 2 +  Sep 3 ... got it
Constantly getting logged out

Brian Christensen
  last edited: Sat, 21 Apr 2018 20:17:59 +0200  
!Hubzilla Support Forum

I seem to get regularly logged out of my instance for no apparent reason, particularly when I visit another hub (i.e. every time I visit the Hubzilla Support Forum I find myself logged out when I return to my own hub). But it doesn't seem to be limited to this, sometimes I just randomly get knocked out even when I stay on my own server.

Checking off "remember me" seems to have no effect. Is there an Apache or PHP related configuration regarding cookies and/or sessions that I should be looking at?
giac hellvecio
do you use some firefox-chrome plugin for block coockies?
Brian Christensen
Good call. Looks like Ghostery is the culprit. Marking my own hub as "trusted" along with others I visit seems to resolve this issue. Don't know why I didn't think to look at that. Thanks for the tip!
RSS Feed Question

M. Dent
!Hubzilla Support Forum

When linking to an RSS Feed on a multi-site blog, the profile for the connection gets populated with the author info of the first post ever downloaded.  Is there a way to override the profile information on at least some connections (like RSS feeds) in order to fix things like this?

Also - (likewise for RSS feeds) - is it possible to make RSS Posts "shareable"?
Marshall Sutherland
Feed-mostly public sounds familiar. When first set up, I find that the feed channel, itself, will have some number of historical posts, but my channel only sees new posts as they come in from that point forward. Could this be what you are seeing? It doesn't sound like it, but I thought I should ask.

When I set up the feed channel, there are a couple of steps. Maybe one of them is missing.
I'm sure you have the connection to the actual feed, since you see something
Your feed channel needs to have the Channel Sources feature (in Additional Features / Post Composition Features) turned on.
That will give a new setting page called Channel Sources. On that page, you need to add that connection (the connection to the actual feed) as a source.

Have all those things been done?
Erik R
I never added the feed-channel as channel-source on my main channel.

I agree that only new items in the feed will show up so I figure I will know tomorrow :)
Erik R
I never managed to add the feed as "Channel source", instead I just connected to the feed and the content shows up in the feed-channel-wall (home).

I sadly lost all content of the feed-channel when I changed from feed-mostly public to what-ever and back. The feed is updated once or twice a day so I have to wait.
Profile image upload fails consistently

Sturdy Stonehead
!Hubzilla Support Forum
When I try to change my profile (https://cni-coop.net/profile/cni) image, it consistently fails to upload new picture. "Image upload failed" -- and that's it. There is probably more diagnostics available, but I do not know where to look for it.

Docker installation.

Harper Pollock
Ingo: See attached (no).




Galette: Where can I check it? Also, intial image uploaded finely.
Ingo Juergensmann
Well, my idea was that the image that you want to upload exceeds some 2 MB upload limit. But those images doesn't appear to be large enough.
Mike Macgirvin
  last edited: Sun, 22 Apr 2018 01:14:55 +0200  
Profile photos and Cover photos are the last remaining file uploads that are subject to PHP upload limits. You can upload into the editor or into your cloud storage without encountering these limits, but for these two activities,
check the php.ini for your webserver (you may have more than one php.ini) and review and possibly adjust


post_max_size needs to be larger than upload_max_filesize

If an upload results in a white screen (this can happen for some newer cellphone images if your server is in a memory starved environment) install the imagick program for your operating system. There is a place on the admin/site page to provide the path for externally generating stage1 thumbnails (usually /usr/bin/convert) rather than attempting to generate them in memory. You still want to give PHP as much memory as you can get away with, because this can affect your ability to export/backup/clone your channel content.
!Hubzilla Support Forum

Is there an option to show comments via the tree when you can answer for not only last comments but any comment?
For example show comments like this:

|- comment 1
|- comment 2
|   |- comment for 2
|   \_ comment for 2
|- comment 3
|   |- comment for 3
|   |    \_ comment for comment :)
|   \_ comment for 3
\_ comment for 4
Vitaly Astakhov
На счёт мобильного: есть какое-то API?
Я так понимаю, ничего кроме Zot нет. Это протокол, на котором и работает Хабзилла.
Vitaly Astakhov
Ок. Я вижу наше обсуждение в фрэндике и даже коммент оставил. Интересно пролетит или нет. Твои ответы в Мастодон выглядят как-то оторванными от контекста и сложно понять что происходит и там я тоже ответить пытался. И не понимаю как мне удалось везде на тебя подписаться, а на себя не получается.
"cloned channel not found" by migration from hub version 3.4RC to hub version 3.2.2 - bug or feature?

neue medienordnung plus
Hubzilla community advertise the Nomadic Identity feature as unique feature of Hubzilla accounts. I get the hint "Cloned channel not found" when I attempt import the channel from one hub with version 3.4RC to hub with version 3.2.2. Is this behavior a bug or feature? I mean, that this #VersionHurdle make the "Nomadic Identity" pledge of Hubzilla implausible.

#exportImport #NomadicIdentity #HubzillaPromotion #NomadicIdentityPledge @Hubzilla Development+ @Hubzilla Support Forum+

neue medienordnung plus
btw, after apgrade from 3.2.2 to 3.4RC works the migration for this two hubs.
Disabling public comments

Brian Christensen
!Hubzilla Support Forum

Is there any way to restrict commenting on public posts to only authenticated users? I can't seem to find any configuration for this.
Brian Christensen
Perfect, this is exactly what I was looking for. Thanks!
Mike Macgirvin
  last edited: Sat, 21 Apr 2018 10:25:54 +0200  
There's a bug involved. On the short term I recommend site admins execute

% util/config system.anonymous_comments 0

however some newly created channels may have ended up with anonymous permission enabled which shouldn't have been. The config setting above prevents any more channels from being misconfigured but it won't fix those that already are. We're working on a fix to turn them back off.
RSS is not recognised.

Sturdy Stonehead
!Hubzilla Support Forum

Following the method given in FAQ, I was trying to add https://cnicoop.wordpress.com/feed/ as a connection to one of our channels (cni@cni-coop.net). However answer was "Remote channel or protocol unavailable.", both for explicit feed address and for standard URL.
Any suggestions?
Galette Saucisse
I'm able to add the feed  https://cnicoop.wordpress.com/feed/ as a contact
Have you enabled admin->site->Allow Feeds as Connections ?

tip: create a channel "CNI" and then add the contact  https://cnicoop.wordpress.com/feed/
Community Network Infrastructure Cooperative
It was the admin thing, thank you.
!Hubzilla Support Forum

How do desactivated notification from events. I desactivate the star of the event. but it does not help. Event is not activable or not.

Maybe I miss something
Theme Folder

 Hilden (Map) 
!Hubzilla Support Forum in which folder do I have to put threads in files so they can be selected in Hubzilla?
Andrew Manning
  last edited: Fri, 20 Apr 2018 18:35:27 +0200  

You can use the until/add_theme_repo tool if you have a git repo for it.
giac hellvecio
 my house near the sea 
An ex.

If I go in /pubsites  I see hubzilla.rocks as FREE and as OPEN , but we have "Please enter your invitation code" in that hub.
so, there is  a way to modify and shows the right things in /pubsites?

@Hubzilla Support Forum+
Erik R
Hi Galette,

In order for the util/add_theme_repo to work well the theme must be in a sub directory in the GIT-repository. As of now I get separate themes in the list for css, img, php etc.

Is this possible to fix?

Galette Saucisse
Hi Erik,

Fixed. I've created the git-repo hubzilla-themes, so you can now do this (tested, it works)

util/add_theme_repo https://github.com/galettesaucisse/hubzilla-themes.git greenbasic

bon journee a toi
Erik R
Super! Thanks!

// Erik
 Hilden (Map) 
!Hubzilla Support Forum Images enrich a page and make it more interesting. That's why it would be nice if, as in Wordpress, there would be an add-on that inserts pictures of Pixarbay into the post when creating a post, like in the vidoe below.

Channels cannot discover each other (within the same hub!)

Harper Pollock
at https://cni-coop.net (docker-based installation) I set up two accounts. One is my personal, with 3 channels: general social, hardcore political and technology-oriented.
I also set up a collective account for the coop, with first channel, being general forum.
Now, I try to set up my personal technology channel to be a source for Coop general forum. The problem is that I cannot connect them. I tried both ways and I also tried to another personal channel to main forum. All ends with "Channel discovery failed".

Now I am totally lost...
Harper Pollock
From the content it looks like permissions. I modified it. Going to test...
Harper Pollock
Webfinger returns proper data for full address, empty after handle alone.
Probe works in both cases.

Thank you for leading me through it. I hope this will be also useful for others.
Harper Pollock
Webfinger returns proper data for full address, empty after handle alone.
Probe works in both cases.

Thank you for leading me through it. I hope this will be also useful for others.
Upside down

Stephan Maus
  last edited: Thu, 19 Apr 2018 08:59:19 +0200  
!Hubzilla Support Forum  Very strange: each time, I upload a picture since yesterday, its upside down. Is that due to the Australian origin of #hubzilla? 🙄 Any ideas? Thanks !
Yes, see something similar now too. The image is correct in Gnome Browser on Fedora. Doesn't that also use Webkit? Like Alex's iPad, where the image is also correct? It's upside down in Firefox (on Fedora) or Lightning on Android. Seems like something in the rendering of the image in the browser... . (I run Hubzilla, Version 3.2.2)
M. Dent
Very strange.... Linux running Chrome - the image is upside down within Hubzilla, but if I right mouse click and open it by itself in a separate browser tab, it is right-side-up.
Mike Macgirvin
As it turns out there are some undesirable interactions with the php imagick driver - even accounting for the previous bug. A new fix has been submitted.

It's difficult to neatly describe all the weird interactions that were involved so let me just say we're doing our best to get it right in the face of a number of conflicting variables and external forces which have conspired to get it all wrong.
nginx config

!Hubzilla Support Forum
Hi guys. I'm getting 504 error on hubzilla with nginx config. I used the sample from the git repo.

Any idea? I dont see anything in the logs,
Falgn0n The Wizard
Is that a timeout problem? I struggled with a timeouts as well. Turned out to be nginx rewrite rules.
Check these blocks:

location / {
if ($is_args != "") {
rewrite ^/(.[i]) /index.php?q=$uri&$args last;
rewrite ^/(.[/i]) /index.php?q=$uri last;

location ^~ /.well-known/ { allow all; rewrite ^/(.*) /index.php?q=$uri&$args last; }

My whole vhost is here: https://pastebin.librenet.co.za/?2ecf61bf58bcd829#Go2awHbWSRwiUFBq3yrZp7c/TZ5klFMBrDaFefAYHyU=

Kris Kelvin ✪
 La Ilusión 
!Hubzilla Support Forum Hi people! I come for a very simple question:

Do you know if Hubzilla has a bitcoin wallet? I want do donate a few dollars to development :)
Haakon Meland Eriksen (Parlementum)
Donate app