I'm trying to execute the zone sql statements for my MZMT. I have the basic MZMT files copied over and the module is installed.
I am receiving errors when running the US geo zone sql.
When I run the script through zencart admin/tools/Install SQL patches I receive the following error: 1064 You have an error in your SQL syntax near 'geo_zones` VALUES ('', 'Shp: United States: 48', 'United States: Continental 48' at line 1
Merlinpa1969 advised that I should run the scripts through phpMyAdmin, this did not work either.
I then received this error: #1146 - Table geo_zones doesn't exist
I looked through my tables and I have a zen_geo_zones table, but not a geo_zones table.
Is there something I need to change in the script or is there something I forgot to do?
The only thing I can think of is in the setup instructions it states that the pre defined zones are set up with "shp" at the beginning of the filename.
I'm just not sure.
Bookmarks