Zen Cart Logo
Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Database table prefix not recognized when establishing product restriction in coupons

Database table prefix not recognized when establishing product restriction in coupons

Views: 2,091

Results 1 to 6 of 6
18 Mar 2013, 8:06 AM
#1
ronlee67 avatar

ronlee67

Totally Zenned

Join Date:
Sep 2006
Location:
Colorado Springs CO USA
Posts:
519
Plugin Contributions:
0

Database table prefix not recognized when establishing product restriction in coupons

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');
18 Mar 2013, 4:13 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Database table prefix not recognized when establishing product restriction in coupons

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

18 Mar 2013, 6:48 PM
#3
ronlee67 avatar

ronlee67

Totally Zenned

Join Date:
Sep 2006
Location:
Colorado Springs CO USA
Posts:
519
Plugin Contributions:
0

Re: Database table prefix not recognized when establishing product restriction in coupons

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!

DrByte:

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

18 Mar 2013, 9:58 PM
#6
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Database table prefix not recognized when establishing product restriction in coupons

ronlee67:

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...