Greetings,
My work group runs a small inter-office wiki (MediaWiki) with a MariaDB backend. One of our side projects is to explore the possibility of integrating the wiki with one of our pre-existing information management systems. W were thinking that a database trigger could be used to call a stored procedure to export the data but we are running into problems implementing this solution. ==The Problem== Every time we try to implement a trigger, the MediWiki instance reports the following error: "A database query error has occurred. This may indicate a bug in the software." ==The Code== A slightly redacted version of the trigger: DELIMITER // CREATE TRIGGER [trigger name] AFTER UPDATE on text FOR EACH ROW BEGIN CALL [name of our stored procedure]; END; // DELIMITER; The stored procedure itself has been tested and functions properly but I am not able to share the code. All I can say is that it builds and executes prepared statements in the course of its operation. ==The Question== Has anyone else run into this problem? If so, what was the solution? Or am I bumping up against a database constraint that I am (obviously) unaware of? Thanks in advance for any replies! Sent from [ProtonMail](https://protonmail.ch) on my PDP-11 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
