I installed zencart V1.5.1, After I changed the store country from US to the Netherlands and set the zone to none I'm getting this error even after I reset the country back to us :

1054 Unknown column 'countries_active' in 'field list'
in:
[SELECT countries_active FROM countries WHERE countries_id = '223']

Please Help !

http://www.arab-broker.com/orientalmeal/

It's back working again ! I don't know how, I didn't do anything it's just got fixed ! probably a problem with the hosting side !

You installed the "Selectable Countries" plugin and forgot to install the associated SQL patch:

# Selectable Countries Plugin - Install SQL to add the countries_active field to the countries table.
ALTER TABLE countries ADD countries_active char(1) default 1;

alhakeem2001:

It's back working again ! I don't know how, I didn't do anything it's just got fixed ! probably a problem with the hosting side !

lat9:

You installed the "Selectable Countries" plugin and forgot to install the associated SQL patch:

Selectable Countries Plugin - Install SQL to add the countries_active field to the countries table.

ALTER TABLE countries ADD countries_active char(1) default 1;

I still didn't add any plugins to my zincart! What I did is,  I just changed the location of my store from US to The Netherlands and tried to add a new test customer for testing, But once I click on submit I get this error ! Now It's only fixed after I added that line of sql patch ( you provided ) to my database and it's working now without any problem, SO FAR !!! Thanks :smile: