Hi Cecilia, This patch is working for me! Thank you.
Hermann > Am 20.07.2020 um 07:43 schrieb Cecilia Vela Gurovic > <[email protected]>: > > Hi Hermann, > > This issue looks similar to the one reported here > https://bugs.launchpad.net/mahara/+bug/1877906 > > Since you are using Mahara 20.04.0, and this fix was released on > 20.04.1, you could try upgrading to that new minor point or applying the > patch for that specific issue and let us know if that solves the > problem. > > For 20.04 you can find the code here > https://reviews.mahara.org/#/c/10969/ > > Cheers, > Cecilia > > -- > You received this bug notification because you are subscribed to the bug > report. > https://bugs.launchpad.net/bugs/1883478 > > Title: > MariaDB 10.2 error with Elasticsearch 6.8/SSO from Moodle not working > > Status in Mahara: > Triaged > > Bug description: > After upgrading to MariaDB 10.2 (mandatory for Moodle 3.9) Mahoodle > integration fails. Logging into Mahara throws a couple of errors and does not > work anymore. > Disabling Elasticsearch solves the problem :-( -- everything working again. > Elasticsearch/SSO from Moodle 3.8.x was working perfectly before the upgrade > to MariaDB 10.2 (from 10.1). > Versions: > Elasticsearch: > "version" : { > "number" : "6.8.10", > "build_flavor" : "default", > "build_type" : "deb", > "build_hash" : "537cb22", > "build_date" : "2020-05-28T14:47:19.882936Z", > "build_snapshot" : false, > "lucene_version" : "7.7.3", > "minimum_wire_compatibility_version" : "5.6.0", > "minimum_index_compatibility_version" : "5.0.0" > Moodle: > Version: 3.9 (2020061500) > Release: 06.15.2020 > PHP: 7.3.19-1+ubuntu16.04.1+deb.sury.org+1 > MySQL: 10.2.32-MariaDB-10.2.32+maria~xenial-log > Mahara: 20.04.0 > > > [DBG] 64 (lib/dml.php:180) 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_qu...' at line 2] in > EXECUTE("INSERT INTO "search_elasticsearch_queue" (itemid, type) > SELECT '3', 'usr' WHERE NOT EXISTS ( > SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid > = '3' AND type = 'usr' > )")Command was: INSERT INTO "search_elasticsearch_queue" > (itemid, type) > SELECT ?, ? WHERE NOT EXISTS ( > SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid > = ? AND type = ? > ) > [WAR] 64 (lib/errors.php:859) Could not execute command: INSERT INTO > "search_elasticsearch_queue" (itemid, type) > SELECT ?, ? WHERE NOT EXISTS ( > SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid > = ? AND type = ? > ) > Call stack (most recent first): > log_message(string(size 240), integer, true, true) at > /var/www/mahara-20.04.0/htdocs/lib/errors.php:95 > log_warn(string(size 240)) at > /var/www/mahara-20.04.0/htdocs/lib/errors.php:859 > SQLException->__construct(string(size 240)) at > /var/www/mahara-20.04.0/htdocs/lib/dml.php:181 > execute_sql(string(size 213), array(size 4)) at > /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2300 > ElasticsearchIndexing::add_to_queue(string(size 1), string(size 3), null) at > /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2268 > ElasticsearchIndexing::bulk_add_to_queue(array(size 1)) at > /var/www/mahara-20.04.0/htdocs/lib/dml.php:1507 > update_record(string(size 3), object(stdClass), array(size 1)) at > /var/www/mahara-20.04.0/htdocs/auth/user.php:417 > User->commit() at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/lib.php:249 > AuthXmlrpc->request_user_authorise(string(size 40), string(size 30)) at > /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/land.php:78 > [WAR] 64 (lib/dml.php:181) Could not execute command: INSERT INTO > "search_elasticsearch_queue" (itemid, type) > SELECT ?, ? WHERE NOT EXISTS ( > SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid > = ? AND type = ? > ) > Call stack (most recent first): > execute_sql(string(size 213), array(size 4)) at > /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2300 > ElasticsearchIndexing::add_to_queue(string(size 1), string(size 3), null) at > /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2268 > ElasticsearchIndexing::bulk_add_to_queue(array(size 1)) at > /var/www/mahara-20.04.0/htdocs/lib/dml.php:1507 > update_record(string(size 3), object(stdClass), array(size 1)) at > /var/www/mahara-20.04.0/htdocs/auth/user.php:417 > User->commit() at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/lib.php:249 > AuthXmlrpc->request_user_authorise(string(size 40), string(size 30)) at > /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/land.php:78 > > To manage notifications about this bug go to: > https://bugs.launchpad.net/mahara/+bug/1883478/+subscriptions -- 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/1883478 Title: MariaDB 10.2 error with Elasticsearch 6.8/SSO from Moodle not working Status in Mahara: Triaged Bug description: After upgrading to MariaDB 10.2 (mandatory for Moodle 3.9) Mahoodle integration fails. Logging into Mahara throws a couple of errors and does not work anymore. Disabling Elasticsearch solves the problem :-( -- everything working again. Elasticsearch/SSO from Moodle 3.8.x was working perfectly before the upgrade to MariaDB 10.2 (from 10.1). Versions: Elasticsearch: "version" : { "number" : "6.8.10", "build_flavor" : "default", "build_type" : "deb", "build_hash" : "537cb22", "build_date" : "2020-05-28T14:47:19.882936Z", "build_snapshot" : false, "lucene_version" : "7.7.3", "minimum_wire_compatibility_version" : "5.6.0", "minimum_index_compatibility_version" : "5.0.0" Moodle: Version: 3.9 (2020061500) Release: 06.15.2020 PHP: 7.3.19-1+ubuntu16.04.1+deb.sury.org+1 MySQL: 10.2.32-MariaDB-10.2.32+maria~xenial-log Mahara: 20.04.0 [DBG] 64 (lib/dml.php:180) 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_qu...' at line 2] in EXECUTE("INSERT INTO "search_elasticsearch_queue" (itemid, type) SELECT '3', 'usr' WHERE NOT EXISTS ( SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = '3' AND type = 'usr' )")Command was: INSERT INTO "search_elasticsearch_queue" (itemid, type) SELECT ?, ? WHERE NOT EXISTS ( SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = ? AND type = ? ) [WAR] 64 (lib/errors.php:859) Could not execute command: INSERT INTO "search_elasticsearch_queue" (itemid, type) SELECT ?, ? WHERE NOT EXISTS ( SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = ? AND type = ? ) Call stack (most recent first): log_message(string(size 240), integer, true, true) at /var/www/mahara-20.04.0/htdocs/lib/errors.php:95 log_warn(string(size 240)) at /var/www/mahara-20.04.0/htdocs/lib/errors.php:859 SQLException->__construct(string(size 240)) at /var/www/mahara-20.04.0/htdocs/lib/dml.php:181 execute_sql(string(size 213), array(size 4)) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2300 ElasticsearchIndexing::add_to_queue(string(size 1), string(size 3), null) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2268 ElasticsearchIndexing::bulk_add_to_queue(array(size 1)) at /var/www/mahara-20.04.0/htdocs/lib/dml.php:1507 update_record(string(size 3), object(stdClass), array(size 1)) at /var/www/mahara-20.04.0/htdocs/auth/user.php:417 User->commit() at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/lib.php:249 AuthXmlrpc->request_user_authorise(string(size 40), string(size 30)) at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/land.php:78 [WAR] 64 (lib/dml.php:181) Could not execute command: INSERT INTO "search_elasticsearch_queue" (itemid, type) SELECT ?, ? WHERE NOT EXISTS ( SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = ? AND type = ? ) Call stack (most recent first): execute_sql(string(size 213), array(size 4)) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2300 ElasticsearchIndexing::add_to_queue(string(size 1), string(size 3), null) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2268 ElasticsearchIndexing::bulk_add_to_queue(array(size 1)) at /var/www/mahara-20.04.0/htdocs/lib/dml.php:1507 update_record(string(size 3), object(stdClass), array(size 1)) at /var/www/mahara-20.04.0/htdocs/auth/user.php:417 User->commit() at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/lib.php:249 AuthXmlrpc->request_user_authorise(string(size 40), string(size 30)) at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/land.php:78 To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1883478/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
