Another Paypal IPN problem-cant see the orders in admin

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 https://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
)

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.

...

but when i goto https://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 1482This 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?

dfoxengr:

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.

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.

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.

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.

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?

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.

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

dfoxengr:

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.

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

thanks for you help drbyte

dfoxengr:

ok so has anyone found a solution to this?
now im back to square 1...Well, if you've put back all your 1.3.8 code, then the error messages and the problems in the logs that you posted should all have been cleared up.

So, what exactly are the symptoms you're facing now? Do you have any new logs to show?

heres my newest log after changing back to 1.3.8 files:::::::::::
symptoms are the same, where it is not saving orders in the admin area.
i got all the files from 1.3.8 and uploaded them over the 1.3.7 files like you said. then reinstalled paypal module in admin correctly.
all setting in paypal are still correct.
now im back to where i was the other day.

also its now showing the item name as MODULE_PAYMENT_PAYPAL_PURCHASE_DESCRIPTION_TITLE
i fixed that the other day but cant remember how to now.

thank you for the help.

Mar 06 2008 7:22 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Mar 06 2008 7:22 -- IPN INFO - POST VARS received (sorted):
Array
(
[business] =>
[charset] => windows-1252
[contact_phone] =>
[custom] => zenid=ca787c8f0c13b81c5820650d31ee95fc
[first_name] =>
[item_name] => MODULE_PAYMENT_PAYPAL_PURCHASE_DESCRIPTION_TITLE
[item_number] => Store Receipt
[last_name] =>
[mc_currency] => USD
[mc_gross] => 0.02
[notify_version] => 2.4
[payer_email] =>
[payer_id] => 7TTXT99TJ6LGY
[payer_status] => verified
[payment_date] => 07:22:24 Mar 06, 2008 PST
[payment_gross] => 0.02
[payment_status] => Pending
[payment_type] => instant
[pending_reason] => address
[quantity] => 1
[receiver_email] =>
[receiver_id] => JQ3URCJD2YVKE
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 0E1441033W114330S
[txn_type] => web_accept
[verify_sign] => AVnm5M8Jv.b5yCJcjnTxUifPZdflAkTjQfBa3IE7O132rsiLI2AtpFaf
)

Mar 06 2008 7:22 -- 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: 752
Connection: close

Array
(
[txn_type] => web_accept
[payment_date] => 07:22:24 Mar 06, 2008 PST
[last_name] =>
[residence_country] => US
[pending_reason] => address
[item_name] => MODULE_PAYMENT_PAYPAL_PURCHASE_DESCRIPTION_TITLE
[payment_gross] => 0.02
[mc_currency] => USD
[business] =>
[payment_type] => instant
[verify_sign] => AVnm5M8Jv.b5yCJcjnTxUifPZdflAkTjQfBa3IE7O132rsiLI2AtpFaf
[payer_status] => verified
[tax] => 0.00
[payer_email] =>
[txn_id] => 0E1441033W114330S
[quantity] => 1
[receiver_email] =>
[first_name] =>
[payer_id] => 7TTXT99TJ6LGY
[receiver_id] => JQ3URCJD2YVKE
[contact_phone] =>
[item_number] => Store Receipt
[payment_status] => Pending
[shipping] => 0.00
[mc_gross] => 0.02
[custom] => zenid=ca787c8f0c13b81c5820650d31ee95fc
[charset] => windows-1252
[notify_version] => 2.4
[cmd] => _notify-validate
)

Mar 06 2008 7:22 -- 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 ...

Mar 06 2008 7:22 -- 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 ...

Mar 06 2008 7:22 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = proxy.shr.secureserver.net:80 (110) Connection timed out

https://www.paypal.com/cgi-bin/webscr

dfoxengr:

also its now showing the item name as MODULE_PAYMENT_PAYPAL_PURCHASE_DESCRIPTION_TITLE
i fixed that the other day but cant remember how to now.Your /includes/languages/english/modules/payment/paypal.php file should contain that definition. You're either missing that file or it didn't upload right, or you're using a much older version of it.

alright. you keep saying older version, but ive upgraded to all the newest 1.3.8 stuff, and thats when the problems started. how do i get to the newest version then? im not really that great at this stuff, so please bear with me.

thank you.

EDIT: i just reuploaded that file and tried an order again and now it's what it's supposed to say.

but when paypal was supposed to redirect me back to my site, it did not. and the settings in paypal are still correct.
it sent me back to the correct address but with a ton of extra characters attached to the end afte the "referer paypal" part.
the screen was blank so i guess it didnt complete the order for my admin side.
heres the return url
http://www.mystore.com/index.php?main_page=checkout_process

heres the LOG:

[return] => http://www.foxraceco.com/index.php?main_page=checkout_process&referer=paypal
[cancel_return] => http://www.foxraceco.com/index.php?main_page=checkout_payment
[shopping_url] => http://www.foxraceco.com/index.php?main_page=shopping_cart
[notify_url] => http://www.foxraceco.com/ipn_main_handler.php
[redirect_cmd] => _xclick

========================thats part of one.

Mar 06 2008 17:40 -- 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 ...

Mar 06 2008 17:40 -- 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 ...

Mar 06 2008 17:40 -- IPN INFO - Confirmation/Validation response

Mar 06 2008 17:40 -- Breakpoint: 1 - Collected data from PayPal notification

Mar 06 2008 17:40 -- IPN WARNING :: Transaction was not marked as VERIFIED. Keep this report for potential use in fraud investigations.
IPN Info =

Mar 06 2008 17:40 -- IPN FATAL ERROR :: Transaction did not validate

==========================THERES SOME MORE

Why do you have the CURL proxy enabled?

saw something about godaddy might need curl on another thread.
ill disable it.
like i said, i dont know hardly anything about this stuff. and it was fine for 3 years until january.

should i show another log after i disable?

WOW great news. i took off the curl and it now works.

I guess the only thing that i even accomplished through all of this was manually uploading the 1.3.8 paypal payment files. they probably werent written correctly when i did the upgrade so i would recommend that to everyone.
thank you so much for the help drbyte.

Glad you got it sorted out!