error when looking at customers list

Phoca Cart - complex e-commerce extension
andraspal
Phoca Member
Phoca Member
Posts: 17
Joined: 16 May 2018, 19:46

error when looking at customers list

Post by andraspal » 24 May 2019, 11:40

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?

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 7073
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: error when looking at customers list

Post by Benno » 24 May 2019, 12:09

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

Kind regards,
Benno

andraspal
Phoca Member
Phoca Member
Posts: 17
Joined: 16 May 2018, 19:46

Re: error when looking at customers list

Post by andraspal » 24 May 2019, 12:27

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
Phoca Member
Phoca Member
Posts: 17
Joined: 16 May 2018, 19:46

Re: error when looking at customers list

Post by andraspal » 24 May 2019, 13:24

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.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41217
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error when looking at customers list

Post by Jan » 24 May 2019, 17:46

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
If you find Phoca extensions useful, please support the project

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41217
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error when looking at customers list

Post by Jan » 27 May 2019, 13:34

Hi, should be OK in version 3.2.0

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

Jan
If you find Phoca extensions useful, please support the project

andraspal
Phoca Member
Phoca Member
Posts: 17
Joined: 16 May 2018, 19:46

Re: error when looking at customers list

Post by andraspal » 27 May 2019, 13:51

It is good now indeed, thank you!

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41217
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error when looking at customers list

Post by Jan » 27 May 2019, 20:34

Ok
If you find Phoca extensions useful, please support the project

Post Reply