Bonjour à tous,
j'aimerais savoir si l'un de vous a testé Galette V0.8.3
(http://download.tuxfamily.org/galette/galette-0.8.3.tar.bz2) avec une
configuration serveur:
Wampserver 3.0.6 32 bit x86 – Apache 2.4.23 – PHP 5.6.25 – MySQL
5.7.14 – PhpMyAdmin 4.6.4
De mon côté, l'installation se passe conformément à la doc mais
lorsque je veux créer un adhérent j'ai l'erreur suivante:
"Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'false'
for column 'required' at row 1' in
C:\wamp\www\galette-0.8.3\galette\includes\Zend-2.3.7\Zend\Db\Adapter\Driver\Pdo\Statement.php
on line 244" (voir pièce jointe).
Je n'ai pas cette erreur dans la même configuration serveur avec
Galette V0.7.8. (avec les lib de l'époque).
J'ai du mal mal à savoir d'où vient l'erreur, j'ai mis un
var_dump($this) dans Statement.php et on voit bien que
ParameterContainer/data est rempli n'importe comment.
J'espère être compréhensible dans mes explications.
Merci d'avance.
--
Cordialement,
Amaury FROMENT
C:\wamp\www\galette-0.8.3\galette\includes\Zend-2.3.7\Zend\Db\Adapter\Driver\Pdo\Statement.php:214:
object(Zend\Db\Adapter\Driver\Pdo\Statement)[31]
protected 'pdo' =>
object(PDO)[20]
protected 'profiler' => null
protected 'driver' =>
object(Zend\Db\Adapter\Driver\Pdo\Pdo)[13]
protected 'connection' =>
object(Zend\Db\Adapter\Driver\Pdo\Connection)[14]
protected 'driver' =>
&object(Zend\Db\Adapter\Driver\Pdo\Pdo)[13]
protected 'profiler' => null
protected 'driverName' => string 'mysql' (length=5)
protected 'connectionParameters' =>
array (size=7)
...
protected 'resource' =>
object(PDO)[20]
...
protected 'inTransaction' => boolean false
protected 'dsn' => string
'mysql:dbname=asnextersql;host=localhost;port=3306;charset=utf8' (length=62)
protected 'statementPrototype' =>
object(Zend\Db\Adapter\Driver\Pdo\Statement)[15]
protected 'pdo' => null
protected 'profiler' => null
protected 'driver' =>
&object(Zend\Db\Adapter\Driver\Pdo\Pdo)[13]
protected 'sql' => string '' (length=0)
protected 'isQuery' => null
protected 'parameterContainer' => null
protected 'parametersBound' => boolean false
protected 'resource' => null
protected 'isPrepared' => boolean false
protected 'resultPrototype' =>
object(Zend\Db\Adapter\Driver\Pdo\Result)[16]
protected 'statementMode' => string 'forward' (length=7)
protected 'resource' => null
protected 'options' => null
protected 'currentComplete' => boolean false
protected 'currentData' => null
protected 'position' => int -1
protected 'generatedValue' => null
protected 'rowCount' => null
protected 'features' =>
array (size=0)
empty
protected 'sql' => string 'INSERT INTO `galette_fields_config` (`field_id`,
`table_name`, `required`, `visible`, `id_field_category`, `position`) VALUES
(:field_id, :table_name, :required, :visible, :id_field_category, :position)'
(length=202)
protected 'isQuery' => null
protected 'parameterContainer' =>
object(Zend\Db\Adapter\ParameterContainer)[85]
protected 'data' =>
array (size=6)
'field_id' => string ':field_id' (length=9)
'table_name' => string ':table_name' (length=11)
'required' => string ':required' (length=9)
'visible' => string ':visible' (length=8)
'id_field_category' => string ':category' (length=9)
'position' => string ':position' (length=9)
protected 'positions' =>
array (size=6)
0 => string 'field_id' (length=8)
1 => string 'table_name' (length=10)
2 => string 'required' (length=8)
3 => string 'visible' (length=7)
4 => string 'id_field_category' (length=17)
5 => string 'position' (length=8)
protected 'errata' =>
array (size=0)
empty
protected 'parametersBound' => boolean false
protected 'resource' =>
object(PDOStatement)[87]
public 'queryString' => string 'INSERT INTO `galette_fields_config`
(`field_id`, `table_name`, `required`, `visible`, `id_field_category`,
`position`) VALUES (:field_id, :table_name, :required, :visible,
:id_field_category, :position)' (length=202)
protected 'isPrepared' => boolean true
( ! ) Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'false' for
column 'required' at row 1' in
C:\wamp\www\galette-0.8.3\galette\includes\Zend-2.3.7\Zend\Db\Adapter\Driver\Pdo\Statement.php
on line 244
( ! ) PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer
value: 'false' for column 'required' at row 1 in
C:\wamp\www\galette-0.8.3\galette\includes\Zend-2.3.7\Zend\Db\Adapter\Driver\Pdo\Statement.php
on line 239
Call Stack
# Time Memory Function Location
1 0.0014 173784 {main}( ) ...\self_adherent.php:0
2 0.1065 4280280 Galette\Entity\FieldsConfig->__construct( )
...\self_adherent.php:62
3 0.1089 4279600 Galette\Entity\FieldsConfig->_checkUpdate( )
...\FieldsConfig.php:151
4 0.1130 4304952 Galette\Entity\FieldsConfig->_insert( )
...\FieldsConfig.php:313
5 0.1141 4365592 Zend\Db\Adapter\Driver\Pdo\Statement->execute( )
...\FieldsConfig.php:829
6 0.1145 4371176 execute ( ) ...\Statement.php:239
( ! ) Zend\Db\Adapter\Exception\InvalidQueryException: Statement could not be
executed (HY000 - 1366 - Incorrect integer value: 'false' for column
'required' at row 1) in
C:\wamp\www\galette-0.8.3\galette\includes\Zend-2.3.7\Zend\Db\Adapter\Driver\Pdo\Statement.php
on line 244
Call Stack
# Time Memory Function Location
1 0.0014 173784 {main}( ) ...\self_adherent.php:0
2 0.1065 4280280 Galette\Entity\FieldsConfig->__construct( )
...\self_adherent.php:62
3 0.1089 4279600 Galette\Entity\FieldsConfig->_checkUpdate( )
...\FieldsConfig.php:151
[Galette-devel] Demande d'info installation de Galette V0.8.3