[6.0] regression since commit #2759

[Raphaël Valyi - http://www.akretion.com]

Hello,

looks like at revision #2759 of trunk branch, when you try to create a database you get that error:
[2010-09-21 15:28:01,035][template1] INFO:web-services:CREATE DATABASE: multicomp
[2010-09-21 15:28:02,540][multicomp] INFO:init:module base: loading objects
[2010-09-21 15:28:02,610][multicomp] INFO:init:module base: creating or updating database tables
[2010-09-21 15:28:09,881][multicomp] INFO:data:storing computed values of fields.function 'global'
[2010-09-21 15:28:09,883][multicomp] INFO:data:storing computed values of fields.function 'menus_by_module'
[2010-09-21 15:28:10,104][multicomp] INFO:data:storing computed values of fields.function 'reports_by_module'
[2010-09-21 15:28:10,273][multicomp] INFO:data:storing computed values of fields.function 'views_by_module'
[2010-09-21 15:28:10,476][multicomp] INFO:init:module base: loading base_data.xml
[2010-09-21 15:28:11,659][multicomp] INFO:init:module base: loading security/base_security.xml
[2010-09-21 15:28:11,823][multicomp] INFO:init:module base: loading base_menu.xml
[2010-09-21 15:28:11,977][multicomp] INFO:init:module base: loading res/res_security.xml
[2010-09-21 15:28:12,035][multicomp] INFO:init:module base: loading res/res_config.xml
[2010-09-21 15:28:12,092][multicomp] INFO:init:module base: loading data/res.country.state.csv
[2010-09-21 15:28:12,311][multicomp] INFO:init:module base: loading base_update.xml
[2010-09-21 15:28:12,448][multicomp] INFO:init:module base: loading ir/wizard/wizard_menu_view.xml
[2010-09-21 15:28:12,473][multicomp] INFO:init:module base: loading ir/ir.xml
[2010-09-21 15:28:13,956][multicomp] INFO:init:module base: loading ir/workflow/workflow_view.xml
[2010-09-21 15:28:14,244][multicomp] INFO:init:module base: loading module/module_view.xml
[2010-09-21 15:28:14,343][multicomp] INFO:init:module base: loading module/module_web_view.xml
[2010-09-21 15:28:14,372][multicomp] INFO:init:module base: loading module/module_data.xml
[2010-09-21 15:28:14,375][multicomp] INFO:init:module base: loading module/module_report.xml
[2010-09-21 15:28:14,389][multicomp] INFO:init:module base: loading module/wizard/base_module_import_view.xml
[2010-09-21 15:28:14,436][multicomp] INFO:init:module base: loading module/wizard/base_module_update_view.xml
[2010-09-21 15:28:14,482][multicomp] INFO:init:module base: loading module/wizard/base_language_install_view.xml
[2010-09-21 15:28:14,528][multicomp] INFO:init:module base: loading module/wizard/base_import_language_view.xml
[2010-09-21 15:28:14,560][multicomp] INFO:init:module base: loading module/wizard/base_module_upgrade_view.xml
[2010-09-21 15:28:14,617][multicomp] INFO:init:module base: loading module/wizard/base_export_language_view.xml
[2010-09-21 15:28:14,648][multicomp] INFO:init:module base: loading module/wizard/base_update_translations_view.xml
[2010-09-21 15:28:14,677][multicomp] INFO:init:module base: loading res/res_request_view.xml
[2010-09-21 15:28:14,819][multicomp] INFO:init:module base: loading res/res_lang_view.xml
[2010-09-21 15:28:14,873][multicomp] INFO:init:module base: loading res/res_log_view.xml
[2010-09-21 15:28:14,931][multicomp] INFO:init:module base: loading res/partner/partner_report.xml
[2010-09-21 15:28:14,944][multicomp] INFO:init:module base: loading res/partner/partner_view.xml
[2010-09-21 15:28:15,368][multicomp] INFO:init:module base: loading res/bank_view.xml
[2010-09-21 15:28:15,413][multicomp] INFO:init:module base: loading res/country_view.xml
[2010-09-21 15:28:15,495][multicomp] INFO:init:module base: loading res/res_currency_view.xml
[2010-09-21 15:28:15,536][multicomp] INFO:init:module base: loading res/partner/crm_view.xml
[2010-09-21 15:28:15,605][multicomp] INFO:init:module base: loading res/partner/wizard/partner_sms_send_view.xml
[2010-09-21 15:28:15,629][multicomp] INFO:init:module base: loading res/partner/wizard/partner_wizard_spam_view.xml
[2010-09-21 15:28:15,653][multicomp] INFO:init:module base: loading res/partner/wizard/partner_clear_ids_view.xml
[2010-09-21 15:28:15,672][multicomp] INFO:init:module base: loading res/partner/wizard/partner_wizard_ean_check_view.xml
[2010-09-21 15:28:15,692][multicomp] INFO:init:module base: loading res/partner/partner_data.xml
[2010-09-21 15:28:15,732][multicomp] INFO:init:module base: loading res/ir_property_view.xml
[2010-09-21 15:28:15,792][multicomp] INFO:init:module base: loading security/base_security.xml
[2010-09-21 15:28:15,854][multicomp] INFO:init:module base: loading maintenance/maintenance_view.xml
[2010-09-21 15:28:15,945][multicomp] INFO:init:module base: loading security/ir.model.access.csv
[2010-09-21 15:28:16,635][multicomp] INFO:init:module base: loading base_demo.xml
[2010-09-21 15:28:16,688][multicomp] INFO:init:module base: loading res/partner/partner_demo.xml
[2010-09-21 15:28:17,595][multicomp] INFO:init:module base: loading res/partner/crm_demo.xml
[2010-09-21 15:28:17,636][multicomp] INFO:init:module base: loading test/base_test.xml
[2010-09-21 15:28:17,681][multicomp] INFO:init:module base: loading test/test_context.xml
[2010-09-21 15:28:18,377][multicomp] INFO:init:updating modules list
[2010-09-21 15:28:18,378][multicomp] ERROR:db.cursor:Programming error: syntax error at or near ")"
LINE 1: ...CT count(id) AS count FROM ir_module_module WHERE name in ()
                                                                      ^
, in query SELECT count(id) AS count FROM ir_module_module WHERE name in %s
[2010-09-21 15:28:18,379][multicomp] ERROR:web-services:[01]: CREATE DATABASE
[2010-09-21 15:28:18,379][multicomp] ERROR:web-services:[02]: Traceback (most recent call last):
[2010-09-21 15:28:18,379][multicomp] ERROR:web-services:[03]: File "/home/rvalyi/DEV/openerp/server/bin/service/web_services.py", line 99, in __call__
[2010-09-21 15:28:18,379][multicomp] ERROR:web-services:[04]: update_module=True)[1]
[2010-09-21 15:28:18,379][multicomp] ERROR:web-services:[05]: File "/home/rvalyi/DEV/openerp/server/bin/pooler.py", line 61, in restart_pool
[2010-09-21 15:28:18,379][multicomp] ERROR:web-services:[06]: return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[07]: File "/home/rvalyi/DEV/openerp/server/bin/pooler.py", line 39, in get_db_and_pool
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[08]: addons.load_modules(db, force_demo, status, update_module)
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[09]: File "/home/rvalyi/DEV/openerp/server/bin/addons/__init__.py", line 805, in load_modules
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[10]: _check_module_names(cr, itertools.chain(tools.config['init'].keys(), tools.config['update'].keys()))
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[11]: File "/home/rvalyi/DEV/openerp/server/bin/addons/__init__.py", line 765, in _check_module_names
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[12]: cr.execute("SELECT count(id) AS count FROM ir_module_module WHERE name in %s", (tuple(mod_names),))
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[13]: File "/home/rvalyi/DEV/openerp/server/bin/sql_db.py", line 75, in wrapper
[2010-09-21 15:28:18,380][multicomp] ERROR:web-services:[14]: return f(self, *args, **kwargs)
[2010-09-21 15:28:18,381][multicomp] ERROR:web-services:[15]: File "/home/rvalyi/DEV/openerp/server/bin/sql_db.py", line 122, in execute
[2010-09-21 15:28:18,381][multicomp] ERROR:web-services:[16]: res = self._obj.execute(query, params)
[2010-09-21 15:28:18,381][multicomp] ERROR:web-services:[17]: ProgrammingError: syntax error at or near ")"
[2010-09-21 15:28:18,381][multicomp] ERROR:web-services:[18]: LINE 1: ...CT count(id) AS count FROM ir_module_module WHERE name in ()
[2010-09-21 15:28:18,381][multicomp] ERROR:web-services:[19]:

Reverting to #2758 fixes the issue for me. Hope this helps

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

Thanks.
Fixed by the immediate revision 2760.