Home Forums Plugin Support WP User Frontend Pro WP User Frontend Pro – Unable to save Paypal Transaction

This topic is: resolved

This topic contains 2 replies, has 3 voices, and was last updated by  Tareq Hasan 4 years, 10 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #23317

    Darwin
    Member

    After submitting and successfully paying thru Paypal, the recent Transactions are not showing up in the Transactions page of the admin panel.

    After debugging the SQL query being executed, I noticed there was an additional field “profile_id” that is not present in the current transaction table. THis was causing the SQL error thus resulting to the issue i just described above.

    To fix this temporarily, I ALTER the transaction table and added that missing field.

    Below is the transcript:

    mysql> INSERT INTO wpuf_transaction (user_id,status,cost,post_id,pack_id,payer_first_name,payer_last_name,payer_email,payment_type,payer_address,transaction_id,created,profile_id) VALUES (107,'web_accept','1.00′,0,'1415′,'Darwin','Valencia','XXX@XXX.com','Paypal','US','XXXX','2014-07-10 13:23:05′,”)
    -> ;
    ERROR 1054 (42S22): Unknown column ‘profile_id' in ‘field list'
    mysql> desc wpuf_transaction;
    +——————+————–+——+—–+—————–+—————-+
    | Field | Type | Null | Key | Default | Extra |
    +——————+————–+——+—–+—————–+—————-+
    | id | mediumint(9) | NO | PRI | NULL | auto_increment |
    | user_id | bigint(20) | YES | | NULL | |
    | status | varchar(255) | NO | | pending_payment | |
    | cost | varchar(255) | YES | | | |
    | post_id | bigint(20) | YES | | NULL | |
    | pack_id | bigint(20) | YES | | NULL | |
    | payer_first_name | longtext | YES | | NULL | |
    | payer_last_name | longtext | YES | | NULL | |
    | payer_email | longtext | YES | | NULL | |
    | payment_type | longtext | YES | | NULL | |
    | payer_address | longtext | YES | | NULL | |
    | transaction_id | longtext | YES | | NULL | |
    | created | datetime | NO | | NULL | |
    +——————+————–+——+—–+—————–+—————-+
    13 rows in set (0.01 sec)

    mysql> ALTER TABLE wpuf_transaction ADD COLUMN profile_id bigint(20);

    Hope this helps.

    #23369

    Sekander Badsha
    Member
    Post count: 2067

    Hello Darwin,
    Your post is not clear to me. Did you find out a bug in User Frontend and Posted the fix ?

    #23439

    Tareq Hasan
    Keymaster
    Post count: 2831

    Thanks for the report Darwin. Will be fixed ๐Ÿ™‚

Viewing 3 posts - 1 through 3 (of 3 total)

The topic ‘WP User Frontend Pro – Unable to save Paypal Transaction’ is closed to new replies.