Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
You are here: HomeForum
Welcome, Guest
  • Page:
  • 1

TOPIC: Problem with the modulus.

Problem with the modulus. 9 years ago #23054

So the problem is ... When you connect the module displays the following:

UNKNOWN COLUMN 'A' IN 'WHERE CLAUSE' SQL=SELECT A.*, EXISTS (SELECT TRUE FROM AX89W_ZOO_CATEGORY_ITEM WHERE ITEM_ID=A.ID AND CATEGORY_ID=0) AS FRONTPAGE FROM AX89W_ZOO_ITEM AS A LEFT JOIN AX89W_ZOO_CATEGORY_ITEM AS B ON A.ID = B.ITEM_ID WHERE A.APPLICATION_ID = 2 AND A AND A.STATE = 1 AND (A.PUBLISH_UP = '0000-00-00 00:00:00' OR A.PUBLISH_UP <= '2015-03-03 07:45:06') AND (A.PUBLISH_DOWN = '0000-00-00 00:00:00' OR A.PUBLISH_DOWN >= '2015-03-03 07:45:06') AND B.CATEGORY_ID IN (53) GROUP BY A.ID HAVING FRONTPAGE=1 ORDER BY A.PRIORITY ASC LIMIT 0,5

This problem is available on the home page: chsail.ru
on other pages of the module works: chsail.ru/yaht-kluby-2.html
Last Edit: 9 years ago by temes.
  • Page:
  • 1
Time to create page: 0.22 seconds

Notification

Please find your issue via Suggested Posts before submitting your question. We have solved the most of issues and maybe your issue was solved before.

Latest My Topics

No posts to display.

Love all our templates?

Join our membership clubs starting at $49 only for access to all of our templates

Join Now
Home Pricing
Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
SearchSupport
Magento Themes Magento Extensions Free Magento Extensions Prestashop Themes Prestashop Modules Magento 2 Themes