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!
Try looking into the daatabe directly in phpmyadmin by running the query:
and it should return you the id of that unapproved customer.
Code: Select all
Select customer_id from oc_customer where approved='0';
Thanks, tried it, but there seems to be nothing in the database that matches it:florinsith wrote:Try looking into the daatabe directly in phpmyadmin by running the query:and it should return you the id of that unapproved customer.Code: Select all
Select customer_id from oc_customer where approved='0';
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0011 sec)
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
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Looks like disabled customers are also taken into account. I looked at the method used to display customers awaiting approval and it is:
So as you can see it checks the status also.
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'];
}
Who is online
Users browsing this forum: No registered users and 115 guests