[Mahara-contributors] [Bug 1877906] Re: MariaDB error when creating secret URL

2020-11-01 Thread Robert Lyon
** Changed in: mahara
Milestone: 20.10.0 => None

-- 
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:
  Fix Released
Status in Mahara 19.10 series:
  Fix Released
Status in Mahara 20.04 series:
  Fix Released
Status in Mahara 20.10 series:
  Fix Released

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


[Mahara-contributors] [Bug 1877906] Re: MariaDB error when creating secret URL

2020-10-21 Thread Robert Lyon
** Changed in: mahara/20.10
   Status: Fix Committed => Fix Released

-- 
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:
  Fix Released
Status in Mahara 19.10 series:
  Fix Released
Status in Mahara 20.04 series:
  Fix Released
Status in Mahara 20.10 series:
  Fix Released

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


[Mahara-contributors] [Bug 1877906] Re: MariaDB error when creating secret URL

2020-08-03 Thread Lisa Seeto
** Changed in: mahara/20.04
   Status: Fix Committed => Fix Released

-- 
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:
  Fix Committed
Status in Mahara 19.10 series:
  Fix Released
Status in Mahara 20.04 series:
  Fix Released
Status in Mahara 20.10 series:
  Fix Committed

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


[Mahara-contributors] [Bug 1877906] Re: MariaDB error when creating secret URL

2020-08-03 Thread Cecilia Vela Gurovic
** Changed in: mahara/19.10
   Status: Fix Committed => Fix Released

-- 
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:
  Fix Committed
Status in Mahara 19.10 series:
  Fix Released
Status in Mahara 20.04 series:
  Fix Committed
Status in Mahara 20.10 series:
  Fix Committed

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


[Mahara-contributors] [Bug 1877906] Re: MariaDB error when creating secret URL

2020-06-03 Thread Cecilia Vela Gurovic
** No longer affects: mahara/19.04

-- 
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:
  Fix Committed
Status in Mahara 19.10 series:
  Fix Committed
Status in Mahara 20.04 series:
  Fix Committed
Status in Mahara 20.10 series:
  Fix Committed

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


[Mahara-contributors] [Bug 1877906] Re: MariaDB error when creating secret URL

2020-05-11 Thread Robert Lyon
** Changed in: mahara/20.04
   Status: New => Fix Committed

** Changed in: mahara/19.10
   Status: New => Fix Committed

-- 
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:
  Fix Committed
Status in Mahara 19.04 series:
  New
Status in Mahara 19.10 series:
  Fix Committed
Status in Mahara 20.04 series:
  Fix Committed
Status in Mahara 20.10 series:
  Fix Committed

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


[Mahara-contributors] [Bug 1877906] Re: MariaDB error when creating secret URL

2020-05-11 Thread Robert Lyon
** Changed in: mahara/20.10
   Status: In Progress => Fix Committed

-- 
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:
  Fix Committed
Status in Mahara 19.04 series:
  New
Status in Mahara 19.10 series:
  Fix Committed
Status in Mahara 20.04 series:
  Fix Committed
Status in Mahara 20.10 series:
  Fix Committed

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