Problem with categories and product associations

[Jfruiz]

When I try to create an association from a category or a product I get a popup windows with message:

1064 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 'AND `a`.`language` IN ('*','en-GB') ORDER BY a.ordering' at line 1

That window could not be closed.

System info:
Database Type mysql
Database Version 5.5.60-0+deb7u1-log
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.15
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.9.18 Stable [ Amani ] 21-April-2020 19:30 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Is that a bug o my config problem?

[Jan]

Hi, thank you for the info, it seems that there were some changes regarding associations in core. This will be fixed in version 3.5.2.

Jan

[Jan]

Try to test this development version:
https://github.com/PhocaCz/PhocaCart/re ... v3.5.2.zip

It should be OK now.

Please let me know.

Jan

[Jfruiz]

After your test update it is perfectly working.

Thank you so much.

[Jfruiz]

Your support is fast and responsive.
I have made a small donation (paypal sender bot_____@gmail.com) and comment in Joomla Extension directory
Thanks again.

*Sent here because at the moment I'm not able to use private messages.

[Jan]

Hi, great, thank you very much.

Jan