Details
-
Bug
-
Resolution: Fixed
-
High
-
4.3.0beta1
-
None
Description
First of all, the ezsurvey extensions has to postgresql schemas:
extension/ezsurvey/sql/postgresql/schema.sql
extension/ezsurvey/sql/postgresql/indices.sql
I guess schema.sql is the one we should use but both gives error when importing:
$ tail var/log/error.log eZPostgreSQLDB: Error: error executing query: CREATE TABLE ezsurvey ( id integer DEFAULT nextval('ezsurvey_s'::text) NOT NULL, title varchar DEFAULT '' NOT NULL, enabled integer DEFAULT 1 NOT NULL, valid_from integer DEFAULT 0 NOT NULL, valid_to integer DEFAULT 0 NOT NULL, redirect_cancel varchar DEFAULT '' NOT NULL, redirect_submit varchar DEFAULT '' NOT NULL, published integer DEFAULT 0 NOT NULL, persistent integer DEFAULT 0 NOT NULL, one_answer integer DEFAULT 0 NOT NULL, contentobject_id integer DEFAULT 0 NOT NULL, contentobjectattribute_id integer DEFAULT 0 NOT NULL, contentobjectattribute_version integer DEFAULT 0 NOT NULL, contentclassattribute_id int(11) DEFAULT 0 NOT NULL, language_code varchar(20) DEFAULT NULL ) ERROR: syntax error at or near "(" LINE 1: ...FAULT 0 NOT NULL, contentclassattribute_id int(11) DEFAU...