Deleted all countries and now I cannot delete old customers

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?

US and USA

What is the address format?

Address format is 2.

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?

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

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?

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.

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.

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.

Ok, let me try to re explain this..At first I wanted to delete all of my customers but before your reply I had created 2 new test customers. Then I had read your reply and followed your directions, which allowed me to access and delete all accounts besides the 2 new test customers that I had created. So I am left with only 2 customers and they are just test customers. I just need to delete the 2 test customers and I will be back to 0 customers and all will be well. Im sorry for the confusion it is just hard for me to explain this.

I just entered "truncate table customers;" into Install SQL patches and hit send and now im done.

Sure, and now you have orphaned address book records in the address_book table, and orphaned customer_info in the customer_info tables, meaning that when you go to create new customers, you run the risk of getting things royally mucked up.
You'll need to truncate those 2 tables as well. And, if you had any group-discounts connected to them, you'll need to truncate that table, too.