Errors on system specials

ThemeBurn SupportForumsOpenCart ThemesPavilion OpenCart ThemeErrors on system specials

This topic has been marked as not resolved.

Current settings:

Current theme Pavilion v2.2.7 /installed on 19.06.2016 12:03/
BurnEngine version 1.2.7
OpenCart version 2.0.2.0
vQmod version 2.5.1
HTTP Server Apache
MySQL server version 5.1.73
PHP version 5.3.3
PHP memory limit 1024 MB
PHP Zip extension Yes

I’m getting this error over and over and wondering if I have all up to date? What else could be causing this with the system specials?:
PHP Notice: Trying to get property of non-object in system/vendor/BurnEngine/catalog/model/productsModel.php on line 157
PHP Warning: Invalid argument supplied for foreach() in system/vendor/BurnEngine/catalog/model/productsModel.php on line 157
PHP Notice: Error: Got error 134 from storage engineError No: 1030SELECT p.*, pd.name, pd.description, pd.meta_description, m.name AS manufacturer, 6707840,
(SELECT price
FROM oc_product_discount AS pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id = ’10′
AND pd2.quantity = ’1′ AND ((pd2.date_start = ’0000-00-00′ OR pd2.date_start NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC
LIMIT 1
) AS discount,
(SELECT price
FROM oc_product_special AS ps
WHERE ps.product_id = p.product_id
AND ps.customer_group_id = ’10′
AND ((ps.date_start = ’0000-00-00′ OR ps.date_start NOW()))
ORDER BY ps.priority ASC, ps.price ASC
LIMIT 1
) AS special,
(SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id
AND r1.status = ’1′
GROUP BY r1.product_id
) AS rating,
(SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id
AND ss.language_id = ’1′
) AS stock_status,
(SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = ’1′
GROUP BY r2.product_id
) AS reviews
FROM oc_product AS p
INNER JOIN oc_product_description AS pd ON p.product_id = pd.product_id
LEFT JOIN oc_manufacturer AS m ON p.manufacturer_id = m.manufacturer_id
INNER JOIN oc_product_to_store p2s ON p.product_id = p2s.product_id
WHERE p.status = 1
AND p.date_available <= NOW()
AND pd.language_id = 1 AND p2s.store_id = 0 ORDER BY RAND() ASC LIMIT 0,3 in /system/library/db/mysqli.php on line 41

November 16, 2017 at 10:08 pm #62591

Hi,

We will need the website url, admin and ftp access, so we can check.

You can use hidepost to share private information with the support staff.

BR,
ThemeBurn team

November 17, 2017 at 3:06 pm #62596

Hello, to access my account you need:

Thank you!

November 17, 2017 at 4:05 pm #62603

I have not yet heard from you.. have you checked this?

November 25, 2017 at 3:03 pm #62661

Hi,

We’ve checked your specials page and it does not seem to cause any errors. With some additional testing we’ve found out that the problem appears when using Latest or Random Products block (widget) in Page Builder.

This is the error that shows in the log – error 134:

https://confluence.atlassian.com/confkb/got-error-134-from-storage-engine-error-due-to-mysql-table-corruption-232554991.html

In brief “error 134″ is an database error in the table index file. You should run a ‘REPAIR’ query on the tables.

BR,
ThemeBurn team

November 29, 2017 at 3:01 pm #62703
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.