Hello Leon/Shannon -jj Behrens, What's the intention of "Notes" in invoice_sku? in database/mysql/invoice function getInvoiceInfo includes: $Query = "SELECT ss.ID, ss.ExternalSKU, s.Name, ss.ListPrice, " . "ss.SalePrice, i.Name, ss.Quantity, ss.Freight, ss.GiftWrap, s.ID," . "ss.Notes " . "FROM invoice_sku ss, sku s, item i " . "WHERE ss.SKU = s.ID " . "AND s.Item = i.ID " . "AND ss.Invoice = $invoice"; and function copyBasketToInvoice: $Query = "INSERT INTO invoice_sku " . "SELECT 0, $invoice, ss.SKU, ss.Quantity, s.ExternalSKU, s.Name, " . "s.ListPrice, s.SalePrice, s.AdditionalShipping, ss.Notes, 0, 'N' " . "FROM session_sku ss, sku s " . "WHERE ss.SKU = s.ID " . "AND ss.Session = '" . $session . "' "; It's not included in the invoice_sku table and is obviously generating errors. In my case I've dropped it from the database/mysql/invoice queries and CREATE_INVOICE can proceed but I was curious if that was what you intended, i.e. should it be added to the database? Nick ---------------------- Lab2 Design-Unit URL: http://www.lab2.com.au e-mail: [EMAIL PROTECTED] ---------------------- _______________________________________________ FreeTrade-dev mailing list [EMAIL PROTECTED] http://share.whichever.com/mailman/listinfo/freetrade-dev
