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:81 called by App_KernelDevDebugContainer.php:1439, 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:169 called by EntityManager.php:181, 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:181 called by AbstractMySQLDriver.php:45, https://github.com/doctrine/dbal/pull/5779, package doctrine/orm)
User Deprecated: Support for MariaDB < 10.4 is deprecated and will be removed in DBAL 4. Consider upgrading to a more recent version of MariaDB. (AbstractMySQLDriver.php:70 called by AbstractDriverMiddleware.php:68, https://github.com/doctrine/dbal/pull/6110, package doctrine/dbal)
"SELECT t0.id AS id_1, t0.url AS url_2, t0.username AS username_3, t0.password AS password_4, t0.token AS token_5, t0.created_at AS created_at_6, t0.tipo AS tipo_7, t0.name AS name_8, t0.iv AS iv_9, t0.tag AS tag_10, t0.apikey AS apikey_11, t0.apisecret AS apisecret_12, t0.user_id AS user_id_13 FROM users_ambienti t0 WHERE t0.url = ? LIMIT 1"
(parameters:
[1 => "https://fad.cafoscarichallengeschool.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.username AS username_3, t0.password AS password_4, t0.token AS token_5, t0.created_at AS created_at_6, t0.tipo AS tipo_7, t0.name AS name_8, t0.iv AS iv_9, t0.tag AS tag_10, t0.apikey AS apikey_11, t0.apisecret AS apisecret_12, t0.user_id AS user_id_13 FROM users_ambienti t0 WHERE t0.url = ? LIMIT 1"
"params" => [1 => "https://fad.cafoscarichallengeschool.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT q0_.id AS id_0, q0_.titolo AS titolo_1, q0_.descrizione AS descrizione_2, q0_.created_at AS created_at_3, q0_.corso_id AS corso_id_4, q0_.corso_title AS corso_title_5, q0_.token AS token_6, q0_.anonimo AS anonimo_7, q0_.user_id AS user_id_8, q0_.ambiente_id AS ambiente_id_9, q0_.questionario_id AS questionario_id_10 FROM questionari q0_ WHERE q0_.ambiente_id = ? AND q0_.corso_id IS NOT NULL ORDER BY q0_.id ASC"
(parameters:
[1 => 11]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT q0_.id AS id_0, q0_.titolo AS titolo_1, q0_.descrizione AS descrizione_2, q0_.created_at AS created_at_3, q0_.corso_id AS corso_id_4, q0_.corso_title AS corso_title_5, q0_.token AS token_6, q0_.anonimo AS anonimo_7, q0_.user_id AS user_id_8, q0_.ambiente_id AS ambiente_id_9, q0_.questionario_id AS questionario_id_10 FROM questionari q0_ WHERE q0_.ambiente_id = ? AND q0_.corso_id IS NOT NULL ORDER BY q0_.id ASC"
"params" => [1 => 11]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "user10@42b.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "user10@42b.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "picerni.antonio@gmail.com"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "picerni.antonio@gmail.com"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "tutor01@cafoscarichallengeschool.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "tutor01@cafoscarichallengeschool.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "tutor08@cafoscarichallengeschool.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "tutor08@cafoscarichallengeschool.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "olimpia.demari@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "olimpia.demari@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "lorenzo.paolini@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "lorenzo.paolini@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "carlotta.barina@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "carlotta.barina@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "irene.fontolan@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "irene.fontolan@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "francesca.mariotto@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "francesca.mariotto@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "elizageorgiana.oanca@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "elizageorgiana.oanca@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "silvia.rancan@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "silvia.rancan@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "manuela.torri@unive.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "manuela.torri@unive.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "user11@42b.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "user11@42b.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "tutor02@cafoscarichallengeschool.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "tutor02@cafoscarichallengeschool.it"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
(parameters:
[1 => "tutor09@cafoscarichallengeschool.it"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1"
"params" => [1 => "tutor09@cafoscarichallengeschool.it"
]
"types" => [1 => 2]
]
deprecation
User Deprecated: Since symfony/validator 6.4: Method "Symfony\Component\Validator\ValidatorBuilder::setDoctrineAnnotationReader()" is deprecated without replacement.
[
"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 = 'questionari' */ ORDER BY k.ORDINAL_POSITION
"""
"params" => [1 => "questionari"
2 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"""
SELECT c.COLUMN_NAME AS field,\n c.COLUMN_TYPE 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 c.COLUMN_TYPE 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 => "questionari"
2 => "questionari"
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
"""