Bonjour

Est-il possible de param= =C3=A9trer les cotisations des adh=C3=A9rents en fonction de la cat=C3=A9go= rie d'adh=C3=A9rent et l'ann=C3=A9e ?

Merc= i de vos r=C3=A9ponses

RP<= /div>

--001a114104706a4e5e052aa731f2-- From pierre.roger@domain.hid Sun Jan 31 23:09:47 2016 Received: from Debian-exim by gna.org with spam-scanned (Exim 4.84) (envelope-from ) id 1aQ0Bf-0004WX-2S for galette-discussion@domain.hid; Sun, 31 Jan 2016 23:09:47 +0100 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on mail.gna.org X-Spam-Level: X-Spam-Status: No, score=-2.1 required=3.3 tests=BAYES_00,FREEMAIL_FROM, FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,RP_MATCHES_RCVD,T_DKIM_INVALID autolearn=unavailable autolearn_force=no version=3.4.0 Received: from smtpoutz298.laposte.net ([178.22.154.198] helo=smtp.laposte.net) by gna.org with esmtp (Exim 4.84) (envelope-from ) id 1aQ0Be-0004WP-ST for galette-discussion@domain.hid; Sun, 31 Jan 2016 23:09:38 +0100 Received: from smtp.laposte.net (localhost [127.0.0.1]) by lpn-prd-vrout010 (Postfix) with ESMTP id 8219B45A211 for ; Sun, 31 Jan 2016 23:09:38 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=laposte.net; s=mail1; t=1454278178; bh=VK1QXP5dPncwcY/5RmU49ajXGd0Q1aXaV0n0ZgAxmvI=; h=From:Date:Subject:To; b=STq+3aVx3JhM7OXjIb5D8ggKoUMzIGvNRzV8dbS+Sls/q6rdUKvCHfQqwxk/pOge4 +mtDXRn5AdhsgCqwsxsXlmwNYPJ2H2iMLQQlfuGREQqbFrJEZDr4Jd8vJtCuBkiKav o62+Fz1goP35WOEpd9Xane6pEmvLbaZlBBE3yvhBC+U1NzVg/MYdO5U1g1+ldBlH7O YE6VLI23+BG2HdmJUgHEvFdTxHpz/wdhrNO1M2dNmKjZKqS9V5gYDTcmwPIp1IhRBa frCetPsFqDEBT7T4K4qA43wUdqskL7MPBAahEirnh04LlYwQHAwDjgf6V0vQT3GvXG 4IsP8zenHt/Lg== Received: from lpn-prd-vrin004 (lpn-prd-vrin004.laposte [10.128.63.5]) by lpn-prd-vrout010 (Postfix) with ESMTP id A604D45A3FA for ; Sun, 31 Jan 2016 23:09:35 +0100 (CET) Received: from lpn-prd-vrin004 (localhost [127.0.0.1]) by lpn-prd-vrin004 (Postfix) with ESMTP id E57B270E244 for ; Sun, 31 Jan 2016 23:09:34 +0100 (CET) Received: from mail-lb0-f175.google.com (mail-lb0-f175.google.com [209.85.217.175]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by lpn-prd-vrin004 (Postfix) with ESMTPSA id A8D1E70E240 for ; Sun, 31 Jan 2016 23:09:34 +0100 (CET) Received: by mail-lb0-f175.google.com with SMTP id dx2so65161677lbd.3 for ; Sun, 31 Jan 2016 14:09:34 -0800 (PST) X-Gm-Message-State: AG10YOQN1132rbHs/EH9maFJfoQo/o+tQj807npoFMZGWbSgXMPDafOqW3LG3FYo0iHzkAuCz3s331ZqcJ4AXA== X-Received: by 10.112.147.41 with SMTP id th9mr7157783lbb.74.1454278174377; Sun, 31 Jan 2016 14:09:34 -0800 (PST) MIME-Version: 1.0 Received: by 10.114.29.162 with HTTP; Sun, 31 Jan 2016 14:09:14 -0800 (PST) From: Pierre ROGER Date: Sun, 31 Jan 2016 23:09:14 +0100 X-Gmail-Original-Message-ID: Message-ID: To: Galette general discussion Content-Type: multipart/alternative; boundary=047d7b3a84c4fd1138052aa8855b X-VR-SrcIP: 209.85.217.175 X-VR-FullState: 0 X-VR-Score: -100 X-VR-Cause-1: gggruggvucftvghtrhhoucdtuddrfeekjedrtdelgdduheekucetufdoteggodetrfdotffvucfrrhho X-VR-Cause-2: fhhilhgvmecunfetrffquffvgfenuceurghilhhouhhtmecuhedttdenucesvcftvggtihhpihgvnhht X-VR-Cause-3: shculddquddttddmnecujfgurhephfffkffuvfgtsegrtderredttdejnecuhfhrohhmpefrihgvrhhr X-VR-Cause-4: vgcutffqiffgtfcuoehpihgvrhhrvgdrrhhoghgvrheslhgrphhoshhtvgdrnhgvtheqnecurfgrrhgr X-VR-Cause-5: mhepmhhouggvpehsmhhtphhouhhtpdhhvghlohepmhgrihhlqdhlsgdtqdhfudejhedrghhoohhglhgv X-VR-Cause-6: rdgtohhmpdhinhgvthepvddtledrkeehrddvudejrddujeehpdhmrghilhhfrhhomhepphhivghrrhgv X-VR-Cause-7: rdhrohhgvghrsehlrghpohhsthgvrdhnvghtpdhrtghpthhtohepghgrlhgvthhtvgdqughishgtuhhs X-VR-Cause-8: shhiohhnsehgnhgrrdhorhhg X-VR-AvState: No X-VR-State: 0 Subject: [Galette-discussion] Import : Galop d'essai OK; Import KO X-BeenThere: galette-discussion@domain.hid X-Mailman-Version: 2.1.18 Precedence: list List-Id: Galette general discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 31 Jan 2016 22:09:48 -0000 --047d7b3a84c4fd1138052aa8855b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Bonsoir Lors de l'import de mes adh=C3=A9rents, le galop d'essai marche mais pas l'importation. J'ai fait un essai avec un seul enregistrement et =C3=A7a donne =C3=A7a : Dans le fichier log : 178.33.103.145 - 2016-01-31 22:05:22 - 5 - PHP Notice: Undefined variable: this in /home/unapeda/www/Galette/lib/Galette/IO/FileTrait.php on line 428 178.33.103.145 - 2016-01-31 22:05:27 - 5 - PHP Notice: Undefined variable: members_fields_cats in /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php on line 216 178.33.103.145 - 2016-01-31 22:05:34 - 5 - PHP Notice: Undefined variable: members_fields_cats in /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php on line 216 178.33.103.145 - 2016-01-31 22:05:34 - 3 - Query error: INSERT INTO `galette_adherents` (`id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `societe_adh`, `titre_adh`, `ddn_adh`, `sexe_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `date_modif_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`, `pref_lang`, `lieu_naissance`, `gpgid`, `fingerprint`, `parent_id`) VALUES ('', 'TOTO', 'Franc', '', 'ASSOC1', '1', NULL, '1', '100 grand rue', 'Bat B', '85000', 'LA ROCHE SUR YON', '', '', '', 'toto@domain.hid', '', '', '', '', '', '', 'jabber', '85000', '', '2016-01-31', '2016-01-31', '1', '0', '0', '0', NULL, 'fr_FR', '', '', '', NULL) exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`unapedaassoc`.`galette_adherents`, CONSTRAINT `galette_adherents_ibfk_1` FOREIGN KEY (`id_statut`) REFERENCES `galette_statuts` (`id_statut`))' in /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Driver/Pdo/Co= nnection.php:438 Stack trace: #0 /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Driver/Pdo/Co= nnection.php(438): PDO->query('INSERT INTO `ga...') #1 /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Adapter.php(1= 90): Zend\Db\Adapter\Driver\Pdo\Connection->execute('INSERT INTO `ga...') #2 /home/unapeda/www/Galette/lib/Galette/Core/Db.php(731): Zend\Db\Adapter\Adapter->query('INSERT INTO `ga...', 'execute') #3 /home/unapeda/www/Galette/lib/Galette/Entity/Adherent.php(1262): Galette\Core\Db->execute(Object(Zend\Db\Sql\Insert)) #4 /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php(325): Galette\Entity\Adherent->store() #5 /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php(173): Galette\IO\CsvIn->_storeMembers('galette_import_...') #6 /home/unapeda/www/Galette/import.php(107): Galette\IO\CsvIn->import('galette_import_...', Array, false) #7 {main} 178.33.103.145 - 2016-01-31 22:05:34 - 3 - Something went wrong :'( | SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`unapedaassoc`.`galette_adherents`, CONSTRAINT `galette_adherents_ibfk_1` FOREIGN KEY (`id_statut`) REFERENCES `galette_statuts` (`id_statut`)) #0 /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Driver/Pdo/Co= nnection.php(438): PDO->query('INSERT INTO `ga...') #1 /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Adapter.php(1= 90): Zend\Db\Adapter\Driver\Pdo\Connection->execute('INSERT INTO `ga...') #2 /home/unapeda/www/Galette/lib/Galette/Core/Db.php(731): Zend\Db\Adapter\Adapter->query('INSERT INTO `ga...', 'execute') #3 /home/unapeda/www/Galette/lib/Galette/Entity/Adherent.php(1262): Galette\Core\Db->execute(Object(Zend\Db\Sql\Insert)) #4 /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php(325): Galette\Entity\Adherent->store() #5 /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php(173): Galette\IO\CsvIn->_storeMembers('galette_import_...') #6 /home/unapeda/www/Galette/import.php(107): Galette\IO\CsvIn->import('galette_import_...', Array, false) #7 {main} 178.33.103.145 - 2016-01-31 22:05:34 - 3 - [Galette\IO\CsvIn] Une erreur est survenue lors de l'enregistrement de l'adh=C3=A9rent ligne 1 (TOTO Fran= c) : Merci de votre aide RP --047d7b3a84c4fd1138052aa8855b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Bonsoir

Lors de l'import= de mes adh=C3=A9rents, le galop d'essai marche mais pas l'importat= ion.

J'ai fait un essai avec un seul enregistr= ement et =C3=A7a donne =C3=A7a :

Dans le fichier l= og :

178.33.103.145 - 2016-01-31 22:05:22= - 5 - PHP Notice: Undefined variable: this in /home/unapeda/www/Galette/li= b/Galette/IO/FileTrait.php on line 428

178.33.103.145 - 2016-01-3= 1 22:05:27 - 5 - PHP Notice: Undefined variable: members_fields_cats in /ho= me/unapeda/www/Galette/lib/Galette/IO/CsvIn.php on line 216

178.3= 3.103.145 - 2016-01-31 22:05:34 - 5 - PHP Notice: Undefined variable: membe= rs_fields_cats in /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php on lin= e 216

178.33.103.145 - 2016-01-31 22:05:34 - 3 - Query error: INS= ERT INTO `galette_adherents` (`id_statut`, `nom_adh`, `prenom_adh`, `pseudo= _adh`, `societe_adh`, `titre_adh`, `ddn_adh`, `sexe_adh`, `adresse_adh`, `a= dresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `ema= il_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_p= ublic_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `date_modi= f_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_= info`, `date_echeance`, `pref_lang`, `lieu_naissance`, `gpgid`, `fingerprin= t`, `parent_id`) VALUES ('', 'TOTO', 'Franc', '= ', 'ASSOC1', '1', NULL, '1', '100 grand rue= ', 'Bat B', '85000', 'LA ROCHE SUR YON', '&= #39;, '', '', 'toto@domain.hid= mail.com', '', '', '', '', '= 9;, '', 'jabber', '85000', '', '2016-01= -31', '2016-01-31', '1', '0', '0', '= ;0', NULL, 'fr_FR', '', '', '', NULL) e= xception 'PDOException' with message 'SQLSTATE[23000]: Integrit= y constraint violation: 1452 Cannot add or update a child row: a foreign ke= y constraint fails (`unapedaassoc`.`galette_adherents`, CONSTRAINT `galette= _adherents_ibfk_1` FOREIGN KEY (`id_statut`) REFERENCES `galette_statuts` (= `id_statut`))' in /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db= /Adapter/Driver/Pdo/Connection.php:438

Stack trace:

#0 = /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Driver/Pdo/Co= nnection.php(438): PDO->query('INSERT INTO `ga...')

#1= /home/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Adapter.php(= 190): Zend\Db\Adapter\Driver\Pdo\Connection->execute('INSERT INTO `g= a...')

#2 /home/unapeda/www/Galette/lib/Galette/Core/Db.php(7= 31): Zend\Db\Adapter\Adapter->query('INSERT INTO `ga...', 'e= xecute')

#3 /home/unapeda/www/Galette/lib/Galette/Entity/Adhe= rent.php(1262): Galette\Core\Db->execute(Object(Zend\Db\Sql\Insert))

#4 /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php(325): Galette\= Entity\Adherent->store()

#5 /home/unapeda/www/Galette/lib/Gale= tte/IO/CsvIn.php(173): Galette\IO\CsvIn->_storeMembers('galette_impo= rt_...')

#6 /home/unapeda/www/Galette/import.php(107): Galett= e\IO\CsvIn->import('galette_import_...', Array, false)

#7 {main}

178.33.103.145 - 2016-01-31 22:05:34 - 3 - Something w= ent wrong :'( | SQLSTATE[23000]: Integrity constraint violation: 1452 C= annot add or update a child row: a foreign key constraint fails (`unapedaas= soc`.`galette_adherents`, CONSTRAINT `galette_adherents_ibfk_1` FOREIGN KEY= (`id_statut`) REFERENCES `galette_statuts` (`id_statut`))

#0 /ho= me/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Driver/Pdo/Conne= ction.php(438): PDO->query('INSERT INTO `ga...')

#1 /h= ome/unapeda/www/Galette/includes/Zend-2.3.7/Zend/Db/Adapter/Adapter.php(190= ): Zend\Db\Adapter\Driver\Pdo\Connection->execute('INSERT INTO `ga..= .')

#2 /home/unapeda/www/Galette/lib/Galette/Core/Db.php(731)= : Zend\Db\Adapter\Adapter->query('INSERT INTO `ga...', 'exec= ute')

#3 /home/unapeda/www/Galette/lib/Galette/Entity/Adheren= t.php(1262): Galette\Core\Db->execute(Object(Zend\Db\Sql\Insert))

<= div>#4 /home/unapeda/www/Galette/lib/Galette/IO/CsvIn.php(325): Galette\Ent= ity\Adherent->store()

#5 /home/unapeda/www/Galette/lib/Galette= /IO/CsvIn.php(173): Galette\IO\CsvIn->_storeMembers('galette_import_= ...')

#6 /home/unapeda/www/Galette/import.php(107): Galette\I= O\CsvIn->import('galette_import_...', Array, false)

#7= {main}

178.33.103.145 - 2016-01-31 22:05:34 - 3 - [Galette\IO\Cs= vIn] Une erreur est survenue lors de l'enregistrement de l'adh=C3= =A9rent ligne 1 (TOTO Franc) :

Merci de votre aide