Treasury, Donat o meter not recording

SOTGMarine · New Member Joined: May 23, 2005 Posts: 10

Now time to test I guess... everything looks like it'll work... but who knows!

Raven · Posted: Mon May 23, 2005 7:01 pm

No, it should not. You are supposed to make a copy of the config.inc.php file and call it config.php. It's in the Installation instructions although it isn't exactly clear either Smile

. Really, either way will work.

SOTGMarine · New Member Joined: May 23, 2005 Posts: 10

Nope, .. crap.. still doesn't work. I saw you got it to work on this site Raven,.. how? the donations go through fine, but nothing shows up on the Donate-o-Meter and no IPN records come back.. Any suggestions? I'm patient and ready to work through this to figure it out. I'm sure there are plenty of people who want to see a resolution to this issue, as I've seen it on many-a-forum, including sourceforge.

Gimme what ya got, Raven and 64, I'm ready to tackle this thing.

SOTGMarine · New Member Joined: May 23, 2005 Posts: 10

In the translog table, the last two times i tested the IPN, they came back with the same results but different entries in the table:

Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
Logging events<br>

Then the second, most recent one:

Debug mode activated
Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
Logging events<br>

I doubt it's supposed to be in "Debug mode" is that an issue?

It is also, obviously, not populating the transactions table... I noticed on my version 1.0 I had installed before, that after I manually populated that table with an entry, I received a strange IPN reconcilliation from PayPal. It was totally off the wall and obsurd, but at least it communicated with me.

SOTGMarine · New Member Joined: May 23, 2005 Posts: 10

In modules/Donations/index.php

there are some lines of code that are blocked out, ... could that have anything to do with this?

// if( $tr_config['don_show_date'] )
$query_Recordset1 .= 'DATE_FORMAT( payment_date, \'%b-%e\' ) AS date, ';
// else
// $query_Recordset1 .= '\'\' AS date, ';
// if( $tr_config['don_show_amt'] )
$query_Recordset1 .= 'CONCAT(\'$\',SUM(mc_gross)) AS amt ';
// else
// $query_Recordset1 .= '\'\' AS amt ';

SOTGMarine · New Member Joined: May 23, 2005 Posts: 10

I'm pretty new to php, so I probably shouldn't be doing thiis on my own, but what exactly defines which recordset is which.

I notice that it refers to recordset 1 and recordset 3 all the time, and those are the databases that should be populated, but I'm looking through the code for something that defines which recordset is which, and I can't find anything.. I'm probably barking completely up the wrong tree... but I'm bored and I'm trying to fix this thing. grrrrr. It's amazing to me that you have no problems with this script, Raven. You seem to be the only person on the planet running this script successfully. You didn't encounter any problems?

SOTGMarine · New Member Joined: May 23, 2005 Posts: 10

Any help would be appreciated.

Thanks.

Raven · Posted: Mon May 30, 2005 11:18 pm

Well, after 2 grueling hours of debugging, I have determined the probable cause, but it looks like you will need to work with your host and possibly PayPal. Through debugging, I determined that you are receiving the following header back from PayPal when you try to reconnect to retrieve the payment data:

$res = HTTP/1.0 503 Service Unavailable

The data is posting correctly in PayPal but when your ipn script is called to retrieve the data, PayPal is sending "HTTP/1.0 503 Service Unavailable". It's a rather ambiguous message, but upon further investigation I found this thread at PayPal:

Only registered users can see links on this board!
Get registered or login to the forums!

And upon even more investigation, if you (your host) are using Squid as your redirection proxy, it seems to be a known problem and the solution, it seems, has to do with how you connect to PayPal via the proxy. Hopefully this will get you on the track to resolution.

SOTGMarine · New Member Joined: May 23, 2005 Posts: 10

Well that's not good news at all. Thank you for your help, I'll make a donation for your assistance. Hopefully I can figure this out with my host. It's GoDaddy.com though. .. I would imagine it would be a fairly well-known problem if everyone with godaddy was having this issue.

Raven · Posted: Tue May 31, 2005 5:30 am

GoDaddy is mentioned specifically in the research I did. Do a Google search for "paypal 503 Service Unavailable"

SnowSFO · New Member Joined: Jul 03, 2005 Posts: 8

Does anyone know where to get ver 1.1? the link to codewiz is broken. We have 1.0 setup, but it is not showing the donations. Everything else tests out fine. Want to try 1.1 and see if that fixes the problem. Thanks in advance.

Raven · Posted: Thu Jul 21, 2005 10:12 am

Try

Only registered users can see links on this board!
Get registered or login to the forums!

SnowSFO · New Member Joined: Jul 03, 2005 Posts: 8

Raven,Thanks alot. I had looked through all your downloads, but never saw it. We will set it up and see if that corrects the problem we are having.

Donovan · Client Joined: Oct 07, 2003 Posts: 691 Location: Ohio

Make sure you do not use the dbg=1 parameter in your PayPal IPN URL configuration. That puts the script into debug mode and it won't record anything.

inoculateit · New Member Joined: Aug 20, 2005 Posts: 10

Kewl you got some of the errors to dissapear, now there is only this:

Debug mode activated

PHP-Nuke Treasury mod

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------
Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
Selecting database...FAILED - err:
Executing test query...No Database Selected

manoe · Client Joined: Aug 14, 2005 Posts: 136

I too am having this issue. I run the test and it shows its all working. I set up the paypal info correctly. The only thing that I do not have set up is the Thank You and the Cancelled pages. I am not sure that matters or not.

I have made 3 paypments to paypal. I get the email saying they have been made but I see nothing on the website. I had the techs at Midphase set up the backend stuff and they said it should be good to go. I am at a loss here.

manoe · Client Joined: Aug 14, 2005 Posts: 136

Is anyone able to help me with this problem? I would be willing to give you access to my admin even. I cant get this working and I really am a beginner with PHP...

I would definately Donate fund your way Raven if you can jump in and help me here. I will be waiting an answer.

Oh here is the test that I ran. It too is in debug mode.

--------------------------------------------------------
Debug mode activated

PHP-Nuke Treasury mod

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------
Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
Selecting database...OK!
Executing test query...PASSED!
PayPal Receiver Email:

Only registered users can see links on this board!
Get registered or login to the forums!

events

----------------------------------------------------------------
If you don't see any error messages, you should be good to go!

mrmackey · New Member Joined: Nov 26, 2004 Posts: 12

same old problem i guess has this been resolved with the ipn reconcile

if so i am dammed if i can find it:)

everything set up fine and working just the 2 points which i have

1) still wont connect to ipn and update it
2) cant manual add either

am using nuke treasuery 1.1 as i said before everything went smothly till now Sad

have sorted it the easy way have unistalled and using a diff one not quite right what i want but it will do after all the heartache:)

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

I cant get the files to download from your site @ codewiz.com

I still get the donations block inside the survey as well.

finalheaven · Regular Joined: Jul 15, 2006 Posts: 64

I'm having the same issues with donations not being recorded.

I've fixed the copyright issue. I've fixed the Survey block issue. Now that I finally activated it, I'm getting an issue with donations not displaying.

I'll try searching for "paypal 503 Service Unavailable" and see if there's a solution there. Does this stuff really need to be this difficult and convoluted? My IPN tests all come back positive and AOK.

kypdr · New Member Joined: Feb 22, 2007 Posts: 17

I think I finally got my problem solved with the database connecting issues.

Mine:

Code:

include("../config.inc.php
");

Suppose to be:

Code:

include("../config.inc.php");

Now with that set I clicked the click here to test IPN
Everything checks out, but when I try to make a donation I get this error.

Quote:

Error Detected

We cannot process this transaction because there is a problem with the PayPal email address supplied by the seller. Please contact the seller to resolve the problem. If this payment is for an eBay listing, you can contact the seller via the "Ask Seller a Question" link on the listing page. When you have the correct email address, payment can be made at

Only registered users can see links on this board!
Get registered or login to the forums!

Question?
Can you use IPN with a personal account? I ask because the activate IPN under doesn't show up. But I did manage to find it using the help desk. But I'm not 100% sure if its setup.

Raven · Posted: Tue Mar 06, 2007 10:54 pm

Quote:

Mine:
include("../config.inc.php
");

Suppose to be:
include("../config.inc.php");

I actually addressed the config issue up towards the top of this page. Here is the correct way.

Raven wrote:

You are supposed to make a copy of the config.inc.php file and call it config.php. It's in the Installation instructions although it isn't exactly clear either Smile

.

kypdr · New Member Joined: Feb 22, 2007 Posts: 17

Does your Paypal account have to be a business or premium account to use an IPN or can you use a personal account.

2Bob · Hangin' Around Joined: Jan 24, 2006 Posts: 25

Hi Guys,

I had this module / block working fine for 12 months. Then last month someone donated and it did not show on the block or reconcile.
It definatly worked perfect in january , but in febuary it failed in the same way others above have discribed.

Nothing has changed on my side , although NOW i have updated to v1.1 today.

I read above "ravens" comments about "$res = HTTP/1.0 503 Service Unavailable " But this means nothing to a layman such as I.

Any suggestions on where I should start to look ?

Is this something my host could have changed? and if so what, and what? how do I find out? and what (how to word) do I say to them ?

Thanks in advance for any assistance.

wiz · Client Joined: Oct 09, 2006 Posts: 357 Location: UK

It Seems that this is a widespread issue. I am too struggling to get the Donations to show, even after manually adding them. Maybe my host is the issue Wink

Hopefully once RN76.2.1 is released. Raven will have time to work on RN_treasury.