FIXED (outdated mariadb version) Re: recent mariadb and json: what about Memcached_DataObject.php

[Gijs Hillenius]

This installation is on a newly downloaded version of PiOS on a
Raspberry. For some reason it ran mariadb-server-10.0 (from Jessie). I
purged that, installed the bullseye version (mariadb-10.5) redid the
installation, and now it works.


yay!

>
> Is it possible that recent versions of MariaDB come with JSON support
> which causes Memcached_DataObject.php to fail?
>
> The error message displayed on the site following a (seemingly
> succesful) installation;
>
> Notice] DB_DataObject error []: MDB2 Error: syntax error
>
> Trying to investigate this further, I added /this/ to my config.php:
>
> $config['db']['debug'] = 1;
>
> which gives me lots of debug output on the database. It seems to be in
> Memcached_DataObject.php.
>
>
>
> Notice: Query Error: [mdb2_error: message="MDB2 Error: syntax error"
> code=-2 mode=return level=notice prefix="" info="_doQuery: [Error
> message: Could not execute statement]
>
> [Last executed query: SELECT `notice`.*
> FROM `notice`
>
> INNER JOIN (
> WITH t1 (id, id_pos) AS (VALUES (NULL,0) LIMIT 0)
> SELECT * FROM t1
> ) AS `notice_vals` USING (id)
> WHERE ( `notice`.id IS NOT NULL )
>
>
> ORDER BY `notice_vals`.id_pos
> ]
> [Native code: 1064]
>
> [Native message: 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 't1 (id, id_pos) AS (VALUES (NULL,0) LIMIT 0)
>
> SELECT * FROM t1
> ) AS `notice_val' at line 5]
> "]
>
> Notice: 1: Clearing Cache for notice
> User: 1: Clearing Cache for user
>

-- 
No woman can call herself free until she can choose consciously whether
she will or will not be a mother.
                -- Margaret H. Sanger