Fatal error: Uncaught exception ‘Exception’ with message ‘Error: Unknown column ‘main_category’ in ‘where clause’
Error No: 1054
SELECT category_id FROM oc_product_to_category WHERE product_id = ‘523’ AND main_category = ‘1’ LIMIT 1′

Вопрос
1
2
3
<span class="pln">Ошибка  Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'main_category' in 'where clause'&lt;br/&gt;Error No: 1054&lt;br/&gt;SELECT category_id FROM oc_product_to_category WHERE product_id = '523' AND main_category = '1' LIMIT 1'
Решается запросом SQL
ALTER TABLE </span><span class="str">`oc_product_to_category`</span><span class="pln"> ADD </span><span class="str">`main_category`</span><span class="pln"> tinyint</span><span class="pun">(</span><span class="lit">1</span><span class="pun">)</span><span class="pln"> NOT NULL DEFAULT </span><span class="str">'0'</span><span class="pun">;</span>
нет решения 0
Анонимно 1 месяц 1 Ответ 113 просмотров 0

Ответ ( 1 )

  1. doriani4k
    0
    Ответить

    не хватает таблицы  зайди и создай пустую

    1
    <span class="pln">main_category</span> - type text

Напишите ответ