YH issue with QueueWorker by Hubzilla ≥ 8.0

[rocky-III]

From Hubzilla ≥ 8.0 the QueueWorker function became a core feature.

If you want to upgrade and came from Hubzilla ≤ 8.0 than the old QueueWorker addon has to be disable under /admin/addons/ so that the core QueueWorker function will start to work.

If you do that with the provided YH HZ package somehow the QueueWorker db table

workerq

will get deleted also and not be new created by YH and this will cause that no posts will leave you hub anymore.

If you notice the same issue you can create the "workerq" table manually

This can be done e.g. in phpMyAdmin by executing the following command:

CREATE TABLE workerq (
    workerq_id BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    workerq_priority smallint,
    workerq_reservationid varchar(25) DEFAULT NULL,
    workerq_processtimeout datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
    workerq_data text,
    workerq_uuid char(36) NOT NULL DEFAULT '',
    workerq_cmd varchar(191) NOT NULL DEFAULT '',
    KEY workerq_priority (workerq_priority),
    KEY workerq_reservationid (workerq_reservationid),
    KEY workerq_processtimeout (workerq_processtimeout),
    KEY workerq_uuid (workerq_uuid)
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4;

Be sure that you also delete the QueueWorker addon from the YH Hubzilla /var/www/hubzilla/addon folder for good

That's it and things should work again.