Xataface Forums

Hiya,

In my apache logs, I'm getting the following:

Code: Select all

PHP Notice:  Undefined index: alias in /var/www/html/public/dataface/Dataface/Table.php on line 2046, referer: http://www.dogbiscuit.org.uk/index.php?-table=BillData&-action=related_records_list&-cursor=1&-skip=0&-limit=30&-mode=list&-recordid=BillData%3FBillDataID%3D16&-relationship=SiteData
PHP Warning:  ucfirst() expects parameter 1 to be string, array given in /var/www/html/public/dataface/Dataface/Table.php on line 2385, referer: http://www.dogbiscuit.org.uk/index.php?-table=BillData&-action=related_records_list&-cursor=1&-skip=0&-limit=30&-mode=list&-recordid=BillData%3FBillDataID%3D16&-relationship=SiteData
PHP Warning:  Illegal offset type in /var/www/html/public/dataface/Dataface/Table.php on line 2047, referer: http://www.dogbiscuit.org.uk/index.php?-table=BillData&-action=related_records_list&-cursor=1&-skip=0&-limit=30&-mode=list&-recordid=BillData%3FBillDataID%3D16&-relationship=SiteData


Because of this line in BillData/BillData.php

Code: Select all

function __sql__(){
        return "select t.*, datediff(t.SupplyPeriodEnd,t.SupplyPeriodStart) as StandingChargeUnits, t.TotalCostExVAT*t.MPAN1LowerVATPerc/(100)*t.LowBillDataVATRates+t.TotalCostExVAT*t.MPAN1HigherVATPerc/(100)*t.HighBillDataVATRates as VAT, t.TotalCostExVAT*t.MPAN1LowerVATPerc/(100)*t.LowBillDataVATRates+t.TotalCostExVAT*t.MPAN1HigherVATPerc/(100)*t.HighBillDataVATRates + t.TotalCostExVAT AS BillTotal from BillData t";
}


Have I made an error with the code? It works as far as I can tell but I guess somewhere, the framework doesn't like it.

Can you shed any light?

Cheers

Paul

Currently the SQL parser can't handle in-line arithmetic (e.g. 10*5 or columnname*100)... This is likely what it is objecting to. I was a little surprised when you originally showed your solution that involved this arithmetic when you said that it was working...

that's my best guess right now.

Hi Steve,

Ah right. I've seen you mention this before. Yeah, the code works fine. The calculations are correct so there're no issues there. I'll just ignore the errors for now

Thanks

Paul