Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    433
    Plugin Contributions
    1

    Default Error 1054 Unknown column 'countries_active' in 'field list'

    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/

  2. #2
    Join Date
    Nov 2007
    Posts
    433
    Plugin Contributions
    1

    Default Re: Error 1054 Unknown column

    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 !

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: Error 1054 Unknown column

    You installed the "Selectable Countries" plugin and forgot to install the associated SQL patch:
    Code:
    # 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;

  4. #4
    Join Date
    Nov 2007
    Posts
    433
    Plugin Contributions
    1

    Default Re: Error 1054 Unknown column

    Quote Originally Posted by alhakeem2001 View Post
    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 !
    Quote Originally Posted by lat9 View Post
    You installed the "Selectable Countries" plugin and forgot to install the associated SQL patch:
    Code:
    # 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

 

 

Similar Threads

  1. v151 Fatal error: 1054:Unknown column 'gzpost' in 'field list'
    By dellaenterprises in forum Upgrading to 1.5.x
    Replies: 11
    Last Post: 22 Jan 2013, 12:29 AM
  2. Error 1054 Unknown column 'customers_authorisation' in 'field list'
    By Jacqs Fairy in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 21 Jul 2011, 09:39 PM
  3. Error 1054 Unknown column 'products_length' in 'field list'
    By exdealsad in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 3 Nov 2010, 06:42 PM
  4. ERROR 1054 Unknown column 'zen_order_id' in 'field list'
    By paperthreads in forum PayPal Express Checkout support
    Replies: 6
    Last Post: 16 Feb 2010, 04:03 AM
  5. Replies: 1
    Last Post: 13 Jan 2007, 11:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR