大神们，进来看一下，是不是openerp的bug
-
按照网上视频教程"30分钟开发OpenERP 功能模块"，在7.0和8.0中做，总是做不成，大神们帮忙给看一下呀，我怀疑是代码bug。
视频网址：
[检测到链接无效，已移除]
注：
在建立菜单那一步骤需要多建立一级菜单
我建立的是三层菜单，课程管理》》课程》》课程界面，按照视频上建立两层菜单出不来界面的。
在建立完菜单后，在界面中新建课程时出现下面错误提示：
OpenERP Server Error
Traceback (most recent call last):
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 348, in dispatch
response["result"] = self.call_function(**self.params)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 220, in call_function
return checked_call(self.db, *args, **kwargs)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\service\model.py", line 113, in wrapper
return f(dbname, *args, **kwargs)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 215, in checked_call
return self.func(*a, **kw)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 532, in call
return self.method(*args, **kw)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\addons\web\controllers\main.py", line 1217, in call_kw
return self.call_kw(model, method, args, kwargs)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\addons\web\controllers\main.py", line 1209, in call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\osv\orm.py", line 4111, in create
tuple([f[2] for f in columns if len(f) > 2])
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\sql_db.py", line 153, in wrapper
return f(self, *args, **kwargs)
File "D:\GreenOpenERP-8.0-latest-win-x86\openerp\sql_db.py", line 218, in execute
res = self.obj.execute(query, params)
ProgrammingError: column "x_startdate" of relation "x_lesson" does not exist
LINE 1: INSERT INTO "x_lesson" ("id", "x_startdate", "x_enddate", "x...
^
提示上说：x_startdate等不存在，或者关系x_lesson不存在，我看了，确实确实是存在的，都是我创建的呀。。。。
______________________________________________________________________________________
[color=red]感谢开发群 上海-Joshua 大神的无私帮助，初步诊断，大神怀疑有个模块有bug，因时间太晚，明天继续诊断
请其他大神帮忙按照上面链接中的教程走一遍试试，openerp的发展离不开大神们的帮助，谢谢你们，辛苦了。[/color] -
我也在学这个视屏 我在建立模型的时候就会出现问题
OpenERP Server Error
Traceback (most recent call last):
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 348, in dispatch
response["result"] = self._call_function(**self.params)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 220, in _call_function
return checked_call(self.db, *args, **kwargs)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\service\model.py", line 113, in wrapper
return f(dbname, *args, **kwargs)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 215, in checked_call
return self.func(*a, **kw)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\http.py", line 532, in call
return self.method(*args, **kw)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\addons\web\controllers\main.py", line 1217, in call_kw
return self._call_kw(model, method, args, kwargs)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\addons\web\controllers\main.py", line 1209, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\addons\base\ir\ir_model.py", line 185, in write
return super(ir_model,self).write(cr, user, ids, vals, context)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\osv\orm.py", line 3839, in write
result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\osv\fields.py", line 627, in set
id_new = obj.create(cr, user, act[2], context=context)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\addons\base\ir\ir_model.py", line 359, in create
self.pool[vals['model']]._auto_init(cr, ctx)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\osv\orm.py", line 2672, in _auto_init
self._m2m_raise_or_create_relation(cr, f)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\osv\orm.py", line 2978, in _m2m_raise_or_create_relation
self._save_relation_table(cr, m2m_tbl)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\osv\orm.py", line 2539, in _save_relation_table
""", (relation_table, self._module))
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\sql_db.py", line 153, in wrapper
return f(self, *args, **kwargs)
File "E:\GreenOpenERP-8.0-latest-win-x86\openerp\sql_db.py", line 218, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: character varying = boolean
LINE 5: AND ir_module_module.name=false
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
不知道是什么原因 -
[quote author=Joshua link=topic=16230.msg27460#msg27460 date=1392817673]
创建模型和字段的时候每添加一个保存一次。
[/quote]
我也碰到这个问题了。
您的意思是要把模型或者字段删掉重新建立吗？
我是删除字段了，可是问题依旧。。 -
ProgrammingError: operator does not exist: character varying = boolean
LINE 5: AND ir_module_module.name=false
删除后重新建立模型和字段、保存时报错。。 -
[quote author=mrshelly link=topic=16230.msg29313#msg29313 date=1415668335]
深命短暂, 请远离界面开滑....
[/quote]
好吧，code吧...... -
好像是个bug，要先保存模型，再编辑然后添加字段。。。。
