Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2008
    Posts
    33
    Plugin Contributions
    0

    Default Countries Table error

    Im getting this error from my log file and the login page is blank at the Country Field? :

    [26-May-2015 15:08:56 America/Toronto] PHP Fatal error: 1054:Unknown column 'status' in 'field list' :: select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id, status from countries order by countries_name limit 0, 20 ==> (as called by) (my admin)/countries.php on line 141 <== in /includes/classes/db/mysql/query_factory.php on line 155

    Can someone help?

    v1.5.4

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Countries Table error

    That indicates that you're using v1.5.4 files against a pre-1.5.4 database, and haven't applied all the database changes that running zc_install would normally do.
    .

    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.

  3. #3
    Join Date
    Mar 2008
    Posts
    33
    Plugin Contributions
    0

    Default Re: Countries Table error

    Quote Originally Posted by DrByte View Post
    That indicates that you're using v1.5.4 files against a pre-1.5.4 database, and haven't applied all the database changes that running zc_install would normally do.
    How would I go about fixing this as I need it working?

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Countries Table error

    How would I go about fixing this
    Get a copy of your previous version of ZenCart and compare files against a fresh download of the current version

    A tool like beyond compare or winmerge will assist you
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Mar 2008
    Posts
    33
    Plugin Contributions
    0

    Default Re: Countries Table error

    Quote Originally Posted by kobra View Post
    Get a copy of your previous version of ZenCart and compare files against a fresh download of the current version

    A tool like beyond compare or winmerge will assist you
    Im only getting this message on the login/register page? as in screenshotName:  loginerror.png
Views: 90
Size:  37.2 KB

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,492
    Plugin Contributions
    88

    Default Re: Countries Table error

    You need to run the zc_install script to update your database. Those scripts will add the new column (status) with its proper defaults to the countries database table.

 

 

Similar Threads

  1. v137 SQL Table Error (table doesn't exist?)
    By plymgary1 in forum General Questions
    Replies: 14
    Last Post: 17 Feb 2012, 02:34 PM
  2. Zone Shipping not Disabling for countries defined in the skip countries box
    By cpjfox in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 30 Aug 2009, 12:15 PM
  3. table error please help: "table 'sessions' doesn't exist"
    By ebydrc in forum General Questions
    Replies: 3
    Last Post: 6 Apr 2008, 06:13 AM
  4. Zone Table Rates - do I really have to add all the other countries manually?
    By tracyselena in forum Built-in Shipping and Payment Modules
    Replies: 6
    Last Post: 22 Nov 2007, 05:39 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