Phoca Forum

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?

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

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

After your test update it is perfectly working.

Thank you so much.

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.

Hi, great, thank you very much.

Jan