Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-15345

New ezgmaplocation datatype doesn't work with oracle

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • 4.2.0beta1
    • 4.2.0alpha1, extension/ezoracle 2.0.1
    • Database related
    • None

    Description

      Hi

      The ezgmaplocation datatype doesn't seem to work with ezoracle

      Here is what I get in the log when importing the database into oracle:

      Error (972): ORA-00972: identifikatoren er for lang
      Failed query at offset 114:
      CREATE TABLE ezgmaplocation (
        address VARCHAR2(150),
        contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
        contentobject_attribute_version INTEGER DEFAULT 0 NOT NULL,
        latitude FLOAT DEFAULT 0 NOT NULL,
        longitude FLOAT DEFAULT 0 NOT NULL,
        PRIMARY KEY ( contentobject_attribute_id,contentobject_attribute_version )
      )
      
      Start of error:
      contentobject_attribute_version INTEGER DEFAULT 0 NOT NULL,
        latitude FLOAT DEFAULT 0 NOT NULL,
        longitude FLOAT DEFAULT 0 NOT NULL,
        PRIMARY KEY ( contentobject_attribute_id,contentobject_attribute_version )
      )
      [ Aug 25 2009 13:07:46 ] [] :
      Failed inserting the SQL:
      CREATE TABLE ezgmaplocation (
        address VARCHAR2(150),
        contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
        contentobject_attribute_version INTEGER DEFAULT 0 NOT NULL,
        latitude FLOAT DEFAULT 0 NOT NULL,
        longitude FLOAT DEFAULT 0 NOT NULL,
        PRIMARY KEY ( contentobject_attribute_id,contentobject_attribute_version )
      )
      
      

      A .dba file (of a standard ezwebin install) is attached

      Steps to reproduce

      using ezoracle:

                  $this->dbaFile = 'ezwebin_database.dba';
                  $schemaArray = eZDbSchema::read( $this->dbaFile, true );
                  $dbSchema = eZDbSchema::instance( $schemaArray );
                  $result = $dbSchema->insertSchema( array( 'schema' => true, 'data' => true ) );
      
      

      Attachments

        Activity

          People

            ls ls
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: