Login Disallowed

[ShinyBen]

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:

[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.

[lat9]

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.

[ShinyBen]

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

[lat9]

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.

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.

[ShinyBen]

Thank you so much! The SQL patch fixed it!