home Home arrow Forum arrow Development Help and Support Treasury Component v2.0.2

MH2 Login

Welcome, Guest. Please login or register.
Did you miss your activation email?
January 09, 2009, 05:35:44 PM
Username: Password:
Login with username, password and session length

Forgot your password?

MH2 Releases

Dec.28
Downloads		FileMH2 Shout Box Version 1.19
Dec.03
Downloads		FileMH2 Random Graphics Version 1.01
Nov.26
Downloads		FileMH2 Treasury Version 2.31
Oct.24
Downloads		FileMH2 Ventrilo Viewer (JOOMLA 1.5) 2.02
Oct.24
Downloads		FileMH2 Ventrilo Viewer (MAMBO) 2.02
    Treasury Component v2.0.2
mh2design Forums
January 09, 2009, 05:35:44 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News:
Advanced search  
Home Help Search Login Register
Pages: [1]
« previous next »
Print
Author Topic: Treasury Component v2.0.2  (Read 984 times)
RichRawlings
Newbie
*
Posts: 5


View Profile
« on: April 21, 2008, 05:34:15 PM »
I'm using Joomla 1.5.2 in legacy and SEO Settings YES, mysql 5.0.45 php 4.3.11

FAILED: CREATE TABLE mh2tr_transactions - Specified key was too long; max key length is 1000 bytes
FAILED: CREATE TABLE mh2tr_register - Specified key was too long; max key length is 1000 bytes

Can annyone help me with this?

Thanks,
Rich

P.S. Debug mode activated

mh2Treasury Component

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------
Connection to db - OK!
Assigning Post Variables
Opening connection and validating request with PayPal...
Connected to PayPal
Selecting database...OK!
Executing test query...FAILED
PayPal Receiver Email: richrawlings@xxxxxx.com
Logged
Mick
Administrator
Sr. Member
*****
Posts: 355



View Profile Email
« Reply #1 on: April 21, 2008, 11:49:41 PM »
Is your SQL running in safe mode by chance?

The reason your verification has failed is because the tables have not been created.

Here are the SQL calls made to create the tables, you can manually add them and if necessary remove the UNIQUE INDEXs but make sure you leave the primary indexs.

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),
   UNIQUE INDEX IDX1_register (UID_member, first_name, last_name, payer_business_name, payer_email, subscr_id, subscr_date));
   
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),
   UNIQUE INDEX IDX2_ppipns (txn_id, item_number, payer_email, custom, payment_date, payment_status, subscr_date, subscr_id))   
Logged
RichRawlings
Newbie
*
Posts: 5


View Profile
« Reply #2 on: April 22, 2008, 10:34:27 AM »
Thanks for your reply Mick!

Yes, I was in safe mode. I turned safe mode off, and tried to re-install and got the same message. I also tried to manually install database tables and still no luck, but thanks for the help!
Logged
Mick
Administrator
Sr. Member
*****
Posts: 355



View Profile Email
« Reply #3 on: April 22, 2008, 11:59:36 AM »
Try again with these options:

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));
Logged
RichRawlings
Newbie
*
Posts: 5


View Profile
« Reply #4 on: April 22, 2008, 02:15:01 PM »
Thanks, Mick!

That went down on the database  Grin

I'll be back, going to see if I find other problems in the component, If all is running good, I'll be back to donate.

Thanks for the support!

Rich
Logged
Mick
Administrator
Sr. Member
*****
Posts: 355



View Profile Email
« Reply #5 on: April 22, 2008, 05:06:56 PM »
Glad we could get it working for you!
Logged
Dukessa
Newbie
*
Posts: 1


View Profile
« Reply #6 on: May 12, 2008, 10:38:31 PM »
Hi!

I got the same db issue.
So I tried the last 2 queries you suggested.

The first query worked and created the table, but the second query didnt work.
Should I try to execute the second query the way you suggested it the first time?

Thank you  Smiley
Logged
Mick
Administrator
Sr. Member
*****
Posts: 355



View Profile Email
« Reply #7 on: May 16, 2008, 07:49:38 AM »
In order to accurately answer that, I would need to know the error you received when running the query.
Logged
Pages: [1]
Print
« previous next »
 
Jump to:  

     

© Mh2Design