Page 1 of 2

error when looking at customers list

Posted: 24 May 2019, 11:40
by 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?

Re: error when looking at customers list

Posted: 24 May 2019, 12:09
by Benno
Hi,
which Joomla! version do you use?
which Phoca Cart version do you use?
which PHP version do you use?

Kind regards,
Benno

Re: error when looking at customers list

Posted: 24 May 2019, 12:27
by 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

Re: error when looking at customers list

Posted: 24 May 2019, 13:24
by 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.

Re: error when looking at customers list

Posted: 24 May 2019, 17:46
by 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

Re: error when looking at customers list

Posted: 27 May 2019, 13:34
by Jan
Hi, should be OK in version 3.2.0

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

Jan

Re: error when looking at customers list

Posted: 27 May 2019, 13:51
by andraspal
It is good now indeed, thank you!

Re: error when looking at customers list

Posted: 27 May 2019, 20:34
by Jan
Ok

Re: error when looking at customers list

Posted: 15 Jul 2019, 14:12
by 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'

Re: error when looking at customers list

Posted: 16 Jul 2019, 13:48
by 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