mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1877906@xxxxxxxxxxxxxxxxxx>]

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