Original:
cr.execute('select * from ir_module_module where name=%s and state=%s', ('product_m2mcategories','installed'))
Will produce SQL statement:
select * from ir_module_module where name=product_m2mcategories and state=installed
Changed:
cr.execute("select * from ir_module_module where name='product_m2mcategories' and state='installed'")
Will produce SQL statement:
select * from ir_module_module where name='product_m2mcategories' and state='installed'
Comment:
The difference is that name='...' is a string in column name and name=product_m2mcategories is a column called product_m2mcategories compared to column name...
Original: m2mcategories' ,'installed' ))
cr.execute('select * from ir_module_module where name=%s and state=%s', ('product_
Will produce SQL statement: m2mcategories and state=installed
select * from ir_module_module where name=product_
Changed: m2mcategories' and state='installed'")
cr.execute("select * from ir_module_module where name='product_
Will produce SQL statement: m2mcategories' and state='installed'
select * from ir_module_module where name='product_
Comment: m2mcategories is a column called product_ m2mcategories compared to column name...
The difference is that name='...' is a string in column name and name=product_