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