Jump to content
Sign in to follow this  
hitball

Fatal error: Uncaught exception 'Exception' with message 'Error: Table './pan/oc_product_viewed'

Recommended Posts

Здравствуйте! Все карточки товара выдают такую ошибку, что делать??? :(

Fatal error: Uncaught exception 'Exception' with message 'Error: Table './pan/oc_product_viewed' is marked as crashed and last (automatic?) repair failed<br />Error No: 144<br />DELETE FROM oc_product_viewed WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)' in /var/www/uti-puti/data/www/pan.com.ua/system/library/db/mysqli.php:40 Stack trace: #0 /var/www/uti-puti/data/www/pan.com.ua/system/library/db.php(16): DB\MySQLi->query('DELETE FROM oc_...', Array) #1 /var/www/uti-puti/data/www/pan.com.ua/catalog/model/catalog/ochelp_viewed.php(22): DB->query('DELETE FROM oc_...') #2 [internal function]: ModelCatalogOchelpViewed->deleteOldViewedProduct('30') #3 /var/www/uti-puti/data/www/pan.com.ua/system/storage/modification/system/engine/loader.php(178): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /var/www/uti-puti/data/www/pan.com.ua/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #6 /var/www/uti-puti/data/www/sexma in /var/www/uti-puti/data/www/pan.com.ua/system/library/db/mysqli.php on line 40

Share this post


Link to post
Share on other sites

такое же сообщение выдет в бд. не дает открыть таблицу. причем в другом магазине этой таблицы совсем нет :huh:

зачем она нужна эта таблица? может просто создать ее? как она должна выглядеть? гляньте, пожалуйста, кто может какие ячейки и их название, чтобы создать

Edited by hitball

Share this post


Link to post
Share on other sites

Надо чинить бд, в phpmyadmin есть кнопка repair

ну или откатить

Share this post


Link to post
Share on other sites

спасибо, помогло!!

REPAIR TABLE `oc_product_viewed`

но так и не могу понять из-за чего это! последнее время вообще ничего не делала(

Share this post


Link to post
Share on other sites
56 минут назад, hitball сказал:

oc_product_viewed

ЗАмечательно что вам кто-то оптимизировал магазин
А какой тип таблицы?

Share this post


Link to post
Share on other sites
57 минут назад, hitball сказал:

DELETE FROM oc_product_viewed WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)

прикольно, а что это такое, которое учитывает количество просмотров за месяц?

Share this post


Link to post
Share on other sites

Выше перечисленые советы не помогли. Может еще кто что может подсказать?  

Share this post


Link to post
Share on other sites
Posted (edited)
В 24.11.2018 в 12:56, spectre сказал:

Надо чинить бд, в phpmyadmin есть кнопка repair

ну или откатить

Добрый вечер!

У меня такая ошибка
Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'thl_8bd.oc_manufacturer_description' doesn't exist<br />Error No: 1146<br />SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = in /home/thl/8ka.com.ua/www/system/library/db/mysqli.php on line 40

Не подскажите решение?

 

Edited by shop24

Share this post


Link to post
Share on other sites

У меня такая ошибка
Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'thl_8bd.oc_manufacturer_description' doesn't exist<br />Error No: 1146<br />SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = in /home/thl/8ka.com.ua/www/system/library/db/mysqli.php on line 40

Не подскажите решение?

 

Share this post


Link to post
Share on other sites

если закинуть ошибку в гугл или переводчик он скажет что не так

Share this post


Link to post
Share on other sites
8 часов назад, shop24 сказал:

'Error: Table 'thl_8bd.oc_manufacturer_description' doesn't exist

нет таблицы oc_manufacturer_description

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.