Something about a coupon

[Guest]

Folks can't check out, and it doesn't exactly look too hot sitting up there like that. Here's what's displayed:

 

1146 - Table 'guardia_osc1.coupon_gv_customer' doesn't exist

 

select amount from coupon_gv_customer where customer_id = '2'

 

[TEP STOP]

 

 

 

I also get this when I go to the admin page and click on Vouchers/Coupons:

 

1146 - Table 'guardia_osc1.TABLE_COUPONS' doesn't exist

 

select count(*) as total from TABLE_COUPONS where coupon_active='Y' and coupon_type != 'G'

 

[TEP STOP]

[♥Vger]

You have installed the files for the CCGV contribution (Credit Class & Gift Vouchers), but you haven't installed the order_total.sql file into your database via phpMyAdmin. The errors are because the tables in that sql file haven't been added to the database.

 

Vger

[Guest]

Folks can't check out, and it doesn't exactly look too hot sitting up there like that. Here's what's displayed:

 

1146 - Table 'guardia_osc1.coupon_gv_customer' doesn't exist

 

select amount from coupon_gv_customer where customer_id = '2'

 

[TEP STOP]

I also get this when I go to the admin page and click on Vouchers/Coupons:

 

1146 - Table 'guardia_osc1.TABLE_COUPONS' doesn't exist

 

select count(*) as total from TABLE_COUPONS where coupon_active='Y' and coupon_type != 'G'

 

[TEP STOP]

 

I found that after I installed the database that I still needed to update one more file...here is my post as to what I did to get it working....

 

Yeeeeaaaaahhh baaaaaabeee!!!! KGT you ROCK! I was suffering from the same error which the other person inquired about. After 3 hours of my employers time (while I worked on my personal OSC web site rolleyes.gif ) I finally ran across this post and THIS IS THE FIX...LOOK NO FURTHER IF YOU GET THIS ERROR! I am not sure why, but my database_tables.php file didn't update when I installed the CCGV (which I installed on top of a totally FRESH install of the new m2 release)...in fact, I looked into the CCGV catalog/includes directory and could find NO database_tables.php file that gets added to the includes directory. Soooo...I went ahead and added in a definition for all of the *coupon* stuff to my current/new database_tables.php file and voila!!! Success...I love this forum because every time I invest time searching for stuff I am always delightfully greated with AWESOME posts like yours that solve my problem with OSC...dude (or dudet biggrin.gif ) you rock!!! I am curious though, is that database_tables.php file something that should be updated when you install CCGV or are you supposed to kinda know that that file needs some updating? I had never touched that file before today...here is what I added based on the new coupon stuff that the CCGV is using:

 

define('TABLE_COUPON_EMAIL_TRACK', 'coupons_email_track');

define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

define('TABLE_COUPON_GV_QUEUE', 'coupon_gv_queue');

define('TABLE_COUPON_REDEEM_TRACK', 'coupon_redeem_track');

define('TABLE_COUPONS', 'coupons');

define('TABLE_COUPONS_DESCRIPTION', 'coupons_description');

 

Anyway...it got rid of my errors...now all I need to figure out is how to set up coupons/vouchers now...off to the install.html file :-) Thanks again for the fix!!! I feel a contribution coming on...maybe TheMadHatter_database_tables.php contrib??? blink.gif

 

Cheers,

TheMadHatter

 

p.s. Please let me know if this works for you...