个人中心
gpt4 book ai didi

crash - 奥多 11 : Cant update module because new template was added to the module

转载 作者：行者123 更新时间：2023-12-02 07:32:19 25 4
gpt4 key购买 nike

我对 Odoo 还很陌生，我想玩弄一个测试模块，为此我为网页创建了一些 View (模板)。起初，当只有一个模板时，一切正常，但当我尝试添加另一个模板时，更新突然无法工作了。您将在下面找到第一个和第二个模板的代码以及错误消息以及我的 list 文件

第一个模板

<?xml version="1.0" encoding="utf-8"?>
<odoo>

    <template id="template_test_hello_world" name="Test Hello World">&lt;!DOCTYPE html&gt;
        <html>

            <body>
                <div id="test_hello_world_page_text">
                    <p>Url text: <t t-esc="val"/></p>
                </div>
                <div>
                    <t t-foreach="models" t-as="model">
                        <p><t t-esc="model.id"/><t t-esc="model.preview_name"/></p>
                    </t>
                </div>

            </body>

        </html>
    </template>

</odoo>

第二个模板 
<?xml version="1.0" encoding="utf-8"?>
<odoo>

    <template id="template_random" name="Test Random">&lt;!DOCTYPE html&gt;
        <html>

            <body>
                <div id="test_random_div">
                    <p>BlaBlaBla</p>
                </div>

            </body>

        </html>
    </template>

</odoo>

list 
{
    'name': "Tests",
    'summary': """
        Testing stuff
    """,
    'description': """
        Yes. 
    """,
    'author': "",
    'website': "",
    'category': 'Uncategorized',
    'version': '0.1',
    'depends': [],
    'data': [
        'views/test_hello_world_template.xml',
        'data/test_models.xml',
        'security/ir.model.access.csv',
        'views/random_template.xml',
    ],
    "installable": True,
}

错误消息 
2020-02-07 11:21:47,945 27164 ERROR smthg odoo.sql_db: bad query: b'INSERT INTO "ir_ui_view" ("id", "key", "priority", "active", "type", "name", "mode", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval(\'ir_ui_view_id_seq\'), \'my_module.template_test_hello_world\', 16, true, \'qweb\', \'Test Hello World\', \'primary\', 1, 1, (now() at time zone \'UTC\'), (now() at time zone \'UTC\')) RETURNING id'
ERROR: null value in column "projection" violates not-null constraint
DETAIL:  Failing row contains (2531, 2020-02-07 11:21:47.854173, 1, 2020-02-07 11:21:47.854173, t, null, null, null, Test Hello World, null, 16, primary, null, qweb, 1, null, null, null, null, null, null, my_module.template_test_hello_world, null, null, null, null, null).

2020-02-07 11:21:47,946 27164 WARNING smthg odoo.modules.loading: Transient module states were reset
2020-02-07 11:21:48,044 27164 ERROR smthg odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 745, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 723, in _tag_template
    return self._tag_record(record, data_node)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 655, in _tag_record
    id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_model.py", line 1504, in _update
    record = record.create(values)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_ui_view.py", line 408, in create
    return super(View, self).create(self._compute_defaults(values))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3409, in create
    record = self.browse(self._create(old_vals))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3502, in _create
    cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 155, in wrapper
    return f(self, *args, **kwargs)
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 232, in execute
    res = self._obj.execute(query, params)
psycopg2.IntegrityError: null value in column "projection" violates not-null constraint
DETAIL:  Failing row contains (2531, 2020-02-07 11:21:47.854173, 1, 2020-02-07 11:21:47.854173, t, null, null, null, Test Hello World, null, 16, primary, null, qweb, 1, null, null, null, null, null, null, my_module.template_test_hello_world, null, null, null, null, null).


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/etc/odoo/odoo-server/odoo/odoo/modules/registry.py", line 85, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 376, in load_modules
    force, status, report, loaded_modules, update_module, models_to_check)
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 274, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 181, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 95, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 792, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 853, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 752, in parse
    exc_info[2]
  File "/etc/odoo/odoo-server/odoo/odoo/tools/pycompat.py", line 86, in reraise
    raise value.with_traceback(tb)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 745, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 723, in _tag_template
    return self._tag_record(record, data_node)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 655, in _tag_record
    id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_model.py", line 1504, in _update
    record = record.create(values)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_ui_view.py", line 408, in create
    return super(View, self).create(self._compute_defaults(values))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3409, in create
    record = self.browse(self._create(old_vals))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3502, in _create
    cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 155, in wrapper
    return f(self, *args, **kwargs)
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 232, in execute
    res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "projection" violates not-null constraint
DETAIL:  Failing row contains (2531, 2020-02-07 11:21:47.854173, 1, 2020-02-07 11:21:47.854173, t, null, null, null, Test Hello World, null, 16, primary, null, qweb, 1, null, null, null, null, null, null, my_module.template_test_hello_world, null, null, null, null, null).
" while parsing None:4, near
<t name="Test Hello World" t-name="my_module.template_test_hello_world">&lt;!DOCTYPE html&gt;
            <html>

                <body>
                    <div id="test_hello_world_page_text">
                        <p>Url text: <t t-esc="val"/></p>
                    </div>
                    <div>
                        <t t-foreach="models" t-as="model">
                            <p><t t-esc="model.id"/><t t-esc="model.preview_name"/></p>
                        </t>
                    </div>

                </body>

            </html>
        </t>
2020-02-07 11:21:48,048 27164 CRITICAL smthg odoo.service.server: Failed to initialize database `smthg`.
Traceback (most recent call last):
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 745, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 723, in _tag_template
    return self._tag_record(record, data_node)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 655, in _tag_record
    id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_model.py", line 1504, in _update
    record = record.create(values)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_ui_view.py", line 408, in create
    return super(View, self).create(self._compute_defaults(values))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3409, in create
    record = self.browse(self._create(old_vals))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3502, in _create
    cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 155, in wrapper
    return f(self, *args, **kwargs)
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 232, in execute
    res = self._obj.execute(query, params)
psycopg2.IntegrityError: null value in column "projection" violates not-null constraint
DETAIL:  Failing row contains (2531, 2020-02-07 11:21:47.854173, 1, 2020-02-07 11:21:47.854173, t, null, null, null, Test Hello World, null, 16, primary, null, qweb, 1, null, null, null, null, null, null, my_module.template_test_hello_world, null, null, null, null, null).


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/etc/odoo/odoo-server/odoo/odoo/service/server.py", line 1006, in preload_registries
    registry = Registry.new(dbname, update_module=update_module)
  File "/etc/odoo/odoo-server/odoo/odoo/modules/registry.py", line 85, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 376, in load_modules
    force, status, report, loaded_modules, update_module, models_to_check)
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 274, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 181, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
  File "/etc/odoo/odoo-server/odoo/odoo/modules/loading.py", line 95, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 792, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 853, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 752, in parse
    exc_info[2]
  File "/etc/odoo/odoo-server/odoo/odoo/tools/pycompat.py", line 86, in reraise
    raise value.with_traceback(tb)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 745, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 723, in _tag_template
    return self._tag_record(record, data_node)
  File "/etc/odoo/odoo-server/odoo/odoo/tools/convert.py", line 655, in _tag_record
    id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_model.py", line 1504, in _update
    record = record.create(values)
  File "/etc/odoo/odoo-server/odoo/odoo/addons/base/ir/ir_ui_view.py", line 408, in create
    return super(View, self).create(self._compute_defaults(values))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3409, in create
    record = self.browse(self._create(old_vals))
  File "/etc/odoo/odoo-server/odoo/odoo/models.py", line 3502, in _create
    cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 155, in wrapper
    return f(self, *args, **kwargs)
  File "/etc/odoo/odoo-server/odoo/odoo/sql_db.py", line 232, in execute
    res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "projection" violates not-null constraint
DETAIL:  Failing row contains (2531, 2020-02-07 11:21:47.854173, 1, 2020-02-07 11:21:47.854173, t, null, null, null, Test Hello World, null, 16, primary, null, qweb, 1, null, null, null, null, null, null, my_module.template_test_hello_world, null, null, null, null, null).
" while parsing None:4, near
<t name="Test Hello World" t-name="my_module.template_test_hello_world">&lt;!DOCTYPE html&gt;
            <html>

                <body>
                    <div id="test_hello_world_page_text">
                        <p>Url text: <t t-esc="val"/></p>
                    </div>
                    <div>
                        <t t-foreach="models" t-as="model">
                            <p><t t-esc="model.id"/><t t-esc="model.preview_name"/></p>
                        </t>
                    </div>

                </body>

            </html>
        </t>

我最感兴趣的可能是第一行: 
bad query: b'INSERT INTO "ir_ui_view" ("id", "key", "priority", "active", "type", "name", "mode", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval(\'ir_ui_view_id_seq\'), \'my_module.template_test_hello_world\', 16, true, \'qweb\', \'Test Hello World\', \'primary\', 1, 1, (now() at time zone \'UTC\'), (now() at time zone \'UTC\')) RETURNING id'
ERROR: null value in column "projection" violates not-null constraint
DETAIL:  Failing row contains (2531, 2020-02-07 11:21:47.854173, 1, 2020-02-07 11:21:47.854173, t, null, null, null, Test Hello World, null, 16, primary, null, qweb, 1, null, null, null, null, null, null, my_module.template_test_hello_world, null, null, null, null, null).

但是我对 SQL 或 Odoo 还不太了解，而且我在网上发现的很少，尽管我花了将近一整天的时间在这上面，而且，正如您在错误底部看到的那样，似乎有问题第一个模板可能对您很有用，因为您知道在某些时候它是显示在那里的第二个模板。

我想最后我的问题是，有谁知道发生了什么以及我该如何解决这个问题？

最佳答案

对于任何面临同样问题的人来说，问题似乎是由损坏的 View 引起的。系统的完整更新迫使 Odoo 重新创建每个 View ，以便正常工作。这意味着通过在更新命令中将 all 指定为包名称来更新所有包:

odoo-bin -d db -c 配置 -u 全部

关于crash - 奥多 11 : Cant update module because new template was added to the module，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/60112853/

25 4 0
文章推荐： sql - 如何让 DELETE FROM [QUERY] 起作用？
文章推荐： Java 2d 数组列打印两次
文章推荐： Java套接字: NTP application always return null string
文章推荐： PHP OOP - 如何定义带有变量或函数输出的 CONST？
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com