Problem on "Working with databases"

[thiagoluis]

Description

Link to page: Working with databases

I'm following this guide and writing the code to better understand it. After completing each file, I performed a test by submitting the data to the page table and received the following error:

throwable: Error: Object of class DateTimeImmutable could not be converted to string in /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php:173

I went to the save() method of the PageRepository and forced a formatting, then received another error:

throwable: PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column "createdAt" of relation "page" does not exist

I compared it with the columns of the table created in the migration, and they are different: created_at and updated_at. I adjusted the columns in the save() and createPage() methods, and it worked.

When you can, please validate this detail. Thank you!

[Tigrov]

Make sure you are using yiisoft/db library version 2.0

throwable: Error: Object of class DateTimeImmutable could not be converted to string in /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php:173

Could you share the piece of your code that is causing the error?

About

throwable: PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column "createdAt" of relation "page" does not exist

ActiveRecord currently does not map properties to table columns that have different names.
The property must have the same names as the corresponding table columns.

[thiagoluis]

Hello, @Tigrov!
Thanks for your response!

Follow more information about the errors and file:

Reference error of column:

php-1  | Next Yiisoft\Db\Exception\Exception: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "createdAt" of relation "page" does not exist
php-1  | LINE 1: ...NSERT INTO "page" ("id", "title", "slug", "text", "createdAt...
php-1  |                                                              ^
php-1  | The SQL being executed was: INSERT INTO "page" ("id", "title", "slug", "text", "createdAt", "updatedAt") VALUES ('019e0fe1-9ead-7339-a3b7-9e6934f67f49', 'Test', 'test', 'This is a testdrive.', '2026-05-10 03:15:05', '2026-05-10 03:15:05') in /var/www/app/vendor/yiisoft/db/src/Exception/ConvertException.php:45
php-1  | Stack trace:
php-1  | #0 /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php(208): Yiisoft\Db\Exception\ConvertException->run()
php-1  | #1 /var/www/app/vendor/yiisoft/db/src/Command/AbstractCommand.php(609): Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->internalExecute()
php-1  | #2 /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php(302): Yiisoft\Db\Command\AbstractCommand->queryInternal(1)
php-1  | #3 /var/www/app/vendor/yiisoft/db/src/Command/AbstractCommand.php(396): Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->queryInternal(1)
php-1  | #4 /var/www/app/src/Web/Page/PageRepository.php(30): Yiisoft\Db\Command\AbstractCommand->execute()
php-1  | #5 /var/www/app/src/Web/Page/EditAction.php(61): App\Web\Page\PageRepository->save(Object(App\Web\Page\Page))

Error DateTimeImmutable:

php-1  | throwable: Error: Object of class DateTimeImmutable could not be converted to string in /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php:173
php-1  | Stack trace:
php-1  | #0 /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php(173): PDOStatement->bindValue(':qp4', Object(DateTimeImmutable), 2)
php-1  | #1 /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php(156): Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->bindPendingParams()
php-1  | #2 /var/www/app/vendor/yiisoft/db/src/Command/AbstractCommand.php(607): Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->prepare(false)
php-1  | #3 /var/www/app/vendor/yiisoft/db/src/Driver/Pdo/AbstractPdoCommand.php(302): Yiisoft\Db\Command\AbstractCommand->queryInternal(1)
php-1  | #4 /var/www/app/vendor/yiisoft/db/src/Command/AbstractCommand.php(396): Yiisoft\Db\Driver\Pdo\AbstractPdoCommand->queryInternal(1)
php-1  | #5 /var/www/app/src/Web/Page/PageRepository.php(30): Yiisoft\Db\Command\AbstractCommand->execute()
php-1  | #6 /var/www/app/src/Web/Page/EditAction.php(61): App\Web\Page\PageRepository->save(Object(App\Web\Page\Page))

I followed the example Working with Databases.

• In this guide, the attribute have name without underscore, and defined with a instance of DateTimeImmutable.
• The example was't used ActiveRecord.
• The keys commented in my code, It was I fixed to work.

The file that I fixed was PageRepository:

public function save(Page $page): void
{
    $row = [
        'id' => $page->id,
        'title' => $page->title,
        'slug' => $page->slug,
        'text' => $page->text,
        'createdAt' => $page->createdAt,
        'updatedAt' => $page->updatedAt,
        // 'created_at' => $page->createdAt->format('Y-m-d H:i:s'),
        // 'updated_at' => $page->updatedAt->format('Y-m-d H:i:s'),
    ];

    if ($this->exists($page->id)) {
        $this->connection->createCommand()->update('{{%page}}', $row, ['id' => $page->id])->execute();
    } else {
        $this->connection->createCommand()->insert('{{%page}}', $row)->execute();
    }
}

The Page file:

public static function create(
        string $id,
        string $title,
        string $text,
        ?string $slug = null,
        DateTimeImmutable $createdAt = new DateTimeImmutable(),
        DateTimeImmutable $updatedAt = new DateTimeImmutable(),
    ): self
    {
        return new self(
            id: $id,
            title: $title,
            slug: $slug ?? (new Inflector())->toSlug($title),
            text: $text,
            createdAt: $createdAt,
            updatedAt: $updatedAt,
        );
    }

Versions

composer show yiisoft/db
name     : yiisoft/db
descrip. : Database abstraction layer and query builder
keywords : database, dbal, query-builder, sql, yii
versions : * 2.0.1
released : 2026-02-09, 3 months ago

docker compose exec php php-fpm -v
PHP 8.5.6 (fpm-fcgi) (built: May  8 2026 16:44:03) (NTS)
Copyright (c) The PHP Group
Built by https://github.com/docker-library/php
Zend Engine v4.5.6, Copyright (c) Zend Technologies
    with Zend OPcache v8.5.6, Copyright (c), by Zend Technologies