Unable to delete customer

[plc613]

ah! I see. Didn't know that(just updated from 1.5.0) thx!

So there's this:
[22-Apr-2014 13:13:03 America/New_York] PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in /public_html/includes/functions/functions_lookups.php on line 928

which I assume needs fixing but isn't related to this topic. And this:
[22-Apr-2014 15:29:57 UTC] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #1 is not an array in public_html/HIDDEN/customers.php on line 1106
[22-Apr-2014 15:29:57 UTC] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #2 is not an array in public_html/HIDDEN/customers.php on line 1108
[22-Apr-2014 15:29:57 UTC] PHP Warning: reset() expects parameter 1 to be array, null given in public_html/HIDDEN/includes/classes/object_info.php on line 29
[22-Apr-2014 15:29:57 UTC] PHP Warning: Variable passed to each() is not an array or object in public_html/HIDDEN/includes/classes/object_info.php on line 30

Odd. Because it did reflect the time around which I first tried deleting the customer earlier today but I just tried again and it didn't create an entry at all...

[plc613]

Now I'm actually getting a bit concerned with this...

In the admin activity log, there was an email address. I did some digging and came up with this:

http://www.xjbz.gov.cn/cxfz/viewyjjy.asp?id=762

The number listed in that box(88952634) is the number that was used for the First Name and company fields.

[DrByte]

So what exactly is the concern now?

[plc613]

Primarily that I can't delete the customer but also that the entry links back to an Asian site. Should I suspect foul play here?

[DrByte]

Foul play? Maybe. Bots and malicious visitors are always trying things on millions of sites every day. Could be they were hoping they could create an account that would let them send spam from your tell-a-friend page. But if you're using v151 then you probably don't have a tell-a-friend page, but they might not know that.

Anyway, as lat9 has posted, your inability to delete the customer is probably connected to having missing country/zone details for whatever country/zone they specified. That could be a result of having deleted countries/states/zones from your database after they created that account. Whatever the cause, you can manually delete it from the database by finding the customers_id from the customers table, and then deleting that customer's record from every other table in the database (and there are lots) where that customers_id is in the table. Some tables may have multiple entries. customers_id will be in tables related to customers, addresses, orders, coupons, emails, discounts, and more: www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema

[plc613]

That could be a result of having deleted countries/states/zones from your database after they created that account.

Certainly not that I recall. There are currently 13 pages of countries & 10 pages of zones.

[lat9]

It's actually the customer's address_book entry that's got the invalid/unknown country ID. Go to your webhost's cPanel and bring up phpMyAdmin.

1. Click on the address_book table's link on the lefthand side of the display.
2. Click the Search button and enter the id of this rogue customer as the customers_id Value and click Go.
3. When the customer's address_book record is displayed, write down what the values for entry_country_id and entry_zone_id are and post them back here.

[lat9]

ah! I see. Didn't know that(just updated from 1.5.0) thx!

So there's this:
[22-Apr-2014 13:13:03 America/New_York] PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in /public_html/includes/functions/functions_lookups.php on line 928

which I assume needs fixing but isn't related to this topic.

Agreed.

And this:
[22-Apr-2014 15:29:57 UTC] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #1 is not an array in public_html/HIDDEN/customers.php on line 1106
[22-Apr-2014 15:29:57 UTC] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #2 is not an array in public_html/HIDDEN/customers.php on line 1108
[22-Apr-2014 15:29:57 UTC] PHP Warning: reset() expects parameter 1 to be array, null given in public_html/HIDDEN/includes/classes/object_info.php on line 29
[22-Apr-2014 15:29:57 UTC] PHP Warning: Variable passed to each() is not an array or object in public_html/HIDDEN/includes/classes/object_info.php on line 30

Odd. Because it did reflect the time around which I first tried deleting the customer earlier today but I just tried again and it didn't create an entry at all...

As with most code-related problems that result in multiple errors/warnings being issued, the first item usually cascades into a slew of related issues. That's the case here.

The first warning indicates that, for some reason, there is no valid country reference found for the customer's record. The code, in customers.php, starting at line 1099 is, with the italicized line being 1106:

        $country = $db->Execute("select countries_name
                                 from " . TABLE_COUNTRIES . "
                                 where countries_id = '" . (int)$customers->fields['entry_country_id'] . "'");

        $reviews = $db->Execute("select count(*) as number_of_reviews
                                 from " . TABLE_REVIEWS . " where customers_id = '" . (int)$customers->fields['customers_id'] . "'");

        $customer_info = array_merge($country->fields, $info->fields, $reviews->fields);

Are you familiar with phpMyAdmin usage? If so, it would be interesting to see what's in the customers table for this person.

What database collation (latin1 vs utf8) are you using? It could be as simple as a customer from China attempting to create a valid account on your site but having issues (as you are now) since there's a character-set mismatch somewhere in your configuration.

[plc613]

Agreed.

As with most code-related problems that result in multiple errors/warnings being issued, the first item usually cascades into a slew of related issues. That's the case here.

Are you familiar with phpMyAdmin usage? If so, it would be interesting to see what's in the customers table for this person.

Somewhat. monkey see monkey do ;)

What database collation (latin1 vs utf8) are you using? It could be as simple as a customer from China attempting to create a valid account on your site but having issues (as you are now) since there's a character-set mismatch somewhere in your configuration.

There appears to be a mixture of latin1 and utf8. Is that fixable? I should prob. mention that prior to GeekHost I was on a shared server. So although I did not opt to using their "apps collection" to install ZC I may have been subjected to non-standard stuff. Upgrading to 1.5.1 was a breeze once I moved so at least my files are standards compliant(I use the Piccadilly Posh template)

[plc613]

Not certain this is what you're referring to or not:
6 m 88952634 88952634 0001-01-01 00:00:00 safe3q###################### 6 88952634 88952634 91d3baf3026eeed25f7fd5c0eaa00914:90 1 0 HTML 0 0