error when looking at customers list

[andraspal]

This is what I see when trying to open the list of customers.

500 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.type = 0 OR a.type IS NULL) GROUP BY a.id ORDER BY u.name asc LIMIT 5' at line 9 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.type = 0 OR a.type IS NULL) GROUP BY a.id ORDER BY u.name asc' at line 9

What could be the solution?

[Benno]

Hi,
which Joomla! version do you use?
which Phoca Cart version do you use?
which PHP version do you use?

Kind regards,
Benno

[andraspal]

Joomla 3.9.6
Phoca Cart: 3.1.9
PHP: 7.0.33 (I am soon (in a minute or so)switching to 7.1) although it was working before.

Thanx
Andras

[andraspal]

Ok, I kinda see whats happening though no solution.

For some unknown reason it started working. Then I again typed in a name in the customers search box, and voila, it happened again!
So when I use the search field in customers list that when the whole list disappears and I get the error message. I wonder what fixed it for a while(until I searched again)

Edit: logging out and back in fixed it.

[Jan]

Hi, thank you for the info, confirmed, it is associated with search, there is a typo error. Will be fixed in version 3.2.0 Stable.

Jan

[Jan]

Hi, should be OK in version 3.2.0

https://www.phoca.cz/news/1034-phoca-ca ... 0-released

Jan

[andraspal]

It is good now indeed, thank you!

[Jan]

Ok

[mi3oo]

Hi, I use the:

Joomla! 3.9.10
Phoca Cart 3.2.2
PHP Version 7.1.17

and I have this error: 500 Unknown column 'a.city' in 'field list' Unknown column 'a.city' in 'field list'

[Jan]

Hi, enable debug mode in your Joomla! global configuration and you get whole error message including all the details. Will be great to get more details to see where this problem occurs (there will be more detailed information about the database table, etc. etc.).

Jan