klevu / content Goto Github PK

Hello @klevu ,

I have another error in admin var/www/html/Magento2.1.4/vendor/magento/module-config/Model/Config/Structure/Element/Iterator.php on line 59.
It shows notice error in admin section when clicking Store->Configuration.

Thanks,
Moin

Conditions:

• Magento Commerce 2.1.9 (Enterprise)
• klevu/module-content 2.1.24

Description:
While processing with cron Klevu then job-code "klevu_search_content_sync" gets status error and in messages field is stated following SQL-statement error as below in "Error" section.

There seems to be partial support for row_id but still used page_id where it doesn't exist:

vendor/klevu/module-content/Model/Content.php

Error in cron_schedule-table:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.page_id' in 'field list', query was: 
SELECT `k`.`product_id` AS `page_id` FROM `klevu_product_sync` AS `k`
 LEFT JOIN `cms_page` AS `c` ON k.product_id = c.page_id AND (c.created_in <= 1 AND c.updated_in > 1)
 LEFT JOIN `cms_page_store` AS `v` ON v.page_id = c.page_id WHERE (((k.store_id = :store_id AND v.store_id != 0) AND (k.type = :type) AND (k.product_id NOT IN (SELECT `i`.`page_id` FROM `cms_page_store` AS `i` WHERE (i.page_id NOT IN ('')) AND (i.store_id = :store_id OR i.store_id = 0)))) OR ( (k.product_id IN ('') OR (c.page_id IS NULL) OR (c.is_active = 0)) AND (k.type = :type) AND k.store_id = :store_id)) GROUP BY `k`.`product_id`
`

@klevu
Hello,

I am new to magento and i m using this extension but it shows this error.
Exception #0 (ReflectionException): Class Klevu\Search\Helper\Config does not exist