Error with filters

  • Posts: 31
  • Thank you received: 0
10 years 1 month ago #208517

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.4.42
-- Error-message(debug-mod must be tuned on) -- : 1140

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT DISTINCT b.product_id,max(b.familia) as max_testfamilia_3, min(b.familia) as min_testfamilia_3 FROM nvb4t_hikashop_product_category AS a LEFT JOIN nvb4t_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (12,18,19,2) AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY a.ordering ASC

Hello, I´m trying to use filters in the site and when I turn on the module the page have an error. Could you help me. Regards,

Leo.

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13673
  • MODERATOR
10 years 1 month ago #208522

Hi,

Can you provide a screenshot of the options of that filter and of the testfamilia custom field settings so that we can see how you set them up ?

Please Log in or Create an account to join the conversation.

  • Posts: 31
  • Thank you received: 0
10 years 1 month ago #208627

Hi, see attached. Regards, Leo.

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13673
  • MODERATOR
10 years 1 month ago #208634

Hi,

There are no attachments to your message.

Please Log in or Create an account to join the conversation.

  • Posts: 31
  • Thank you received: 0
10 years 1 month ago #208696

See the attachment. Regards. Leo.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 31
  • Thank you received: 0
10 years 1 month ago #208740

We need your help as soon as possible because We need to launch next week.
When we activate the filters this error is showing:

1140
MIXING OF GROUP COLUMNS (MIN(),MAX(),COUNT(),...) WITH NO GROUP COLUMNS IS ILLEGAL IF THERE IS NO GROUP BY CLAUSE SQL=SELECT DISTINCT B.PRODUCT_ID,MAX(B.VEHICULO) AS MAX_TESTFAMILIA_3, MIN(B.VEHICULO) AS MIN_TESTFAMILIA_3 FROM NVB4T_HIKASHOP_PRODUCT_CATEGORY AS A LEFT JOIN NVB4T_HIKASHOP_PRODUCT AS B ON A.PRODUCT_ID=B.PRODUCT_ID WHERE B.PRODUCT_PUBLISHED=1 AND B.PRODUCT_TYPE = 'MAIN' AND A.CATEGORY_ID IN (12,18,19,2) AND (B.PRODUCT_ACCESS = 'ALL' OR B.PRODUCT_ACCESS LIKE '%,2,%') ORDER BY A.ORDERING ASC

Regards. Leo.

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13673
  • MODERATOR
10 years 1 month ago #208843

Hi,

You didn't provide a screenshot of the custom field settings.
Could you provide a backend access to your website with a link to the products listing page via our contact form:
www.hikashop.com/support/contact-us.html
It will be easier and faster to answer you.

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13673
  • MODERATOR
10 years 4 weeks ago #208858

Hi,

I tried the exact same queries that fail on your website on my website and they work just fine. So there seems to be an issue with the configuration of the server.
After searching for a while, I came by the ONLY_FULL_GROUP_BY mode of MySQL which could be problematic if activated.
Can you make sure that this mode is deactivated in your MySQL (you might need to contact your system administrator or hosting company).
Actually, searchgin again, I stumbled on this:
nickbartlett.com/mixing-of-group-columns...-no-group-by-clause/
And apparently that would be an issue of your MySQL version.
I would like to remember you that the minimum version requirement for MySQL for Joomla 3.x is 5.1 and looking on your website, you're running MySQL 5.0 which theoretically is not supported anymore.
Updating your MySQL might be enough to fix that issue. Again, that might be something for which you would need to contact your hosting company.

The following user(s) said Thank You: marketingfocal

Please Log in or Create an account to join the conversation.

  • Posts: 31
  • Thank you received: 0
10 years 4 weeks ago #209120

Everything works fine.

I created a new filter and now the "vehicle" field appears. (the problem was editing an old filter).

How do I create a link that includes a filter element to a custom field? Ex. I have a "vehicle" model "brand" and need the link to display all items custom field "vehicle" model "brand".

Regards, Leo.

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13673
  • MODERATOR
10 years 4 weeks ago #209122

Hi,

Turn on the "redirect POST mode" setting of the Hikashop configuration.
You'll then see the parameters directly in the URL and you'll be able to change them directly in the URL and copy/paste the search URLs where you want to use them.

Please Log in or Create an account to join the conversation.

Time to create page: 0.097 seconds
Powered by Kunena Forum