درخواست راهنمایی در مورد ارور

beh-kharid

تازه وارد
با سلام

مدتی هست که ارور لاگ ارور زیر را نشون میده

ممنون می شم اگه راهنمایی بفرمایید که این ارور چیه و چطور میشه درستش کرد.

کد:
[03-May-2015 11:47:34 UTC] خطای 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 'DES, wp_posts.post_date DESC LIMIT 0, 16' at line 8 در پایگاه‌داده وردپرس برای دستور SELECT SQL_CALC_FOUND_ROWS wp_posts.*, AVG( wp_commentmeta.meta_value ) as average_rating, SUM( wp_comments.comment_approved ) as sum_of_comments_approved FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )LEFT OUTER JOIN wp_comments ON(wp_posts.ID = wp_comments.comment_post_ID)LEFT JOIN wp_commentmeta ON(wp_comments.comment_ID = wp_commentmeta.comment_id)WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (34)) AND ( ( wp_postmeta.meta_key = '_visibility' AND CAST(wp_postmeta.meta_value AS CHAR) IN ('visible','catalog') )) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') AND ( wp_commentmeta.meta_key = 'rating' OR wp_commentmeta.meta_key IS null ) GROUP BY wp_posts.ID ORDER BY sum_of_comments_approved DESC, average_rating DES, wp_posts.post_date DESC LIMIT 0, 16 ساخته شده توسط require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts[03-May-2015 11:48:07 UTC] خطای 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 'DES, wp_posts.post_date DESC LIMIT 0, 32' at line 8 در پایگاه‌داده وردپرس برای دستور SELECT SQL_CALC_FOUND_ROWS wp_posts.*, AVG( wp_commentmeta.meta_value ) as average_rating, SUM( wp_comments.comment_approved ) as sum_of_comments_approved FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )LEFT OUTER JOIN wp_comments ON(wp_posts.ID = wp_comments.comment_post_ID)LEFT JOIN wp_commentmeta ON(wp_comments.comment_ID = wp_commentmeta.comment_id)WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (34)) AND ( ( wp_postmeta.meta_key = '_visibility' AND CAST(wp_postmeta.meta_value AS CHAR) IN ('visible','catalog') )) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') AND ( wp_commentmeta.meta_key = 'rating' OR wp_commentmeta.meta_key IS null ) GROUP BY wp_posts.ID ORDER BY sum_of_comments_approved DESC, average_rating DES, wp_posts.post_date DESC LIMIT 0, 32 ساخته شده توسط require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
 
آخرین ویرایش توسط مدیر:

MohammadQ

کاربر عضو
والا دقیق نمیدونم ، حوصله ام نکشید بخونم اما اون طور که مشخص هستش ارور مربوط به MySQL هستش 

 

Mohammad

مدیر انجمن
پرسنل مدیریت
روی لوکال تست میگیرید یا هاست؟

 
بالا