Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » Treasury and Supporters » Block not updating, payments go through fine.
Block not updating, payments go through fine.
For managing donations, site expenses and supporters - further enhancements only in the Donations Pro version.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  eCommerce » Treasury and Supporters

View previous topic :: View next topic  
Author Message
sohi440
Nice Poster
Nice Poster

Offline Offline
Joined: Aug 31, 2005
Posts: 5

PostPosted: Thu Sep 01, 2005 12:24 pm
Post subject: Block not updating, payments go through fine.

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. Embarassed

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:

Quote::

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


Website Payment Preferences
Quote::

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
Quote::
Instant Payment Notification (IPN) On
Instant Payment Notification (IPN) URL: http://www.mydoimain.com/index.php?name=Treasury&file=ipntreas

Payment Receiving Preferences:
Quote::
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 Smile I would
appreciate any help. Thanks.


sohi440 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Thu Sep 01, 2005 7:29 pm
Post subject: Re: Block not updating, payments go through fine.

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.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
sohi440
Nice Poster
Nice Poster

Offline Offline
Joined: Aug 31, 2005
Posts: 5

PostPosted: Fri Sep 02, 2005 1:19 am
Post subject: Re: Block not updating, payments go through fine.

Quote::
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 Very Happy

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 Rolling Eyes


sohi440 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Fri Sep 02, 2005 5:50 am
Post subject: Re: Block not updating, payments go through fine.

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's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
sohi440
Nice Poster
Nice Poster

Offline Offline
Joined: Aug 31, 2005
Posts: 5

PostPosted: Fri Sep 02, 2005 8:17 am
Post subject: Re: Block not updating, payments go through fine.

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:

Code::
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:

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

OR

Code::
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 Smile


sohi440 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Wed Sep 21, 2005 9:01 pm
Post subject: Re: Block not updating, payments go through fine.

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 Confused


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
sohi440
Nice Poster
Nice Poster

Offline Offline
Joined: Aug 31, 2005
Posts: 5

PostPosted: Thu Sep 22, 2005 4:06 am
Post subject: Re: Block not updating, payments go through fine.

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. Cool

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. Laughing

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. Very Happy


sohi440 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Thu Sep 22, 2005 6:03 am
Post subject: Re: Block not updating, payments go through fine.

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.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
djdevon3
Nice Poster
Nice Poster

Offline Offline
Joined: Mar 30, 2005
Posts: 10

PostPosted: Tue Sep 27, 2005 7:22 pm
Post subject: Re: Block not updating, payments go through fine.

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. Sad


djdevon3 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Tue Sep 27, 2005 9:29 pm
Post subject: Re: Block not updating, payments go through fine.

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.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
djdevon3
Nice Poster
Nice Poster

Offline Offline
Joined: Mar 30, 2005
Posts: 10

PostPosted: Wed Sep 28, 2005 9:42 pm
Post subject: Re: Block not updating, payments go through fine.

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. Sad


djdevon3 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
sohi440
Nice Poster
Nice Poster

Offline Offline
Joined: Aug 31, 2005
Posts: 5

PostPosted: Fri Sep 30, 2005 5:38 am
Post subject: Re: Block not updating, payments go through fine.

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

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. Cool

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. Laughing Just trying to give them good word-of-mouth for being a good host.

Peace all.


sohi440 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Fri Sep 30, 2005 5:42 am
Post subject: Re: Block not updating, payments go through fine.

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 Smile


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
djdevon3
Nice Poster
Nice Poster

Offline Offline
Joined: Mar 30, 2005
Posts: 10

PostPosted: Thu Oct 06, 2005 4:22 am
Post subject: Re: Block not updating, payments go through fine.

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.


djdevon3 please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  eCommerce » Treasury and Supporters
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum