2015-11-26 14:33
Programinė įranga »
Nemokama apskaitos programa »
#1294892
Klaidos turinys: 'SQLite error
no such column: I.VatIsVirtual'.
2015-11-26 14:08
Programinė įranga »
Nemokama apskaitos programa »
#1294888
Po paskutinio atnaujinimo neina atidaryti sąskaitų. DB Klaidų taisymas nepadėjo. Išsaugoti sąskaitos taip pat neina.
Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, C.ID, C.Pavad, C.Kodas, C.SP_kodas, C.E_Mail, b.Op_data, b.Op_Dok, b.Op_turinys, O.CurrencyCode, O.CurrencyRate, O.LanguageCode, O.CommentsInternal, MAX(I.Tar), SUM(I.SumOriginal), SUM(I.SumVatOriginal), SUM(I.SumLTL), SUM(I.SumVatLTL), SUM(I.Discount), SUM(I.DiscountVat), SUM(I.DiscountLTL), SUM(I.DiscountVatLTL), O.AccountPayer, SUM(CASE WHEN I.VatIsVirtual>0 THEN I.SumVatOriginal - I.DiscountVat ELSE 0 END) AS VirtualVat, SUM(CASE WHEN I.VatIsVirtual>0 THEN I.SumVatLTL - I.DiscountVatLTL ELSE 0 END) AS VirtualVatLTL FROM bz b LEFT JOIN InvoicesMade O ON O.ID=b.Op_ID LEFT JOIN sfd as I ON I.SF_ID=O.ID LEFT JOIN asmenys C ON C.ID=b.Op_analitika WHERE b.Op_data>=$DF AND b.Op_data<=$DT AND NOT O.ID IS NULL GROUP BY O.ID ORDER BY b.Op_data;=b.Op_ID LEFT JOIN sfd as I ON I.SF_ID=O.ID LEFT JOIN asmenys C ON C.ID=b.Op_analitika WHERE b.Op_data>=$DF AND b.Op_data<=$DT AND NOT O.ID IS NULL GROUP BY O.ID ORDER BY b.Op_data;], Params: ?DF=2015-10-27; ?DT=2015-11-26;
Klaidos turinys: 'SQLite error
no such column: I.VatIsVirtual'.