Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-2238

doctrine:schema:update partially broken

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 2.3
    • Fix Version/s: None
    • Component/s: Tools
    • Environment:
      OS X 10.7.5
      PHP 5.4.4
      Postgres SQL 9.1.6

      also confirmed on:
      Linux (Debian testing, Kernel 2.6.32)
      PHP 5.4.4
      PostgreSQL 9.1.9
      Doctrine 2.3.2

      Description

      the app/console doctrine:schema:update command generates a seemingly random number of statements like these:

      ALTER TABLE geodata ALTER humidity SET ;
      ALTER TABLE geodata ALTER lake SET ;
      ALTER TABLE message ALTER translate SET ;

      which are obvious invalid SQL commands. The mappings are fine, validate and the application works just fine. Here's an example from the mapping files including two of the above statements:

      <field name="coast" type="boolean"/>
      <field name="lake" type="boolean"/>
      <field name="river" type="boolean"/>
      <field name="humidity" type="float"/>
      <field name="biome" type="string"/>

      I am using doctrine2-spatial as an extension for GIS information. This problem shows up both in entities using spatial data and entities not using spatial data.

      I'll gladly help debug this, as right now I can't update my dev database with --force, I need to use --dump-sql and filter out the invalid lines.

        Issue Links

          Activity

          Tom Vogt created issue -
          Tom Vogt made changes -
          Field Original Value New Value
          Attachment schemadiff.txt [ 11373 ]
          Tom Vogt made changes -
          Environment OS X 10.7.5
          PHP 5.4.4
          Postgres SQL 9.1.6
          OS X 10.7.5
          PHP 5.4.4
          Postgres SQL 9.1.6

          also confirmed on:
          Linux (Debian testing, Kernel 2.6.32)
          PHP 5.4.4
          PostgreSQL 9.1.9
          Doctrine 2.3.2
          Benjamin Eberlei made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Duplicate [ 3 ]
          Benjamin Eberlei made changes -
          Link This issue duplicates DBAL-504 [ DBAL-504 ]

            People

            • Assignee:
              Benjamin Eberlei
              Reporter:
              Tom Vogt
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: