Postgres - missing "channel

Postgres - missing "channel_active" column

Sun, 29 Apr 2018 18:17:21 -0400 last edited: Sun, 29 Apr 2018 19:03:37 -0400

!Hubzilla Support Forum
While testing some functionality I noticed I cant remove channel. Initially I thought it's due to LDAP authentication, but checking logs reveals that for some reason my db does not have the channel_active column.

Undefined column: 7 ERROR: column "channel_active" of relation "channel" does not exist
LINE 1: UPDATE channel SET channel_active = '

Any ideas?

hubzilla postgres

show all 12 comments

muppeth

Sun, 29 Apr 2018 18:20:13 -0400

Also seeing quite few others like

Undefined column: 7 ERROR: column "[zrl=http://activitystrea.ms/schema/1.0/like"]http://activitystrea.ms/schema/1.0/like"[/zrl] does not exist
LINE 9: AND verb NOT IN ("[zrl=http://activitystrea.ms/schema/1.0/li..]http://activitystrea.ms/schema/1.0/li..[/zrl]

Michael

Sun, 29 Apr 2018 18:52:54 -0400

Check for failed database updates: /admin/dbsync/

muppeth

Sun, 29 Apr 2018 19:02:24 -0400

muppeth tagged muppeth's post with â‹•hubzilla

Sun, 29 Apr 2018 19:06:48 -0400 last edited: Sun, 29 Apr 2018 19:06:51 -0400

channel_active was added in a (very) recent update. Somebody else had mentioned it failing on postgres, but I don't have a postgres test install at the moment and can't easily check it. The source for this update is in Zotlabs/Update/_1212.php

You should have a report of a failed update in admin/dbsync (and it also should have been emailed to the admin). You may be able to replay the update and see if it works on the second try, but I'm not hopeful. We'll probably need to alter the SQL somehow for postgres

I'm still locating the source for the verb issue (from the comment).

muppeth

Sun, 29 Apr 2018 19:11:57 -0400

I had two failed updates, but seems like that didnt help.

Sun, 29 Apr 2018 20:18:06 -0400 last edited: Sun, 29 Apr 2018 20:18:11 -0400

The second issue was reported in issue #1101 and fixed in dev 6 days ago. I see you're running 3.4RC1 which you might want to refresh as we're now at 3.4RC3.

Mario Vavti

Mon, 30 Apr 2018 08:51:31 -0400

The first issue was due to a typo in update 1211 this should be fixed now - you will probably need to fix that manually. The second issue (first comment) is related to a query in mod ping. I thought i fixed that though when you first reported it @muppeth.

muppeth

Mon, 14 May 2018 19:49:55 -0400

Still cant remove channels. I get `auth.php:100:account_verify_password: password failed ` could it be because of ldap auth `account_verify_password` does not find password? Where can I find the module that does the channel removal?

Mon, 14 May 2018 20:52:26 -0400

could it be because of ldap auth

Very probable.

Zotlabs/Module/Removeme.php

Mon, 14 May 2018 23:31:01 -0400

Patch has been submitted.

muppeth

Thu, 17 May 2018 19:28:50 -0400

I pulled the change and applied it to our master to check. I still get the error.

Thu, 17 May 2018 20:12:08 -0400

Works for me.