Deleted all countries and now I cannot delete old customers

[whatisthat456]

I went through and deleted all the countries one by one and forgot to skip over USA and now I cant remember what should be in the spots for ISO codes 2 and 3 and address format?

[stevesh]

US and USA

[whatisthat456]

What is the address format?

[stevesh]

Address format is 2.

[whatisthat456]

Thanks so much. Now I have a problem that since I just deleted all the other countries my customers that were from outside the USA I cant seem to delete them from my customers page in admin?

[whatisthat456]

I had received a international order and then noticed I had all the countries still active. So i deleted all the countries except USA and now I go into the admin/customers and cannot delete the any customers and this shows whenever I click on of the customers.

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/****/public_html/admin/customers.php on line 1099

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/****/public_html/admin/customers.php on line 1101

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/****/public_html/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/****/public_html/admin/includes/classes/object_info.php on line 30

[whatisthat456]

The warning are shown for all previous customers but I have created a new test customer and the warning are not displayed for it. I just need to delete all my old customers manually if there is a way?

[DrByte]

By deleting the country record, you've actually broken EVERY customer who has that country set in their address books.
Merely adding the country back again DOES NOT fix the problem, because your new record gets a new record number, which doesn't match the numbers stored internally in all the address books.
It would be a good lesson to have you restore your countries database table, putting things back in their good functional state. But, by the sound of your posts that's way beyond your level of knowledge with databases. I recommend you start making regular database backups, as a start.

In the interim, the following might work, assuming you *have* added back a country record for USA. This overrides the internal tracking managed by the database, and should relink the customer addresses to the broken USA record you added:
1. Go to Admin->Tools->Install SQL Patch
2. Copy-and-paste the following into the big text field, and click Send.

update countries set countries_id=223 where countries_iso_code_3 = 'USA';

3. Go to your customers page and check whether your US customers can be accessed properly.

[whatisthat456]

I did what you said to do in your post and that allowed me to access the old accounts. But now the accounts that I had created after deleting all the countrys are now showing the warnings. How can I simply delete the 2 accounts as they are just test accounts I made to try to figure out if the warnings would show on new accounts.

[DrByte]

I'm confused. First, you said you wanted to delete 2 customers. Then you said you wanted to delete all your customers. Then you said you wanted to delete all your old customers. And now you're saying you just want to delete 2 test accounts.