Forum OpenACS Q&A: install 4.5 simple-survey package error

psql:simple-survey-create.sql:184: ERROR:  parser: parse error at or
near ")"
psql:simple-survey-create.sql:223: ERROR:
Relation "survsimp_surveys" does not exist
psql:simple-survey-create.sql:248: ERROR:
Relation "survsimp_questions" does not exist
psql:simple-survey-create.sql:267: ERROR:
Relation "survsimp_surveys" does not exist
psql:simple-survey-create.sql:288: ERROR:
Relation "survsimp_responses" does not exist
psql:simple-survey-create.sql:329: ERROR:
Relation "survsimp_responses" does not exist
psql:simple-survey-create.sql:337: ERROR:
Relation "survsimp_question_responses" does not exist
psql:simple-survey-create.sql:367: ERROR:
Relation "survsimp_surveys" does not exist
psql:simple-survey-create.sql:383: ERROR:
Relation "survsimp_question_choices" does not exist
psql:simple-survey-create.sql:407: ERROR:
Relation "survsimp_surveys" does not exist
psql:simple-survey-create.sql:410: ERROR:
Relation "survsimp_question_responses" does not exist
Collapse
Posted by Reuven Lerner on
I encountered this also, and fixed it in one of my installations (although I don't remember which one, and I can't remember if it was a CVS installation or the official tarfile).  If I'm not mistaken, the creating the survsimp_surveys table doesn't work because of an extraneous comma after the definition of the display_type column.  Remove that comma, and all should be fine.

If I can find dig up more information about what I did, I'll post it here.

Collapse
Posted by Sanjeev Sharma on
If this is the same error I got from a cvs checkout 2 days ago then at line 184 you need to remove the comma at the end.

If you're trying to install the entire set of modules from cvs BBoard will also fail.

Right now I'm working with the tarball 4.5.0-relase with the new ecommerce modules from CVS.  Everything at least installs with this setup, I'm just starting to customize now.

Collapse
Posted by Don Baccus on
I've commited the change, thanks, guys.

Remember ... we encourage folks to submit bug reports and patches to the SDM!