Odoo 中文社区

在 8.0正式版安装这三个addons 后后台的菜单上的搜索没问题，
前台website的 forums 模块上的论坛一搜索出现 500错误

Error

Error message:
'NoneType' object has no attribute '_columns'

⁠

Traceback

Traceback (most recent call last):
File "/home/lv/g101/source/addons/website/models/ir_http.py", line 204, in _handle_exception
response = super(ir_http, self)._handle_exception(exception)
File "/home/lv/g101/source/openerp/addons/base/ir/ir_http.py", line 100, in _handle_exception
return request._handle_exception(exception)
File "/home/lv/g101/source/openerp/http.py", line 596, in _handle_exception
return super(HttpRequest, self)._handle_exception(exception)
File "/home/lv/g101/source/openerp/addons/base/ir/ir_http.py", line 126, in _dispatch
result = request.dispatch()
File "/home/lv/g101/source/openerp/http.py", line 614, in dispatch
r = self._call_function(**self.params)
File "/home/lv/g101/source/openerp/http.py", line 283, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/home/lv/g101/source/openerp/service/model.py", line 113, in wrapper
return f(dbname, *args, **kwargs)
File "/home/lv/g101/source/openerp/http.py", line 280, in checked_call
return self.endpoint(*a, **kw)
File "/home/lv/g101/source/openerp/http.py", line 733, in call
return self.method(*args, **kw)
File "/home/lv/g101/source/openerp/http.py", line 376, in response_wrap
response = f(*args, **kw)
File "/home/lv/g101/source/addons/website_forum/controllers/main.py", line 106, in questions
question_count = Post.search(cr, uid, domain, count=True, context=context)
File "/home/lv/g101/source/openerp/api.py", line 237, in wrapper
return old_api(self, *args, **kwargs)
File "/home/lv/g101/source/openerp/addons/fts_forum/fts_forum.py", line 154, in search
filters = self._get_filter_expression(cr, uid, args, context).to_sql()
File "/home/lv/g101/source/openerp/api.py", line 237, in wrapper
return old_api(self, *args, **kwargs)
File "/home/lv/g101/source/openerp/addons/fts_forum/fts_forum.py", line 118, in _get_filter_expression
args = get_applicable_args(expression.normalize_domain(args), 0)[0]
File "/home/lv/g101/source/openerp/addons/fts_forum/fts_forum.py", line 106, in get_applicable_args
op1 = get_applicable_args(args, index + 1)
File "/home/lv/g101/source/openerp/addons/fts_forum/fts_forum.py", line 106, in get_applicable_args
op1 = get_applicable_args(args, index + 1)
File "/home/lv/g101/source/openerp/addons/fts_forum/fts_forum.py", line 106, in get_applicable_args
op1 = get_applicable_args(args, index + 1)
File "/home/lv/g101/source/openerp/addons/fts_forum/fts_forum.py", line 92, in get_applicable_args
args[index][0] in orm_model._columns or
AttributeError: 'NoneType' object has no attribute '_columns'

想写个产品tfs搜索...

在步科大神的指导下完成的，完成了PG数据库的部分优化......

PG的配置文件是数据库目录下的postgresql.conf文件，8.0以后的版本可支持K，M，G这样的参数，只要修改相应参数后重新启动PG服务就OK了。

effective_cache_size：是postgresql能够使用的最大缓存，这个数字对于独立的pgsql服务器而言应该足够大，比如4G的内存，可以设置为3.5G(437500)

shared_buffers：这是最重要的参数，postgresql通过shared_buffers和内核和磁盘打交道，因此应该尽量大，让更多的数据缓存在shared_buffers中。通常设置为实际RAM的10％是合理的，比如50000(400M) 实际设置到 30-50%都是合适的

但是首先要先设置 Linux 系统 shmmax 的大小，默认是很低的
根据你的内存大小选择合适的
1.
运行命令，看看 shm 有多少
# cat /proc/sys/kernel/shmmax
[attachimg=2]
默认就怎么多了，下面我们来更改

2.
像我的VPS 是2G 的内存，修改如下
#vi /etc/sysctl.conf
在最后，加上以上2行
kernel.shmmax = 1055092736
kernel.shmall = 257591

#sysctl -p
运行以上命令，确认一下参数正确
[attachimg=1]

3.
命令行查看 postgresql的运行日志
$ tail -f xxx/pgsql/postgresql.log （ xxx 是你绿色版的目录）
[attachimg=3]

再开一个终端，修改 xxx(绿色版路径)/pgsql/date/postgresql.conf 下面的sharedbuffer（用vi 命令也行，直接编辑器编辑也可以）
我改为256MB
shared_buffers = 256MB # min 128kB

重新启动绿色版 OE
可以看到postgresql 启动正常了
[attachimg=4]

-------------------------------------
shmmax 和 shmall 算法如下：

#!/bin/bash
# simple shmsetup script
page_size=getconf PAGE_SIZE
phys_pages=getconf _PHYS_PAGES
shmall=expr $phys_pages / 2
shmmax=expr $shmall \* $page_size
echo kernel.shmmax = $shmmax
echo kernel.shmall = $shmall

在 centos 6.2安装的时候出现
chkconfig postgresql-9.2 on
falled 是什么原因导致的...

用你写的一健脚本在 centos 6.2 64位上面安装出现这样的故障...

[quote author=digitalsatori link=topic=5777.msg14425#msg14425 date=1362840316]
[quote author=cheung1989 link=topic=5777.msg14421#msg14421 date=1362820295]
头痛死了我也是折腾几百次痛苦
[/quote]
如果只会安装/卸载/重启电脑，那么你折腾一千次也没有任何提高。
每折腾一次，你都要学会分析问题，至少要学会提问题，寻找答案。
是你折腾系统，不要让系统折腾你

如果只是测试系统，下面有已经配置好的系统。系统安装好了，你的痛苦也并不会就此消除，要学的东西才刚刚开始
http://demo.openerp.cn 用户名/密码： admin/admin

[/quote]

刚刚开始是故障好像没啥规律，
ImportError: No module named osv 安装模块时好像经常出类似错误，具体是什么原因呢？？找不到模块？？？？

下了你的openerp 7.0版本...请问 centos 的登录密码多少呢？

这个更神了，安装第一关模块 CRM模块，没成功后就一直下面这个的错误提示了
win7 64位 openerp8 allinone 系统有要求安装Windows server 上吗？那么不稳定的！！！！！！
太神奇，还是俺们太菜了！！！

OpenERP Server Error
Traceback (most recent call last):
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\web\http.py", line 194, in dispatch
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\web\controllers\main.py", line 1086, in call_button
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\web\controllers\main.py", line 1074, in _call_kw
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\web\session.py", line 43, in proxy
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\web\session.py", line 30, in proxy_method
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\web\session.py", line 88, in send
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\netsvc.py", line 236, in dispatch_rpc
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\service\model.py", line 27, in dispatch
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\service\model.py", line 138, in execute_kw
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\service\model.py", line 100, in wrapper
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\service\model.py", line 148, in execute
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\service\model.py", line 135, in execute_cr
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\base\module\module.py", line 425, in button_immediate_install
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\base\module\module.py", line 476, in button_immediate_function
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\pooler.py", line 39, in restart_pool
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\modules\registry.py", line 214, in new
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\modules\loading.py", line 338, in load_modules
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\modules\loading.py", line 251, in load_marked_modules
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\modules\loading.py", line 154, in load_module_graph
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\modules\module.py", line 346, in load_openerp_module
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server.\openerp\modules\module.py", line 82, in load_module
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\base_action_rule_init.py", line 23, in <module>
File "C:\Program Files (x86)\OpenERP 8.0dev-20130228-000101\Server\server\openerp\addons\base_action_rule\test_models.py", line 1, in <module>
ImportError: No module named osv

重6.0 安装到 8.0...用windows 整合版本动不动安装某个模块就出故障，然后系统就彻底没办法再安装模块来....

可怜的偶已经把openerp重装了NNNN次了....

是不是openerp 就是那么不稳定？还是windows版本就那么不稳定，XP win7 win8 32位的，64位的都试过了？还是有些模块注定不能安装？？？

现在整个机器专门装上 CENTOS 6.3 来安装openerp，以前没怎么接触过Linux 配置都蛮痛苦的，大家有啥经验呢....

我们准备给自己外贸公司上 ERP，现在已经有套简单的了，想测试下openerp如何！

重6.0 安装到 8.0...用windows 整合版本动不动安装某个模块就出故障，然后系统就彻底没办法再安装模块来....

可怜的偶已经把openerp重装了NNNN次了....

是不是openerp 就是那么不稳定？还是windows版本就那么不稳定，XP win7 win8 32位的，64位的都试过了？还是有些模块注定不能安装？？？
现在整个机器专门装上 CENTOS 6.3 来安装openerp，以前没怎么接触过Linux 配置都蛮痛苦的，大家有啥检验呢....

我们准备给自己外贸公司上 ERP，现在已经有套简单的了，想测试下openerp如何！

Odoo 中文社区

222411

帖子