mh2design Forums

Development => Help and Support => Topic started by: RichRawlings on April 22, 2008, 03:49:44 PM



Title: IE an Treasury Component v2.0.2?
Post by: RichRawlings on April 22, 2008, 03:49:44 PM
Hey Mick, component is not taking me to my paypal donation page. I have disabled email-cloaking and still no luck with IE7 on Vista. Good news is, it worked fine with Opera, Firefox, and Safari.

Mick, you have a fix for IE7?

Rich


Title: Re: IE an Treasury Component v2.0.2?
Post by: Mick on April 22, 2008, 05:23:48 PM
Try the new 2.0.3 version.  IE tends to make you jump through hoops to get it working as it should. 

Which area are you seeing the issue?


Title: Re: IE FIXED an Treasury Component v2.0.3
Post by: RichRawlings on April 23, 2008, 11:19:17 AM
Downloaded 2.0.3, I still had to manually add the database tables, but all seems to be working right now!

CREATE TABLE IF NOT EXISTS mh2tr_subscriptions(
   UID_Register             BIGINT AUTO_INCREMENT,
   UID_member               BIGINT,
   first_name            VARCHAR(64),
   last_name             VARCHAR(64),
   payer_business_name   VARCHAR(127),
   payer_email           VARCHAR(127),
   custom                      VARCHAR(255),
   subscr_status         VARCHAR(20),
   subscr_id             VARCHAR(20),
   subscr_date           DATETIME,
   subscr_effective      DATETIME,
   period3               VARCHAR(5),
   amount3               DECIMAL(10, 2),
   recur_times           INT,
   times_filled          INT,
   times_failed          INT,
   times_refunded        INT,
   PRIMARY KEY(UID_Register));

CREATE TABLE IF NOT EXISTS mh2tr_transactions(
   UID_transactions       BIGINT            AUTO_INCREMENT,
   business               VARCHAR(127),
   item_name              VARCHAR(127),
   item_number            VARCHAR(127),
   receiver_email         VARCHAR(127),
   receiver_id            VARCHAR(127),
   address_street         VARCHAR(200),
   address_city           VARCHAR(40),
   address_state          VARCHAR(40),
   address_zip            VARCHAR(20)  NOT NULL,
   address_country        VARCHAR(64),
   first_name             VARCHAR(64),
   last_name              VARCHAR(64),
   payer_business_name    VARCHAR(127),
   payer_email            VARCHAR(127),
   payer_id               VARCHAR(13),
   contact_phone          VARCHAR(20),
   status_address         VARCHAR(15),
   status_payer           VARCHAR(15),
   custom                 VARCHAR(255),
   invoice                VARCHAR(127),
   memo                   VARCHAR(255),
   option_selection1      VARCHAR(200),
   option_name2             VARCHAR(200),
   option_selection2      VARCHAR(200),
   payment_date           DATETIME     NOT NULL,
   payment_status         VARCHAR(20),
   payment_type           VARCHAR(10),
   pending_reason         VARCHAR(20),
   reason_code            VARCHAR(20),
   txn_id                 VARCHAR(20),
   txn_type               VARCHAR(20),
   exchange_rate          DECIMAL(5, 2),
   mc_currency            VARCHAR(5)   NOT NULL,
   mc_fee                 DECIMAL(10, 2),
   mc_gross               DECIMAL(10, 2),
   payment_fee            DECIMAL(10, 2),
   payment_gross          DECIMAL(10, 2),
   settle_amount          DECIMAL(10, 2),
   settle_currency        VARCHAR(5),
   subscr_date            DATETIME,
   subscr_effective       DATETIME,
   period3                VARCHAR(5),
   amount3                DECIMAL(10, 2),
   mc_amount3             DECIMAL(10, 2),
   recurring              TINYINT,
   reattempt              TINYINT,
   retry_at               DATETIME,
   recur_times            INT,
   subscr_id              VARCHAR(20),
   PRIMARY KEY(UID_transactions),
   UNIQUE INDEX IDX1_ppipns (UID_transactions));

Thanks Mick, and a donation will be on the way for your great support!