SQL errors, Hubzilla 3.4RC with Postgresql
Created by: ma1uta
Hello.
I run Hubzill 3.4RC (commit 67ce5f4c) with PostgreSQL 10. There are errors in the logs:
2018-04-23T12:49:36Z:LOG_ERR:7b45r6v5vorv66fdsma4cj991s:dba_driver.php:459:db_logger: dba_pdo: ERROR: SELECT id, item_wall FROM item
WHERE uid = 2 and item_unseen = 1
and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 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 != 'http://purl.org/zot/activity/file'
AND verb NOT IN ("http://activitystrea.ms/schema/1.0/like", "http://purl.org/zot/activity/dislike")
AND author_xchan != '1GXP9LaQPWBQk3x1TqgREmqonyLivmh58Igiwz9_-C44RRNJ6GuKWpmZqPlMG4W_upe_GSNHLMUekLKuviLGNQ';
SQLSTATE[42703]: Undefined column: 7 ERROR: column "http://activitystrea.ms/schema/1.0/like" does not exist
LINE 6: AND verb NOT IN ("http://activitystrea.ms/schema/1.0/li...
^