Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Credit Class & Gift Voucher


Recommended Posts

Ok I just addes http://www.oscommerce.com/community/contributions,282 (Credit Class & Gift Voucher) it was not the latest version it was CCGV 5.15a (Full Package) but 4 some rason i dont have the fille name "filename.php" or database_table.php

 

can some one tell me were to get those files

 

Thaks

at the end of the day the code will be good

Link to comment
Share on other sites

Ok my error for now are :

 

1) 1146 - Table 'coolbug.TABLE_COUPON_GV_CUSTOMER' doesn't exist

 

2) select amount from TABLE_COUPON_GV_CUSTOMER where customer_id = '3'

 

I need to know what the value of TABLE_COUPON_GV_CUSTOMER should be

at the end of the day the code will be good

Link to comment
Share on other sites

ok another error i have

when I send a Gift E-mail to a custumer they get this message when they press on the link

 

 

 

1146 - Table 'coolbug.COUPONS' doesn't exist

 

select c.coupon_id, c.coupon_amount from COUPONS c, TABLE_COUPON_EMAIL_TRACK et where coupon_code = 'c2ff75' and c.coupon_id = et.coupon_id

 

[TEP STOP]

at the end of the day the code will be good

Link to comment
Share on other sites

if you have an early version of oscommerce then the filenames and database tables would be defined in the application_top.php

 

your errors are all related to not having the database tables defined

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Ok my error for now are :

 

1) 1146 - Table 'coolbug.TABLE_COUPON_GV_CUSTOMER' doesn't exist

 

2) select amount from TABLE_COUPON_GV_CUSTOMER where customer_id = '3'

 

I need to know what the value of TABLE_COUPON_GV_CUSTOMER should be

 

 

ok on the Cat/includes/database_tables.php

 

I added

 

////////////# GV

define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

define('TABLE_COUPONS', 'COUPONS');

 

define('TABLE_coupon_email_track', 'coupon_email_track');

define('TABLE_coupon_gv_queue', 'coupon_gv_queue');

define('TABLE_coupon_redeem_track', 'coupon_redeem_track');

define('TABLE_coupons_description', 'coupons_description');

 

 

and that took care of those erros

at the end of the day the code will be good

Link to comment
Share on other sites

ok another error i have

when I send a Gift E-mail to a custumer they get this message when they press on the link

1146 - Table 'coolbug.COUPONS' doesn't exist

 

select c.coupon_id, c.coupon_amount from COUPONS c, TABLE_COUPON_EMAIL_TRACK et where coupon_code = 'c2ff75' and c.coupon_id = et.coupon_id

 

[TEP STOP]

 

 

This is the e-mail link that takes me there

 

https://coolbugstuff.com/gv_redeem.php?gv_no=c2ff75

at the end of the day the code will be good

Link to comment
Share on other sites

I know I am posting alot in my own thing but I just keep seeing new thing

 

i was going threw my admin area and i have a new payment mod that is called "Credit Class Error"

 

is that supose to be that way?

in any case it dose not show on the checkout page

at the end of the day the code will be good

Link to comment
Share on other sites

ok on the Cat/includes/database_tables.php

 

I added

 

////////////# GV

define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

define('TABLE_COUPONS', 'COUPONS');

 

define('TABLE_coupon_email_track', 'coupon_email_track');

define('TABLE_coupon_gv_queue', 'coupon_gv_queue');

define('TABLE_coupon_redeem_track', 'coupon_redeem_track');

define('TABLE_coupons_description', 'coupons_description');

 

 

and that took care of those erros

 

 

That is wrong because the the name of the constants shoud be all CAPS

 

this is the right way

 

 

////////////# GV

define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

define('TABLE_COUPONS', 'coupons');

 

define('TABLE_COUPON_EMAIL_TRACK', 'coupon_email_track');

define('TABLE_COUPON_GV_QUEUE', 'coupon_gv_queue');

define('TABLE_COUPON_REDEEM_TRACK', 'coupon_redeem_track');

define('TABLE_COUPONS_DESCRIPTION', 'coupons_description');

at the end of the day the code will be good

Link to comment
Share on other sites

 

I was reeding untill page 3* and I find a couple of theings but I still cant get what my error is.

I think I should post it in there any ways

at the end of the day the code will be good

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...