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

Viewing survey results doesn't work in oracle

    Details

      Description

      It doesn't work to view the results of an survey when using oracle (everything will have 0% )

      Looking in the ezdebug I get the following errors:

      Error: eZOracleDB  	Mar 26 2010 11:16:20
       
      Error (932): ORA-00932: inkonsekvente datatyper: forventet -, fikk CLOB
      Failed query at offset 18:
      SELECT text,count(text) as count from ezsurveyquestionresult where questionoriginal_id='2' group by text
       
      Start of error:
      text) as count from ezsurveyquestionresult where questionoriginal_id='2' group by text
       
      Warning: PHP: E_WARNING 	Mar 26 2010 11:16:20
       
      Invalid argument supplied for foreach() in /var/www/apache2php52/ezporacle/.run/extension/ezsurvey/modules/survey/classes/ezsurveymultiplechoice.php on line 852
      

        Issue Links

          Activity

          Hide
          Jérôme Renard added a comment -

          Possible helping patch.ezsurvey.diff.gz

          Show
          Jérôme Renard added a comment - Possible helping patch. ezsurvey.diff.gz
          Hide
          Gaetano Giunta added a comment - - edited

          Reason: this sql

          "SELECT text,count(text) as count from ezsurveyquestionresult where questionoriginal_id='$ID' group by text" is not compatible with Oracle when text field is CLOB type.

          Show
          Gaetano Giunta added a comment - - edited Reason: this sql "SELECT text,count(text) as count from ezsurveyquestionresult where questionoriginal_id='$ID' group by text" is not compatible with Oracle when text field is CLOB type.
          Hide
          Bertrand Dunogier added a comment -

          Fixed in https://github.com/ezsystems/ezsurvey/commit/a9509c35ccc6d62758e550d61350bb81b35a7ac0 (ezsurvey-2.3 beta2).

          A database update is required. A script is provided for that in update/database/oracle/

          Show
          Bertrand Dunogier added a comment - Fixed in https://github.com/ezsystems/ezsurvey/commit/a9509c35ccc6d62758e550d61350bb81b35a7ac0 (ezsurvey-2.3 beta2). A database update is required. A script is provided for that in update/database/oracle/
          Hide
          Geir Arne Waaler added a comment -

          Seems like this is solved with no additional documentation needed, so I move it to Closed.

          Geir Arne Waaler
          eZ Documentation

          Show
          Geir Arne Waaler added a comment - Seems like this is solved with no additional documentation needed, so I move it to Closed. Geir Arne Waaler eZ Documentation
          Hide
          ezrobot added a comment -

          This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

          Show
          ezrobot added a comment - This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

            People

            • Assignee:
              Bertrand Dunogier
              Reporter:
              Vidar Langseid
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: