This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.
When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:
Hi,
I'm using the latest version of mojo mojoPortal 2.3.5.8, with PostGres in a Windows 7 machine.
I've created a new survey, although when I click Start Survey, I have this error:
ERROR: 42601: syntax error at or near ")"
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Npgsql.NpgsqlException: ERROR: 42601: syntax error at or near ")" After debug i found the problem is in SurveyFeature.Data.DBQuestionOption.GetAll(Guid questionGuid).
sqlCommand.Append("ORDER BY \"order\" ) "); the parentheses next to \"order\" is not correct.
After remove it, works well.
Thanks
Thanks for the bug report and fix. This is now fixed in the source code repository.
Best,
Joe
Thanks :)