Odoo 中文社区

各位好，
现在已经在Ubuntu上部署了GreenOpenERP，但是是8.0RC1的，现在8.0有正式版了，请问如何更新呢？直接覆盖靠谱吗？
我已经有了很多数据，很担心数据丢失。
谢谢！

仔细阅读OpenERP用户使用手册的薪酬管理部分，https://doc.odoo.com/7.0/zh_CN/book/4/4_11_HR/4_11_HR_payroll/

出现这个错误主要是因为我对工资管理的流程理解错了，不应该手动添加薪酬，而是应该点击“计算”，则系统会自动添加由工资结构定义的薪酬，无需手动添加和修改，也就会绕过之前提到的问题了。
不要删除contract_id等，可能会造成意想不到的错误。

我的解决方法是：由于contract_id（其实还有employee_id和salary_rule_id）是外键，和contract.id相关联，先删除它，再加回来即可。（数据库表：hr_payslip_line）

但是这样有问题，就是不能正确计算工资，估计是salary_rule_id的问题，还需要再研究一下完美的解决方法。

在“计算薪酬”部分添加了一个薪酬之后就报错：

'Integrity Error', 'The operation cannot be completed, probably due to the following:\n- deletion: you may be trying to delete a record while other records still reference it\n- creation/update: a mandatory field is not correctly set\n\n[object with reference: contract_id - contract.id]'

详细的出错信息如下，有没有人碰到过这个问题？

2014-09-22 13:40:00,673 9150 ERROR udlrtech openerp.sql_db: bad query: INSERT INTO "hr_payslip_line" ("id", "condition_select", "code", "appears_on_payslip", "amount_select", "name", "sequence", "condition_python", "amount_python_compute", "amount_percentage", "amount", "company_id", "rate", "slip_id", "condition_range", "active", "category_id", "amount_fix", "quantity", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('hr_payslip_line_id_seq'), 'none', 'base', true, 'fix', 'base', 5, '
# Available variables:
#----------------------
# payslip: object containing the payslips
# employee: hr.employee object
# contract: hr.contract object
# rules: object containing the rules code (previously computed)
# categories: object containing the computed salary rule categories (sum of amount of all rules belonging to that category).
# worked_days: object containing the computed worked days
# inputs: object containing the computed inputs

# Note: returned value have to be set in the variable ''result''

result = rules.NET > categories.NET * 0.10', '
# Available variables:
#----------------------
# payslip: object containing the payslips
# employee: hr.employee object
# contract: hr.contract object
# rules: object containing the rules code (previously computed)
# categories: object containing the computed salary rule categories (sum of amount of all rules belonging to that category).
# worked_days: object containing the computed worked days.
# inputs: object containing the computed inputs.

# Note: returned value have to be set in the variable ''result''

result = contract.wage * 0.10', '0.0000', '100.00', 1, '100.0000', 11, 'contract.wage', true, 1, '0.00', '1.00', 242, 242, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id
Traceback (most recent call last):
  File "/home/wanghenan/GreenOdoo-8.0-linux64/source/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "contract_id" violates not-null constraint
DETAIL:  Failing row contains (41, none, base, 2014-09-22 13:40:00.658672, fix, 5, null, 242, 100.0000, null, t, contract.wage, t, null, null, 0.00, null, 242, null, null,
# Available variables:
#----------------------
# payslip: objec..., 100.00,
# Available variables:
#----------------------
# payslip: objec..., 1, base, null, 0.0000, null, 2014-09-22 13:40:00.658672, null, 1.00, 1, 11).

2014-09-22 13:40:00,673 9150 ERROR udlrtech openerp.http: Exception during JSON request handling.
Traceback (most recent call last):
  File "/home/wanghenan/GreenOdoo-8.0-linux64/source/openerp/http.py", line 479, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/wanghenan/GreenOdoo-8.0-linux64/source/openerp/http.py", line 498, in dispatch
    result = self._call_function(**self.params)
  File "/home/wanghenan/GreenOdoo-8.0-linux64/source/openerp/http.py", line 314, in call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/wanghenan/GreenOdoo-8.0-linux64/source/openerp/service/model.py", line 149, in wrapper
    raise openerp.osv.orm.except_orm(('Integrity Error'), msg)
except_orm: ('Integrity Error', 'The operation cannot be completed, probably due to the following:\n- deletion: you may be trying to delete a record while other records still reference it\n- creation/update: a mandatory field is not correctly set\n\n[object with reference: contract_id - contract.id]')

已经解决了，参考：《Odoo8.0邮件发送问题的临时解决办法》http://blog.sina.com.cn/s/blog_7cb52fa80101s3hq.html

根据 广州-步科 的提示，更改addons/base/ir/ir_mail_server.py
将“smtp_from = message['Return-Path'] or message['From']”
更改为“smtp_from = '[email protected]'”
其中“[email protected]”可改为你公司的邮箱地址。
改后重启Odoo服务，就可以发送电子邮件了。

最近安装了GreenOpenERP 8.0版本，发现新建用户之后无法给用户发送修改密码的邮件了，如图所示：
[img2][attach=1][/img2]
本来这里只能填写Name和Email Address的，但是我修改了一下，发现res_users里没有email其实，email应该是对应的res_partner的，所以我将Email Address改成了email，新增一个Login显示login（其实这段跟主题没啥关系，只是想吐槽一下最新的设计怪怪的）。
问题是点击“Send an invitation email”之后提示440错误：

[center]Mail Delivery Failed

向SMTP服务器 'smtp.udlrtech.com'发送邮件失败。
SMTPSenderRefused: 440
mail from account doesn't conform with authentication (Auth Account:[email protected]|Mail Account:[email protected])
[email protected][/center]

这里udlrtech.com是我设置的别名域，但是这个bounce-684-res.users-559我就不知道是怎么来的了，这直接导致收件人的地址不正确，进而无法发邮件，不知道有没有碰到类似的问题，求帮助！