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

已关闭
Gijs3 年之前创建 · 1 条评论
Gijs 评论于 3 年之前

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 评论于 3 年之前
发布者

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.
Gijs3 年之前 关闭
登录 并参与到对话中。
未选择里程碑
未指派成员
1 名参与者
正在加载...
取消
保存
这个人很懒,什么都没留下。