Uploaded image for project: 'Ibexa IBX'
  1. Ibexa IBX
  2. IBX-8566

Postgres: error when translating a content object into 31st language

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Medium Medium
    • Customer request
    • 4.6.8
    • None
    • Yes

    Description

      Steps to reproduce (Ibexa Experience):

      1. Add 30 languages
      2. Add translations to folder Ibexa Platform  (../admin/view/content/52/full/1/2)
      3. No issue until 30 translations in total are available.
      4. Add 31st language (so, click 'create' in 'Create a new translation' modal)

      Result:

      PDOException
      PDOException:
      SQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value "2147483648" is out of range for type integer
      CONTEXT:  unnamed portal parameter $7 = '...'
      
        at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
        at PDOStatement->execute(null)
           (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)
        at Doctrine\DBAL\Driver\PDOStatement->execute()
           (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1527)
        at Doctrine\DBAL\Connection->executeStatement('INSERT INTO ezcontentobject_name (contentobject_id, content_version, content_translation, name, language_id, real_translation) VALUES(?, ?, ?, ?, (SELECT    CASE        WHEN (initial_language_id = ? AND (language_mask & ?) <> 0 )        THEN (? | 1)        ELSE ?    END    FROM ezcontentobject    WHERE id = ?), ?)', array(1, 14, 'est-EE', 'Folder', 2147483648, 2147483648, 2147483648, 2147483648, 1, 'est-EE'), array(1, 1, 2, 2, 1, 1, 1, 1, 1, 2))
           (vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:216)
        at Doctrine\DBAL\Query\QueryBuilder->execute()
           (vendor/ibexa/core/src/lib/Persistence/Legacy/Content/Gateway/DoctrineDatabase.php:1347)
        at Ibexa\Core\Persistence\Legacy\Content\Gateway\DoctrineDatabase->setName(1, 14, 'Folder', 'est-EE')
           (vendor/ibexa/core/src/lib/Persistence/Legacy/Content/Gateway/ExceptionConversion.php:368)
        at Ibexa\Core\Persistence\Legacy\Content\Gateway\ExceptionConversion->setName(1, 14, 'Folder', 'est-EE')
           (vendor/ibexa/core/src/lib/Persistence/Legacy/Content/Handler.php:608)
        at Ibexa\Core\Persistence\Legacy\Content\Handler->updateContent(1, 14, object(UpdateStruct))
           (var/cache/dev/ContainerOwkNGxe/Handler_cacf6dc.php:127)
        at ContainerOwkNGxe\Handler_cacf6dc->updateContent(1, 14, object(UpdateStruct))
           (vendor/ibexa/core/src/lib/Persistence/Cache/ContentHandler.php:337)
        at Ibexa\Core\Persistence\Cache\ContentHandler->updateContent(1, 14, object(UpdateStruct))
           (vendor/ibexa/core/src/lib/Repository/ContentService.php:1428)
        at Ibexa\Core\Repository\ContentService->internalUpdateContent(object(VersionInfo), object(ContentUpdateStruct), array())
           (vendor/ibexa/core/src/lib/Repository/ContentService.php:1279)
        at Ibexa\Core\Repository\ContentService->updateContent(object(VersionInfo), object(ContentUpdateStruct), array())
           (var/cache/dev/ContainerOwkNGxe/ContentService_c2d6f3b.php:183)
        at ContainerOwkNGxe\ContentService_c2d6f3b->updateContent(object(VersionInfo), object(ContentUpdateStruct), array())
           (vendor/ibexa/core/src/lib/Event/ContentService.php:194)
        at Ibexa\Core\Event\ContentService->updateContent(object(VersionInfo), object(ContentUpdateStruct), array())
           (vendor/ibexa/core/src/lib/Repository/SiteAccessAware/ContentService.php:171)
        at Ibexa\Core\Repository\SiteAccessAware\ContentService->updateContent(object(VersionInfo), object(ContentUpdateStruct), array())
           (vendor/ibexa/admin-ui/src/lib/EventListener/ContentProxyCreateDraftListener.php:124)
        at Ibexa\AdminUi\EventListener\ContentProxyCreateDraftListener->translate(object(ContentProxyTranslateEvent), 'Ibexa\\Contracts\\AdminUi\\Event\\ContentProxyTranslateEvent', object(TraceableEventDispatcher))
           (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118)
        at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(ContentProxyTranslateEvent), 'Ibexa\\Contracts\\AdminUi\\Event\\ContentProxyTranslateEvent', object(TraceableEventDispatcher))
           (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
        at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener)), 'Ibexa\\Contracts\\AdminUi\\Event\\ContentProxyTranslateEvent', object(ContentProxyTranslateEvent))
           (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
        at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(ContentProxyTranslateEvent), 'Ibexa\\Contracts\\AdminUi\\Event\\ContentProxyTranslateEvent')
           (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
        at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(ContentProxyTranslateEvent), 'Ibexa\\Contracts\\AdminUi\\Event\\ContentProxyTranslateEvent')
           (vendor/ibexa/site-factory/src/lib/Event/EventDispatcher.php:28)
        at Ibexa\SiteFactory\Event\EventDispatcher->dispatch(object(ContentProxyTranslateEvent))
           (vendor/ibexa/admin-ui/src/bundle/Controller/ContentEditController.php:50)
        at Ibexa\Bundle\AdminUi\Controller\ContentEditController->proxyTranslateAction(1, null, 'est-EE', 42)
           (vendor/symfony/http-kernel/HttpKernel.php:163)
        at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
           (vendor/symfony/http-kernel/HttpKernel.php:75)
        at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
           (vendor/symfony/http-kernel/Kernel.php:202)
        at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
           (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
        at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
           (vendor/autoload_runtime.php:35)
        at require_once('/var/www/html/vendor/autoload_runtime.php')
           (public/index.php:5)
      

      Note: Migration file  postgres_test_languages.yamlcan be used on a fresh install to create languages and translations (steps 1-3)
       

      Designs

        Attachments

          Activity

            People

              Unassigned Unassigned
              thorsten.reiter@ibexa.co Thorsten Reiter
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: