after hubzilla update: no more file uploads

2019-09-23 09:47:53

Hans Sandmeier via Hubzilla Support Forum

hans@hub.netzgemeinde.eu

My friend updated hubzilla from 3.01 to 4.4.1 and everything seemed to work, he still can post some text, but now can't upload any photos, or attach them.

When trying to upload photos, the debug log shows the following:
Ok, I checked the debug log, and found this:

%!{^K.....B...\n.\r....(PQ.\n.(.Uu.I.\n.\07V.>..)8.B.D......p.0|......e.q~.hP.?Y.\rn..&i.[2...j..n..j1.4+3ZR...<.P..Rx.z.......z..(.qd#.>UXN.c.G.\n..:9.P..}DTe....hP....8.A.\n.H...qB.^L`.B.05...\n.\r.....(...B.\n.R5Ub.\n.....(T.F.(P.4cu`...AL...P.AH..Z..R.A.\Z..\n..!B\rnNM\n......=..\n.f../.i....\\9..  ..hNhP.VtD.8....)\r..NhP.e#.(P.P(P.R\0.B..F..X.B...+.(Re V..J.).\nP.hzP.I..h..E(P.R...;u...mM......a...e.!...C  vJ..L...B.... pE.#.=j..T..X.92......D1. ...q....[h-...@I. .VE\n.....GO..S...../jkn.\\.7.....o.4..*:.....le...+.@.$..\n;\'..]i..........3..$G..C*..n6....v....E#%[.U.B.%...^....3.>PZ..qvu..;nq............u...G\r..8..8.....^L.B.n\Z..)t...i.k.<..F^..\"L..V{.$..yN......N....*|..%{...|.G5V...?..   &{X....[..CA..gc`! .n\'\'$..M1....])%....2ej...=.L...ie....,2...t..k..I..Op-.......]..1 7w....Gq).)Y$..0..\n.q.\n\'.....', 0, 534172, 3, 0, '', '', '4ab35e4b0eeb5aec818081739243b43e89c5354545d20772b9e34113cb046497/b66e3d5d097170157f94ecf350b6bfc9dda257b4219308ad096e1104b8534bce/d2bf064e0b4c406d18f7693f16b2efb56bf1ff08acd660f884eaa27f7131c69a/c10d1f6f-8b62-494f-8aaf-ed583661bf94/86774ffe-376c-4b40-809c-570cb1c58eac', 'Fotos/unsortiert/2019/2019-09//Screenshot-bib-karte-ostasien3.jpg', '<RhPTJFcyH2qsifrHhe2Wlrs5B3t-zvOpjmwdBtDwJSFx8D5VOaFdyKi6kMpSNQdg8O_P4juFy0gz1DOSxCdreA>', '', '', '', '2019-09-24 07:40:43', 0)
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'expires' in 'field list'
2019-09-23T07:40:44Z:LOG_INFO:89dbdc4825:PhotoDriver.php:495:save: Photo save imgscale 3 returned 0
2019-09-23T07:40:44Z:LOG_INFO:89dbdc4825:photos.php:325:photo_upload: Photo store failed.
2019-09-23T07:40:44Z:LOG_INFO:89dbdc4825:zot.php:3270:build_sync_packet: build_sync_packet
2019-09-23T07:40:44Z:LOG_INFO:89dbdc4825:zot.php:3270:build_sync_packet: build_sync_packet
2019-09-23T07:40:44Z:LOG_ERR:89dbdc4825:dba_driver.php:459:db_logger: dba_pdo: ERROR: UPDATE channel SET channel_active = '2019-09-23 07:40:44' WHERE channel_id = 2
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channel_active' in 'field list'
2019-09-23T07:40:44Z:LOG_INFO:89dbdc4825:Item.php:534:post: mod_item: post accepted from user1 for user1
2019-09-23T07:40:52Z:LOG_INFO:0885bdef8a:zot.php:666:zot_gethub: Found

Could it be, that the database is still somehow "outdated" though updating hubzilla?

bug update

show all 8 comments

2019-09-23 10:03:08

Max Kostikov

kostikov@tiksi.net

This means that not all of database updates were performed successfully.
According your error messages these were at least 1211 and 1229. You can manually reexecute them - see Zotlabs/Update directory.

2019-09-23 11:00:53

Hans Sandmeier

hans@hub.netzgemeinde.eu

@Max Kostikov
Thanks for your reply! :-)
Ok, I found the according php files in my Zotlabs/Update directory, but how can I execute those? :)

-- I tried "php _1211.php" ...but nothing happened :)

2019-09-23 11:18:28

Max Kostikov

kostikov@tiksi.net

@Hans Sandmeier I don't sure if this will work by such way. I pointed to those files to show what SQL query should be performed for DB update. You can do it from SQL console.
After try to check if this update was applied by channel_active column extistance in channel table.
Somehow like that.

root@zotum:/usr/local/www/zotum.net # mysql -u root -p hubzilla
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 298737
Server version: 8.0.17 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [hubzilla]> SHOW COLUMNS FROM channel;
+------------------------+---------------------+------+-----+---------------------+----------------+
| Field                  | Type                | Null | Key | Default             | Extra          |
+------------------------+---------------------+------+-----+---------------------+----------------+
| channel_id             | int(10) unsigned    | NO   | PRI | NULL                | auto_increment |
| channel_account_id     | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_primary        | tinyint(1) unsigned | NO   | MUL | 0                   |                |
| channel_name           | char(191)           | NO   | MUL |                     |                |
| channel_address        | char(191)           | NO   | MUL |                     |                |
| channel_guid           | char(191)           | NO   | MUL |                     |                |
| channel_guid_sig       | text                | NO   |     | NULL                |                |
| channel_hash           | char(191)           | NO   | MUL |                     |                |
| channel_timezone       | char(128)           | NO   | MUL | UTC                 |                |
| channel_location       | char(191)           | NO   | MUL |                     |                |
| channel_theme          | char(191)           | NO   | MUL |                     |                |
| channel_startpage      | char(191)           | NO   |     |                     |                |
| channel_pubkey         | text                | NO   |     | NULL                |                |
| channel_prvkey         | text                | NO   |     | NULL                |                |
| channel_notifyflags    | int(10) unsigned    | NO   | MUL | 65535               |                |
| channel_pageflags      | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_dirdate        | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
| channel_lastpost       | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
| channel_deleted        | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
| channel_active         | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
| channel_max_anon_mail  | int(10) unsigned    | NO   | MUL | 10                  |                |
| channel_max_friend_req | int(10) unsigned    | NO   | MUL | 10                  |                |
| channel_expire_days    | int(11)             | NO   | MUL | 0                   |                |
| channel_passwd_reset   | char(191)           | NO   |     |                     |                |
| channel_default_group  | char(191)           | NO   | MUL |                     |                |
| channel_allow_cid      | mediumtext          | NO   |     | NULL                |                |
| channel_allow_gid      | mediumtext          | NO   |     | NULL                |                |
| channel_deny_cid       | mediumtext          | NO   |     | NULL                |                |
| channel_deny_gid       | mediumtext          | NO   |     | NULL                |                |
| channel_removed        | tinyint(1)          | NO   | MUL | 0                   |                |
| channel_system         | tinyint(1)          | NO   | MUL | 0                   |                |
| channel_moved          | char(191)           | NO   | MUL |                     |                |
| channel_password       | varchar(191)        | NO   |     | NULL                |                |
| channel_salt           | varchar(191)        | NO   |     | NULL                |                |
| channel_portable_id    | char(191)           | NO   | MUL |                     |                |
+------------------------+---------------------+------+-----+---------------------+----------------+
35 rows in set (0.01 sec)

2019-09-23 13:22:47

Hans Sandmeier

hans@hub.netzgemeinde.eu

Thanks again Kostikov!
I did as you said, and this was the result:

MariaDB [hubzilla]> SHOW COLUMNS FROM channel;
+------------------------+---------------------+------+-----+---------------------+----------------+
| Field                  | Type                | Null | Key | Default             | Extra          |
+------------------------+---------------------+------+-----+---------------------+----------------+
| channel_id             | int(10) unsigned    | NO   | PRI | NULL                | auto_increment |
| channel_account_id     | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_primary        | tinyint(1) unsigned | NO   | MUL | 0                   |                |
| channel_name           | char(255)           | NO   | MUL |                     |                |
| channel_address        | char(255)           | NO   | UNI |                     |                |
| channel_guid           | char(255)           | NO   | MUL |                     |                |
| channel_guid_sig       | text                | NO   |     | NULL                |                |
| channel_hash           | char(255)           | NO   | MUL |                     |                |
| channel_timezone       | char(128)           | NO   | MUL | UTC                 |                |
| channel_location       | char(255)           | NO   | MUL |                     |                |
| channel_theme          | char(255)           | NO   | MUL |                     |                |
| channel_startpage      | char(255)           | NO   |     |                     |                |
| channel_pubkey         | text                | NO   |     | NULL                |                |
| channel_prvkey         | text                | NO   |     | NULL                |                |
| channel_notifyflags    | int(10) unsigned    | NO   | MUL | 65535               |                |
| channel_pageflags      | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_dirdate        | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
| channel_lastpost       | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
| channel_deleted        | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
| channel_max_anon_mail  | int(10) unsigned    | NO   | MUL | 10                  |                |
| channel_max_friend_req | int(10) unsigned    | NO   | MUL | 10                  |                |
| channel_expire_days    | int(11)             | NO   | MUL | 0                   |                |
| channel_passwd_reset   | char(255)           | NO   |     |                     |                |
| channel_default_group  | char(255)           | NO   | MUL |                     |                |
| channel_allow_cid      | mediumtext          | NO   |     | NULL                |                |
| channel_allow_gid      | mediumtext          | NO   |     | NULL                |                |
| channel_deny_cid       | mediumtext          | NO   |     | NULL                |                |
| channel_deny_gid       | mediumtext          | NO   |     | NULL                |                |
| channel_r_stream       | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_r_profile      | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_r_photos       | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_r_abook        | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_stream       | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_wall         | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_tagwall      | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_comment      | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_mail         | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_photos       | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_chat         | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_a_delegate     | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_r_storage      | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_storage      | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_r_pages        | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_pages        | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_a_republish    | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_w_like         | int(10) unsigned    | NO   | MUL | 0                   |                |
| channel_removed        | tinyint(1)          | NO   | MUL | 0                   |                |
| channel_system         | tinyint(1)          | NO   | MUL | 0                   |                |
| channel_moved          | char(255)           | NO   | MUL |                     |                |
| channel_password       | varchar(255)        | NO   |     |                     |                |
| channel_salt           | varchar(255)        | NO   |     |                     |                |
+------------------------+---------------------+------+-----+---------------------+----------------+

Thus, I would say, there is indeed nochannel_activefield. Hmm.

So does anyone know, how I can do such DB updates manually? :-)

2019-09-23 14:02:50

Max Kostikov

kostikov@tiksi.net

@Hans Sandmeier
In this case find in _1211.php SQL command to add this field and execute it in SQL console.

root@zotum:/usr/local/www/zotum.net # cat Zotlabs/Update/_1211.php
<?php

namespace Zotlabs\Update;

class _1211 {

        function run() {

                if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
                        $r1 = q("ALTER TABLE channel ADD channel_active timestamp NOT NULL DEFAULT '0001-01-01 00:00:00' ");
                        $r2 = q("create index \"channel_active_idx\" on channel (\"channel_active\")");

                        $r = ($r1 && $r2);
                }
                else {
                        $r = q("ALTER TABLE `channel` ADD `channel_active` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' ,
                                ADD INDEX `channel_active` (`channel_active`)");
                }

                if($r)
                        return UPDATE_SUCCESS;
                return UPDATE_FAILED;

        }

}

For MySQL it will be

ALTER TABLE `channel` ADD `channel_active` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', ADD INDEX `channel_active` (`channel_active`);

Don't forget to add trailing ;.

2019-09-23 23:00:04

Hans Sandmeier

hans@hub.netzgemeinde.eu

Ah thank you, I will try it. I thought there is some "magic trick" to execute the php, but okay, I know now what to do :)

2019-09-24 01:30:23

El Dorado

mike@z.macgirvin.com

Let's say DB update #1999 failed. Even if it doesn't register as failed for some reason you can visit the webpage

https://hub.netzgemeinde.euadmin/dbsync/1999

(as an administrator of the site) and it will attempt to re-execute the update.

Recently (much more recently than these updates) we added the ability to verify an update so from the admin/dbsync page you can actually check if it was successful and retry it if it wasn't. Hopefully this addition will make this type of operation much less traumatic in the future.

2019-09-24 11:35:19

elmussol

elmussol@elsmussols.net

/me adds to toolbox.