OpenSource-Tools / LiquidVoting

1 stars 0 forks source link

Search not working #39

Closed kvdmolen closed 9 years ago

kvdmolen commented 9 years ago

Think it did work before, but now, try any search, e.g.: http://178.62.254.91/lf/index/search.html?_webmcp_csrf_secret=2wmBhCoAfCPL7EljGlRYMPAsi9vCRezJ&_webmcp_routing.default.module=index&_webmcp_routing.default.view=index&_webmcp_routing.default.mode=forward&q=a

I get this error:

Database error of class SyntaxErrorOrAccessRuleViolation occured:
column reference "created" is ambiguous
Stack trace follows:
[C]: in function 'escalate'
../lib/mondelefant.lua:765: in function 'exec'
../lib/mondelefant.lua:785: in function 'count'
/opt/LiquidVoting/frontend/app/main/index/search.lua:80: in function 'func'
../env/execute/file_path.lua:24: in function 'file_path'
../env/execute/view.lua:17: in function 'view'
../env/execute/filtered_view.lua:31: in function <../env/execute/filtered_view.lua:30>
(...tail calls...)
../env/execute/multi_wrapped.lua:18: in function 'inner_func'
../env/execute/inner.lua:19: in function 'inner'
...
/opt/LiquidVoting/frontend/app/main/_filter/20_session.lua:26: in function 'func'
../env/execute/file_path.lua:24: in function 'file_path'
../env/execute/_add_filters_by_path.lua:17: in function 'wrapper_func'
../env/execute/wrapped.lua:21: in function <../env/execute/wrapped.lua:11>
(...tail calls...)
../env/execute/filtered_view.lua:28: in function 'filtered_view'
webmcp.lua:382: in function <webmcp.lua:257>
[C]: in function 'xpcall'
webmcp.lua:256: in main chunk
[C]: in function 'pcall'
/opt/webmcp/cgi-bin/webmcp-wrapper.lua:7: in main chunk
[C]: in ?
nktc commented 9 years ago

Indeed, this was a regression introduced in https://github.com/Socioneers/LiquidVoting/commit/a439318c65c4375b2bfbfe8d0cd0a3f2da861516. It's fixed now.