This topic contains 2 reply and 3 voices, and was last updated by Tareq Hasan 5 years, 2 months ago
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 Sekander Badsha

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

July 13, 2014 at 1:11 pm 23439
Tareq Hasan Tareq Hasan

Thanks for the report Darwin. Will be fixed 🙂

Viewing 2 Posts - 1 through 2 (of 2 total)