SCRIPT3R |
11-27-2005 07:07 AM |
for those receiving the following error email notice...
Quote:
Database error in vBulletin 3.5.1:
Invalid SQL:
INSERT INTO donation_paypalipn (
`txn_id`, `userid`, `test_ipn`, `notify_version`, `verify_sign`,
`first_name`, `last_name`, `payer_business_name`, `address_name`,
`address_street`, `address_city`, `address_state`, `address_zip`,
`address_country`, `address_status`, `payer_email`, `payer_id`,
`payer_status`, `business`, `receiver_email`, `receiver_id`,
`item_name`, `ip_address`, `quantity`, `invoice`,
`memo`, `tax`, `option_name1`, `option_selection1`, `option_name2`,
`option_selection2`, `payment_date`, `parent_txn_id`, `txn_type`,
`payment_type`, `payment_status`, `pending_reason`, `reason_code`,
`mc_gross`, `mc_fee`, `mc_currency`, `mc_handling`, `mc_shipping`,
`settle_amount`, `settle_currency`, `exchange_rate`, `case_id`,
`case_type`, `case_creation_date`, `valid`
) VALUES (
'', '0', '0', '0', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '0', '',
'', '0', '', '', '',
'', '', '', '',
'', '', '', '',
'0', '0', '', '0', '0',
'0', '', '0', '',
'', '', '0'
);;
MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Sunday, November 27th 2005 @ 03:35:20 AM
Script : http://forum.......com/ppverify.php
Referrer :
IP Address : 24.152.196.233
Username : Unregistered
Classname : vb_database
|
it has something to do with an Invalid Transaction i'm sure you have. supposedly, if you delete said invalid transaction, you won't get that error again, BUT that invalid transaction cannot be deleted from within the CP! any advice on how to delete that transaction elsewhere, like from within the db?
Update: using phpMyAdmin, i have deleted this particular "Invalid Transaction" transaction from the corresponding table. i have not received the above error since.
|