Hello,
On 14/03/14 03:39, Rene Montilva wrote:
Hi List
i want to config siremis with postgresql and really to much things fail for the install, at the end y left the siremis db with mysql and kamailio with postgresql but the problems continue, when i want to show subscriber list from siremis interface, i get an error and check the postgresql log and found this
LOG: sentencia: SET NAMES 'utf8' ERROR: error de sintaxis en o cerca de «`» en carácter 101 SENTENCIA: SELECT T0.id, T0.username, T0.domain, T0.password, T0.email_address, T0.ha1, T0.ha1b, T0.rpid FROM `subscriber` T0 LIMIT 10
what could be the right config?
postgres doesn't seem to like backticks which are used in cubi/openbiz. See next links for some discussion and eventual patch to fix it:
- https://groups.google.com/forum/#!topic/openbiz-cubi/4KdlKRQ9-ng/discussion - http://code.google.com/p/openbiz-cubi/issues/detail?id=25
Cheers, Daniel