| Description: | 1/ go to /comm/index.php?mainmenu=commercial&leftmenu=
No bugs on the page but the logs contains :
2013-05-07 16:13:40 WARNING 2.6.99.127 DoliDBPgsql::query SQL error usesavepoint = 0 - SELECT a.id, a.percent, a.datep as da, a.datep2 as da2, a.fk_user_author, a.label, c.code, c.libelle, s.rowid, s.nom as sname, s.client FROM (llx_c_actioncomm as c, llx_actioncomm as a LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid) WHERE c.id = a.fk_action AND a.entity = 1 AND (a.percent >= 100 OR (a.percent = -1 AND a.datep2 <= '2013-05-07 16:13:40')) ORDER BY a.datep2 DESC LIMIT 3 - ERROR: 42601: syntax error at or near ","
LINE 1: ...nom as sname, s.client FROM (llx_c_actioncomm as c, llx_acti...
^
LOCATION: scanner_yyerror, scan.l:1002 = DB_ERROR_SYNTAX
2013-05-07 16:13:40 ERR 2.6.99.127 Error url="" query_string=mainmenu=commercial&leftmenu=, sql=SELECT a.id, a.percent, a.datep as da, a.datep2 as da2, a.fk_user_author, a.label, c.code, c.libelle, s.rowid, s.nom as sname, s.client FROM (llx_c_actioncomm as c, llx_actioncomm as a LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid) WHERE c.id = a.fk_action AND a.entity = 1 AND (a.percent >= 100 OR (a.percent = -1 AND a.datep2 <= '2013-05-07 16:13:40')) ORDER BY a.datep2 DESC LIMIT 3, db_error=ERROR: 42601: syntax error at or near ","
LINE 1: ...nom as sname, s.client FROM (llx_c_actioncomm as c, llx_acti...
^
LOCATION: scanner_yyerror, scan.l:1002
2013-05-07 16:13:40 WARNING 2.6.99.127 DoliDBPgsql::query SQL error usesavepoint = 0 - SELECT a.id, a.label, a.datep as dp, a.datep2 as dp2, a.fk_user_author, a.percent, c.code, c.libelle, s.nom as sname, s.rowid, s.client FROM (llx_c_actioncomm as c, llx_actioncomm as a LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid) WHERE c.id = a.fk_action AND a.entity = 1 AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep2 > '2013-05-07 16:13:40')) ORDER BY a.datep DESC, a.id DESC LIMIT 10 - ERROR: 42601: syntax error at or near ","
LINE 1: ...ame, s.rowid, s.client FROM (llx_c_actioncomm as c, llx_acti...
^
LOCATION: scanner_yyerror, scan.l:1002 = DB_ERROR_SYNTAX
2013-05-07 16:13:40 ERR 2.6.99.127 Error url="" query_string=mainmenu=commercial&leftmenu=, sql=SELECT a.id, a.label, a.datep as dp, a.datep2 as dp2, a.fk_user_author, a.percent, c.code, c.libelle, s.nom as sname, s.rowid, s.client FROM (llx_c_actioncomm as c, llx_actioncomm as a LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid) WHERE c.id = a.fk_action AND a.entity = 1 AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep2 > '2013-05-07 16:13:40')) ORDER BY a.datep DESC, a.id DESC LIMIT 10, db_error=ERROR: 42601: syntax error at or near ","
LINE 1: ...ame, s.rowid, s.client FROM (llx_c_actioncomm as c, llx_acti...
^
LOCATION: scanner_yyerror, scan.l:1002
|
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch.
Aucun→ Fixed