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 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
