[14-Sep-2022 11:41:35 UTC] WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 36 für Abfrage
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND wp_posts.ID IN (10656,8392,8392,8392,8392,24909,24797,8392,24869,25044,25121,25134,24791,24791,24791,8392,8392,8392,8392,8392,8392,25142,25142,25142,25142,24791,8392,8392,8392,8392,24797,24860,24797,24864,9268,24869,24869,24869,24869,24797,8392,24797,24891,24891,24891,24791,24869,24869,24869,8392,8392,8392,8392,8392,8392,8392,24869,8392,8392,8392,8392,8392,8392,8392,24896,24869,24869,24869,25134,24797,24909,24909,24797,24917,24920,8987,8987,24923,24797,24927,24797,25000,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,24797,8987,8987,24797,24981,24981,8987,24994,24981,25000,24797,8987,25006,25013,9268,8987,24909,24896,24896,24797,8987,24906,25013,25044,25030,24797,25138,8392,25036,24788,24788,24788,24864,24797,24860,24923,24797,10656,10656,10656,10656,10656,25078,25078,25078,25078,25078,25078,25078,25078,24857,10656,10656,25100,24797,24857,24864,25100,24864,25100,24797,25131,25127,8392,25040,24797,24787,25138,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,24869,25252,24869,25142,25142,25167,25167,24797,25006,24869,24788,25138,24864,25030,25030,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,24891,24869,24797,24797,8392,24869,8987,24791,25252,24797,25134,25134,24869,24869,24860,25078,25078,25078,25078,10656,10656,24852,10656,10656,24864,25044,25044,25044,24857,9268,8987,25013,25006,25006,25000,25000,24994,24981,24797,24797,24927,24869,25170,25170,25170,25170,25170,25170,24869,24869,25100,24797,24797,24797,24797,24797,24797,24797,24860,25142,25142,24791,24791,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,8392,24852,24852,24854,24857,24854,24857,24857,24864,24860,24860,24864,24869,24869,24869,24869,24869,24869,24869,24891,24896,24896,24896,24896,24896,24896,24896,24906,24906,24917,24909,24909,24909,24909,24917,24920,24920,24923,24923,24927,8987,24981,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,24797,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,8987,24981,24981,24981,24981,24981,24981,24981,24981,24994,24994,24994,24994,25000,25000,25006,25006,25006,25013,25013,25025,9268,9268,9268,9268,9268,25028,25025,25025,25030,25028,25037,25030,25030,25040,25040,25044,25044,25044,25044,10656,10656,10656,10656,10656,10656,10656,10656,10656,10656,10656,10656,25078,25078,25078,25078,25078,25078,25078,25078,25078,25078,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25121,25124,25127,25124,25124,25127,25127,25131,25131,25134,25138,24864,25142,25142,25142,25142,25142,25167,25170,24869,25170,25170,25170,25170,25170,25170,25248,25248,25248,24788,25134,24797,24869,24797,24797,24797,24791,24797,8987,24797,24797,24797,24797,24797,24797,24797,25040,24797,24797,24891,24797,24852,24896,24854,24854,25121,24864,25142,24869,24869,24869,24869,24869,24869,24797,24797,24797,24797,24797,24797,24891,24869,24891,24906,24891,24869,24869,24896,24909,24896,24917,24896,24896,24896,24891,24896,24906,24909,24917,24909,24917,24920,24920,24923,24909,24909,24927,24920,24923,24909,24909,24927,24930,24927,24923,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24930,24981,24981,24930,24930,24930,24981,24981,24930,24930,24930,24930,24981,24981,24981,24994,24981,25100,24994,24994,24994,24994,25000,24981,25006,25000,25000,25017,25000,25006,24981,24994,25006,25006,25037,25017,25017,25006,25017,25017,25006,25017,25013,25025,25017,25025,25025,25017,25030,25030,25000,25000,25006,25013,25030,25030,25030,25013,25028,25030,25037,25040,25040,25044,25044,25078,25040,25044,25044,25044,25044,25040,25036,25044,25053,25053,25100,24981,24896,24869,24869,24860,24860,24854,24791,25053,25053,25044,25053,25053,25053,25053,25053,25053,25053,25053,25053,25053,25053,25053,25053,25053,25053,25078,25053,25053,25053,25100,25053,25078,25078,25078,25078,25053,25053,25078,25078,25078,25078,25078,25078,25028,24923,24909,24787,24788,25037,24981,24981,24930,24906,24896,24896,24869,24797,24791,24791,25078,25078,25078,25078,25078,25078,25078,25078,25078,25078,25124,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25100,25121,25121,25121,25127,25131,25127,25124,25124,25127,25127,25131,25131,25134,25134,25138,25138,25138,25167,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25142,25167,25167,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25170,25248,25138,25252,25142,25142,25142,25170,25170,25170,25252,8392,24854,24869,25037,25037,10656,25044,25248,25248) AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (14)
)
AND
wp_term_relationships.term_taxonomy_id IN (528)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'ywgc-disabled' OR wp_posts.post_status = 'ywgc-dismissed' OR wp_posts.post_status = 'ywgc-code-not-valid'))) AND ( ( ( wpml_translations.language_code = 'de' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'e-landing-page','elementor_library','document_template' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'de'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'de'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','ae_global_templates','product','product_variation','document_template','br_notice','wpcf7_contact_form','cookielawinfo' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','ae_global_templates','product','product_variation','document_template','br_notice','wpcf7_contact_form','cookielawinfo' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.ID ASC
LIMIT 0, -1
von require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/taxonomy-product-tag.php'), wc_get_template, include('/plugins/woocommerce/templates/archive-product.php'), do_action('woocommerce_after_main_content'), WP_Hook->do_action, WP_Hook->apply_filters, shoptimizer_after_content, do_action('shoptimizer_sidebar'), WP_Hook->do_action, WP_Hook->apply_filters, shoptimizer_get_sidebar, get_sidebar, locate_template, load_template, require_once('/themes/shoptimizer/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WP_Widget_Block->widget, apply_filters('widget_block_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, WoofiltersWpf->render, WoofiltersViewWpf->renderHtml, WoofiltersViewWpf->generateFiltersHtml, WoofiltersViewWpf->setFilterExistsItems, WoofiltersWpf->getFilterExistsItems, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, CBR_Product_Restriction->product_by_country_pre_get_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
Languages: English (English )Spanish (Español )Italian (Italiano )
Timezone: Europe/Rome (GMT+02:00)
Hello!
So the error is coming from WP All Import and i can see the problem here is not really a WPML issue per sè but the fact that WP All import seems to be either doing a wrong Database query or they need to update something in its query.
However, can you please check with the WP All Import authors to see if they are aware of a similar issue, so they can at least try to understand exactly why is this error happening (they've probably had this issue in the past and it's very likely they'll understand why it would happen)?
I'm saying this because the error comes from a wrong syntax and the queries are written in the WP All Import Plugin, which then we use wih our plugin, but you also mentioned that you don't really see any problem in the site, which means could suggest the problem was a temporary one which was then fixed by the plugin on another try.
You can let us know afterwards so we can try to understand what we can do about it.
Languages: English (English )Spanish (Español )Italian (Italiano )
Timezone: Europe/Rome (GMT+02:00)
Alright!
This ticket will be open for another 14 days. to renew this automatic closing time, you can write before those 14 days are up and they will be renewed.
Please let me know what the WP All Import team. we're here to help when needed.
Regards.
The topic ‘[Closed] Error in debug log’ is closed to new replies.
