Public bug reported:
We have the following error on a site with MariaDB and elascticsearch
set up if we want to create a new secret URL for a view:
mysqli 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 'WHERE NOT EXISTS (
SELECT 1 FROM "search_elasticsearch_q' at line 2] in
EXECUTE("INSERT INTO "search_elasticsearch_queue" (itemid, type)
SELECT '1234', 'view' WHERE NOT EXISTS (
SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid
= '1234' AND type = 'view'
)")Command was: INSERT INTO "search_elasticsearch_queue"
(itemid, type)
SELECT ?, ? WHERE NOT EXISTS (
SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid
= ? AND type = ?
)
** Affects: mahara
Importance: Medium
Assignee: Cecilia Vela Gurovic (ceciliavg)
Status: In Progress
** Affects: mahara/19.04
Importance: Medium
Status: New
** Affects: mahara/19.10
Importance: Medium
Status: New
** Affects: mahara/20.04
Importance: Medium
Status: New
** Affects: mahara/20.10
Importance: Medium
Assignee: Cecilia Vela Gurovic (ceciliavg)
Status: In Progress
** Changed in: mahara
Importance: Undecided => Medium
** Also affects: mahara/20.04
Importance: Undecided
Status: New
** Also affects: mahara/19.04
Importance: Undecided
Status: New
** Also affects: mahara/20.10
Importance: Medium
Assignee: Cecilia Vela Gurovic (ceciliavg)
Status: In Progress
** Also affects: mahara/19.10
Importance: Undecided
Status: New
** Changed in: mahara/20.04
Milestone: None => 20.04.1
** Changed in: mahara/19.10
Milestone: None => 19.10.4
** Changed in: mahara/19.04
Milestone: None => 19.04.6
** Changed in: mahara/20.04
Importance: Undecided => Medium
** Changed in: mahara/19.10
Importance: Undecided => Medium
** Changed in: mahara/19.04
Importance: Undecided => Medium
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask
on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1877906
Title:
MariaDB error when creating secret URL
Status in Mahara:
In Progress
Status in Mahara 19.04 series:
New
Status in Mahara 19.10 series:
New
Status in Mahara 20.04 series:
New
Status in Mahara 20.10 series:
In Progress
Bug description:
We have the following error on a site with MariaDB and elascticsearch
set up if we want to create a new secret URL for a view:
mysqli 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 'WHERE NOT EXISTS (
SELECT 1 FROM "search_elasticsearch_q' at line 2] in
EXECUTE("INSERT INTO "search_elasticsearch_queue" (itemid, type)
SELECT '1234', 'view' WHERE NOT EXISTS (
SELECT 1 FROM "search_elasticsearch_queue" WHERE
itemid = '1234' AND type = 'view'
)")Command was: INSERT INTO "search_elasticsearch_queue"
(itemid, type)
SELECT ?, ? WHERE NOT EXISTS (
SELECT 1 FROM "search_elasticsearch_queue" WHERE
itemid = ? AND type = ?
)
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1877906/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
