Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (A-GATE, Jake), 29 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/09/11
Posts: 140
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 4 1 2 3 4 >
Topic Options
#215597 - 07/18/08 10:30 PM Paypal Subscription
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Hi all,

I updated my forum to 7.3.1 prior to my move to a new server in the USA and since then people making subscriptions are not showing up as active only pending.

Yet in my paypal account the payment has been approved. Usually the process only takes around 15 minutes to go through and be active on the forum.

If anyone has any information on how to correct this it would be appreciated.
_________________________
Regards,

Bruce
www.outdoorking.com
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#215637 - 07/20/08 12:04 PM Re: Paypal Subscription [Re: Outdoorking]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It could be that you haven't activated IPN on the paypal side. Here's the steps you need to follow:

In order to use PayPal for automated subscriptions you must perform the following steps:

1. Log in to your Business or Premier account in Paypal.
2. Click the Profile subtab.
3. In the Selling Preferences column, click the Instant Payment Notification Preferences
link.
4. Click the Edit button.
5. Select the checkbox to activate IPN.
6. In the Notification URL text box, you can either leave this blank or enter the url to the paypal-ipn script, ie. http://www.ubbcentral.com/forums/ubbthreads.php?ubb=paypal-ipn
7. Click the Save button.
Top
#215643 - 07/20/08 05:44 PM Re: Paypal Subscription [Re: Rick]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Thanks Rick for you help it is greatly appreciated.
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#215645 - 07/20/08 06:37 PM Re: Paypal Subscription [Re: Outdoorking]
JAISP Offline
old hand
Registered: 02/10/07
Posts: 1144
I set it up, now I hope my members send me some money to help pay for the new server I'm putting it on, lol.
Top
#215648 - 07/20/08 07:44 PM Re: Paypal Subscription [Re: JAISP]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
In actuality, you don't need to activate it in paypal and here is the reason why i haven't done so.

i have multiple IPN locations and paypal IPN activation sets you up for one site address.

it also doesn't let you just activate it and leave the site blank, sooo you're kinda screwed there.

you'd be ok, if you're receiving all the goods from one URL however..

i leave it 'deactivated', but paypal plays nice with ubbthreads and responds to the proper URL, because Ricks interface tells it where to respond to.. this has been tested to work fine on 5 7.3.1 sites i am involved with..

just my :2c:
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#215650 - 07/21/08 12:06 AM Re: Paypal Subscription [Re: SD]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Thanks Rick and guys for your help, I will be testing today to see if all is ok.

I did not realise that the site move would cause so many different issues but it is a learning curve and thank god all the members here are so helpful with good advice. smile
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#215803 - 07/24/08 06:21 AM Re: Paypal Subscription [Re: Rick]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Originally Posted By: Rick
It could be that you haven't activated IPN on the paypal side. Here's the steps you need to follow:

In order to use PayPal for automated subscriptions you must perform the following steps:

1. Log in to your Business or Premier account in Paypal.
2. Click the Profile subtab.
3. In the Selling Preferences column, click the Instant Payment Notification Preferences
link.
4. Click the Edit button.
5. Select the checkbox to activate IPN.
6. In the Notification URL text box, you can either leave this blank or enter the url to the paypal-ipn script, ie. http://www.ubbcentral.com/forums/ubbthreads.php?ubb=paypal-ipn
7. Click the Save button.


Rick,

Here is the information regarding my paypal which is on a Linux server:

Instant Payment Notification (IPN) On
Instant Payment Notification (IPN) URL: http://www.outdoorking.com/forum/ubbthreads.php?ubb=paypal-ipn

The members are not being activated just sit as pending.

Do I need to change any other files for it to work as it all worked great on a windows server prior to the shift.

Any help would be appreciated as it is getting really frustrating.
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#215814 - 07/24/08 03:29 PM Re: Paypal Subscription [Re: Outdoorking]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
The script name is actually wrong, my fault, but not exactly sure that's the issue, because we send them the URL to notify when a request is made. However, since it's declared there it might be overriding it.

The script name should be paypal_ipn instead of paypal-ipn.

Other than that, the only thing that could be preventing this is if your php configuration doesn't allow an fsockopen call (you might want to check with your host on that).
Top
#215822 - 07/24/08 06:38 PM Re: Paypal Subscription [Re: Rick]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Rick,

I have changed the link with paypal and will check with my host today regarding the fsockopen.

Thanks for your assistance again.
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#215823 - 07/24/08 09:10 PM Re: Paypal Subscription [Re: Outdoorking]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Your host is likely blocking fsockopen; i've seen a lot doing this for "security"
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#215827 - 07/24/08 09:17 PM Re: Paypal Subscription [Re: Gizmo]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
we should add a little fsockopen test in the admin cpanel, kinda like the captcha preview dealio..
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#215832 - 07/25/08 02:08 AM Re: Paypal Subscription [Re: Rick]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Originally Posted By: Rick
The script name is actually wrong, my fault, but not exactly sure that's the issue, because we send them the URL to notify when a request is made. However, since it's declared there it might be overriding it.

The script name should be paypal_ipn instead of paypal-ipn.

Other than that, the only thing that could be preventing this is if your php configuration doesn't allow an fsockopen call (you might want to check with your host on that).


Rick I have checked with paypal and the payments are going through ok but still sitting as pending on the forum. The web host is saying that fsockopen call is not restricted.

They are pointing to the software or Host which is running Linux.

Would it have anything to do with the MySQL data base as the files had to be changed from lower case to upper case in order for the forum to work.

I have noticed this error in my log but don't know if it has anything to do with paypal:


Script:

/home/content/o/u/t/outdoorking/html/forum/scripts/grabnext.inc.php - Line: 194
SELECT t2.POST_ID,t2.TOPIC_IS_STICKY
FROM ubbt_POSTS as t1,
ubbt_TOPICS as t2
WHERE t2.FORUM_ID = 11
AND t2.TOPIC_IS_STICKY='0'
AND t2.TOPIC_LAST_REPLY_TIME < 1214139872
AND t1.TOPIC_ID = t2.TOPIC_ID
ORDER BY t3.USER_DISPLAY_NAME desc
LIMIT 1
- Unknown column 't3.USER_DISPLAY_NAME' in 'order clause'


Edited by Outdoorking (07/25/08 02:22 AM)
Edit Reason: update
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#215833 - 07/25/08 02:44 AM Re: Paypal Subscription [Re: Outdoorking]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
hrm.. that might be totally unrelated to paypal.. but also might be a bug in other stuff laugh
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#215841 - 07/25/08 10:40 AM Re: Paypal Subscription [Re: SD]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
I think we're going to need a support ticket for this one. Since it sounds like it was working before the move to the new server and now it's not it's kinda hard to say what it is.
Top
#215843 - 07/25/08 12:51 PM Re: Paypal Subscription [Re: Rick]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
he also moved from outdooking.com.au to plain ole outdoorking.com

_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#215967 - 07/29/08 04:09 AM Re: Paypal Subscription [Re: Rick]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Originally Posted By: Rick
I think we're going to need a support ticket for this one. Since it sounds like it was working before the move to the new server and now it's not it's kinda hard to say what it is.


Rick I have submitted a support ticket.
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#216220 - 08/04/08 05:04 PM Re: Paypal Subscription [Re: Rick]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Originally Posted By: Rick
I think we're going to need a support ticket for this one. Since it sounds like it was working before the move to the new server and now it's not it's kinda hard to say what it is.


Rick,

I have submitted a ticket some time back but have not had a reply yet.
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#216879 - 09/08/08 05:37 PM Re: Paypal Subscription [Re: Rick]
Outdoorking Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Sydney, Australia
Hi all,

I have installed zencart software on my site and it works with paypal no problems so I thinking that since the move from one server .com.au to .com maybe causing the issue that I have with the forum regarding paypal payments.

The other thing is that it was on a windows server and then moved to a Linux server.

Any help would be appreciated.
_________________________
Regards,

Bruce
www.outdoorking.com
Top
#223735 - 03/07/09 04:53 PM Re: Paypal Subscription [Re: Outdoorking]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Available Subscription Groups
Version 7.4.1

I don't seem to be able to get "Trial Settings" Set-up
to show in the Available Subscription Groups Page.

(Ive amended a donation setting to trail and the donation
subscription will not show in the list ?)

Allow a trial period: Ticked
Trial Amount: 2:00
Trial Period: 1 Month

Donations will work
And Subscription Settings will also show up.

Ive enabled the IPN in Paypal and added my url with this.
/ubbthreads.php?ubb=paypal-ipn

I'm trying to test this before i go live with it.


Edited by Mark S (03/07/09 04:57 PM)
Edit Reason: added version number
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223737 - 03/07/09 04:57 PM Re: Paypal Subscription [Re: Mark S]
JAISP Offline
old hand
Registered: 02/10/07
Posts: 1144
I thought it was "paypal_ipn".
Top
#223738 - 03/07/09 04:58 PM Re: Paypal Subscription [Re: JAISP]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
ok your right on that one lol
Updating my pay pal now lol

But i cant see that changing the fact that its not showing up?
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223739 - 03/07/09 05:00 PM Re: Paypal Subscription [Re: Mark S]
JAISP Offline
old hand
Registered: 02/10/07
Posts: 1144
The Pay Pal stuff needs tons of work, It works for some sites and not others. It should work equally on every site. It is very lacking.

Perhaps this may get addressed and fixed someday.
Top
#223740 - 03/07/09 05:03 PM Re: Paypal Subscription [Re: JAISP]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
do you have the trial period working on your sites ?

Next question as i'm still setting all this up,

Anuual Subscriptions No PENDING 03/07/09 09:26 PM

How long is it going to say PENDING in my Subscriptions Page ?

What i done was tested it went to pay pal and just canceled it.
Will they dissapear soon enough or stay there and be a pain?
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223742 - 03/07/09 06:04 PM Re: Paypal Subscription [Re: Mark S]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Pending will remain on your subscriptions page for 24 hours.
Top
#223744 - 03/07/09 06:06 PM Re: Paypal Subscription [Re: Rick]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Oh, and if there is ONLY a trial period with no actual subscription then it won't show.
Top
#223747 - 03/07/09 06:44 PM Re: Paypal Subscription [Re: Rick]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
ok

So how does that work?
Do you have an example a can understand?

How does Trial Period and a cost work with the subscription
with a cost? I'm not getting it.

> Scratches Head <

What's your thinking on the Trial period box?
How does that fit in?

thanks
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223750 - 03/07/09 06:53 PM Re: Paypal Subscription [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
ok

1 month trial say £1
12 Month subscription £10

What would happen after the 1 Month ?
Is the users account charged £10 or is it a manual thing
they have to re-submit the subscription.

I'm asking to the end how would a member cancel say
after 20 days and not wanting to go into the 12 month.

What would they do and if any thing would i have to do.

thanks
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223758 - 03/07/09 07:17 PM Re: Paypal Subscription [Re: Mark S]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
We are starting to see a lot of questions on this feature with little documentation.
Maybe since this is a monetary thing this feature should be in it's own forum.
_________________________
Blue Man Group
Top
#223760 - 03/07/09 07:32 PM Re: Paypal Subscription [Re: Ruben]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
That's what ive asked for in the past as were dealing with money and members in one swoop not the best mix.

A Subscriptions forum
A Permissions forum too.

Im stuck testing it as its late in the UK and no one is on line
with a dam pay pal account.

I registered for a pay pal sand box but i will be buggered
if i understand how that works,
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223766 - 03/07/09 09:55 PM Re: Paypal Subscription [Re: Mark S]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
Yeah, I registered a sand box as well, but the forms they have you fill out to test a transaction are rather cryptic. I managed to get it to connect to my server and update the database, but it was put in as pending; I had to approve it.
_________________________
Marching Percussion ( Drumline ) Community
Top
#223776 - 03/08/09 08:03 AM Re: Paypal Subscription [Re: DLWebmaestro]
JAISP Offline
old hand
Registered: 02/10/07
Posts: 1144
The Pay Pal subscription on my site does not work. When someone tries to do a subscription it will show as pending even though the transaction has went through. If I do not manually edit the data base it will stay pending forever not allowing the subscription to be active.

I turned off the subscription stuff on my site just for this reason as you can not do anything with it unless you edit the database directly using PHPMyAdmin. Rick has in the thing that you need to make all the adjustments in PayPal but if it does not communicate with the message board and or you can not make the changes in PayPal that you need to make then it is pretty much useless to us or have.
Top
#223777 - 03/08/09 09:47 AM Re: Paypal Subscription [Re: JAISP]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
I got one of my members to test out the donation part of it
and it worked a treat.

Sorry yours is not working Thelockman.

Ive decided to go down the road of an enhanced account
as in more pm's and images in signatures for a donation.

Will see how that pan's out and then i may have to look
at the subscriptions thing, but i would like to know
how the trial and subscription work together?

What happens when the trial is over?
Is it automated and the next payment of a full subscription taken?
Or will a user have to manually agree to the next part?
And can a user cancel before the subscription begins while
in a trial period?

Rick ? Anyone?
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223778 - 03/08/09 11:42 AM Re: Paypal Subscription [Re: Mark S]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
When a user signs up for a trial, they can cancel anytime during that trial and that's it. If they keep their trial active the entire length then it will automatically turn into the full subscription that you have setup.

This is one of the things where the inline documentation is definitely needed.

Anyone having problems with it where it's sticking as pending I'd certainly like to help as I'd like to make sure everything is workng as it should be. When it gets stuck at pending that means paypal hasn't posted back to the paypal_ipn script for some reason.
Top
#223784 - 03/08/09 01:26 PM Re: Paypal Subscription [Re: Rick]
JAISP Offline
old hand
Registered: 02/10/07
Posts: 1144
I pretty much gave up on it. No documentation and do not wish to spend hours playing around with PayPal and the message board.
Top
#223785 - 03/08/09 03:25 PM Re: Paypal Subscription [Re: JAISP]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
cheers rick smile

Its getting a little clear now.
I'm treading softly so i'm not making any mistakes.

But up to now its working sweet and its doing what it says
on the tin for my Donations Set up.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223792 - 03/08/09 06:58 PM Re: Paypal Subscription [Re: Mark S]
JAISP Offline
old hand
Registered: 02/10/07
Posts: 1144
Originally Posted By: Rick
When it gets stuck at pending that means paypal hasn't posted back to the paypal_ipn script for some reason.


I have checked the MySQL database and see PayPal has sent back through the "paypal_ipn" as the information is in the database and nothing is missing. Like I stated earlier is that is remained "Pending" untill I manually edited the database and then it went into an active subscription. After the subscription period ran out it remained "Active" for those users and still remains that way today. Those subscriptions ran out in December.

Like I said unless you have a way to do it in the message board software and not through PayPal it is cumbersome and really more of a hassle then it is worth. If you wish to setup a test board or use the area I had set aside for you several months ago and test and play with it feel free to do so but other then that unless you can control it through the Administration Control Panel I'm pretty much done with that idea, like I stated repeatedly it is to much of a hassle.
Top
#223794 - 03/08/09 07:33 PM Re: Paypal Subscription [Re: JAISP]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
humm me gonna test that one out !
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223800 - 03/08/09 11:03 PM Re: Paypal Subscription [Re: JAISP]
Basil Offline
addict
Registered: 08/18/06
Posts: 685
Loc: Southwest US
Originally Posted By: Thelockman
Originally Posted By: Rick
When it gets stuck at pending that means paypal hasn't posted back to the paypal_ipn script for some reason.


I have checked the MySQL database and see PayPal has sent back through the "paypal_ipn" as the information is in the database and nothing is missing. Like I stated earlier is that is remained "Pending" untill I manually edited the database and then it went into an active subscription. After the subscription period ran out it remained "Active" for those users and still remains that way today. Those subscriptions ran out in December.

Like I said unless you have a way to do it in the message board software and not through PayPal it is cumbersome and really more of a hassle then it is worth. If you wish to setup a test board or use the area I had set aside for you several months ago and test and play with it feel free to do so but other then that unless you can control it through the Administration Control Panel I'm pretty much done with that idea, like I stated repeatedly it is to much of a hassle.


I have had generally good luck with the system EXCEPT (and Rick, I think this was discussed a few versions ago), it seems I have that problem of it sticking on Pending when the person uses an "eCheck" instead of a straight Paypal transaction from their PayPal account or a Credit Card.

Now, as it happens, I have a fellow who just today signed up for a subscription via Paypal using an eCheck. When I look at my Pay Pal account I can see the check is still "pending" with expected completion date of 11 March (3 days from now). It will be interesting to see if the subscription database updates once the eCheck has cleared. Right now my Database says "PAYMENT PENDING". I'll report back,

Basil
Top
#224436 - 03/20/09 01:16 PM Re: Paypal Subscription [Re: Basil]
pinkmelon Offline
journeyman
Registered: 03/19/09
Posts: 64
I have used this subscription feature before and it works very well. It is fantastic.
The problem is that Paypal did not like my kind of site and turned me off.
Would be nice if this worked with other payment options.
Top
Page 1 of 4 1 2 3 4 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image