Shop

WordPress database error: [<div style="clear:both">&nbsp;</div><div class="queries" style="clear:both; margin_bottom:2px; border: red dotted thin;">Queries made or created this session were<br/> <ol> <li>Raw query: INSERT into wp_wcfm_daily_analysis (`is_shop`, `is_store`, `is_product`, `product_id`, `author_id`, `count`, `visited`) VALUES (1, 0, 0, 0, 14, 1, '2019-04-18') ON DUPLICATE KEY UPDATE count = count+1</li> <li>Rewritten: INSERT INTO wp_wcfm_daily_analysis (is_shop, is_store, is_product, product_id, author_id, count, visited) VALUES (1, 0, 0, 0, 14, 1, '2019-04-18')</li> <li>With Placeholders: INSERT INTO wp_wcfm_daily_analysis (is_shop, is_store, is_product, product_id, author_id, count, visited) VALUES (1, 0, 0, 0, 14, 1, :param_0 )</li> <li>Prepare: INSERT INTO wp_wcfm_daily_analysis (is_shop, is_store, is_product, product_id, author_id, count, visited) VALUES (1, 0, 0, 0, 14, 1, :param_0 )</li> <li>Executing: array ( 0 => '2019-04-18', )</li> </ol> </div><div style="clear:both; margin_bottom:2px; border: red dotted thin;" class="error_message" style="border-bottom:dotted blue thin;">Error occurred at line 692 in Function execute_query. <br/> Error message was: Error while executing query! Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: wp_wcfm_daily_analysis.product_id, wp_wcfm_daily_analysis.author_id, wp_wcfm_daily_analysis.visited </div><pre>#0 PDOEngine->get_error_message() called at [/home/infopasardesa/public_html/wp-content/plugins/sqlite-integration/pdodb.class.php:254] #1 PDODB->query(INSERT into wp_wcfm_daily_analysis (`is_shop`, `is_store`, `is_product`, `product_id`, `author_id`, `count`, `visited`) VALUES (1, 0, 0, 0, 14, 1, '2019-04-18') ON DUPLICATE KEY UPDATE count = count+1) called at [/home/infopasardesa/public_html/wp-content/plugins/wc-frontend-manager/core/class-wcfm-frontend.php:479] #2 WCFM_Frontend->wcfm_save_page_analytics_data() called at [/home/infopasardesa/public_html/wp-includes/class-wp-hook.php:286] #3 WP_Hook->apply_filters(, Array ([0] => )) called at [/home/infopasardesa/public_html/wp-includes/class-wp-hook.php:310] #4 WP_Hook->do_action(Array ([0] => )) called at [/home/infopasardesa/public_html/wp-includes/plugin.php:465] #5 do_action(wp_footer) called at [/home/infopasardesa/public_html/wp-includes/general-template.php:2684] #6 wp_footer() called at [/home/infopasardesa/public_html/wp-content/themes/shop-isle/footer.php:24] #7 require_once(/home/infopasardesa/public_html/wp-content/themes/shop-isle/footer.php) called at [/home/infopasardesa/public_html/wp-includes/template.php:704] #8 load_template(/home/infopasardesa/public_html/wp-content/themes/shop-isle/footer.php, 1) called at [/home/infopasardesa/public_html/wp-includes/template.php:653] #9 locate_template(Array ([0] => footer-shop.php,[1] => footer.php), 1) called at [/home/infopasardesa/public_html/wp-includes/general-template.php:76] #10 get_footer(shop) called at [/home/infopasardesa/public_html/wp-content/plugins/woocommerce/templates/archive-product.php:107] #11 include(/home/infopasardesa/public_html/wp-content/plugins/woocommerce/templates/archive-product.php) called at [/home/infopasardesa/public_html/wp-includes/template-loader.php:77] #12 require_once(/home/infopasardesa/public_html/wp-includes/template-loader.php) called at [/home/infopasardesa/public_html/wp-blog-header.php:19] #13 require(/home/infopasardesa/public_html/wp-blog-header.php) called at [/home/infopasardesa/public_html/index.php:17] </pre>]
INSERT into wp_wcfm_daily_analysis (`is_shop`, `is_store`, `is_product`, `product_id`, `author_id`, `count`, `visited`) VALUES (1, 0, 0, 0, 14, 1, '2019-04-18') ON DUPLICATE KEY UPDATE count = count+1