Здравствуйте, прошу помощи в исправлении ошибки. В программировании я не очень.
У нас стоит модуль производителей, в нем есть две возможности:
выбрать всех производителей или выбрать из списка.
При выборе из списка, он не видит производителей и в журнале появляются такие ошибки:
2018-07-09 13:16:30 - PHP Notice: Error: Column 'name' in where clause is ambiguous<br />Error No: 1052<br />SELECT c.manufacturer_id, md.name, c.sort_order FROM oc_manufacturer c LEFT JOIN oc_manufacturer_description md ON (c.manufacturer_id = md.manufacturer_id) WHERE md.language_id = '1' AND name LIKE 'APECS%' ORDER BY name ASC LIMIT 0,5 in /system/library/db/mysqli.php on line 41
2018-07-09 13:16:30 - PHP Notice: Trying to get property of non-object in /system/storage/modification/admin/model/catalog/manufacturer.php on line 159
2018-07-09 13:16:30 - PHP Warning: Invalid argument supplied for foreach() in /admin/controller/catalog/manufacturer.php on line 488
in /system/storage/modification/admin/model/catalog/manufacturer.php on line 159
if (isset($data['start']) || isset($data['limit'])) {
if ($data['start'] < 0) {
$data['start'] = 0;
}
if ($data['limit'] < 1) {
$data['limit'] = 20;
}
$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
}
$query = $this->db->query($sql);
return $query->rows;
}
in /admin/controller/catalog/manufacturer.php on line 488
if (utf8_strlen($this->request->post['keyword']) > 0) {
$this->load->model('catalog/url_alias');
$url_alias_info = $this->model_catalog_url_alias->getUrlAlias($this->request->post['keyword']);
if ($url_alias_info && isset($this->request->get['manufacturer_id']) && $url_alias_info['query'] != 'manufacturer_id=' . $this->request->get['manufacturer_id']) {
$this->error['keyword'] = sprintf($this->language->get('error_keyword'));
}
if ($url_alias_info && !isset($this->request->get['manufacturer_id'])) {
$this->error['keyword'] = sprintf($this->language->get('error_keyword'));
}
if ($this->error && !isset($this->error['warning'])) {
$this->error['warning'] = $this->language->get('error_warning');
}
}
return !$this->error;
}