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

eZSurvey has error in postgresql schema file

    XMLWordPrintable

    Details

      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...
      

        Attachments

          Activity

            People

            Assignee:
            qwix Jérôme Renard
            Reporter:
            vl Vidar Langseid
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: