Closed (fixed)
Project:
Community Accounting
Version:
7.x-3.0-rc4
Component:
Display
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 Dec 2012 at 16:08 UTC
Updated:
20 Jul 2013 at 18:44 UTC
Hi,
After updating from RC3 to RC4 all worked fine except the reconstruction of mcapi_index table. I must recreate this table:
CREATE ALGORITHM = UNDEFINED VIEW mcapi_index AS
SELECT
t.xid,
t.serial,
t.payer AS uid1,
t.payee AS uid2,
0 AS income,
w.worth_quantity AS expenditure,
- w.worth_quantity AS diff,
w.worth_quantity AS volume,
w.worth_currcode AS currcode,
t.created
FROM mcapi_transactions t
RIGHT JOIN field_data_worth w ON t.xid = w.entity_id
WHERE state > 0
UNION
SELECT
t.xid,
t.serial,
t.payee AS uid1,
t.payer AS uid2,
w.worth_quantity AS income,
0 AS expenditure,
w.worth_quantity AS diff,
w.worth_quantity AS volume,
w.worth_currcode AS currcode,
t.created
FROM mcapi_transactions t
RIGHT JOIN field_data_worth w ON t.xid = w.entity_id
WHERE state > 0
Comments
Comment #1
matslats commented