MoisesZaragoza Posted May 16, 2006 Share Posted May 16, 2006 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 Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 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 Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
moonbeam Posted May 16, 2006 Share Posted May 16, 2006 Try admin/includes/filenames.php. Good Luck, Moon Quote "Woohoo, Just Havin Funnn!" Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 Thanks I was looking for the one for the catalog. not the admin but thanks Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 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] Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
241 Posted May 16, 2006 Share Posted May 16, 2006 (edited) 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 May 16, 2006 by 241 Quote 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! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 I was looking were those thigs were declared on the contreibution sorry If I was not clear Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 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 Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 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 Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 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 Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 16, 2006 Author Share Posted May 16, 2006 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'); Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 17, 2006 Author Share Posted May 17, 2006 I was able to fix everything. but now I was testing but i do not know how i pay with the certificate that I have Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
Guest Posted May 17, 2006 Share Posted May 17, 2006 I was able to fix everything. but now I was testing but i do not know how i pay with the certificate that I have Did you ever look in http://www.oscommerce.com/forums/index.php?showtopic=158518 for your answers? Quote Link to comment Share on other sites More sharing options...
MoisesZaragoza Posted May 17, 2006 Author Share Posted May 17, 2006 Did you ever look in http://www.oscommerce.com/forums/index.php?showtopic=158518 for your answers? 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 Quote at the end of the day the code will be good Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.