Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

CCGV Support Bootstrap version


tmcca

Recommended Posts

I just submitted an update to CCGV for Bootstrap this does the following:

 

Sell Gift Certificates. Send store credits Give sign up bonuses Create coupon codes Customers can redeem GCs online Customers can send GC Balances to friends via email More, more, more.

Upcoming to work with Paypal App work in progress.

Please submit any issues; bugs; suggestions; etc

Enjoy

Link to comment
Share on other sites

Link to comment
Share on other sites

Hi all

Any idea why I am getting this error in my admin area;

Gift Voucher Release Queue pixel_trans.gif
1146 - Table 'mitchug_.TABLE_COUPON_GV_QUEUE' doesn't exist

select c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id from customers c, TABLE_COUPON_GV_QUEUE gv where (gv.customer_id = c.customers_id and gv.release_flag = 'N')

[TEP STOP]

I already have this table in my sql,

CREATE TABLE coupon_gv_queue (
  unique_id int(5) NOT NULL auto_increment,
  customer_id int(5) NOT NULL default '0',
  order_id int(5) NOT NULL default '0',
  amount decimal(8,4) NOT NULL default '0.0000',
  date_created datetime DEFAULT '1970-01-01 00:00:01' NOT NULL,
  date_released datetime DEFAULT '1970-01-01 00:00:01' NOT NULL,
  ipaddr varchar(32) NOT NULL default '',
  release_flag char(1) NOT NULL default 'N',
  PRIMARY KEY  (unique_id),
  KEY uid (unique_id,customer_id,order_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

 

So why am I still getting this error in almost every page of the module?

Many thanks in advance

Mitchell

 

Link to comment
Share on other sites

@austcoll,

the table name constants have not been added to includes/database_tables.php

But better to hardcode the table names: replace " ' . TABLE_COUPON_GV_QUEUE . ' " by "coupon_gv_queue" in both files

Edited by raiwa
Link to comment
Share on other sites

  • 3 weeks later...

Hi.

Is anyone else having the problem of sending an amount via mail in admin and it emails a code to the customer.

When the customer enters the redeem code at checkout it comes up saying error this code is not valid?

In admin under Vouchers Sent it shows the voucher there and also shows not redeemed but at customer side its invalid.

Link to comment
Share on other sites

  • 3 weeks later...

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