CRAZY Halloween Deal: 45% OFF for All Products & Subscriptions
0
Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
You are here: HomeForum

We are here to serve :)

Our support team is currently online to solve your issues.

Our support team is currently offline

Our support heroes might not be around this hour. Please expect some delays.

Our support is available from

Monday - Friday 8am - 5:30pm GMT+7

Your time: 00:00:00
Our time: 00:00:00

Welcome, Guest
  • Page:
  • 1

TOPIC: Problem with the modulus.

Problem with the modulus. 4 years, 7 months 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: 4 years, 7 months ago by temes.
  • Page:
  • 1
Time to create page: 0.34 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.

Suggested Posts

(/)
Result not found!

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
Magento Themes Magento Extensions Free Magento Extensions Prestashop Themes Prestashop Modules Magento 2 Themes

H A L L O W E E N S A L E!

45% OFF

Everything at SmartAddons

Code: SPOOKY19