I have had the same problem. I added the provided SQL patch into the tools>SQL Patches in Administration and got that error.
Part of the provided script is as follows:




#
# Table structure for table `geo_zones`
#

DROP TABLE IF EXISTS geo_zones;
CREATE TABLE geo_zones (
geo_zone_id int(11) NOT NULL auto_increment,
geo_zone_name varchar(32) NOT NULL default '',
geo_zone_description varchar(255) NOT NULL default '',
last_modified datetime default NULL,
date_added datetime NOT NULL default '',
PRIMARY KEY (geo_zone_id)
) TYPE=MyISAM;

#
# Dumping data for table `geo_zones`
#

INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('1', 'Australian Zones', 'All Local Zones', NULL, '');
INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('2', 'World Zones', 'All International Zones', NULL, '');



#
# Table structure for table `zones_to_geo_zones`
#

DROP TABLE IF EXISTS zones_to_geo_zones;
CREATE TABLE zones_to_geo_zones (
association_id int(11) NOT NULL auto_increment,
zone_country_id int(11) NOT NULL default '0',
zone_id int(11) default NULL,
geo_zone_id int(11) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '',
PRIMARY KEY (association_id)
) TYPE=MyISAM;

#
# Dumping data for table `zones_to_geo_zones`
#

INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 2, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 3, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 4, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 5, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 6, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 7, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 8, NULL, 2, 'NULL', '');

Is there some adjustment needed before submitting this Patch?

What happens is this throws my zen cart web site all over the place.
This happened two days ago and I had to dump my database and restore it.

I tried installing this module again with the same frustrating result.
I am getting nowhere