Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2018
    Location
    North Carolina
    Posts
    3
    Plugin Contributions
    0

    database error Login Disallowed

    I'm using ZC v151 on www.shinyghoul.com/store with PHP 5.4.45. Instead of getting the usual button to register at the bottom of the login form, I get 'WARNING: An Error occurred, please refresh the page and try again.' Looking at the log file, I get the following error:

    Code:
    [09-Jun-2018 23:17:16 America/Chicago] PHP Fatal error:  1054:Unknown column 'status' in 'where clause' :: select countries_id, countries_name
                        from zc_countries  where status != 0  order by countries_name in /home1/shinyghoul/public_html/store/includes/classes/db/mysql/query_factory.php on line 120
    I know I could just stick a 'status' column in sources/ZENCART_FULL, but that feels hacky. I'd like to update to the most recent version, but when I download and use my FTP client to manually stick zc_install in there, it doesn't allow me to go to shinyghoul.com/store/zc_install like I would expect it to.

    I believe the store broke when I put in my theme.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    7,885
    Plugin Contributions
    64

    Default Re: Login Disallowed

    That 'status' field was added to the 'countries' table in the Zen Cart database in Zen Cart 1.5.2. I'm not sure why your templatemonster template chose to distribute an updated version of the function file that uses that field, but that's what template monster templates tend to do.

  3. #3
    Join Date
    Jun 2018
    Location
    North Carolina
    Posts
    3
    Plugin Contributions
    0

    Default Re: Login Disallowed

    Would you mind recommending a sustainable fix? I'm not entirely sure what does and doesn't break things

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    7,885
    Plugin Contributions
    64

    Default Re: Login Disallowed

    Since you're running Zen Cart 1.5.1 (released 2012-09-18), you could install the myDEBUG Backtrace plugin to give a teeny bit more information in that log.

    While you're planning your upgrade to a more recent version of Zen Cart, back up your database and then (using your admin's Tools->Install SQL Patches) run the following query.

    Code:
    ALTER TABLE countries ADD status tinyint(1) DEFAULT '1';
    That update, provided in the Zen Cart 1.5.2 upgrade, adds the field that the log you referenced is complaining about.

  5. #5
    Join Date
    Jun 2018
    Location
    North Carolina
    Posts
    3
    Plugin Contributions
    0

    Default Re: Login Disallowed

    Thank you so much! The SQL patch fixed it!

 

 

Similar Threads

  1. v150 Old login password keeps appearing when I login to the admin
    By robertp in forum General Questions
    Replies: 8
    Last Post: 19 Oct 2012, 07:54 PM
  2. Login Timeout after Add to Cart, Logout, Login, Try Checkout
    By squireh in forum All Other Contributions/Addons
    Replies: 14
    Last Post: 28 Jan 2011, 02:35 PM
  3. when I just try to login I am still returned to the login page
    By buildingblocks in forum Upgrading from 1.3.x to 1.3.9
    Replies: 14
    Last Post: 23 Jul 2010, 11:16 PM
  4. Offline credit card module disallowed by some hosts?
    By Ousel in forum Built-in Shipping and Payment Modules
    Replies: 34
    Last Post: 3 Oct 2008, 10:52 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