Details
-
Bug
-
Resolution: Fixed
-
High
-
4.2.0alpha1, extension/ezoracle 2.0.1
-
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
Issue Links
- relates to
-
EZP-15408 ezstarrating lacks schema files
- Closed