stararmy I updated struct and SQLlite and now any page that used struct (which I have a ton of) shows the error message "PDOException: SQLSTATE[HY000]: General error: 1 no such column: data_products.published" or similar. I am trying to figure out how to fix this but I'm not sure where to start.
fini I had the same error after updating sqlite and struct. After update i think dbversion=19 should be correct. Your solution UPDATE opts SET val=18 WHERE opt='dbversion' solved the problem. After that i did UPDATE opts SET val=19 WHERE opt='dbversion' and it works further. Maybe the first step is not neccessary. Unfortunately i did not check dbversion with SELECT * FROM opts before. I have another setup where the problem did not occur.
vic666 I have the same issue, none of my struct pages work and SQLite seems to be the culprite. Unfortunately, even the SQLite interface in DokuWiki is affected. When I press the "List tables" link, I get a 403 error. Any advice?
stararmy Just had to do this again to unbreak my wiki after updating SQLlite and struct. See also: https://forum.dokuwiki.org/d/21194-attention-on-sqlite-update-and-related-plugins-like-struct
stararmy It somehow broke itself after a while again. See: https://forum.dokuwiki.org/d/21208-updating-struct-and-sqlite-broke-my-wiki-again