Another Paypal IPN problem-cant see the orders in admin

[dfoxengr]

it started happening mid january, and i upgraded to 1.3.8 at the beginning of january. it happens on all paypal payments, not just echecks.

paypal isnt returning information to my site so i dont see the orders in admin such as others are experiencing.

all my paypal and zen cart settings are correct.
-----------------------------------------------------------
ive also run the two validation checks always recommend and theyre fine it seems.

but when i goto www.myurl.com/ipn_main_handler... i get this error

Fatal error: Cannot redeclare replace_accents() (previously declared in /home/foxst2/public_html/includes/modules/payment/paypal/paypal_functions.php:547) in /home/foxst2/public_html/includes/functions/functions_general.php on line 1482

----------------------------------------------------------
and when paypal tried to take me back to my site after placing the test order i got this error:
1054 Unknown column 'zen_order_id' in 'field list'
in:
[SELECT zen_order_id, paypal_ipn_id, payment_status, txn_type, pending_reason FROM paypal WHERE txn_id = '' OR parent_txn_id = '' ORDER BY zen_order_id DESC ]
-------------------------------------------

here is the log from an order i just tested:

there were like 8 error debug logs, so theyre in order that i received them in my inbox. with large spaces between them.

-------------------------------------------
PDT Returned Data Array
(
)







IPN WARNING :: PDT Transaction was not marked as SUCCESS. Keep this report
for potential use in fraud investigations.
IPN Info =







PDT WARNING :: Order not marked as "Completed". Check for Pending reasons
or wait for IPN to complete.
[payment_status] =>
[pending_reason] =>







IPN INFO - Confirmation/Validation response












IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:80 (0) Success

http://www.paypal.com/cgi-bin/webscr
Trying again without specified protocol ...










IPN INFO - POST VARS to be sent back for validation:
To: http://proxy.shr.secureserver.net:3128
POST http://www.paypal.com/cgi-bin/webscr HTTP/1.1
Host: proxy.shr.secureserver.net
Content-type: application/x-www-form-urlencoded
Content-length: 101
Connection: close

Array
(
[cmd] => _notify-sync
[tx] => 8F825686J25816630
[at] => kcTN6**********8MWp4
)






IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:3128 (0) Success

http://www.paypal.com/cgi-bin/webscr
Trying again without SSL ...
----------------------------------------------



I also got this log, but it was from 12 minutes before I actually placed the order. It must have been made when i put it into the shopping cart, or when i first went to the paypal site(there was time between getting transferred to paypal and actually logging in to pay):

Keys for submission: Array
(
[bn] => zencart
[cmd] => _ext-enter
[rm] => 2
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[page_style] => Primary
[lc] => US
[custom] => zenid=ca787c8f0c13b81c5820650d31ee95fc
[charset] => iso-8859-1
[return] =>
http://www.foxraceco.com/index.php?m...referer=paypal
[cancel_return] =>
http://www.foxraceco.com/index.php?m...eckout_payment
[shopping_url] =>
http://www.foxraceco.com/index.php?m...=shopping_cart
[notify_url] => http://www.foxraceco.com/ipn_main_handler.php
[redirect_cmd] => _xclick
[business] => xxxxx
[first_name] => xxxxx
[last_name] => xxxx
[address1] => xxxxxx
[city] => xxx
[state] => xx
[zip] => xxxxxxxx
[country] => US
[email] => xxxxxxxxxxxx
[H_PhoneNumber] => xxxxxxxxxx
[night_phone_a] => xxx
[night_phone_b] => xxx
[night_phone_c] => xxxx
[day_phone_a] => xxx
[day_phone_b] => xxx
[day_phone_c] => xxxx
[no_shipping] => 1
[currency_code] => USD
[paypal_order_id] =>
[item_name] => Fox Products Purchase
[item_number] => Store Receipt
[upload] => 1
[amount] => 0.02
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00
)

[DrByte]

it started happening mid january, and i upgraded to 1.3.8 at the beginning of january. it happens on all paypal payments, not just echecks.

paypal isnt returning information to my site so i dont see the orders in admin such as others are experiencing.

...

but when i goto www.myurl.com/ipn_main_handler... i get this error

Fatal error: Cannot redeclare replace_accents() (previously declared in /home/foxst2/public_html/includes/modules/payment/paypal/paypal_functions.php:547) in /home/foxst2/public_html/includes/functions/functions_general.php on line 1482

This tells me that you seem to be using a functions_general.php file that's built for an older version. Are you sure you upgraded it properly?

[DrByte]

and when paypal tried to take me back to my site after placing the test order i got this error:
1054 Unknown column 'zen_order_id' in 'field list'

And this tells me that you seem to be using an older version of the PayPal module on a newer version of Zen Cart.

[dfoxengr]

well i upgraded to 1.3.8 in january, and i unistalled and reinstalled the module.
what do you suggest i look for next?
are there any files i should replace? i just replaced all the june 17th update files last night and that didnt help.
thank you.

[DrByte]

well i upgraded to 1.3.8 in january, and i unistalled and reinstalled the module.
what do you suggest i look for next?
are there any files i should replace? i just replaced all the june 17th update files last night and that didnt help.
thank you.

The June 17 patch files are for v1.3.7, not 1.3.8 ... which would explain the symptoms you reported today. You'll have to undo all those changes.

[dfoxengr]

crap. can i just get the 1.3.8 files from the original download and then load them back?

and then how do i get the initial problem to go away?
i just set up the godaddy curl module in admin, could that have fixed it, but me overwriting the 1.3.8 files with 1.3.7 have ruined the fix again?

[DrByte]

The 1.3.8 versions of the files you changed should be fine.
Or restoring files from backup before you applied the changes would likely work too.

[dfoxengr]

ok great, so do you think that curl could have been the original problem?

[DrByte]

ok great, so do you think that curl could have been the original problem?

At the present time, IPN makes no use of CURL, so no, that shouldn't have any impact.

[dfoxengr]

ok so has anyone found a solution to this?
now im back to square 1...

thanks for you help drbyte