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

Discuss bugs related to Logic Invoice.
Post Reply
thumb
Posts: 5
Joined: Thu Nov 02, 2017 8:27 pm

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

Post by thumb » Sat Nov 04, 2017 6:15 am

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 !


Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest