Now I'm really hosed

[mespe]

All kinds of errors what to do? my store is dead in the water at this time


[21-May-2016 13:38:48 America/Phoenix] Request URI: /store/, IP address: 107.216.52.176
#1 trigger_error() called at [//includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [//includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [//includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [//includes/functions/functions_lookups.php:29]
#5 zen_get_countries() called at [//includes/functions/functions_lookups.php:62]
#6 zen_get_country_name() called at [//includes/init_includes/init_header.php:71]
#7 require(//includes/init_includes/init_header.php) called at [//includes/autoload_func.php:48]
#8 require(//includes/autoload_func.php) called at [//includes/application_top.php:170]
#9 require(//includes/application_top.php) called at [/home/content/m/e/s/mespe61/html/store/index.php:26]

[21-May-2016 13:38:48 America/Phoenix] PHP Fatal error: 1054:Unknown column 'status' in 'where clause' :: select countries_name, countries_iso_code_2, countries_iso_code_3
from zen_countries
where countries_id = '223' and status != 0 order by countries_name ==> (as called by) //includes/functions/functions_lookups.php on line 29 <== in //includes/classes/db/mysql/query_factory.php on line 167

[swguy]

Have you corrupted the countries table? It should have a status column. You could just add it back in and set it to 1.
Here's what it should look like:

DROP TABLE IF EXISTS countries;
CREATE TABLE countries (
  countries_id int(11) NOT NULL auto_increment,
  countries_name varchar(64) NOT NULL default '',
  countries_iso_code_2 char(2) NOT NULL default '',
  countries_iso_code_3 char(3) NOT NULL default '',
  address_format_id int(11) NOT NULL default '0',
  status tinyint(1) default 1,
  PRIMARY KEY  (countries_id),
  KEY idx_countries_name_zen (countries_name),
  KEY idx_address_format_id_zen (address_format_id),
  KEY idx_iso_2_zen (countries_iso_code_2),
  KEY idx_iso_3_zen (countries_iso_code_3)
) ENGINE=MyISAM;

[swguy]

The data for populating this table is in a fresh download of Zen Cart in zc_install/sql/install/mysql_utf8.sql.

[mespe]

Too late, I'm really hosed now, can't log into admin.
I decided to restore from backup, but it looks like I missed some files

Getting:

[21-May-2016 16:16:22 America/Phoenix] PHP Fatal error: Call to a member function Execute() on a non-object in /admin/includes/init_includes/init_db_config_read.php on line 13

And line 13 is a comment!!!

[carlwhat]

i highly doubt line 13 is a comment. it certainly was not a comment at the time of the logging of the error. the file may have changed since then, and if tables are now missing fields, its possible you were hacked... but i'm just guessing.

good luck!

[mespe]

my bad, it's not a comment, it's my bad.
I've tried to upgrade to 1.55a and updated the database patch to 1.55 Then I tried to restore
so I restored my database from before the update, and I restored all my files, and now I found the correct php file and it indicates that my patch isn't correct. Can I unpatch from 1.55 back to 1.51?

[mespe]

And between a test site and live site, I mixed up passwords and now I'm hosed. So I was hoping to restore, log in with my old password and start fixing things (or breaking them more, however you want to look at it,,,)

[mespe]

Phew, I managed to work through the issues I had by copying my test admin folder to my live store. So I can log in, but I need to update the database server to the 1.55 patch

[kobra]

Can I unpatch from 1.55 back to 1.51?

You should have a backup of your DB as 1.5.1 - just import it using phpmyadmin

[kobra]

Phew, I managed to work through the issues I had by copying my test admin folder to my live store. So I can log in, but I need to update the database server to the 1.55 patch

Thought you had already done this???

Re run zc_install and select upgrade