Sql Error. Check the manual that corresponds to your MariaDB server

  • any suggestions for help?
    THANK YOU!

    [14-May-2021 07:50:17 UTC] Σφ?λμα You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
) AND wpfj_posts.post_type = 'property' AND (wpfj_posts.post_status = 'publ...' at line 4 β?ση? δεδομ?νων WordPress για α?τηση SELECT SQL_CALC_FOUND_ROWS  wpfj_posts.ID FROM wpfj_posts  LEFT JOIN wpfj_term_relationships ON (wpfj_posts.ID = wpfj_term_relationships.object_id) JOIN wpfj_icl_translations wpml_translations
    							ON wpfj_posts.ID = wpml_translations.element_id
								AND wpml_translations.element_type = CONCAT('post_', wpfj_posts.post_type)  WHERE 1=1  AND wpfj_posts.ID NOT IN (5510) AND wpfj_posts.post_parent NOT IN (5510) AND ( 
  wpfj_term_relationships.term_taxonomy_id IN ()
) AND wpfj_posts.post_type = 'property' AND (wpfj_posts.post_status = 'publish') AND ( ( ( wpml_translations.language_code = 'el' OR (
					wpml_translations.language_code = 'el'
					AND wpfj_posts.post_type IN ( 'e-landing-page','elementor_library' )
					AND ( ( 
			( SELECT COUNT(element_id)
			  FROM wpfj_icl_translations
			  WHERE trid = wpml_translations.trid
			  AND language_code = 'el'
			) = 0
			 ) OR ( 
			( SELECT COUNT(element_id)
				FROM wpfj_icl_translations t2
				JOIN wpfj_posts p ON p.id = t2.element_id
				WHERE t2.trid = wpml_translations.trid
				AND t2.language_code = 'el'
				AND (
					p.post_status = 'publish' OR 
					p.post_type='attachment' AND p.post_status = 'inherit'
				)
			) = 0 ) ) 
				) ) AND wpfj_posts.post_type  IN ('post','page','attachment','wp_block','e-landing-page','elementor_library','property','agent','partners','slide','faq' )  ) OR wpfj_posts.post_type  NOT  IN ('post','page','attachment','wp_block','e-landing-page','elementor_library','property','agent','partners','slide','faq' )  ) GROUP BY wpfj_posts.ID ORDER BY RAND() LIMIT 0, 2 απ? require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/realhomes/single-property.php'), get_template_part, locate_template, load_template, require('/themes/realhomes/assets/modern/partials/property/single.php'), get_template_part, locate_template, load_template, require('/themes/realhomes/assets/modern/partials/property/single/similar-properties.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
Viewing 3 replies - 1 through 3 (of 3 total)

  • The SQL is invalid bc you have no value in your IN requirement, here :

    wpfj_term_relationships.term_taxonomy_id IN ()

    afaik, it would need to be:
    wpfj_term_relationships.term_taxonomy_id IN ('expected-value-here')

    Thread Starter TaitO

    (@taito)

    how i know what value must fill?
    i know how to use phpmyadmin but i dont understand sql like programmer….

    > how i know what value must fill?

    I don’t know what you are trying to accomplish. Or even what file this is in, etc.

    You’ll need to provide more detail.

    The SQL is failing bc you don’t have a parameter in the IN(), but again, I don’t know what you’re trying to do.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Sql Error. Check the manual that corresponds to your MariaDB server’ is closed to new replies.