c2c-oerpscenario team mailing list archive

["Alberto Luengo Cabanillas \(Pexego\)" <alberto@xxxxxxxxx>]

Hello everyone, I reopen this bug because also affects me in stable
6.0.2 version. In my case, the problem was in following line belonging
to 'report/survey_analysis_report.py' file:

cr.execute("select count(sra.answer_id),sqc.rating_weight from survey_response_line sr, survey_response_answer sra ,\
                                        survey_question_column_heading sqc where sr.id = sra.response_id and \
                                        sqc.question_id = sr.question_id  and sra.answer_id = %s and sqc.title ='%s'\
                                       group by sra.answer_id,sqc.rating_weight", (ans.id,matrix_ans[mat_col][1]))

In concrete, "(...)sqc.title ='%s' " was giving me problems. Removing quotes made it work again.
Regards,

** Changed in: openobject-addons
       Status: Invalid => Confirmed

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/723294

Title:
  Sintax error at Survey Statistics trunk version

Status in OpenERP Modules (addons):
  Confirmed

Bug description:
  Server: V6.0.1 on eSmith-Server 8.5 beta
  Client: V6 GTK on windows XP
  Addons: updating using bazar from this addres: lp:~openerp/openobject-addons/trunk on friday feb, 18th (don't take note of revnom)

  Create a survey and respond some surveys. Then go to
  Menu>>Tools>>Informs>>Surveys select the option Surver Statistics. Add
  a survey and select Print.

  This error dialog comes:

  syntax error at or near "1"

                                                                ^

  
  (<class 'psycopg2.ProgrammingError'>, ProgrammingError('syntax error at or near "1"\nL\xc3\x8dNEA 1: ...tion_id  and sra.answer_id = 23 and sqc.title =\'E\'1\'\'+      ...\n                                                              ^\n',), <traceback object at 0xbf80c0c>)

  Don't know if this bug has any relation to this:
  https://bugs.launchpad.net/openobject-addons/+bug/668041 because all
  th surveys appear as started but not finished.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/723294/+subscriptions