Page 1 of 1

Bug: model/billing/invoice.php : Do not show invoice

Posted: Sat Nov 04, 2017 6:15 am
by thumb
A small bug in admin/model/billing/invoice.php

line 153 shall be:
$query = $this->db->query("SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, ( SELECT name FROM " . DB_PREFIX . "status s WHERE s.status_id = i.status_id AND s.language_id = " . (int)$this->config->get('config_language_id') . ") AS status FROM " . DB_PREFIX . "invoice i LEFT JOIN " . DB_PREFIX . "customer c ON c.customer_id = i.customer_id WHERE invoice_id = '" . (int)$invoice_id . "'");

other wise sub sql ( DB_PREFIX_status )returns to many fields in multi lang setups !

Re: Bug: model/billing/invoice.php : Do not show invoice

Posted: Wed Nov 08, 2017 8:16 pm
by Esmond
Thanks, possible to open a issue here? https://github.com/Equotix/Logic-Invoice/issues