Doctrine 1
  1. Doctrine 1
  2. DC-968

I18n and PostgreSQL and DmVersionable

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      PHP 5.3.2, PostgreSQL 8.4.5, Diem 5.1.x

      Description

      I am using PHP 5.3.2 and PostgreSQL 8.4.5, Diem passed all checks in green - OK.

      I started with "A week of Diem Ipsum" and all went ok until I reached building of blog engine. Blog engine example fails in step:

      php symfony doctrine:migrate

      with error message:

      The following errors occurred:
      
          * SQLSTATE[42830]: Invalid foreign key: 7 ERROR: there is no unique constraint matching given keys for referenced table "article_translation". Failing Query: "ALTER TABLE article_translation_version ADD CONSTRAINT article_translation_version_id_article_translation_id FOREIGN KEY (id) REFERENCES article_translation(id) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE"
          * SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block. Failing Query: "CREATE INDEX article_image ON article (image)"
          * SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block. Failing Query: "CREATE INDEX article_author ON article (author)"
          * SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block. Failing Query: "CREATE INDEX article_translation_id ON article_translation (id)"
          * SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block. Failing Query: "CREATE INDEX article_translation_version_id ON article_translation_version (id)"
      

      I removed i18n support in blog engine example and after that migrate went ok. But in Admin interface when I wanted to add
      blog article, although Diem confirmed it saved article, article would not show up in the list, I checked db table, it was empty also.
      Further, if I try to loremize, for 1 fixture I get no error but table is again empty, and for more fixtures then 1, Diem reports error:

      SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block.

      Again I reviewed the model and removed DmVersionable, migrated again and after that I could loremize or create articles without errors.

      Additionally, not related directly to this blog engine example but doctrine related, I noticed errors in Diem Admin interface
      itself when I try to access System->Configuration->Settings . If I access System settings over link
      admin_dev.php/system/configuration/settings/index it shows settings. But when I click on
      dmin_dev.php/system/configuration in menu path and after again to settings
      admin_dev.php/system/configuration/settings/index, error is generated:

      500 | Internal Server Error | Doctrine_Connection_Pgsql_Exception
      SQLSTATE[08P01]: <>: 7 ERROR: bind message supplies 1 parameters, but prepared statement "pdo_stmt_00000008" requires 2

      Are this bugs corrected?

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Jonathan H. Wage
            Reporter:
            Sasha
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: