Jump to content

Rseasy

Members
  • Content count

    2
  • Joined

  • Last visited

About Rseasy

  • Birthday 10/10/1981

Profile Information

  1. Rseasy

    One Page Checkout Support

    Ok I found the solution! Just need to add those value in SQL DB # phpMyAdmin MySQL-Dump # http://www.phpmyadmin.net/ INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('To offer a gift voucher', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Please indicate the amount of the gift voucher which you want to offer a new customer.<br><br>Put 0 if you do not want to offer gift voucher.<br>', 1, 31, NULL, now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('To offer a discount coupon', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'To offer a discount coupon to a new customer, enter the code of the coupon.<br><br>Leave empty if you do not want to offer discount coupon.<BR>', 1, 32, NULL, now(), NULL, NULL); # # Table structure for table 'coupon_email_track' # CREATE TABLE coupon_email_track ( unique_id int(11) NOT NULL auto_increment, coupon_id int(11) NOT NULL default '0', customer_id_sent int(11) NOT NULL default '0', sent_firstname varchar(32) default NULL, sent_lastname varchar(32) default NULL, emailed_to varchar(32) default NULL, date_sent datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (unique_id) ); # # Table structure for table 'coupon_gv_customer' # CREATE TABLE coupon_gv_customer ( customer_id int(5) NOT NULL default '0', amount decimal(8,4) NOT NULL default '0.0000', PRIMARY KEY (customer_id), KEY customer_id (customer_id) ); # # Table structure for table 'coupon_gv_queue' # 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 NOT NULL default '0000-00-00 00:00:00', 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) ); # # Table structure for table 'coupon_redeem_track' # CREATE TABLE coupon_redeem_track ( unique_id int(11) NOT NULL auto_increment, coupon_id int(11) NOT NULL default '0', customer_id int(11) NOT NULL default '0', redeem_date datetime NOT NULL default '0000-00-00 00:00:00', redeem_ip varchar(32) NOT NULL default '', order_id int(11) NOT NULL default '0', PRIMARY KEY (unique_id) ); # # Table structure for table 'coupons' # CREATE TABLE coupons ( coupon_id int(11) NOT NULL auto_increment, coupon_type char(1) NOT NULL default 'F', coupon_code varchar(32) NOT NULL default '', coupon_amount decimal(8,4) NOT NULL default '0.0000', coupon_minimum_order decimal(8,4) NOT NULL default '0.0000', coupon_start_date datetime NOT NULL default '0000-00-00 00:00:00', coupon_expire_date datetime NOT NULL default '0000-00-00 00:00:00', uses_per_coupon int(5) NOT NULL default '1', uses_per_user int(5) NOT NULL default '0', restrict_to_products varchar(255) default NULL, restrict_to_categories varchar(255) default NULL, restrict_to_customers text, coupon_active char(1) NOT NULL default 'Y', date_created datetime NOT NULL default '0000-00-00 00:00:00', date_modified datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (coupon_id) ); # # Table structure for table 'coupons_description' # CREATE TABLE coupons_description ( coupon_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', coupon_name varchar(32) NOT NULL default '', coupon_description text, KEY coupon_id (coupon_id) );
  2. Rseasy

    One Page Checkout Support

    Hi guys, Looks like a great contribution but i can't get it working. I have the following error: 1146 - Table 'rs_os.table_coupons' doesn't exist select * from TABLE_COUPONS where coupon_code = 'NEW_SIGNUP_DISCOUNT_COUPON' [TEP STOP] Does anyone knows how to solve this problem? Thanks!
×