User Deprecated: The Liip\ImagineBundle\Templating\FilterExtension class is deprecated since version 2.7 and will be removed in 3.0; configure "liip_imagine.twig.mode" to "lazy" instead.
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag" service is deprecated, create your own "session.storage.factory" instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\PasswordAuthenticatedInterface" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The ".container.private.security.password_encoder" service is deprecated, use "security.user_password_hasher" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\UserPasswordEncoder" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\UserPasswordHasher" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface" interface is deprecated, use "Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface" instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.encoder_factory.generic" service is deprecated, use "security.password_hasher_factory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactory" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactoryInterface" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactoryInterface" instead.
User Deprecated: Since symfony/security-http 5.4: The "Symfony\Component\Security\Http\RememberMe\RememberMeServicesInterface" interface is deprecated, use "Symfony\Component\Security\Http\RememberMe\RememberMeHandlerInterface" instead.
User Deprecated: Since symfony/security-http 5.4: The "Symfony\Component\Security\Http\RememberMe\AbstractRememberMeServices" class is deprecated, use "Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler" instead.
User Deprecated: Since symfony/security-http 5.4: The "Symfony\Component\Security\Http\RememberMe\TokenBasedRememberMeServices" class is deprecated, use "Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler" instead.
User Deprecated: Since symfony/security-http 5.4: Method "Symfony\Component\Security\Http\Firewall\ContextListener::setRememberMeServices()" is deprecated, use the new remember me handlers instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.listener.guard.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.guard_handler" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\GuardAuthenticatorHandler" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.manager" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\AuthenticationProviderManager" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Event\AuthenticationFailureEvent" class is deprecated, use "Symfony\Component\Security\Http\Event\LoginFailureEvent" with the new authenticator system instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\Firewall\GuardAuthenticationListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.listener.rememberme.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.3: The "Symfony\Component\Security\Http\Firewall\RememberMeListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.listener.anonymous.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.3: The "Symfony\Component\Security\Http\Firewall\AnonymousAuthenticationListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.4: The $authManager argument of "Symfony\Component\Security\Http\Firewall\AccessListener::__construct" is deprecated.
User Deprecated: Since symfony/security-http 5.4: Not setting the $exceptionOnNoToken argument of "Symfony\Component\Security\Http\Firewall\AccessListener::__construct" to "false" is deprecated.
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.factory.service" service is deprecated, use "session.storage.factory.native", "session.storage.factory.php_bridge" or "session.storage.factory.mock_file" instead.
User Deprecated: The "Sensio\Bundle\FrameworkExtraBundle\Configuration\Route" annotation is deprecated since version 5.2. Use "Symfony\Component\Routing\Annotation\Route" instead.
"SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.id = ?"
(parameters:
[1 => "296"
]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.id = ?"
"params" => [1 => "296"
]
"types" => [1 => 1]
]
deprecation
Deprecated: Return type of App\Entity\Sequence::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
User Deprecated: Since symfony/security-core 5.4: Not setting the 5th argument of "Symfony\Component\Security\Core\Authorization\AuthorizationChecker::__construct" to "false" is deprecated.
User Deprecated: Since symfony/security-core 5.4: Using an object that is not an instance of "Symfony\Component\Security\Core\User\UserInterface" as $user in "Symfony\Component\Security\Core\Authentication\Token\AnonymousToken" is deprecated.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.provider.guard.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\Provider\GuardAuthenticationProvider" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\Provider\AuthenticationProviderInterface" interface is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.provider.rememberme.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\Provider\RememberMeAuthenticationProvider" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.provider.anonymous.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\Provider\AnonymousAuthenticationProvider" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.4: Setting the $authenticatorManagerEnabled argument of "Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector::__construct" to "false" is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.4: The "Symfony\Bundle\SecurityBundle\Security\FirewallConfig::allowsAnonymous()" method is deprecated.
[
"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 = 'bethesda' */ ORDER BY k.ORDINAL_POSITION
"""
"params" => [1 => "bethesda"
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 = 'bethesda'\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
"""