- Problem: Using HOLDS, HOLDS LIKE, WITHIN or HOLDS WITHIN on the where= field gives a a SQL error, even though the syntax is correct.
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS '<NAME>' ORDER BY _pageName,Nome LIMIT 100' at line 1 (db13.miraheze.org)
Function: CargoSQLQuery::run Query: SELECT _pageName AS Dex,Nome AS Nome FROM cargo__<TABLE> WHERE Nome HOLDS '<NAME>' ORDER BY _pageName,Nome LIMIT 100
- <TABLE> is the Cargo table and <NAME> is the word after the command in the where field.
I personally don't know how exactly the DB backend works, but I never had a problem using the said commands. Considering the recent outages and the mention of MariaDB, it may have something to do with it, but I'm not sure.
I was also unable to use the commands on my alternative wiki (and this one has only 10 rows in the table)