Symfony灯具返回“无效参数编号:绑定变量的数量不匹配令牌的数量”。
我有这样的学说固定装置:
<?php
declare(strict_types=1);
namespace App\DataFixtures;
use App\Entity\Tenant;
use Doctrine\Bundle\FixturesBundle\Fixture;
use Doctrine\ORM\Id\AssignedGenerator;
use Doctrine\ORM\Id\IdentityGenerator;
use Doctrine\ORM\Mapping\ClassMetadataInfo;
use Doctrine\Persistence\ObjectManager;
final class TenantFixtures extends Fixture
{
public function load(ObjectManager $manager): void
{
$tenant = new Tenant();
$tenant->setDomain('1.example.com');
$tenant->setName('Tenant 1');
$manager->persist($tenant);
$manager->flush();
$metadata = $manager->getClassMetadata(Tenant::class);
$metadata->setIdGenerator(new AssignedGenerator());
$metadata->setIdGeneratorType(ClassMetadataInfo::GENERATOR_TYPE_NONE);
$tenant = new Tenant();
$tenant->setId(100);
$tenant->setDomain('2.example.com');
$tenant->setName('Tenant 2');
$manager->persist($tenant);
$manager->flush();
$metadata->setIdGenerator(new IdentityGenerator());
$metadata->setIdGeneratorType(ClassMetadataInfo::GENERATOR_TYPE_AUTO);
}
}
当我尝试通过bin/Console学说加载它时:固定装置:load -env = test
,我会收到这样的错误:
An exception occurred while executing 'INSERT INTO tenant (name, domain) VALUES (?, ?)' with params [100, "Tenant 2", "2.example.com"]:
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
如何正确保存两个实体?
请注意,第一个具有自动生成的ID,第二个具有分配的ID。此示例简化了。
I have such a Doctrine fixture:
<?php
declare(strict_types=1);
namespace App\DataFixtures;
use App\Entity\Tenant;
use Doctrine\Bundle\FixturesBundle\Fixture;
use Doctrine\ORM\Id\AssignedGenerator;
use Doctrine\ORM\Id\IdentityGenerator;
use Doctrine\ORM\Mapping\ClassMetadataInfo;
use Doctrine\Persistence\ObjectManager;
final class TenantFixtures extends Fixture
{
public function load(ObjectManager $manager): void
{
$tenant = new Tenant();
$tenant->setDomain('1.example.com');
$tenant->setName('Tenant 1');
$manager->persist($tenant);
$manager->flush();
$metadata = $manager->getClassMetadata(Tenant::class);
$metadata->setIdGenerator(new AssignedGenerator());
$metadata->setIdGeneratorType(ClassMetadataInfo::GENERATOR_TYPE_NONE);
$tenant = new Tenant();
$tenant->setId(100);
$tenant->setDomain('2.example.com');
$tenant->setName('Tenant 2');
$manager->persist($tenant);
$manager->flush();
$metadata->setIdGenerator(new IdentityGenerator());
$metadata->setIdGeneratorType(ClassMetadataInfo::GENERATOR_TYPE_AUTO);
}
}
When I try to load it via bin/console doctrine:fixtures:load --env=test
, I receive such an error:
An exception occurred while executing 'INSERT INTO tenant (name, domain) VALUES (?, ?)' with params [100, "Tenant 2", "2.example.com"]:
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
How to save both entities correctly?
Note that the first one has an auto generated id, and the second one has an assigned id. This example is simplified.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论