Symfony灯具返回“无效参数编号:绑定变量的数量不匹配令牌的数量”。

发布于 2025-02-09 15:37:03 字数 1707 浏览 1 评论 0原文

我有这样的学说固定装置:

<?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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文