standard_ipn.php fails with mysql 2013 error

[sgoodwin]

I'm trying to use paypal ipn. I've tried 2.2.3 as well as paypal standard 1.0. The orders don't get updated to the pending status after the payment is successfully made. When I tried to run the IPN script (catalog/ext/modules/payment/paypal/standard_ipn.php) from a browser window, it fails with this error:

 

 

2013 - Lost connection to MySQL server during query

 

select count(*) as total from sessions where sesskey = '59f6308791b09b88ee14d6864a2843b0'

 

[TEP STOP]

 

2006 - MySQL server has gone away

 

select count(*) as total from sessions where sesskey = '59f6308791b09b88ee14d6864a2843b0'

 

[TEP STOP]

 

 

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

 

 

 

Any ideas what the issue is? Your assistance would be greatly appreciated.

 

Steve

[jmroth]

maybe your tables are corrupt, check + repair using phpmyadmin for example?

[sgoodwin]

Tables checked out OK.

 

The problem turned out to be application_top.php.

 

I took out application_top.php, and took the the following code from application_top and added it directly into standard_paypal.php:

 

require('includes/configure.php');

require(DIR_WS_INCLUDES . 'filenames.php');

require(DIR_WS_INCLUDES . 'database_tables.php');

require(DIR_WS_FUNCTIONS . 'general.php');

require(DIR_WS_FUNCTIONS . 'html_output.php');

require(DIR_WS_FUNCTIONS . 'database.php');

 

I replaced the call to tep_mail (about line 185) with a native mail() call.

 

It works now. I'm a bit mystified as to how anyone can use the standard script without these changes.

[jmroth]

Well in that case the problem probably isnt with osC but with some other part of your setup/server.