search

nicusX / moodle-mod_attendanceregister

Attendance Register activity module for Moodle 2
12 stars 17 forks source link

DDL error on upgrade to 2.4.1 on MySQL #42

Closed nicusX closed 11 years ago

nicusX commented 11 years ago

Upgrading to 2.4.1 on MySQL cause DDL error: Debug info: Data truncated for column 'onlinesess' at row 2 ALTER TABLE mdl_attendanceregister_aggregate CHANGE online onlinesess TINYINT(1) NOT NULL DEFAULT 1 Error code: ddlexecuteerror Stack trace:

line 432 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 860 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 88 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
line 77 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
line 693 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 70 of /mod/attendanceregister/db/upgrade.php: call to database_manager->rename_field()
line 629 of /lib/upgradelib.php: call to xmldb_attendanceregister_upgrade()
line 360 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1544 of /lib/upgradelib.php: call to upgrade_plugins()
botiq commented 11 years ago

Hi lorenzo, I modified mdl_attendanceregister_aggregate column name online in onlinesess, as you wrote me, and I could upgrade the module without problems. Many thanks Botiq