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

Closed
opened 3 years ago by Gijs · 1 comments
Gijs commented 3 years ago

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] "]

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] "]
Gijs commented 3 years ago
Poster

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.

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.
Sign in to join this conversation.
No Milestone
No assignee
1 Participants
Loading...
Cancel
Save
There is no content yet.