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