qtype_stack DDL sql execution error

qtype_stack DDL sql execution error

by Kevin McCormick -
Number of replies: 5

Have I found a bug or should I go back and reinstall?

I am installing moodle 39 on my Slackware linux computer.  Installation seems to go OK and moodle works on https://localhost/moodle.  I had to add a firefox security exception for the SSL certificate.  There were a few glitches, but editing the config.php seems to have cleared them up.  The main glitch was entering https://127.0.0.1 as the wwwroot.  Moodle would not load correctly, but I changed that to https://localhost/moodle and it all seemed fine.  Then I tried to install the stack question type plugin,  That also went OK, including downloading the three dependenc zip files.  Then I got to the part where it lists the configuration check and has the button "Update Database Now"  Then the display is "Upgrading to new version" with "qtype_stack" and nothing after that.

php-7.4.7

httpd-2.4.43

mariadb-10.5.4

httpd error log:AH00052: child pid 15139 exit signal Segmentation fault (11)

After a restart of httpd --

httpd error log: zend_mm_heap corrupted

This is from an output screen from an earlier try:

Stack trace:

    line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
    line 1098 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
    line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
    line 427 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
    line 372 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
    line 654 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
    line 1917 of /lib/upgradelib.php: call to upgrade_plugins()
    line 711 of /admin/index.php: call to upgrade_noncore()

Average of ratings: -
In reply to Kevin McCormick

Re: qtype_stack DDL sql execution error

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
MariaDB 10.5? Moodle now has a specific driver $CFG->dbtype = 'mariadb'; $CFG->dblibrary = 'native';.
Average of ratings: -
In reply to Visvanath Ratnaweera

Re: qtype_stack DDL sql execution error

by Kevin McCormick -
Yes, I have this in config.php

$CFG->dbtype = 'mariadb';
$CFG->dblibrary = 'native';

Also, this error in the mariadb error log (/var/lib/mysql/hostname.err
Aborted connection 444 to db: 'moodle' user: 'moodle' host: 'localhost' (Got an error reading communication packets)

I also checked the SSL certificate and firefox has stored as https://127.0.0.1 instead of https://localhost. I deleted the certificate and then readded the exception in firecox with opening moodle again. However, the plugin installation again failed.
Average of ratings: -
In reply to Kevin McCormick

Re: qtype_stack DDL sql execution error

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Looks like your system does not resolve localhost to 127.0.0.1. I don't remember how Slackware handles that, possibly in /etc/hosts?

Edit: Found it! https://www.slackbook.org/html/network-configuration-tcpip.html
Average of ratings: -
In reply to Visvanath Ratnaweera

Re: qtype_stack DDL sql execution error

by Kevin McCormick -
Yes, /etc/hosts. 127.0.0.1 localhost The SSL certificate issue does not seem to be the problem. I will delete what I have and install again.
Average of ratings: -
In reply to Kevin McCormick

Re: qtype_stack DDL sql execution error

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
A fresh start won't be a bad idea. Then don't do many things at once, leave enough time between the steps to be certain that each worked. I also don't see the sense of the SSL certificate for a localhost.
Average of ratings: -