WP User Frontend Pro – Unable to save Paypal Transaction
Viewing 2 Posts - 1 through 2 (of 2 total)
Author | Posts |
---|---|
July 10, 2014 at 8:33 pm 23317 | |
Tareq Hasan | 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.
|
July 12, 2014 at 12:19 pm 23369 | |
Sekander Badsha | Hello Darwin, |
July 13, 2014 at 1:11 pm 23439 | |
Tareq Hasan | Thanks for the report Darwin. Will be fixed 🙂 |
Viewing 2 Posts - 1 through 2 (of 2 total)