Jochen - jochen@start.hubzilla.org

General: This is the home page of a channel. It is similar to someone's profile "wall" in a social network context. Posts created by the channel are displayed according to the observer's viewing permissions.
Create a Post: If you have permission to create posts on the channel page, then you will see the post editor at the top.

Kanal Einstellungen speichern?

Jochen

Sun, 18 Nov 2018 18:41:38 -0500

Hallo zusammen,

habe heute zum ersten mal Hubzilla installiert und stoße leider auf ein Problem!

Der Admin Account ist erstellt - hier hatte ich unter den Kanal-Einstellungen -> Kanaltyp und Privatsphäre-Einstellungen -> Benutzerdefiniert/Experteneinstellung gewählt.

Wähle ich nun unter Kanal Berechtigungslimits etwas aus schließe das Fenster und Bestätige ich die Eingaben passiert leider nichts?? Die Einstellungen werden offenbar nicht gespeichert.

Ähnlich wie beispielsweise auch meine Online-Präsenz zu verbergen.. lege ich den Schalter um und bestätige erscheint beim nächsten Aufruf der Sicherheits- und Datenschutz-Einstellungen passiert leider nicht der gewünschte Effekt?

Hat da jemand vielleicht eine Idee?

!Hubzilla Support Forum

show all 8 comments

Jochen

Sun, 18 Nov 2018 19:19:04 -0500

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated' in 'field list'
2018-11-18T23:59:23Z:LOG_ERR:1893df9d7c:PConfig.php:169:Set: Error: Insert to pconfig failed.
2018-11-18T23:59:23Z:LOG_ERR:1893df9d7c:dba_driver.php:459:db_logger: dba_pdo: ERROR: INSERT INTO pconfig ( uid, cat, k, v, updated ) VALUES ( 4, 'redbasic', 'schema', '---', '2018-11-18 23:59:23' )
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated' in 'field list'
2018-11-18T23:59:23Z:LOG_ERR:1893df9d7c:PConfig.php:169:Set: Error: Insert to pconfig failed.

M. Dent

Sun, 18 Nov 2018 19:35:56 -0500

It appears one of the table updates failed during the installation process.

Are you using Postgres or MYSQL?

Jochen

Sun, 18 Nov 2018 19:51:08 -0500

I'm using MariaDB von Debian 9 - any idea how to fix it?

Luis

Sun, 18 Nov 2018 19:53:48 -0500

Hallo @Jochen
Das klingt als wäre deine Installation nicht sauber durchgelaufen und Tabellen in der Datenbank fehlen.
Ich habe meinen Hub ebenfalls vor wenigen Tagen aufgesetzt und dabei folgende Anleitung befolgt:
https://project.hubzilla.org/help/de/admin/administrator_guide#Manual_Installation

Alternativ könntest du auch mal einen Blick in die Anleitung von @h.ear.t | tobias werfen:

h.ear.t | tobias wrote the following article Mon, 09 Apr 2018 19:02:19 +0200

How to install Hubzilla in 7 easy steps on Debian 9 Stretch

Installing my favorite web suite aka Hubzilla on Debian 9 "Stretch" is a joy. Quick, straightforward and easy. I will show you how to do it in about 10 minutes or less.
Edit 09.04.2018:
Unfortunately certbot has seen some changes and will only work once installed from Debian backports. The package included in Stretch will no longer fetch you any certs. This tutorial has been updated to reflect this.

View article

View summary

What you will need:

Debian 9 basic installation (only deviation in my install was including "basic" and SSH-server, which actually makes sense as you need a way to remote control your system)
Existing domain, correctly configured and pointing to your server

All right then, let's start the Hubzilla installation party.

The Basics: Install the required dependencies:
apt install git apache2 mariadb-server php php-curl php-gd php-mbstring php-xml php-mysql php-zip imagemagick

In order to install the new working certbot version from Debian Strech-Backports, we need to add that mirror to apt and enable pinning to make sure apt will not confuse these packages with the old ones from the main release pool.


echo "deb http://ftp.debian.org/debian stretch-backports main" >> /etc/apt/sources.list.d/backports.list
cat > /etc/apt/preferences.d/stretch<< EOF
Package: *
Pin: release a=stable, v=8
Pin-Priority: 900
EOF

cat > /etc/apt/preferences.d/stretch-backports<< EOF
Package: *
Pin: release n=stretch-backports
Pin-Priority: -10
EOF

cat > /etc/apt/preferences.d/stretch-backports-certbot<< EOF
Package: certbot python-certbot python-certbot-apache python-acme
Pin: release n=stretch-backports
Pin-Priority: 100
EOF

Then we can use backports for the certbot installation.

apt update; apt install certbot python-certbot-apache -t stretch-backports

Webserver apache: Create vhost file /etc/apache2/sites-available/hubzilla.conf and enable vhost, enable the required apache module rewrite. You need to replace example.com with your own domain name.
MyDomain=example.com
Then paste this into your shell.


cat > /etc/apache2/sites-available/hubzilla.conf << EOF
<VirtualHost *:80> 
    ServerAdmin webmaster@localhost
    ServerName $MyDomain
    DocumentRoot /var/www/hubzilla
    <Directory />
        Options FollowSymLinks
        AllowOverride All
    </Directory>
    <Directory /var/www/>
        Options Indexes FollowSymLinks 
        AllowOverride All
        Order allow,deny
        allow from all
    </Directory>
    ErrorLog ${APACHE_LOG_DIR}/hubzilla_error.log
    LogLevel warn
    CustomLog ${APACHE_LOG_DIR}/hubzilla_access.log combined
</VirtualHost>
EOF

Enable the new vhost
a2ensite hubzilla
You might want to disable the default site (enabled automatically upon installation):
a2dissite 000-default.conf
Enable apache modules rewrite
a2enmod rewrite
Restart apache2 in order to activate all these changes
systemctl restart apache2

Download Hubzilla: clone the Hubzilla Git repository and chown everything to be writable to the webserver account www-data
cd /var/www/ ; git clone https://github.com/redmatrix/hubzilla ; chown -R www-data. hubzilla;

To create the database set your desired password first:
MyPassword=SuperSecret
Then actually create the database:

mysql -u root -e "create database hubzilla ; CREATE USER 'hubzilla'@'localhost' IDENTIFIED BY '$MyPassword'; GRANT ALL PRIVILEGES ON hubzilla.* to 'hubzilla'@'localhost';"

SSL Encryption: create the letscencrypt certificates in order to use SSL and have certbot automatically configure your apache vhost to use SSL. Just follow the instructions. Let certbot configure your vhost to use SSL.
certbot
setup a cronjob
echo "*/10 * * * * cd /var/www/hubzilla; /usr/bin/php Zotlabs/Daemon/Master.php Cron" >> /etc/crontab
Finally: open your browser and follow the instructions.
https://my-hubzilla.site

https://hubzilla.rocks/articles/tobias/howto-install-hubzilla-in-7-easy-steps

M. Dent

Sun, 18 Nov 2018 21:02:29 -0500


ALTER TABLE [code]pconfig

ADD updated datetime NOT NULL DEFAULT '0001-01-01 00:00:00' ,
ADD INDEX pconfig_updated (updated)[/code]

This is the update that got missed.

If you know how to use the mysql CLI, you should be able to run this manually.

I'd be a bit concerned that other updates may also have been missed if this one was. If so, you could have similar unexpected results. You might check your logs to see if there are any messages from the installation process that indicate failed updates.

Mario Vavti

Mon, 19 Nov 2018 04:09:18 -0500

@M. Dent it appears the updated column is missing from the schema
So new install will not have it...

Paweł Kurzydłowski

Mon, 19 Nov 2018 04:22:34 -0500

I can confirm the missing column. It also affects saving some administrator options, like channelingu rolę settings. Ma ually adding the column fixed the issue.

M. Dent

Mon, 19 Nov 2018 06:58:04 -0500

@Mario Vavti THAT would do it. My fault. I had thought that new installs just ran through all the DB updates in order - didn't even catch the install schema in the original patch.

It's great we have more devs - and I'm Glad that we've started looking over each other's stuff before merges. No doubt some stuff will still fall through the cracks, especially as us noobs don't yet know all the corners of the code - but the reviews will hopefully catch most things like this in the future.

Kanal Einstellungen speichern?

Jochen

Sun, 18 Nov 2018 18:41:12 -0500

Impressum/Imprint | Datenschutzerklärung/Privacy Policy