Deleted countries are still showing!

Hi folks,

I am a new zenner and know almost nothing about php, I am having a headache on my database connection:

My domain is: xiexianhui.com

I have a site /imex

This site should talk to DB: _imex

I double checked the configuration.php under \imex\includes, it is talking to DB _imex

The problem is in _imex I deleted most countries, I keep only USA and CANADA, I also removed all the other zones and keep only USA states and CANADA provinces. However in imex admin, I still see the complete country list and zone list.

It would be greatly appreciated if anyone can help me sort this out.

Thank you in advance.

HOW did you remove these countries names?

schoolboy:

HOW did you remove these countries names?

I go to phpMyAdmin in cPanel, and go to the database which was indicated being used in configuration.php in \includes

I open the table country and remove all but 2 countries (USA and CANADA).

I go back to zen cart admin page and go to the menu Locations and Taxes, I open countries, surprisingly there are still 238 countries there but in database there are only 2.

Where am I missing?

Thank you very much.

BTW: I am using a customized template, I don't think that is causing problem but who knows?

I go to phpMyAdmin in cPanel, and go to the database which was indicated being used in configuration.php in \includes

I open the table country and remove all but 2 countries (USA and CANADA).

NEVER delete things directly from the database unless instructed to. There is an admin interface to change and edit the countries - Use it.

Kim:

NEVER delete things directly from the database unless instructed to. There is an admin interface to change and edit the countries - Use it.

Why can't delete things directly from DB? It would be very silly if I have to delete the 238 countries one by one manually from Admin interface, right?

... and what happened when you did it your way?

The database contains relational information - meaning things in one table will relate to things in another table - using the admin gets all the parts and pieces correctly.

Kim:

... and what happened when you did it your way?

The database contains relational information - meaning things in one table will relate to things in another table - using the admin gets all the parts and pieces correctly.

So you either never touch the countries or clean it one by one for the 238 records? I can't believe it.

Just build a Zone Definition and in the DETAILS add the United States and Canada ...

Then edit your payment and/or shipping modules and add your Zone to them and now only people from those zones can Pay and/or ship ...

NOTE: the fact that you cleaned the countries from a database and you still see them in your Admin means you removed them from the wrong database or your Admin is looking at one database and your Catalog is looking at another database ...

Check the two files, on the server, for:
/includes/configure.php
/your_secret_admin/includes/configure.php

and ensure that both are using the same database information ...

Ajeh:

NOTE: the fact that you cleaned the countries from a database and you still see them in your Admin means you removed them from the wrong database or your Admin is looking at one database and your Catalog is looking at another database ...

Check the two files, on the server, for:
/includes/configure.php
/your_secret_admin/includes/configure.php

and ensure that both are using the same database information ...

Thank you very much. You are absolutely right, I didn't know that there is another place I need to change in /your_secret_admin/includes/configure.php

:clap::clap::clap::clap:

You are most welcome ... thanks for the update that this was the cause of the problem ... :smile:

I nuked the countries from the databases on both my sites. It worked perfectly.

I nuked the countries from the databases on both my sites. It worked perfectly.For now, anyway. Anytime you mess with a database without knowing the full relational setup of the tables, you are a lawyer representing yourself.

dbltoe:

For now, anyway. Anytime you mess with a database without knowing the full relational setup of the tables, you are a lawyer representing yourself.

Well, it's been 2 1/2 years on one site and a year on the other, through many changes, updates, and configurations. I think if any issues were going to surface they would have done so by now.