Seit der Aktualisierung auf die RC finde ich im Logfile von Friendica gehäuft so

Submitted ⁨⁨23⁩ ⁨hours⁩ ago⁩ by ⁨tux@anonsys.net⁩ to ⁨helpers@forum.friendi.ca⁩

Seit der Aktualisierung auf die RC finde ich im Logfile von Friendica gehäuft solche Datenbank Error:
code: 1054
error: Unknown column 'post-timeline-view.uri-id' in 'WHERE'
params:

SELECT `uri-id` FROM `post-timeline-thread-view` WHERE (`gravity` IN (0, 6) AND `private` = 0 AND `network` IN ('dfrn', 'dspr', 'apub') AND `author-blocked` = 0 AND `author-hidden` = 0 AND `uid` = 0 AND NOT `uri-id` IN (SELECT `uri-id` FROM `post-user` WHERE `origin` AND `post-user`.`uri-id` = `post-timeline-view`.`uri-id`) AND `gravity` = 0 AND `visible` AND NOT `deleted` AND NOT `author-blocked` AND NOT `owner-blocked` AND (NOT `causer-blocked` OR `causer-id` = 0 OR `causer-id` IS NULL) AND NOT `contact-blocked` AND NOT EXISTS(SELECT `uri-id` FROM `post-user` WHERE `uid` = 544 AND `uri-id` = `post-timeline-thread-view`.`uri-id` AND `hidden`) AND NOT EXISTS(SELECT `cid` FROM `user-contact` WHERE `uid` = 544 AND `cid` IN (`author-id`, `owner-id`) AND (`blocked` OR `ignored` OR `is-blocked`)) AND NOT EXISTS(SELECT `gsid` FROM `user-gserver` WHERE `uid` = 544 AND `gsid` IN (`author-gsid`, `owner-gsid`, `causer-gsid`) AND `ignored`)) ORDER BY `uri-id` DESC LIMIT 40

original

Comments

Sort:hotnew top

heluecht@pirati.ca@pirati.ca ⁨19⁩ ⁨hours⁩ ago

@tux Schau mal nach, ob post-timeline-view existiert. Und wenn ja, welche Felder drin sind.

original

tux@anonsys.net ⁨19⁩ ⁨hours⁩ ago

@heluecht
Ja scheint zu existieren:

SHOW TABLES LIKE 'post-timeline-view';
+--------------------------------------------+
| Tables_in_friendicadb (post-timeline-view) |
+--------------------------------------------+
| post-timeline-view                         |
+--------------------------------------------+
1 row in set (0,001 sec)

Es sind folgende Felder vorhanden:

DESCRIBE `post-timeline-view`;
+------------------+-----------------------+------+-----+---------------------+-------+
| Field            | Type                  | Null | Key | Default             | Extra |
+------------------+-----------------------+------+-----+---------------------+-------+
| uid              | mediumint(8) unsigned | NO   |     | NULL                |       |
| uri-id           | int(10) unsigned      | NO   |     | NULL                |       |
| gravity          | tinyint(3) unsigned   | NO   |     | 0                   |       |
| created          | datetime              | NO   |     | 0001-01-01 00:00:00 |       |
| edited           | datetime              | NO   |     | 0001-01-01 00:00:00 |       |
| commented        | datetime              | YES  |     | 0001-01-01 00:00:00 |       |
| received         | datetime              | NO   |     | 0001-01-01 00:00:00 |       |
| changed          | datetime              | YES  |     | 0001-01-01 00:00:00 |       |
| private          | tinyint(3) unsigned   | NO   |     | 0                   |       |
| visible          | tinyint(1)            | NO   |     | 0                   |       |
| deleted          | tinyint(1)            | NO   |     | 0                   |       |
| origin           | tinyint(1)            | NO   |     | 0                   |       |
| global           | tinyint(1)            | NO   |     | 0                   |       |
| network          | char(4)               | NO   |     |                     |       |
| protocol         | tinyint(3) unsigned   | YES  |     | NULL                |       |
| vid              | smallint(5) unsigned  | YES  |     | NULL                |       |
| contact-id       | int(10) unsigned      | NO   |     | 0                   |       |
| contact-blocked  | tinyint(1)            | NO   |     | 1                   |       |
| contact-readonly | tinyint(1)            | NO   |     | 0                   |       |
| contact-pending  | tinyint(1)            | NO   |     | 1                   |       |
| contact-rel      | tinyint(3) unsigned   | NO   |     | 0                   |       |
| contact-uid      | mediumint(8) unsigned | NO   |     | 0                   |       |
| self             | tinyint(1)            | NO   |     | 0                   |       |
| author-id        | int(10) unsigned      | NO   |     | 0                   |       |
| author-blocked   | tinyint(1)            | NO   |     | 1                   |       |
| author-hidden    | tinyint(1)            | NO   |     | 0                   |       |
| author-gsid      | int(10) unsigned      | YES  |     | NULL                |       |
| owner-id         | int(10) unsigned      | NO   |     | 0                   |       |
| owner-blocked    | tinyint(1)            | NO   |     | 1                   |       |
| owner-gsid       | int(10) unsigned      | YES  |     | NULL                |       |
| causer-id        | int(10) unsigned      | YES  |     | NULL                |       |
| causer-blocked   | tinyint(1)            | YES  |     | 1                   |       |
| causer-gsid      | int(10) unsigned      | YES  |     | NULL                |       |
| parent-network   | char(4)               | YES  |     |                     |       |
| parent-owner-id  | int(10) unsigned      | YES  |     | 0                   |       |
| parent-author-id | int(10) unsigned      | YES  |     | 0                   |       |
+------------------+-----------------------+------+-----+---------------------+-------+
36 rows in set (0,002 sec)

original