مشکل query در News Show Pro GK5

[sasasa 10]

سلام

دوستان من News Show Pro GK5 رو روی جوملا 3 نصب کردم اما هنگامی که این ماژول رو فعال میکنم، این query را می بینم که دچار خطا است:

SQL=SELECT content.id AS iid FROM xxxxx_content AS content WHERE content.state = 1 AND content.access IN (

1,1) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-05-10 08:16:26' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-05-10 08:16:26' ) AND ( content.catid = 73 ) ORDER BY content. DESC LIMIT 0,12;

همین query رو وقتی روی دیتا بیس اجرا میکنم خطا میده که syntax error داره:

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 'DESC LIMIT 0,12' at line 1

کسی می تونه من رو راهنمایی کنه؟

تنها نکته ای که هست این است که من محتوی و مجموعه ها را از جوملا 2.5 به 3 منتقل کردم البته در سایت به درستی نمایش داده می شوند. ممکن است که این موضوع باعث خطا شده باشه؟

ممنون میشم که من رو راهنمایی کنید.

[saber 208]

شما بهتره نسخه سازگار با جوملا 3 این ماژول رو دانلود و نصبش کنید

[sasasa 10]

ممنون از پاسختون.

من قبلا این ماژول را از سایت سازنده در لینک زیر برای جوملا 3 گرفته بودم اما حالا صفحه دانلود فیلتر شده و با فیلتر شکن هم یک فایل xml نشون میده.

Download Joomla Modules

به هر حال نسخه 1.8.3 رو مجددا از سایت github به آدرس زیر گرفتم و ماژول قبلی را حذف کردم و دوباره نصب کردم و هنوز این مشکل پابرجاست:

Releases · GavickPro/News-Show-Pro-GK5 · GitHub

در بخش مدیریت وقتی ماژول را باز میکنم در تب data source هم که روی joomla articles است.یک خطا به صورت زیر می بینم. البته اگر روی هر کدام ازموارد دیگر هم باشد، خطا همچنان وجود دارد:

ata_source": "JOOMLA_CONTENT_TITLE", "source": "com_content", "tab": "Joomla_Content_Additional_Settings", "tabj3" : "NSP_DATA_SOURCE_COM_CONTENT", "sources": [ { "name": "ALL_COM_CONTENT_ARTICLES", "value": "com_content_all" }, { "name": "COM_CONTENT_ARTICLES", "value": "com_content_articles" }, { "name": "COM_CONTENT_CATEGORIES", "value": "com_content_categories" }, { "name": "COM_CONTENT_TAGS", "value": "com_content_tags" } ], "supported_options": { "sort_values": { "By date": "created", "By publish up date": "publish_up", "By publish down date": "publish_down", "By modification date": "modified", "By title": "title", "By order": "ordering", "Random order": "random", "By hits amount": "hits", "By *****g": "*****g", "By user input": "user" }, "offset": true, "news_since": true, "news_in": true, "news_featured": true, "only_featured": true, "one_article_per_category": true, "news_unauthorized": true, "time_offset": true }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "EASYBLOG_CONTENT_TITLE", "source": "com_easyblog", "tab": "Easy_Blog_Additional_Settings", "tabj3" : "NSP_DATA_SOURCE_COM_EASYBLOG", "sources": [ { "name": "ALL_COM_EASYBLOG_ARTICLES", "value": "easyblog_all" }, { "name": "COM_EASYBLOG_ARTICLES", "value": "easyblog_articles" }, { "name": "COM_EASYBLOG_CATEGORIES", "value": "easyblog_categories" }, { "name": "COM_EASYBLOG_TAGS", "value": "easyblog_tags" }, { "name": "COM_EASYBLOG_AUTHORS", "value": "easyblog_authors" } ], "supported_options": { "sort_values": { "By date": "created", "By publish up date": "publish_up", "By publish down date": "publish_down", "By modification date": "modified", "By title": "title", "By order": "ordering", "Random order": "random", "By hits amount": "hits", "By user input": "user" }, "offset": true, "news_since": true, "news_in": true, "news_featured": true, "only_featured": true, "one_article_per_category": true, "news_unauthorized": true, "time_offset": true }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "COM_HIKASHOP_TITLE", "source": "com_hikashop", "tab": "HikaShop_Additional_Settings", "tabj3" : "NSP_DATA_SOURCE_COM_HIKASHOP", "sources": [ { "name": "COM_HIKASHOP_PRODUCTS", "value": "com_hikashop_products" }, { "name": "COM_HIKASHOP_CATEGORIES", "value": "com_hikashop_categories" } ], "supported_options": { "sort_values": { "By date": "created", "By title": "title", "By order": "ordering", "Random order": "random", "By hits amount": "hits", "By user input": "user" }, "offset": true, "news_since": true, "news_in": true, "news_featured": false, "only_featured": false, "one_article_per_category": false, "news_unauthorized": false, "time_offset": true }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "K2_CONTENT_TITLE", "source": "com_k2", "tab": "K2_Additional_Settings", "tabj3": "NSP_DATA_SOURCE_COM_K2", "sources": [ { "name": "ALL_COM_K2_ARTICLES", "value": "k2_all" }, { "name": "COM_K2_ARTICLES", "value": "k2_articles" }, { "name": "COM_K2_CATEGORIES", "value": "k2_categories" }, { "name": "COM_K2_TAGS", "value": "k2_tags" }, { "name": "COM_K2_AUTHORS", "value": "k2_authors" } ], "supported_options": { "sort_values": { "By date": "created", "By publish up date": "publish_up", "By publish down date": "publish_down", "By modification date": "modified", "By title": "title", "By order": "ordering", "Random order": "random", "By hits amount": "hits", "By *****g": "*****g", "By user input": "user" }, "offset": true, "news_since": true, "news_in": true, "news_featured": true, "only_featured": true, "one_article_per_category": true, "news_unauthorized": true, "time_offset": true }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "COM_VIRTUEMART_TITLE", "source": "com_virtuemart", "tab": "NSP_DATA_SOURCE_COM_VIRTUEMART", "tabj3": "NSP_DATA_SOURCE_COM_VIRTUEMART", "sources": [ { "name": "COM_VIRTUEMART_PRODUCTS", "value": "com_virtuemart_products" }, { "name": "COM_VIRTUEMART_CATEGORIES", "value": "com_virtuemart_categories" } ], "supported_options": { "sort_values": { "By date": "created", "By title": "title", "By order": "ordering", "Random order": "random", "By hits amount": "hits", "By user input": "user" }, "offset": true, "news_since": true, "news_in": true, "news_featured": true, "only_featured": true, "one_article_per_category": false, "news_unauthorized": true, "time_offset": true }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "JOMSOCIAL_TITLE", "source": "jomsocial", "tab": "NSP_DATA_SOURCE_JOMSOCIAL-options", "tabj3" : "NSP_DATA_SOURCE_COM_EASYBLOG", "sources": [ { "name": "JOMSOCIAL_LATEST_STATUS", "value": "jomsocial_latest_status" }, { "name": "JOMSOCIAL_LATEST_PHOTO", "value": "jomsocial_latest_photo" }, { "name": "JOMSOCIAL_USER_STATUS", "value": "jomsocial_user_status" }, { "name": "JOMSOCIAL_USER_PHOTO", "value": "jomsocial_user_photo" } ], "supported_options": { "sort_values": { "By date": "created", "By title": "title", "Random order": "random" }, "offset": true, "news_since": true, "news_in": false, "news_featured": false, "only_featured": false, "one_article_per_category": false, "news_unauthorized": false, "time_offset": true }, "supported_elements": { "header": false, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "JSON_TITLE", "source": "json_file", "tab": false, "sources": [ { "name": "JSON_FILE", "value": "json_file" } ], "supported_options": { "sort_values": false, "offset": true, "news_since": false, "news_in": false, "news_featured": false, "only_featured": false, "one_article_per_category": false, "news_unauthorized": false, "time_offset": true }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "RSS_TITLE", "source": "rss", "tab": "RSS_Additional_Settings", "tabj3": "NSP_DATA_SOURCE_RSS", "sources": [ { "name": "RSS_FEED", "value": "rss_feed" } ], "supported_options": { "sort_values": false, "offset": true, "news_since": false, "news_in": false, "news_featured": false, "only_featured": false, "one_article_per_category": false, "news_unauthorized": false, "time_offset": false }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

{ "data_source": "XML_TITLE", "source": "xml_file", "tab": false, "sources": [ { "name": "XML_FILE", "value": "xml_file" } ], "supported_options": { "sort_values": false, "offset": true, "news_since": false, "news_in": false, "news_featured": false, "only_featured": false, "one_article_per_category": false, "news_unauthorized": false, "time_offset": true }, "supported_elements": { "header": true, "image": true, "text": true, "readmore": true, "info": true, "info2": true } }

Source of articles