Module_order_total_coupon_include_error

[Redradar]

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.

[Ajeh]

What version of Zen Cart did you start with?

coupon_zone_restriction

was added in v1.3.6 ... it sounds like you are either using a database that was not upgraded or lost a field somewhere ...

[Redradar]

I started with Version 1.2.7. I've never been able to use Coupon Administration; seems like it's always had this problem for us. I had hoped that when we upgraded to a new Zen Cart version that this problem would resolve itself but unfortunately that has not been the case.

Is this problem resolvable?

[Ajeh]

Backup your database ...

Then, you might try the /zc_install and see if the Update Database shows any updates are needed ...

This may or may not correct the problem, but if you see checkboxes on updates, start with just the first checkbox and apply the updates and keep rechecking and applying each one that is checked one by one ...

[Redradar]

Thank you, Linda. I ran the /zc_install on it and am currently on Version 1.3.8a. There are no remaining check boxes on updates. However, nothing has changed with Coupon Administration. Do you have any other suggestions as to how I can fix it?

Even though /zc_install tells me I have the most current version and there's no need to upgrade, the administrative area of our site still denotes "New Version Available v1.3.8 :: Important Security Patch Download Here". Don't know if this is indicative of a problem or not.

[DrByte]

Even though /zc_install tells me I have the most current version and there's no need to upgrade, the administrative area of our site still denotes "New Version Available v1.3.8 :: Important Security Patch Download Here". Don't know if this is indicative of a problem or not.

All forum members were emailed back in July 2009 about an important admin security patch. If you've not applied it yet, you'll still get the warnings in your admin area.
http://www.zen-cart.com/forum/showthread.php?t=130161
http://www.zen-cart.com/forum/showthread.php?t=131115
http://www.zen-cart.com/forum/announcement.php?f=2&a=14