- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我正在使用 Doctrine,通过 StofDoctrineExtensionsBundle 使用 DoctrineExtensions 使用“Doctrine Extensions Sluggable”行为自动生成 slug。
听众似乎已正确注册。实体字段也被标记为 sluggable。
当尝试通过 Symfony 表单持久化我的实体时,不会发生 slug 生成。正在抛出数据库异常。
异常(exception):
An exception occurred while executing 'INSERT INTO event (startDate, endDate, title, slug, description, image, followers, city, place) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["2017-06-24 20:00:00", "2017-06-26 12:00:00", "Test event name for slug generation", null, "Test", null, null, "Somewhere", "Somewhere else"]:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'slug' cannot be null
版本:
PHP 7.0.15
symfony/symfony v3.2.9
doctrine/doctrine-bundle 1.6.8
doctrine/orm v2.5.6
gedmo/doctrine-extensions v2.4.29
stof/doctrine-extensions-bundle v1.2.2
配置.yml
doctrine:
dbal:
driver: pdo_mysql
host: '%database_host%'
port: '%database_port%'
dbname: '%database_name%'
user: '%database_user%'
password: '%database_password%'
charset: UTF8
orm:
auto_generate_proxy_classes: '%kernel.debug%'
naming_strategy: doctrine.orm.naming_strategy.underscore
auto_mapping: true
stof_doctrine_extensions:
default_locale: '%locale%' # pl
translation_fallback: true
orm:
default:
sluggable: true
实体(Event.orm.xml)
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd"
xmlns:gedmo="http://Atlantic18.github.io/DoctrineExtensions/schemas/orm/doctrine-extensions-3.0.xsd">
<entity repository-class="AppBundle\Repository\EventRepository" name="AppBundle\Entity\Event">
<id name="id" type="integer" column="id">
<generator strategy="AUTO"/>
</id>
<field name="startDate" type="datetime" column="startDate"/>
<field name="endDate" type="datetime" column="endDate"/>
<field name="title" type="string" column="title" length="255"/>
<field name="slug" type="string" column="slug" length="255" unique="true">
<gedmo:slug unique="true" updatable="true" fields="title" separator="-" />
</field>
<field name="description" type="text" column="description" nullable="true"/>
<field name="image" type="string" column="image" length="255" nullable="true"/>
<field name="followers" type="integer" column="followers" nullable="true"/>
<field name="city" type="string" column="city" nullable="false" />
<field name="place" type="string" column="place" nullable="true" />
</entity>
</doctrine-mapping>
Controller Action :
public function createAction(Request $request)
{
$form = $this->createForm(EventType::class);
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid()) {
/** @var Event $event */
$event = $form->getData();
$em = $this->getDoctrine()->getManager();
$em->persist($event);
$em->flush();
$this->addFlash('success', 'event created');
return $this->redirectToRoute('calendar_event', [
'slug' => $event->getSlug()
]);
}
return ['form' => $form->createView()];
}
完整堆栈跟踪:
[1] Doctrine\DBAL\Exception\NotNullConstraintViolationException: An exception occurred while executing 'INSERT INTO event (startDate, endDate, title, slug, description, image, followers, city, place) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["2017-06-24 20:00:00", "2017-06-26 12:00:00", "Test event name for slug generation", null, "Test", null, null, "Somewhere", "Somewhere else"]:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'slug' cannot be null
at n/a
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112
at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'INSERT INTO event (startDate, endDate, title, slug, description, image, followers, city, place) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\' with params ["2017-06-24 20:00:00", "2017-06-26 12:00:00", "Test event name for slug generation", null, "Test", null, null, "Somewhere", "Somewhere else"]:SQLSTATE[23000]: Integrity constraint violation: 1048 Column \'slug\' cannot be null', object(PDOException))
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 128
at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'INSERT INTO event (startDate, endDate, title, slug, description, image, followers, city, place) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('2017-06-24 20:00:00', '2017-06-26 12:00:00', 'Test event name for slug generation', null, 'Test', null, null, 'Somewhere', 'Somewhere else'))
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 177
at Doctrine\DBAL\Statement->execute()
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 281
at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1014
at Doctrine\ORM\UnitOfWork->executeInserts(object(ClassMetadata))
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 378
at Doctrine\ORM\UnitOfWork->commit(null)
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356
at Doctrine\ORM\EntityManager->flush(null)
in /project_home/var/cache/dev/appDevDebugProjectContainer.php line 7072
at DoctrineORMEntityManager_00000000751279ee000000007e7efeea3473a0393d6fcd1415b2fc588e376308->flush(null)
in /project_home/var/cache/dev/jms_diextra/doctrine/EntityManager_59394e2cc7d86.php line 313
at EntityManager59394e2cc7d86_546a8d27f194334ee012bfe64f629947b07e4919\__CG__\Doctrine\ORM\EntityManager->flush()
in /project_home/src/AppBundle/Controller/CalendarController.php line 56
at AppBundle\Controller\CalendarController->createAction(object(Request))
in line
at ReflectionMethod->invokeArgs(object(CalendarController), array(object(Request)))
in /project_home/vendor/jms/cg/src/CG/Proxy/MethodInvocation.php line 84
at CG\Proxy\MethodInvocation->proceed()
in /project_home/vendor/jms/security-extra-bundle/Security/Authorization/Interception/MethodSecurityInterceptor.php line 133
at JMS\SecurityExtraBundle\Security\Authorization\Interception\MethodSecurityInterceptor->intercept(object(MethodInvocation))
in /project_home/vendor/jms/cg/src/CG/Proxy/MethodInvocation.php line 79
at CG\Proxy\MethodInvocation->proceed()
in /project_home/var/cache/dev/jms_diextra/proxies/AppBundle-Controller-CalendarController.php line 21
at EnhancedProxye0ff800f_2852d4e43776e45f00f38751350397dbf530e575\__CG__\AppBundle\Controller\CalendarController->createAction(object(Request))
in line
at call_user_func_array(array(object(CalendarController), 'createAction'), array(object(Request)))
in /project_home/var/cache/dev/classes.php line 4228
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
in /project_home/var/cache/dev/classes.php line 4183
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
in /project_home/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 168
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
in /project_home/web/app_dev.php line 28
at require('/project_home/web/app_dev.php')
in /project_home/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Resources/config/router_dev.php line 40
[2] Doctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'slug' cannot be null
at n/a
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 93
at Doctrine\DBAL\Driver\PDOStatement->execute(null)
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 168
at Doctrine\DBAL\Statement->execute()
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 281
at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1014
at Doctrine\ORM\UnitOfWork->executeInserts(object(ClassMetadata))
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 378
at Doctrine\ORM\UnitOfWork->commit(null)
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356
at Doctrine\ORM\EntityManager->flush(null)
in /project_home/var/cache/dev/appDevDebugProjectContainer.php line 7072
at DoctrineORMEntityManager_00000000751279ee000000007e7efeea3473a0393d6fcd1415b2fc588e376308->flush(null)
in /project_home/var/cache/dev/jms_diextra/doctrine/EntityManager_59394e2cc7d86.php line 313
at EntityManager59394e2cc7d86_546a8d27f194334ee012bfe64f629947b07e4919\__CG__\Doctrine\ORM\EntityManager->flush()
in /project_home/src/AppBundle/Controller/CalendarController.php line 56
at AppBundle\Controller\CalendarController->createAction(object(Request))
in line
at ReflectionMethod->invokeArgs(object(CalendarController), array(object(Request)))
in /project_home/vendor/jms/cg/src/CG/Proxy/MethodInvocation.php line 84
at CG\Proxy\MethodInvocation->proceed()
in /project_home/vendor/jms/security-extra-bundle/Security/Authorization/Interception/MethodSecurityInterceptor.php line 133
at JMS\SecurityExtraBundle\Security\Authorization\Interception\MethodSecurityInterceptor->intercept(object(MethodInvocation))
in /project_home/vendor/jms/cg/src/CG/Proxy/MethodInvocation.php line 79
at CG\Proxy\MethodInvocation->proceed()
in /project_home/var/cache/dev/jms_diextra/proxies/AppBundle-Controller-CalendarController.php line 21
at EnhancedProxye0ff800f_2852d4e43776e45f00f38751350397dbf530e575\__CG__\AppBundle\Controller\CalendarController->createAction(object(Request))
in line
at call_user_func_array(array(object(CalendarController), 'createAction'), array(object(Request)))
in /project_home/var/cache/dev/classes.php line 4228
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
in /project_home/var/cache/dev/classes.php line 4183
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
in /project_home/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 168
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
in /project_home/web/app_dev.php line 28
at require('/project_home/web/app_dev.php')
in /project_home/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Resources/config/router_dev.php line 40
[3] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'slug' cannot be null
at n/a
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 91
at PDOStatement->execute(null)
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 91
at Doctrine\DBAL\Driver\PDOStatement->execute(null)
in /project_home/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 168
at Doctrine\DBAL\Statement->execute()
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 281
at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1014
at Doctrine\ORM\UnitOfWork->executeInserts(object(ClassMetadata))
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 378
at Doctrine\ORM\UnitOfWork->commit(null)
in /project_home/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356
at Doctrine\ORM\EntityManager->flush(null)
in /project_home/var/cache/dev/appDevDebugProjectContainer.php line 7072
at DoctrineORMEntityManager_00000000751279ee000000007e7efeea3473a0393d6fcd1415b2fc588e376308->flush(null)
in /project_home/var/cache/dev/jms_diextra/doctrine/EntityManager_59394e2cc7d86.php line 313
at EntityManager59394e2cc7d86_546a8d27f194334ee012bfe64f629947b07e4919\__CG__\Doctrine\ORM\EntityManager->flush()
in /project_home/src/AppBundle/Controller/CalendarController.php line 56
at AppBundle\Controller\CalendarController->createAction(object(Request))
in line
at ReflectionMethod->invokeArgs(object(CalendarController), array(object(Request)))
in /project_home/vendor/jms/cg/src/CG/Proxy/MethodInvocation.php line 84
at CG\Proxy\MethodInvocation->proceed()
in /project_home/vendor/jms/security-extra-bundle/Security/Authorization/Interception/MethodSecurityInterceptor.php line 133
at JMS\SecurityExtraBundle\Security\Authorization\Interception\MethodSecurityInterceptor->intercept(object(MethodInvocation))
in /project_home/vendor/jms/cg/src/CG/Proxy/MethodInvocation.php line 79
at CG\Proxy\MethodInvocation->proceed()
in /project_home/var/cache/dev/jms_diextra/proxies/AppBundle-Controller-CalendarController.php line 21
at EnhancedProxye0ff800f_2852d4e43776e45f00f38751350397dbf530e575\__CG__\AppBundle\Controller\CalendarController->createAction(object(Request))
in line
at call_user_func_array(array(object(CalendarController), 'createAction'), array(object(Request)))
in /project_home/var/cache/dev/classes.php line 4228
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
in /project_home/var/cache/dev/classes.php line 4183
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
in /project_home/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 168
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
in /project_home/web/app_dev.php line 28
at require('/project_home/web/app_dev.php')
in /project_home/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Resources/config/router_dev.php line 40
最佳答案
我看到的唯一区别在于您的 xml 命名空间声明。您在使用版本 2.x 时引用版本 3.x 的 url。官方文档使用这个架构
http://gediminasm.org/schemas/orm/doctrine-extensions-mapping
确保相应地更新您的 xml 映射:
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd"
xmlns:gedmo="http://gediminasm.org/schemas/orm/doctrine-extensions-mapping">
<entity repository-class="AppBundle\Repository\EventRepository" name="AppBundle\Entity\Event">
<id name="id" type="integer" column="id">
<generator strategy="AUTO"/>
</id>
<field name="startDate" type="datetime" column="startDate"/>
<field name="endDate" type="datetime" column="endDate"/>
<field name="title" type="string" column="title" length="255"/>
<field name="slug" type="string" column="slug" length="255" unique="true">
<gedmo:slug unique="true" updatable="true" fields="title" separator="-" />
</field>
<field name="description" type="text" column="description" nullable="true"/>
<field name="image" type="string" column="image" length="255" nullable="true"/>
<field name="followers" type="integer" column="followers" nullable="true"/>
<field name="city" type="string" column="city" nullable="false" />
<field name="place" type="string" column="place" nullable="true" />
</entity>
</doctrine-mapping>
关于symfony - Doctrine Sluggable - 列 'slug' 不能为空,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/44497079/
我正在 csv 上使用 hadoop 来分析一些数据。我使用sql/mysql(不确定)来分析数据,现在陷入了僵局。 我花了好几个小时在谷歌上搜索,却没有找到任何相关的东西。我需要一个查询,在该查询中
我正在为 Bootstrap 网格布局的“简单”任务而苦苦挣扎。我希望在大视口(viewport)上有 4 列,然后在中型设备上有 2 列,最后在较小的设备上只有 1 列。 当我测试我的代码片段时,似
对于这个令人困惑的标题,我深表歉意,我想不出这个问题的正确措辞。相反,我只会给你背景信息和目标: 这是在一个表中,一个人可能有也可能没有多行数据,这些行可能包含相同的 activity_id 值,也可
具有 3 列的数据库表 - A int , B int , C int 我的问题是: 如何使用 Sequelize 结果找到 A > B + C const countTasks = await Ta
我在通过以下功能编写此查询时遇到问题: 首先按第 2 列 DESC 排序,然后从“不同的第 1 列”中选择 只有 Column1 是 DISTINCT 此查询没有帮助,因为它首先从第 1 列中进行选择
使用 Bootstrap 非常有趣和有帮助,目前我在创建以下需求时遇到问题。 “使用 bootstrap 在桌面上有 4 列,在平板电脑上有 2 列,在移动设备上有 1 列”谁能告诉我正确的结构 最佳
我是 R 新手,正在问一个非常基本的问题。当然,我在尝试从所提供的示例中获取指导的同时做了功课here和 here ,但无法在我的案例中实现这个想法,即可能是由于我的问题中的比较维度更大。 我的实
通常我会使用 R 并执行 merge.by,但这个文件似乎太大了,部门中的任何一台计算机都无法处理它! (任何从事遗传学工作的人的附加信息)本质上,插补似乎删除了 snp ID 的 rs 数字,我只剩
我有一个 df , delta1 delta2 0 -1 2 0 -1 0 0 0 我想知道如何分配 delt
您好,我想知道是否可以执行以下操作。显然,我已经尝试在 phpMyAdmin 中运行它,但出现错误。也许还有另一种方式来编写此查询。 SELECT * FROM eat_eat_restaurants
我有 2 个列表(标题和数据值)。我想要将数据值列 1 匹配并替换为头文件列 1,以获得与 dataValue 列 1 和标题值列 2 匹配的值 头文件 TotalLoad,M0001001 Hois
我有两个不同长度的文件,file2 是一个很大的引用文件,我从中提取文件 1 的数据。 我有一行 awk,我通常会对其进行调整以在我的文件中进行查找和替换,但它总是在同一列中进行查找和替换。 所以对于
假设我有两个表,如下所示。 create table contract( c_ID number(1) primary key, c_name varchar2(50) not
我有一个带有 varchar 列的 H2 表,其检查约束定义如下: CONSTRAINT my_constraint CHECK (varchar_field <> '') 以下插入语句失败,但当我删
这是最少量的代码,可以清楚地说明我的问题: One Two Three 前 2 个 div 应该是 2 个左列。第三个应该占据页面的其余部分。最后,我将添加选项来隐藏和
在 Azure 中的 Log Analytics 中,我为 VM Heartbeat 选择一个预定义查询,我在编辑器中运行查询正常,但当我去创建警报时,我不断收到警报“查询未返回 TimeGenera
在 Azure 中的 Log Analytics 中,我为 VM Heartbeat 选择一个预定义查询,我在编辑器中运行查询正常,但当我去创建警报时,我不断收到警报“查询未返回 TimeGenera
今天我开始使用 JexcelApi 并遇到了这个:当您尝试从特定位置获取元素时,不是像您通常期望的那样使用sheet.getCell(row,col),而是使用sheet.getCell(col,ro
我有一个包含 28 列的数据库。第一列是代码,第二列是名称,其余是值。 public void displayData() { con.Open(); MySqlDataAdapter
我很沮丧:每当我缩小这个网页时,一切都变得一团糟。我如何将网页居中,以便我可以缩小并且元素不会被错误定位。 (它应该是 2 列,但所有内容都合并为 1)我试过 但由于某种原因,这不起作用。 www.o
我是一名优秀的程序员,十分优秀!