Dear Moodle community:

A fresh install of Moodle 4.5 has yielded the following:

Debug info: 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 '-course AUTO_INCREMENT = 2' at line 1
ALTER TABLE la-course AUTO_INCREMENT = 2
Error code: ddlexecuteerror 

Stack trace:

• line 503 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
• line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
• line 1189 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
• line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
• line 125 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
• line 84 of /lib/db/install.php: call to database_manager->reset_sequence()
• line 1810 of /lib/upgradelib.php: call to xmldb_main_install()
• line 277 of /admin/index.php: call to install_core()

The server is running Ubuntu 24.04 with MariaDB 10.11.8 and Nginx 1.24.0. I have installed Moodle numerous times and never encountered such an error.

Each time I am performing the installation, I am dropping and re-creating the database in MariaDB and erasing all contents in the Moodle Data folder.

Any suggestions would be most appreciated.

Many thanks.