Phoca Forum

Hi!
I was parsing VM products to Phoca Cart. And I have some issue in admin panel - products list.
When I upload 12k products - system has work success. But when I added 20k products - page products list is very long opened.
So I look explain DB queries and finded very strange query (look screenshot: https://yadi.sk/i/1x-GVLIu3R5dLL).

I can send login and pass to admin panel (if needed).

Hi, I don't see anything strange on that screenshot, I see there one error when the database was not selected. What you exactly mean with the strange query?

Jan

1. Time to load page list products
2. Many GROUP BY (I think - this is strange)
+ check email - I send admin access to test Joomla + Phoca with 20k items (look time to load page with product list)

Hi, I have answered your email.

2) In Joomla! 4, the SQL strict rules are used, so all "group by" must by full (long) - ONLY_FULL_GROUP_BY
See:
https://github.com/joomla/joomla-cms/pull/12494

Jan