=== COPRO 51 DIAG ===

--- SYNDIC ---
{"id_copro":51,"id_gerant":null,"id_president":null,"nom":"SDC Les Rochers","adresse":"1 rue Georges Aumont","code_postal":"35500","ville":"VITR\u00c9","immat":"AA2336436","valide":1,"type_syndic":"benevole","is_founder":1,"trial_ends":null,"creation":"2026-03-31 23:31:44","total_tantiemes":1000}

--- USERS ---
{"id":112,"prenom":"Demo","nom":"Visiteur","admin":1,"mail":"demo@thesyndic.com","compte_450":"450112VISITEUR"}
{"id":116,"prenom":"E","nom":"F","admin":0,"mail":"sdc.lesrochers@gmx.fr","compte_450":"450116F"}
{"id":117,"prenom":"P","nom":"N","admin":0,"mail":"sdc.lesrochers@gmx.fr","compte_450":"450117N"}
{"id":118,"prenom":"C","nom":"L","admin":0,"mail":"sdc.lesrochers@gmx.fr","compte_450":"450118L"}
{"id":119,"prenom":"E","nom":"B","admin":0,"mail":"sdc.lesrochers@gmx.fr","compte_450":"450119B"}
{"id":120,"prenom":"C","nom":"B","admin":0,"mail":"sdc.lesrochers@gmx.fr","compte_450":"450120B"}
{"id":121,"prenom":"M","nom":"G","admin":0,"mail":"sdc.lesrochers@gmx.fr","compte_450":"450121G"}

--- LOTS COLS ---
{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"numero","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"user","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"tantieme","Type":"decimal(11,2)","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"etage","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"copro","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"eau","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"elec","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"habitation","Type":"tinyint(1)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"location","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"lot_attached","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"vendu","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"date_vente","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"vendu_a","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"type","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"superficie","Type":"decimal(11,2)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"id_batiment","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}

--- LOTS ---
{"id":114,"numero":3001,"user":116,"tantieme":"51.00","etage":0,"copro":51,"eau":0,"elec":1,"habitation":1,"location":null,"lot_attached":null,"vendu":null,"date_vente":null,"vendu_a":null,"type":1,"superficie":"65.90","id_batiment":null}
{"id":115,"numero":3002,"user":117,"tantieme":"51.00","etage":0,"copro":51,"eau":0,"elec":1,"habitation":1,"location":null,"lot_attached":null,"vendu":null,"date_vente":null,"vendu_a":null,"type":1,"superficie":"65.50","id_batiment":null}
{"id":116,"numero":3101,"user":118,"tantieme":"51.00","etage":1,"copro":51,"eau":0,"elec":1,"habitation":1,"location":null,"lot_attached":null,"vendu":null,"date_vente":null,"vendu_a":null,"type":1,"superficie":"66.30","id_batiment":null}
{"id":117,"numero":3102,"user":119,"tantieme":"51.00","etage":1,"copro":51,"eau":0,"elec":1,"habitation":1,"location":null,"lot_attached":null,"vendu":null,"date_vente":null,"vendu_a":null,"type":1,"superficie":"66.30","id_batiment":null}
{"id":118,"numero":3201,"user":120,"tantieme":"49.00","etage":2,"copro":51,"eau":0,"elec":1,"habitation":1,"location":null,"lot_attached":null,"vendu":null,"date_vente":null,"vendu_a":null,"type":1,"superficie":"65.80","id_batiment":null}
{"id":119,"numero":3202,"user":121,"tantieme":"49.00","etage":2,"copro":51,"eau":0,"elec":1,"habitation":1,"location":null,"lot_attached":null,"vendu":null,"date_vente":null,"vendu_a":null,"type":1,"superficie":"65.80","id_batiment":null}

--- EXERCICES ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'copro' in 'where clause'

--- BUDGET ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bp.copro' in 'where clause'

--- PLAN COMPTABLE ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'numero' in 'field list'

--- ECRITURES COUNT ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'copro' in 'where clause'

--- LIGNES COUNT ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ec.copro' in 'where clause'

--- FACTURES ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'copro' in 'where clause'

--- FOURNISSEURS ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'numero_compte' in 'field list'

--- TYPES ---
{"id":1,"type":"Electricit\u00e9"}
{"id":2,"type":"Gaz"}
{"id":3,"type":"Eau individuelle"}
{"id":4,"type":"Entretien"}
{"id":5,"type":"Assurance"}
{"id":6,"type":"Administratif"}
{"id":7,"type":"Banque"}
{"id":8,"type":"Travaux"}
{"id":9,"type":"Electricit\u00e9 individuelle"}
{"id":10,"type":"Entretien pisicine"}
{"id":11,"type":"Taxe fonci\u00e8re"}
{"id":14,"type":"Eau commune"}

--- TAUX FOND TRAVAUX ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'copro' in 'where clause'

--- PREPARE_PV COLS ---
{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"id_copro","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"id_exercice","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"date","Type":"date","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"lieu","Type":"text","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"validated","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"date_validation","Type":"timestamp","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"id_validateur","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"heure","Type":"time","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"date_envoi_convocation","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"rappel_envoye","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":""}

--- AGs ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'copro' in 'where clause'

--- MODELES ---
{"id":1,"titre":"D\u00e9signation du pr\u00e9sident de s\u00e9ance"}
{"id":2,"titre":"D\u00e9signation des scrutateurs"}
{"id":3,"titre":"D\u00e9signation du secr\u00e9taire de s\u00e9ance"}
{"id":4,"titre":"Approbation des comptes de l'exercice pass\u00e9"}
{"id":5,"titre":"Vote du budget pr\u00e9visionnel"}
{"id":6,"titre":"Renouvellement du contrat de syndic"}
{"id":7,"titre":"R\u00e9alisation de travaux urgents"}
{"id":8,"titre":"Constitution du fonds travaux"}
{"id":9,"titre":"Autorisation de travaux individuels"}
{"id":10,"titre":"Suppression des vide-ordures"}
{"id":11,"titre":"Installation d\u2019un ascenseur"}
{"id":12,"titre":"Mise en conformit\u00e9 des \u00e9quipements"}
{"id":13,"titre":"Changement de la porte principale"}
{"id":14,"titre":"Remplacement des interphones"}
{"id":15,"titre":"Ravalement de fa\u00e7ade"}
{"id":16,"titre":"R\u00e9fection de la toiture"}
{"id":17,"titre":"Am\u00e9nagement des espaces verts"}
{"id":18,"titre":"Installation de cam\u00e9ras de surveillance"}
{"id":19,"titre":"R\u00e9paration de l\u2019ascenseur"}
{"id":20,"titre":"R\u00e9alisation du DTG"}
{"id":21,"titre":"Souscription ou changement de contrat d\u2019assurance"}
{"id":22,"titre":"Changement de banque"}
{"id":23,"titre":"Renouvellement du contrat de syndic b\u00e9n\u00e9vole"}
{"id":24,"titre":"Recalcul des tanti\u00e8mes"}

=== FIN DIAG ===