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?

Tags:

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 7106
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: 41483
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: 41483
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: 41483
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

mi3oo
Phoca Member
Phoca Member
Posts: 11
Joined: 13 Jul 2019, 13:40

Re: error when looking at customers list

Post by mi3oo » 15 Jul 2019, 14:12

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'

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

Re: error when looking at customers list

Post by Jan » 16 Jul 2019, 13:48

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

Post Reply