Method "Symfony\Component\Console\Command\Command::configure()" might add "void" as a native return type declaration in the future. Do the same in child class "App\Command\CronSync" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: In ORM 3.0, the AttributeDriver will report fields for the classes where they are declared. This may uncover invalid mapping configurations. To opt into the new mode today, set the "reportFieldsWhereDeclared" constructor parameter to true. (AttributeDriver.php:77 called by App_KernelDevDebugContainer.php:1852, https://github.com/doctrine/orm/pull/10455, package doctrine/orm)
User Deprecated: Not enabling lazy ghost objects is deprecated and will not be supported in Doctrine ORM 3.0. Ensure Doctrine\ORM\Configuration::setLazyGhostObjectEnabled(true) is called to enable them. (ProxyFactory.php:166 called by EntityManager.php:177, https://github.com/doctrine/orm/pull/10837/, package doctrine/orm)
User Deprecated: Version detection logic for MySQL will change in DBAL 4. Please specify the version as the server reports it, e.g. "10.9.3-MariaDB" instead of "mariadb-10.9". (AbstractMySQLDriver.php:171 called by AbstractMySQLDriver.php:44, https://github.com/doctrine/dbal/pull/5779, package doctrine/orm)
User Deprecated: Method "Symfony\Component\Security\Core\User\UserInterface::eraseCredentials()" might add "void" as a native return type declaration in the future. Do the same in implementation "App\Entity\Benevole" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: JoinColumn configuration is not allowed on the inverse side of one-to-one associations, and will throw a MappingException in Doctrine ORM 3.0 (ClassMetadataInfo.php:1865 called by ClassMetadataInfo.php:2946, https://github.com/doctrine/orm/pull/10654, package doctrine/orm)
User Deprecated: Method "Symfony\Component\Security\Core\User\UserInterface::eraseCredentials()" might add "void" as a native return type declaration in the future. Do the same in implementation "App\Entity\User" now to avoid errors or add an explicit @return annotation to suppress this message.
"SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.prefixe AS prefixe_4, t0.email AS email_5, t0.email_structure AS email_structure_6, t0.signature AS signature_7, t0.signaturemds AS signaturemds_8, t0.updated_date AS updated_date_9, t0.type AS type_10, t0.poste_odm_mds AS poste_odm_mds_11, t0.address AS address_12, t0.email_ade AS email_ade_13, t0.email_formation AS email_formation_14, t0.email_dlus AS email_dlus_15, t0.email_engagement AS email_engagement_16, t0.iban AS iban_17, t0.parent_id AS parent_id_18, t0.odm_mds_id AS odm_mds_id_19 FROM crf_structure t0 WHERE t0.type = ? ORDER BY t0.name ASC"
(parameters:
[1 => "structure.ul"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.prefixe AS prefixe_4, t0.email AS email_5, t0.email_structure AS email_structure_6, t0.signature AS signature_7, t0.signaturemds AS signaturemds_8, t0.updated_date AS updated_date_9, t0.type AS type_10, t0.poste_odm_mds AS poste_odm_mds_11, t0.address AS address_12, t0.email_ade AS email_ade_13, t0.email_formation AS email_formation_14, t0.email_dlus AS email_dlus_15, t0.email_engagement AS email_engagement_16, t0.iban AS iban_17, t0.parent_id AS parent_id_18, t0.odm_mds_id AS odm_mds_id_19 FROM crf_structure t0 WHERE t0.type = ? ORDER BY t0.name ASC"
"params" => [1 => "structure.ul"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
(parameters:
[1 => 72 => 1]
, types:
[1 => 12 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
"params" => [1 => 72 => 1]
"types" => [1 => 12 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
(parameters:
[1 => 62 => 1]
, types:
[1 => 12 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
"params" => [1 => 62 => 1]
"types" => [1 => 12 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
(parameters:
[1 => 42 => 1]
, types:
[1 => 12 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
"params" => [1 => 42 => 1]
"types" => [1 => 12 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
(parameters:
[1 => 32 => 1]
, types:
[1 => 12 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
"params" => [1 => 32 => 1]
"types" => [1 => 12 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
(parameters:
[1 => 52 => 1]
, types:
[1 => 12 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
"params" => [1 => 52 => 1]
"types" => [1 => 12 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
(parameters:
[1 => 22 => 1]
, types:
[1 => 12 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
"params" => [1 => 22 => 1]
"types" => [1 => 12 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
(parameters:
[1 => 82 => 1]
, types:
[1 => 12 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.age AS age_4, t0.name AS name_5, t0.type AS type_6, t0.pole AS pole_7, t0.files AS files_8, t0.structure_id AS structure_id_9, t0.responsable_id AS responsable_id_10 FROM crf_engagement_action t0 WHERE t0.structure_id = ? AND t0.status = ?"
"params" => [1 => 82 => 1]
"types" => [1 => 12 => 5]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"""
SELECT TABLE_NAME\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = ?\n AND TABLE_TYPE = 'BASE TABLE'\nORDER BY TABLE_NAME
"""
[
"sql" => """
SELECT DISTINCT k.CONSTRAINT_NAME,\n k.COLUMN_NAME,\n k.REFERENCED_TABLE_NAME,\n k.REFERENCED_COLUMN_NAME,\n k.ORDINAL_POSITION /*!50116,\n c.UPDATE_RULE,\n c.DELETE_RULE */\nFROM information_schema.key_column_usage k /*!50116\nINNER JOIN information_schema.referential_constraints c\nON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\nAND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'crf31_dev' */ ORDER BY k.ORDINAL_POSITION
"""
"params" => [1 => "crf31_dev"
2 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"""
SELECT c.COLUMN_NAME AS field,\n IF(\n c.COLUMN_TYPE = 'longtext'\n AND EXISTS(\n SELECT * from information_schema.CHECK_CONSTRAINTS i_c\n WHERE i_c.CONSTRAINT_SCHEMA = 'crf31_dev'\n AND i_c.TABLE_NAME = c.TABLE_NAME\n AND i_c.CHECK_CLAUSE = CONCAT(\n 'json_valid(`',\n c.COLUMN_NAME,\n '`)'\n )\n ),\n 'json',\n c.COLUMN_TYPE\n ) AS type,\n c.IS_NULLABLE AS `null`,\n c.COLUMN_KEY AS `key`,\n c.COLUMN_DEFAULT AS `default`,\n c.EXTRA,\n c.COLUMN_COMMENT AS comment,\n c.CHARACTER_SET_NAME AS characterset,\n c.COLLATION_NAME AS collation\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_NAME = c.TABLE_NAME\n WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
"""
[
"sql" => """
SELECT c.COLUMN_NAME AS field,\n IF(\n c.COLUMN_TYPE = 'longtext'\n AND EXISTS(\n SELECT * from information_schema.CHECK_CONSTRAINTS i_c\n WHERE i_c.CONSTRAINT_SCHEMA = 'crf31_dev'\n AND i_c.TABLE_NAME = c.TABLE_NAME\n AND i_c.CHECK_CLAUSE = CONCAT(\n 'json_valid(`',\n c.COLUMN_NAME,\n '`)'\n )\n ),\n 'json',\n c.COLUMN_TYPE\n ) AS type,\n c.IS_NULLABLE AS `null`,\n c.COLUMN_KEY AS `key`,\n c.COLUMN_DEFAULT AS `default`,\n c.EXTRA,\n c.COLUMN_COMMENT AS comment,\n c.CHARACTER_SET_NAME AS characterset,\n c.COLLATION_NAME AS collation\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_NAME = c.TABLE_NAME\n WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
"""
"params" => [1 => "crf31_dev"
2 => "crf31_dev"
3 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 23 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"""
SELECT NON_UNIQUE AS Non_Unique,\n INDEX_NAME AS Key_name,\n COLUMN_NAME AS Column_Name,\n SUB_PART AS Sub_Part,\n INDEX_TYPE AS Index_Type\nFROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
"""