Post by wafflemeister » Sun Aug 09, 2015 4:48 am

I am a bit clueless, but I have this one customer that out of nowhere showed up as requiring approval. When I look into my customers and filter for customers who have No Approval, nothing shows up. I never required customers to have to acquire approval for their account.
The only thing I can think of is a customer that I just disabled yesterday. I tried to enabled them again bit that did not solve the situation.
Any suggestions would be greatly appreciated.
Thank you!

New member

Posts

Joined
Fri Jun 21, 2013 11:10 pm

Post by florinsith » Mon Aug 10, 2015 3:17 pm

Try looking into the daatabe directly in phpmyadmin by running the query:

Code: Select all

Select customer_id from oc_customer where approved='0';
and it should return you the id of that unapproved customer.

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am


Post by wafflemeister » Tue Aug 11, 2015 12:57 am

florinsith wrote:Try looking into the daatabe directly in phpmyadmin by running the query:

Code: Select all

Select customer_id from oc_customer where approved='0';
and it should return you the id of that unapproved customer.
Thanks, tried it, but there seems to be nothing in the database that matches it:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0011 sec)

New member

Posts

Joined
Fri Jun 21, 2013 11:10 pm

Post by IP_CAM » Tue Aug 11, 2015 1:31 am

I had that once, with one of my v.1.5.6.x Test-Versions, and I recall, to have 'stopped - left' the registration Process, in some way, for some reason, in some 'late' stage, and possibly even by use of some not default Reg-Setup. It's too long since, already. It left an unknown user, with no real data, behind, waiting to be 'enabled'. Just to mention it.
Ernie

Please don't send me OC Forum Personal Messages, just contact: jti@jacob.ch
---
OC 1.5.6.5 LIGHT Test Site: http://www.bigmax.ch/shop/
OC 1.5.6.5 V-PRO Test Site: http://www.openshop.li/shop/
My Github OC Site: https://github.com/IP-CAM
2'800+ FREE OC Extensions on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by florinsith » Tue Aug 11, 2015 10:54 pm

Looks like disabled customers are also taken into account. I looked at the method used to display customers awaiting approval and it is:

Code: Select all

public function getTotalCustomersAwaitingApproval() {
		$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer WHERE status = '0' OR approved = '0'");

		return $query->row['total'];
	}
So as you can see it checks the status also.

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am


Post by wafflemeister » Tue Aug 25, 2015 1:39 am

Thank you!

New member

Posts

Joined
Fri Jun 21, 2013 11:10 pm
Who is online

Users browsing this forum: Jeens and 25 guests