Wrong duration

[sam-suresh]

The last call for example, took 4 minutes but it shows 4 seconds.
v5.2.3 (2024072500)

[jrchamp]

Hi @sam-suresh,

It looks like you have the updated version of the code, but the upgrade task may not have run. Specifically:

moodle-mod_zoom/db/upgrade.php

Lines 980 to 991 in aa82084

	if ($oldversion < 2024070300) {
	// Update existing meeting occurrence duration to seconds.
	$occurrences = $DB->get_records('zoom_meeting_details');
	foreach ($occurrences as $occurrence) {
	$duration = $occurrence->end_time - $occurrence->start_time;
	$DB->set_field_select('zoom_meeting_details', 'duration', $duration, 'id = ?', [$occurrence->id]);
	}
	// Zoom savepoint reached.
	upgrade_mod_savepoint(true, 2024070300, 'zoom');
	}

Do you know if a Moodle admin has gone through the upgrade steps? If you log in as an admin, or specifically go to /admin/index.php, it should have indicated that an upgrade was necessary.

If Moodle thinks that everything is upgraded, the SQL to fix all of the rows at once looks like:

UPDATE mdl_zoom_meeting_details SET duration = end_time - start_time;

If you have any questions, please let us know.