error when consulting account chart

[Nicolas Bessi - Camptocamp]

Hello,
when working with consolidated account a small bug may appear there may be And And in sql because some string are not empty.

This fix the problem :

=== modified file 'account/account.py'
--- account/account.py 2010-03-03 08:39:20 +0000
+++ account/account.py 2010-03-10 09:41:06 +0000
@@ -211,9 +211,9 @@
             aml_query = self.pool.get('account.move.line')._query_get(cr, uid, context=context)

             wheres = [""]
- if query:
+ if query.strip():
                 wheres.append(query.strip())
- if aml_query:
+ if aml_query.strip():
                 wheres.append(aml_query.strip())
             query = " AND ".join(wheres)

[Vinay Rana (OpenERP) (vra-openerp)]

Hello Nicolas,

Would you please introduce us to such a situation which can generate the bug?

We agree with your solution, but we don't see any way to face to this error.

Thank you for noting this point.

[Jay Vora (Serpent Consulting Services) (jayvora)]

Its better to cover few attacks.
It has been fixed by revision 2680 <email address hidden>.
Thanks.