Database table prefix not recognized when establishing product restriction in coupons

[ronlee67]

Setting up discount coupon on this site for first time.

Everything works except that I am unable to establish coupon restrictions because Zencart not recognizing the prefix on my database table for 'products_to_categories'.

My database tables are prefixed "ws_"'

I get the following error when entering a product restriction:

1146 Table 'zc_wilks.products_to_categories' doesn't exist
in:
[select products_id from products_to_categories where categories_id = '7' and products_id not in (select product_id from coupon_restrict where coupon_id = '2')]
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.

Related entries in admin/includes/configure.php:

 define('DB_PREFIX', 'ws_');
  define('DB_DATABASE', 'zc_wilks');

Related entries in includes/configure.php:

 define('DB_PREFIX', 'ws_');
  define('DB_DATABASE', 'zc_wilks');

[DrByte]

Ya, that was a bug that was fixed in v1.5.0

[ronlee67]

Thanks.
Guess that finally gives me the push to upgrade.
My reluctance to upgrade is based on how good Zencart works for me since the version 1.3 series came out, that I never felt the need to upgrade and rework the contributions back into a newer version.

That's meant as a compliment to the development team. Good Job guys and gals of the development team!

Ya, that was a bug that was fixed in v1.5.0

[DrByte]

Found it in the Bug Reports section: http://www.zen-cart.com/showthread.p...icting-coupons

[ronlee67]

Found it in the Bug Reports section: http://www.zen-cart.com/showthread.p...icting-coupons

Thanks, made the changes. Works perfect.

Ron

[schoolboy]

My reluctance to upgrade is based on how good Zencart works for me since the version 1.3 series came out

If you're on the 1.3 series, just make sure it's 1.3.9h . It's still robust and reliable...