Zen Cart 1.3.7 - Upgrade
Patch: 1::
Database Patch Level: 1.3.7
Database: MySQL 5.0.88
Add Ons: Simple SEO URL
Installing locally on Windows Vista

I have installed the Order Total module. In red caps next to Discount Coupon it states "MODULE_ORDER_TOTAL_COUPON_INCLUDE ERROR".

It gives me the option to remove or edit it. How would I correct it?

Discount Coupon

This module is installed
true

Sort Order
280

Include Shipping
false

Include Tax
true

Re-calculate Tax
Standard

Tax Class
--none--

When I go to Coupon Administration in Gift Certificate/Coupons, under Discount Coupons it states:

"1054 Unknown column 'coupon_zone_restriction' in 'field list'
in:
[select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p roducts, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from coupons where coupon_active='Y' and coupon_type != 'G' limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

I have checked Google for this syntax and nothing comes up in a search. I checked Zen Cart forum and there is nothing I can find on this problem.

I then downloaded the full version of 1.3.7.1 and FPTed the following files to the corresponding directories in case I have a corrupted file (found coupon_id in each of the following documents using Developers Tool Kit so tried updating these files):

www/catalog/admin/coupon_admin.php
www/catalog/includes/modules/order_total/ot_coupon.php
www/catalog/includes/modules/order_total/ot_gv.php
www/catalog/includes/modules/pages/gv_redeem/header_php.php
www/catalog/admin/includers/languages/english/coupon_admin.php
www/catalog/includes/modules/pages/discount_coupon/header_php.php
www/catalog/includes/templates/template_default/popup_coupon_help/tpl_main_page.php

It didn't make any difference. Everything displays exactly the way it did prior to me FTPing the files to the server.

Mail Gift Certificates Queue, Mail Gift Certificates, and Gift Certificates Sent all display and work properly. However, Coupon Administration has never displayed properly and I have never been able to use it. Our customers keep asking for discount coupons but we can only administer gift certificates, and not coupons. How can I fix this?

(I would consider reinstalling the whole module but we have two pages of Gift Certificates Sent with some still outstanding, and I'm concerned that I might inadvertently wipe out that information.)

Thank you in advance for any enlightenment you can give.