Bonjour,
La base de données ne comporte aucune donnée.
J’ai sauvegardé la base via phpMyadmin, je l’ai renommé rosariosis.sql et l’ai placé dans le dossier d’installation.
Ensuite j’ai tapé l’adresse mondomaine.com/InstallDatabase.php, j’obtiens un long message d’erreur :
We have a problem, please contact technical support ...
09/30/2025 07:57:34
Date
DB Execute Failed. 1304 PROCEDURE calc_cum_cr_gpa already exists
Failure Notice
-- MySQL database dump
-- Note: database charset must be utf8mb4 and collation must be utf8mb4_unicode_520_ci
-- Fix illegal mix of collations error for views
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_520_ci';
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
-- FJ No auto increment value when 0 is given as an ID.
-- Used to insert "No Address" inside address table.
-- and "Student" inside user_profiles table.
SET sql_mode=CONCAT(@@sql_mode,',NO_AUTO_VALUE_ON_ZERO');
-- Always use InnoDB (default), avoid MyISAM
SET default_storage_engine=InnoDB;
-- Name: calc_cum_cr_gpa(mp_id integer, s_id integer); Type: FUNCTION;
-- @since 11.1 SQL set min Credits to 0 & fix division by zero error
CREATE PROCEDURE calc_cum_cr_gpa(mp_id integer, s_id integer)
BEGIN
UPDATE student_mp_stats
SET cum_cr_weighted_factor = (case when cr_credits = '0' THEN '0' ELSE cr_weighted_factors/cr_credits END),
cum_cr_unweighted_factor = (case when cr_credits = '0' THEN '0' ELSE cr_unweighted_factors/cr_credits END)
WHERE student_mp_stats.student_id = s_id and student_mp_stats.marking_period_id = mp_id;
END;
……..
……..
Merci de votre assistance.