Tryton - Issues



Title can not open invoice report
Priority bug Status resolved
Superseder Nosy List ced, roundup-bot, tufei
Type crash Components account_invoice
Assigned To ced Keywords

Created on 2012-07-06.11:14:55 by tufei, last changed by ced.

New changeset 3b77f743131c by C?dric Krier in branch 'default':
Store report cache using buffer
msg14736 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2013-11-26.00:30:25
Please test patch at review1941002
The patch only fix new invoices, for old invoices you must set to null the
invoice_report_cache column of the invoice to get the report re-computed and
stored again with the right format.
msg11233 (view) Author: [hidden] (tufei) Date: 2012-07-15.08:23:56
i just use default setting and default format. .odt file.
i use debian with sqlite db ,not postgresql.
msg11179 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2012-07-09.12:15:05
In which format do you store the invoice?
msg11173 (view) Author: [hidden] (tufei) Date: 2012-07-06.11:14:54
I Use 2.4 from ,  work with sqlite database.
 when after i create an invoice ,i click the "open report"-"invoice" ;first it
works; but next time i login to tryton,then click  the "open report"-"invoice";
it have issue. thanks.

Traceback (most recent call last):
  File "/trytond/protocols/", line 123, in _marshaled_dispatch
    response['result'] = dispatch_method(method, params)
  File "/trytond/protocols/", line 156, in _dispatch
    res = dispatch(*args)
  File "/trytond/protocols/", line 156, in dispatch
    res = getattr(obj, method)(*args_without_context, **kargs)
  File "/trytond/modules/account_invoice/", line 2175, in execute
    res = super(InvoiceReport, self).execute(ids, data)
  File "/trytond/report/", line 131, in execute
    type, data = self.parse(action_report, objects, datas, {})
  File "/trytond/modules/account_invoice/", line 2196, in parse
    if invoice.invoice_report_cache:
  File "/trytond/model/", line 230, in __getattr__
    return self[name]
  File "/trytond/model/", line 174, in __getitem__
    for data in, ffields.keys()):
  File "/trytond/model/", line 526, in read
    table_args + red_ids + history_args + domain2)
  File "/trytond/backend/sqlite/", line 300, in execute
    res = self.cursor.execute(sql, params)
OperationalError: Could not decode to UTF-8 column 'invoice_report_cache'
with text 'PK'
Date User Action Args
2013-11-28 23:09:39cedsetstatus: testing -> resolved
2013-11-28 23:09:28roundup-botsetnosy: + roundup-bot
messages: + msg14790
2013-11-26 00:30:26cedsetstatus: need-eg -> testing
assignedto: ced
component: + account_invoice
messages: + msg14736
2013-11-26 00:12:44cedlinkissue3521 superseder
2012-07-15 08:23:57tufeisetmessages: + msg11233
2012-07-09 12:15:05cedsetstatus: unread -> need-eg
nosy: + ced
messages: + msg11179
2012-07-06 11:14:55tufeicreate

Showing 10 items. Show all history (warning: this could be VERY long)