#1 31 Jan 2020 - 16:23:26

Toudousman
Membre
Inscription : 07 Nov 2012
Messages : 2

Même matières plusieurs fois sur le bulletin

Bonjour,

Nous nous retrouvons avec toutes les matières qui se répètent 3 fois sur le bulletin.
Nous avons le même visuel dans le module vidéprojecteur
Comment faire pour régler ce problème ?

Je vous remercie par avance pour votre aide
Thierry

Hors ligne

#2 31 Jan 2020 - 17:18:46

Toudousman
Membre
Inscription : 07 Nov 2012
Messages : 2

Re : Même matières plusieurs fois sur le bulletin

Bonjour ,
j'ai ces messages dans le warning

23/01/2020  17:55:25
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Comprehesion.orale M'BAPPE' AND date='2020-01-23' AND ((id_classe='3' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='8'
DB Error: syntax error

23/01/2020  18:01:19
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Comprehesion.orale M'BAPPE' AND date='2019-10-07' AND ((id_classe='3' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='8'
DB Error: syntax error

23/01/2020  21:59:12
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Cycle cellulaire' AND date = '2019\-09-25' AND coef = '2.00\' AND n.elev_id IN (394,395,397,398,399,400,401,403,404,405,406,407,409,410,412,414,415,416,417,418,419,420,421,422,423,424,425,427,428,429,430,432,433,434,435,436,504\) AND code_mat = '39\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  21:59:17
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Cycle cellulaire' AND date = '2019\-09-25' AND coef = '2.00\' AND n.elev_id IN (394,395,397,398,399,400,401,403,404,405,406,407,409,410,412,414,415,416,417,418,419,420,421,422,423,424,425,427,428,429,430,432,433,434,435,436,504\) AND code_mat = '39\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  21:59:22
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Les maladies génétiques' AND date = '2019\-11-08' AND coef = '2.00\' AND n.elev_id IN (394,395,397,398,399,400,401,403,404,405,406,407,409,410,412,414,415,416,417,418,419,420,421,422,423,424,425,427,428,429,430,432,433,434,435,436,504\) AND code_mat = '39\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  21:59:39
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Cycle cellulaire' AND date = '2019\-09-25' AND coef = '2.00\' AND n.elev_id IN (394,395,397,398,399,400,401,403,404,405,406,407,409,410,412,414,415,416,417,418,419,420,421,422,423,424,425,427,428,429,430,432,433,434,435,436,504\) AND code_mat = '39\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  21:59:52
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Les maladies génétiques' AND date = '2019\-11-08' AND coef = '2.00\' AND n.elev_id IN (394,395,397,398,399,400,401,403,404,405,406,407,409,410,412,414,415,416,417,418,419,420,421,422,423,424,425,427,428,429,430,432,433,434,435,436,504\) AND code_mat = '39\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  21:59:57
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Cycle cellulaire' AND date = '2019\-09-25' AND coef = '2.00\' AND n.elev_id IN (394,395,397,398,399,400,401,403,404,405,406,407,409,410,412,414,415,416,417,418,419,420,421,422,423,424,425,427,428,429,430,432,433,434,435,436,504\) AND code_mat = '39\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  22:03:12
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'La mondialisation' AND date = '2020\-01-23' AND coef = '0.50\' AND n.elev_id IN (257,265,266,268,358,360,364,365,368,369,370,371,375,376,377,378,381,382,383,431,505\) AND code_mat = '15\' AND prof_id = '8\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  22:03:16
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'La mondialisation' AND date = '2020\-01-23' AND coef = '0.50\' AND n.elev_id IN (257,265,266,268,358,360,364,365,368,369,370,371,375,376,377,378,381,382,383,431,505\) AND code_mat = '15\' AND prof_id = '8\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  22:04:09
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'La mondialisation' AND date = '2020\-01-23' AND coef = '0.50\' AND n.elev_id IN (257,265,266,268,358,360,364,365,368,369,370,371,375,376,377,378,381,382,383,431,505\) AND code_mat = '15\' AND prof_id = '8\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

23/01/2020  22:06:49
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'La mondialisation' AND date = '2020\-01-23' AND coef = '0.50\' AND n.elev_id IN (257,265,266,268,358,360,364,365,368,369,370,371,375,376,377,378,381,382,383,431,505\) AND code_mat = '15\' AND prof_id = '8\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

24/01/2020  01:28:27
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'contrat de travail' AND date = '2019\-11-13' AND coef = '1.00\' AND n.elev_id IN (257,265,266,268,358,360,364,365,368,369,370,371,375,376,377,378,381,382,383,431,505\) AND code_mat = '10\' AND prof_id = '24\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

24/01/2020  01:29:41
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'contrat de travail' AND date = '2019\-11-13' AND coef = '1.00\' AND n.elev_id IN (257,265,266,268,358,360,364,365,368,369,370,371,375,376,377,378,381,382,383,431,505\) AND code_mat = '10\' AND prof_id = '24\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

24/01/2020  01:39:02
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Organisation de sante' AND date = '2019\-10-22' AND coef = '1.00\' AND n.elev_id IN (257,265,266,268,358,360,364,365,368,369,370,371,375,376,377,378,381,382,383,431,505\) AND code_mat = '10\' AND prof_id = '24\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

29/01/2020  20:09:41
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Evaluation biens et services12' AND date = '2020\-01-24' AND coef = '1.00\' AND n.elev_id IN (437,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471\) AND code_mat = '23\' AND prof_id = '21\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

29/01/2020  20:09:47
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Evaluation biens et services12' AND date = '2020\-01-24' AND coef = '1.00\' AND n.elev_id IN (437,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471\) AND code_mat = '23\' AND prof_id = '21\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

29/01/2020  23:56:26
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Tissus conjonctifs de l'os' AND date='2019-09-26' AND ((id_classe='6' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

29/01/2020  23:59:54
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Tissus conjonctifs de l'os' AND date='2019-09-26' AND ((id_classe='6' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  00:28:52
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Structure d'un os long' AND date='2019-11-13' AND ((id_classe='6' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  21:01:05
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Structure d'un os long' AND date='2020-01-30' AND ((id_classe='6' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  21:04:12
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Structure d'un os long' AND date='2020-01-30' AND ((id_classe='6' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  21:13:00
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Tissus conjonctifs de l'os' AND date='2019-11-14' AND ((id_classe='4' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  21:17:16
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Tissus conjonctifs de l'os' AND date='2019-11-14' AND ((id_classe='4' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  21:39:36
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Structure d'un os long' AND date='2020-01-30' AND ((id_classe='4' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  21:47:52
Base de type : mysql
Fichier : /97119/triade/verifSujetNote.php
Notice sur la ligne :
SELECT * FROM tria_notes WHERE sujet='Structure d'un os long' AND date='2019-10-10' AND ((id_classe='4' AND id_groupe='0') OR (id_classe='-1' AND id_groupe='0')) AND code_mat='19'
DB Error: syntax error

30/01/2020  21:50:39
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Syst me osseux' AND date = '2019\-11-28' AND coef = '1.00\' AND n.elev_id IN (437,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471\) AND code_mat = '19\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

30/01/2020  21:52:39
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Syst me osseux' AND date = '2019\-11-28' AND coef = '1.00\' AND n.elev_id IN (437,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471\) AND code_mat = '19\' AND prof_id = '6\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

31/01/2020  11:17:13
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Evaluation biens et services12' AND date = '2020\-01-24' AND coef = '1.00\' AND n.elev_id IN (437,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471\) AND code_mat = '23\' AND prof_id = '21\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

31/01/2020  11:17:19
Base de type : mysql
Fichier : /97119/triade/notevisu3.php
Notice sur la ligne :
SELECT note_id, CONCAT( upper(trim(e.nom)),' ',trim(e.prenom) ) , round(note,2), n.elev_id, n.typenote, n.notationsur FROM tria_notes n, tria_eleves e WHERE sujet = 'Evaluation biens et services12' AND date = '2020\-01-24' AND coef = '1.00\' AND n.elev_id IN (437,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471\) AND code_mat = '23\' AND prof_id = '21\' AND n.elev_id = e.elev_id ORDER BY e.nom,e.prenom
DB Error: syntax error

Que faire ?

Hors ligne

#3 11 Feb 2020 - 23:37:20

administrateur
Administrator
Inscription : 09 Sep 2012
Messages : 491

Re : Même matières plusieurs fois sur le bulletin

Quel version de php utilisez vous ?

Hors ligne

Pied de page des forums