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