Zen Cart Logo
Forums / General Questions / Countries still in drop down after deletion from DB

Countries still in drop down after deletion from DB

Locked

Views: 1,219

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
28 May 2009, 7:29 PM
#1
nj2miami avatar

nj2miami

New Zenner

Join Date:
May 2009
Posts:
6
Plugin Contributions:
0

Countries still in drop down after deletion from DB

Hey guys.

I deleted all but 2 countries from the coutries table in the DB but they still all appear in drop down lists and in the Admin->Locations->Countries list.

I thought by deleting them from the DB that it would do the trick but obviously it didn't. Many of the posts I see relating to Countries are from 2006ish and before 1.3.8 which I am using.

Has something changed? Do I need to make a change elsewhere?

Thanks

1 Jun 2009, 6:17 AM
#2
nj2miami avatar

nj2miami

New Zenner

Join Date:
May 2009
Posts:
6
Plugin Contributions:
0

Re: Countries still in drop down after deletion from DB

Still looking for any help here. Any thoughts?

1 Jun 2009, 7:52 AM
#3
get_em_fast avatar

get_em_fast

Totally Zenned

Join Date:
Dec 2006
Location:
Seligman, MO U.S.A.
Posts:
2,072
Plugin Contributions:
1

Re: Countries still in drop down after deletion from DB

Go to Admin>Locations / Taxes>Countries.........and delete away.

Hope this helps.

Teach them to shop and they will shop today;
Teach them to Zen and they will OWN a shop tomorrow!

1 Jun 2009, 8:25 AM
#4
nj2miami avatar

nj2miami

New Zenner

Join Date:
May 2009
Posts:
6
Plugin Contributions:
0

Re: Countries still in drop down after deletion from DB

Yeah, thanks. I knew about that already, but I was wondering why if I deleted them from the main DB, why they would still be showing up in the interface and drop downs.

I am assuming that they are read fromt hat initial table but are then stored somewhere else?

Just trying to see where.

Thanks though.

2 Jun 2009, 6:38 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Countries still in drop down after deletion from DB

I suspect you're deleting them from the wrong table then. Perhaps you have multiple sets of tables in your database? ie: "countries", "zen_countries", "mystore_countries", etc? Zen Cart uses the tables whose prefix is determined by the DB_PREFIX value in your configure.php files. If you go altering data in the wrong set of tables, then you're going to see unexpected results.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

2 Jun 2009, 7:45 AM
#6
nj2miami avatar

nj2miami

New Zenner

Join Date:
May 2009
Posts:
6
Plugin Contributions:
0

Re: Countries still in drop down after deletion from DB

My DB_PREFIX is zen, and all my tables are zen_X, in this case, zen_countries.

There are no other duplicate named tables in the DB.

I ended 1x1 deleting from the Admin/Locations section, but I am curious as to where else, if somewhere, this data is actually stored.

2 Jun 2009, 9:09 AM
#7
nj2miami avatar

nj2miami

New Zenner

Join Date:
May 2009
Posts:
6
Plugin Contributions:
0

Re: Countries still in drop down after deletion from DB

OK, so I did some more digging because it was driving me nuts and I found that:

  1. The /includes/configure.php file was pointing to a different DB than the /admin/includes/configure.php file.

Also, the absolute paths were different.

How could the store still be working?