#240 Debian 11 with mariadb-server-10.0 seems to point to an error in Memcached_DataObject.ph (error in your SQL syntax)

Hi

Installation of Nightly on a (fresh) Debian 11 (mariadb-server-10.0) seems to have completed OK. However - is it possible that there is outdated code in Memcached_DataObject.php?

I get this error (after setting :$config'[db']['debug'] = 1 in config.php)

[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_vals' at line 5] "]

Fixed.

This is on a raspberry, and for some reason that installs mariadb-server-10.0 (which is from jessie). I purged that, and then installed to mariadb-server-10.

Installation now completes, and I see the intended front page.