I did an upgrade of the struct-plugin and got this error after the upgrade:
HY000 1 no such column: data_aufgaben.published
SELECT data_aufgaben.rid AS rid,
data_aufgaben.pid AS PID,
data_aufgaben.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_aufgaben.pid AS C0,
data_aufgaben.col3 AS C1,
data_aufgaben.col5 AS C2,
data_aufgaben.col6 AS C3,
data_aufgaben.col7 AS C4
FROM
data_aufgaben AS data_aufgaben
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_aufgaben.pid != ''
AND data_aufgaben.pid = schema_assignments.pid
AND schema_assignments.tbl = 'aufgaben'
WHERE ( ( data_aufgaben.pid = '' OR ( GETACCESSLEVEL(data_aufgaben.pid) > 0 AND PAGEEXISTS(data_aufgaben.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_aufgaben.pid) AND data_aufgaben.latest = 1) OR (IS_PUBLISHER(data_aufgaben.pid) !=1 AND data_aufgaben.published = 1) ) AND ( data_aufgaben.col8 != 'erledigt' ) )
GROUP BY data_aufgaben.pid,
data_aufgaben.rid,
C0,
C1,
C2,
C3,
C4
It seems that the feature of checking whether an element is published was introduced in this change on september 27, 2022:
https://github.com/cosmocode/dokuwiki-plugin-struct/commit/ff40ffd7c6b2e9c0d6dcb877d9936109638dc582
I think it would be easy to create the missing column - but I don't know the exact sql-command. Maybe someone has an nice solution? Otherwise I would try to fix it by myself.
Btw.: I got a backup from before the upgrade, so doing some experiments isn't dangerous.
Greetings,
Christoph
EDIT: I tried to execute
ALTER TABLE data_aufgaben ADD COLUMN published INT DEFAULT NULL
in the sqlite-interface (which I found in the code of the plugin), but this gave me only the error
HY000 1 near "COLUMN": syntax error:
CREATE TEMPORARY TABLE t1667035814 ( pid TEXT DEFAULT "", rev INTEGER NOT NULL, latest BOOLEAN NOT NULL DEFAULT 0, col1 DEFAULT '', col2 DEFAULT '', col3 DEFAULT '', col4 DEFAULT '', col5 DEFAULT '', col6 DEFAULT '', col7 DEFAULT '', col8 DEFAULT '', rid INTEGER, PRIMARY KEY(pid, rev, rid ) , COLUMN published INT DEFAULT NULL)
Edit #2:
The version of my sqlite-plugin is 2022-05-29, the sqlite-plugin was the recent version when I upgraded the struct-plugin.