Помогите настроить product.php и header.tpl лезут ошибки

[axlnik]

Как обычно сидел заполнял сайт, после заполнения категории вылетел, попробовал зайти перекидывает на пустую страницу: arhimed.net/admin/index.php?route=common/login

Сам сайт все нормально отображается.

та жа проблема с другими сайтами на этой базе.

Установил новый магазин там все работает.

Тех поддержка говорит у них все в порядке.

Я сверху установил инсталлер, востановил базу, в админку заходит но видит дефолтовую базу товаров. Изменил PREFIX на префикс своей старой базы, вернулся к ошибке с пустым окном, по совету залез в логи ошибок результат в 3 посте

[CODEONETEAM]

Ошибка HTTP 500 (Internal Server Error), она же "белый экран"

[axlnik]

спасибо большое за подсказку:

2014-09-11 17:12:57 - PHP Notice:  Undefined index: tag in /мой сайт/catalog/model/catalog/product.php on line 41

 

2014-09-11 17:12:57 - PHP Notice:  Undefined index: ean in /мой сайт/catalog/model/catalog/product.php on line 45

 

2014-09-11 17:12:57 - PHP Notice:  Undefined index: jan in /мой сайт/catalog/model/catalog/product.php on line 46

 

2014-09-11 17:12:57 - PHP Notice:  Undefined index: isbn in /мой сайт/catalog/model/catalog/product.php on line 47

 

2014-09-11 17:12:57 - PHP Notice:  Undefined index: mpn in /мой сайт/catalog/model/catalog/product.php on line 48

 

 

 

2014-09-11 17:12:57 - PHP Notice:  Undefined variable: filter_name in /мой сайт/catalog/view/theme/fancycart/template/common/header.tpl on line 75

 

 

2014-09-11 17:15:07 - PHP Notice:  Error: Unknown column 'salt' in 'where clause'<br />Error No: 1054<br />SELECT * FROM customer WHERE LOWER(email) = 'не известный мне емейл' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('не известный мне пароль'))))) OR password = 'код') AND status = '1' AND approved = '1' in /var/www/u2117266/data/www/arhimed.net/system/database/mysql.php on line 50

 

2014-09-11 17:16:06 - PHP Notice:  Undefined variable: filter_name in /var/www/u2117266/data/www/arhimed.net/catalog/view/theme/fancycart/template/common/header.tpl on line 75

 

2014-09-11 17:17:37 - PHP Notice:  Error: Unknown column 'salt' in 'where clause'<br />Error No: 1054<br />SELECT * FROM user WHERE username = 'мой логин' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('мой пароль'))))) OR password = 'код') AND status = '1' in /var/www/u2117266/data/www/arhimed.net/system/database/mysql.php on line 50

 

2014-09-11 17:18:11 - PHP Notice:  Error: Unknown column 'salt' in 'where clause'<br />Error No: 1054<br />SELECT * FROM user WHERE username = 'логин' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('пароль'))))) OR password = 'код') AND status = '1' in /var/www/u2117266/data/www/arhimed.net/system/database/mysql.php on line 50

 

product.php

public function getProduct($product_id) {
if ($this->customer->isLogged()) {
$customer_group_id = $this->customer->getCustomerGroupId();
} else {
$customer_group_id = $this->config->get('config_customer_group_id');
}


$query = $this->db->query("SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '" . (int)$customer_group_id . "' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '" . $this->NOW . "') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '" . $this->NOW . "')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '" . (int)$customer_group_id . "' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '" . $this->NOW . "') AND (ps.date_end = '0000-00-00' OR ps.date_end > '" . $this->NOW . "')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM " . DB_PREFIX . "product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '" . (int)$customer_group_id . "') AS reward, (SELECT ss.name FROM " . DB_PREFIX . "stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '" . (int)$this->config->get('config_language_id') . "') AS stock_status, (SELECT wcd.unit FROM " . DB_PREFIX . "weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS weight_class, (SELECT lcd.unit FROM " . DB_PREFIX . "length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS length_class, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM " . DB_PREFIX . "review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.date_available <= '" . $this->NOW . "' AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'");


if ($query->num_rows) {
return array(
'seo_title'        => $query->row['seo_title'],
'seo_h1'           => $query->row['seo_h1'],
'product_id'       => $query->row['product_id'],
'name'             => $query->row['name'],
'description'      => $query->row['description'],
'meta_description' => $query->row['meta_description'],
'meta_keyword'     => $query->row['meta_keyword'],
41   'tag'              => $query->row['tag'],
42    'model'            => $query->row['model'],
43     'sku'              => $query->row['sku'],
44     'upc'              => $query->row['upc'],
45     'ean'              => $query->row['ean'],
46     'jan'              => $query->row['jan'],
47     'isbn'             => $query->row['isbn'],
48     'mpn'              => $query->row['mpn'],
49     'location'         => $query->row['location'],
50     'quantity'         => $query->row['quantity'],

 

 

header.tpl

<div id='header_btm'>
   <div id="search">
  <div class="search_inside">
75     <?php if ($filter_name) { ?>
76     <input type="text" name="filter_name" value="<?php echo $filter_name; ?>" />
77     <?php } else { ?>
78     <input type="text" name="filter_name" value="<?php echo $text_search; ?>" onclick="this.value = '';" onkeydown="this.style.color = '#444444';" />
   <?php } ?>
   <div class="button-search"></div>
   </div>
 </div>
   <?php echo $language; ?>
   <?php echo $currency; ?>
  </div>

 

Не понимаю, что не так

[axlnik]

не смог решить проблему, откатился назад