error when looking at customers list

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

error when looking at customers list

Post 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?

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

Re: error when looking at customers list

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

Re: error when looking at customers list

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

Re: error when looking at customers list

Post 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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error when looking at customers list

Post 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
If you find Phoca extensions useful, please support the project
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error when looking at customers list

Post by Jan »

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: 32
Joined: 16 May 2018, 19:46

Re: error when looking at customers list

Post by andraspal »

It is good now indeed, thank you!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error when looking at customers list

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
mi3oo
Phoca Member
Phoca Member
Posts: 21
Joined: 13 Jul 2019, 13:40

Re: error when looking at customers list

Post 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'
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error when looking at customers list

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