Discount coupons for category is not working,error MySQL

[Rimo]

Hi,

I just checked the files and here they are:

By the way I am using the dutch versions so you will find here two files of coupon_restrict.php

admin/includes/language/english

<?php
/**
 * @package admin
 * @copyright Copyright 2003-2010 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: coupon_restrict.php 16174 2010-05-02 14:10:30Z drbyte $
 */

define('HEADING_TITLE', 'Discount Coupons Product/Category Restrictions');
define('HEADING_TITLE_CATEGORY', 'Category Restrictions');
define('HEADING_TITLE_PRODUCT', 'Product Restrictions');

define('HEADER_COUPON_ID', 'Coupon ID');
define('HEADER_COUPON_NAME', 'Coupon Name');
define('HEADER_CATEGORY_ID', 'Category ID');
define('HEADER_CATEGORY_NAME', 'Category Name');
define('HEADER_PRODUCT_ID', 'Product ID');
define('HEADER_PRODUCT_NAME', 'Product Name');
define('HEADER_RESTRICT_ALLOW', 'Allow');
define('HEADER_RESTRICT_DENY', 'Deny');
define('HEADER_RESTRICT_REMOVE', 'Remove');
define('IMAGE_ALLOW', 'Allow');
define('IMAGE_DENY', 'Deny');
define('IMAGE_REMOVE', 'Remove');
define('TEXT_ALL_CATEGORIES', 'All Categories');

define('MAX_DISPLAY_RESTRICT_ENTRIES', 20);
define('TEXT_ALL_PRODUCTS_ADD', 'Add All Category Products');
define('TEXT_ALL_PRODUCTS_REMOVE', 'Remove All Category Products');
define('TEXT_INFO_ADD_DENY_ALL', '<strong>For Add all Category Products, only Products not already set for restrictions will be added.<br />
                    For Delete all Category Products, only Products that are specified Deny or Allow will be removed.</strong>');

define('TEXT_MANUFACTURER', 'Manufacturer: ');
define('TEXT_CATEGORY', 'Category: ');
define('ERROR_DISCOUNT_COUPON_DEFINED_CATEGORY', 'Category Not Completed');
define('ERROR_DISCOUNT_COUPON_DEFINED_PRODUCT', 'Product Not Completed');

admin/includes/languages/dutch

<?php
//dutch translation Zencart ; v1.3.7 2007-09-11 by Edwin Wiering ; v1.3.5 2006-09-04 by joostvdl ; dutch translation Zencart v1.2.6d 2005-11-12  by dutchguy 
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers                           |
// |                                                                      |   
// | http://www.zen-cart.com/index.php                                    |   
// |                                                                      |   
// | Portions Copyright (c) 2003 osCommerce                               |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | http://www.zen-cart.com/license/2_0.txt.                             |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | [email protected] so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
//  $Id: coupon_restrict.php 3666 2006-05-28 21:21:37Z wilt $
//

define('HEADING_TITLE', 'Kortingsbonnen Artikel/Categorie beperkingen');
define('HEADING_TITLE_CATEGORY', 'Categorie beperkingen');
define('HEADING_TITLE_PRODUCT', 'Artikel beperkingen');

define('HEADER_COUPON_ID', 'Kortingsbon ID');
define('HEADER_COUPON_NAME', 'Naam kortingsbon');
define('HEADER_CATEGORY_ID', 'Categorie ID');
define('HEADER_CATEGORY_NAME', 'Categorienaam');
define('HEADER_PRODUCT_ID', 'Artikel ID');
define('HEADER_PRODUCT_NAME', 'Artikelnaam');
define('HEADER_RESTRICT_ALLOW', 'Toestaan');
define('HEADER_RESTRICT_DENY', 'Weigeren');
define('HEADER_RESTRICT_REMOVE', 'Verwijderen');
define('IMAGE_ALLOW', 'Toestaan');
define('IMAGE_DENY', 'Weigeren');
define('IMAGE_REMOVE', 'Verwijderen');
define('TEXT_ALL_CATEGORIES', 'Alle Categorieën');
?>

I copied this from the files,but at the end of admin/includes/languages/english/coupon_restricted.php i am missing ?> can this be a problem?

[RodG]

By the way I am using the dutch versions so you will find here two files of coupon_restrict.php

If I'd known that I would have suggested that you simply change languages to see if the problem goes away.

Not needed now though, I see where your problem is.

The dutch version of this file is based on an older version of zencart, as such, some of the defines are missing, including the one under discussion.

You will need to add these missing defines to your dutch file. Just copy them over from the english one and edit as needed.

As for the missing "?>" - No, this will NOT cause you any problems. It is supposed to be that way. It should be removed from the dutch file when you update it with the missing entries.

Cheers
Rod

[Ajeh]

Your dutch file appears to be missing a number of defines that are in the english ...

[Rimo]

Thank you all
You were right,the problem was the dutch file.
I copied the english to the dutch file,problem solved

[Ajeh]

You are most welcome ... thanks for the update that your language file was out of date ...

[Digiwinkel]

Thank you all
You were right,the problem was the dutch file.
I copied the english to the dutch file,problem solved

GREAT!!! They are missing in the Russian language files too,... Thanks!