Block not updating, payments go through fine. Reply to topic

Hello. I've seen this question asked a few times before, but after a few days of searching I haven't been able to come across a solution. I'm hoping someone can help me out. It may be a stupid mistake on my part, but I just don't see it.

I have a clean install of Treasury running on a clean install of Dragonfly
v 9.0.5.0.
I installed the module first, through the admin panel, then the block.
I have upgraded my PayPal to a Business account.
Clicking the IPN test link gives me 100% OK.

Donations succeed through, and then I refund them. Everything works perfectly except for the block updating. I've also tried adding one entry first, per someone's idea here, no luck.

Here are my settings:

URL for Return Page: www.myDomain.com/index...e=ipntreas
URL for IPN Notification: www.myDomain.com/index...e=ipntreas

Website Payment Preferences

Auto Return: Off
Return URL:
Payment Data Transfer: Off
Identity Token:
Block Non-encrypted Website Payment: Off
PayPal Account Optional: On (I have tried Off)
Contact Telephone Number:Off (PayPal recommends this option)

Instant Payment Notification Preferences

Instant Payment Notification (IPN) On
Instant Payment Notification (IPN) URL: http://www.mydoimain.com/index.php?name=Treasury&file=ipntreas

Payment Receiving Preferences:

Block payments from U.S. users who do not provide a Confirmed Address: No

Block payments sent to me in a currency I do not hold:
No, accept them and convert them to U.S. Dollars

Sorry for the long post, just trying to be thorough I would
appreciate any help. Thanks.

admin.php?op=Treasury
Click the "Config" button
Check your settings for "Donat-o-Meter Config"

Especially for "Swing Date", where a value of say, 3, will stop payments for September being shown until 3 September, so that late August donations get displayed for a few days.

admin.php?op=Treasury
Click the "Config" button
Check your settings for "Donat-o-Meter Config"

Especially for "Swing Date", where a value of say, 3, will stop payments for September being shown until 3 September, so that late August donations get displayed for a few days.

Hello and thank you for your interest Phoenix

At the end of August, yesterday, I had the Swing Date set to 3, because I was under the assumption that the payments for August that we were testing would still be shown until the 3rd of September. Is that correct usage?.

Per your suggestion I have lowered it to 1, now that it is September. I will have my firend try it out ASAP, since I can't send payments to myself... doh

hmm, your understanding and useage was correct, and your PayPal settings appear correct, so I am at a loss to explain why your block doesn't display data.

Presumably this also means the data is not being recorded in your database?

Phoenix wrote

hmm, your understanding and useage was correct, and your PayPal settings appear correct, so I am at a loss to explain why your block doesn't display data.

Presumably this also means the data is not being recorded in your database?

As far as the database... I'm no expert so please bear with me...

It looks like there were 5 total tables created:

cms_treas_cfg cms_treas_currency cms_treas_finance cms_treas_trans cms_treas_translog

From looking at the individual tables, it looks as if cms_treas_finance and cms_treas_trans are the only two of significance here.

cms_treas_finance seems to hold data for PayPal IPN reconcile and cms_treas_trans is the one that holds data for the donation block?

cms_treas_trans seems to update correctly when I manually add a donation. I can add/delete/edit with no problems. I currently have one entry which is the one that I manually added. It just seems that it won't do it automatically.

In my cms_treas_translog I have 10 entries which all say either:

Opening connection and validating request with PayPal... OK! Logging events

OR

Debug mode activated Opening connection and validating request with PayPal... OK! Logging events

Am I missing any tables? Anything seem out of place? I've also tried to uninstall and reinstall Treasury.

One thing that I am questioning is my PayPal account. TO the best of my knowledge, I did upgrade to a free business account... that is sufficient correct? The next step up costs 30 bucks a month. There IS one piece of information that I did not provide PayPal with and that is my SSN# that they ask for in order to lift some $500 limit on bank transfers or something. It only said "recommended" and didn't think it was necessary to Treasury working.. please correct me if I'm wrong.

Lastly, thanks for taking the time to help me out. The instructions are so simple and others have it working fine, so it must be a simple user error that I am not catching, hopefully.

Thanks alot and I look forward to any replies

Sorry for the delayed response.

Your observations of the table construction and function is correct.

You only require the 'free' paypal account to operate and your SSN shouldn't affect anything.

I can't see anything obvious to prevent it working

Hey no problem bro. I appreciate the help regardless of when you answer. I'm sure you have alot of things on your plate with DF.

I do have one idea, but would like some input from you.

I was recently trying to install a status script for Ventrilo on my website, but it would not work, even after following all directions to the letter. After a few posts on the Ventrilo site, the conclusion was that, the outgoing ports that are necessary to conduct the status check of the Ventrilo server, were being blocked by my webhost.

I am currently with godaddy hosting. Do you think that this could possibly be the source of my problems with your module? Could blocked ports possibly be the culprit? Would you perhaps, know of anyone using your module with godaddy hosting?

I have gone back and triple-checked every one of my settings and simply cannot find fault with my PayPal settings nor your module settings. I am simply at a loss to explain it, so I guess that makes two of us.

I don't mind manually updating the block with any donations we may receive, since it is just a small clan gaming site, with no real traffic. It's a great module and works great otherwise. It's just not 'automatic' for me, but no big deal.

Anyways, let me know if you come up with any ideas. I can also give you admin access to my website in case you feel like it would help with troubleshooting. Thanks for the help Phoenix.

hmm, a web host can certainly create an issue.

I have the module set up for sandbox testing, which you can do yourself after signing up to their development site, and it also has some great support forums.

However, since I already have the facility, I can also check yours by temporarily changing a couple of settings in your Treasury admin panel, so just PM me with a user/password for admin access to the Treasury module and I'll check it out.

I'm having the same issue. I've setup my config and it accepts payments but autoreconcile doesn't work and block shows nothing. No errors with ipn.

It looks like everything is working as it should I don't get it.

I noticed in phpmyadmin that there isn't a primary key for a lot of the tables. It popped up little title boxes and said a primary key is recommended. worth looking into.

I've tried changing the ipn address from http:// to www because it doesn't include that in there by default. still didn't work.

i'm at a loss for what is going on with it. are there any settings in the files that i have to change manually?

what does auto reconcile do anyway? it looks like it should grab the payment data from the paypal account or cross reference it with data you input manually. once someone donates how does that info get into the admin module. does it have to be input manually. sorry mine isn't working so i dont know how it's supposed to work or how to fix it.

Autoreconcile has nothing to do with the donation process - it's merely a mechanism for tidying up the financial tracking aspect within the database. If you don't have IPN transactions recorded, there is nothing to reconcile.

Only the config table has no primary key - not sure about the 'lot of tables' you are looking at.

If you are not receiving payments then you need to check you have followed all install instructions as detailed in install.txt.

If users fail to click the 'Continue' button at the end of the process, the IPN transfer will not be completed, but Paypal will still provide you with an email containing the relevant details for manual entry through admin.

Well how does it get entered into the block? Do I have to add them manually? I figured it happened automatically somehow in which case it's not working.

I've had 3 people donate so it is working. I have 3 donations registered in paypal. They are sitting in there and I've set the IPN to what the install says.

Just wanted to update real quick for ya Phoenix... and I guess you too DJ Devon..

It turns out that it was my webhost causing problems. I'm not sure of what exactly they were doing, but I suspect the blocking of some necessary ports.

For example, I was also trying to use a Ventrilo status script on my site, and had the same same symptoms. Everything was setup correctly, I double-checked, triple-checked... everything was kosher. After contacting Ventrilo support, the only theory left was that my webhost was blocking necessasy ports. After switching webhosts, my Ventrilo status script worked flawlessly, as does your Treasury mod.

My previous webhost was Go Daddy Economy hosting. I suppose it was my fault in a way, for going with cheap hosting ($3.95/mo) but my current webhost is even cheaper, with way more features AND everything works as intended.

So, my apologies Phoenix. I hope I haven't caused you too much trouble in the way of support. I know you went out of your way to help and I appreciate that. I don't usually ask for help, but I was racking my brain on this one. Thanks again for great support and an excellent module for DF.

I hope this helps you also DJ Devon. If you can swing it, you may want to try another webhost. My current webhost is Cubichosting. I only mention them because their support has been more than top notch and I highly recommend them. There's no affiliate program, so I make nothing. Just trying to give them good word-of-mouth for being a good host.

Peace all.

No trouble at all - I'm pleased it was what I suspected, so many thanks for the feedback. The sandbox is pretty handy for verifying functionality.

Enjoy

I finally got it working by reinstalling it twice. For some reason it just started picking up the reconciles and donations. go figure. i have another issue but i'll make another post about that.