Version 1.6.0 appeared to be messed up.



Version 1.6.0 appeared to be messed up.

Version 1.5.9 was renamed to 1.6.1 in order to exclude latest changes.

Sorry for this mess. I’ll let you know about the progress on multipriced posts soon.

77 comments to Version 1.6.0 appeared to be messed up.

  • I was wondering if your plugin can be used on template pages. For instance, I would like for the user to be required to pay before being allowed to view wp-signup.php

    If this is possible, can you explain how.

    Thank You =D

  • You can change your template to surround all the content wit are_paypal_pleaselogin tags. And add a blog price. Maybe this is a solution, but I am not sure.

  • Thanks for your response Aurimas. The code is my biggest problem. I don’t know what code to use. I can’t figure out how to convert the short code (pseudo code) into php format.

  • In this case the only solution to wait while I will implement this. I don’t know when I’ll have time – I am now very busy. And the next change in line is multipriced posts.

  • Hi again. Thanks for taking the time to respond to my questions and good luck with the next change. =D

  • Hello,

    I have a question. I’d like to publish some paid contents. But I want to sell subscriptions : the guy who buy it will have a full access to all the paid contents for 3 months. Can your tool do that ? And if yes, is it compatible with the payment for only one paid post ?

    Thx !

  • Yes. You can have a subscribe button. and you can configure the plugin in many different ways. there are post/page price which applies per post or page. Blog price which applies for all teh hidden content and there is a kinda bonus system which allows a complex configuration – user pays for one post/page but gets access to several posts/pages :)

  • Ok thanks.

    But how technically do I have to manage the guys who pays for 3 months ? Do I have to manually close their access at the end of the period ? I didn’t get this point.

    Also, is there a way to manage some subscriptions manually ? Like if I want to be paid by check notes (it’s for BtoB purpose, they’re used to pay this way).

  • At the end of the period they will be automatically charged by paypal. In case they will stop the subscription the content will go hidden.

  • Very helpful information helped a lot thanks.

  • Hello Aurimas,

    I am the webmaster and developer of Test Your Knowledge and I would like to ask about a problem I’m having,

    You see when someone clicks Buy Now it says link appears to be invalid so I checked the template and fixed it but it won’t save the fixed pieces, what can I do.

  • Something is wrong there with these templates HTML code is in between tags. It can be something goes wrong and templates and form hets ruined.

  • Hello Aurimas,
    Thank you for helping but I was using your plug-in on my blog at http://blog.testyourknowledgewebsite.com sorry about that.

  • Does this system support people who are not registered to paypal or no?

  • It supports paypal payments only. User must have paypal in order to pay for content.

  • Stefano

    the plugin 1.6.1 shows in the main page:
    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'expire) > CURDATE() OR expire is null OR expire = 0)' at line 1]
    SELECT users.* FROM . wp_are_paypal_users users WHERE (users.post_id=’-1′) AND users.user_id=’0′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)

    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'expire) > CURDATE() OR expire is null OR expire = 0)' at line 1]
    SELECT users.* FROM . wp_are_paypal_users users WHERE (users.post_id=’1′) AND users.user_id=’0′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)

    Into Are_paypal / paypal data on admin it shows the following:

    WordPress database error: [Table 'axelweb_wordpress.wp_are_paypal_paypal_requests' doesn't exist]
    select * from wp_are_paypal_paypal_requests

  • try to remove the plugin, plugins tables, and options and reinstall the plugin…

  • Stefano

    I tried several times, but it doesn’t work. I don’t think it’s a table problem, seems more of a syntax one. I run MySQL version 4.0.25-standard; PHP version 4.4.2; WP 2.7.

    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'expire) > CURDATE() OR expire is null OR expire = 0)' at line 1]
    SELECT users.* FROM . wp_are_paypal_users users WHERE (users.post_id=’-1′) AND users.user_id=’1′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)

    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'expire) > CURDATE() OR expire is null OR expire = 0)' at line 1]
    SELECT users.* FROM . wp_are_paypal_users users WHERE (users.post_id=’1′) AND users.user_id=’1′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)

  • Could you try to run those sqls by hand and check for syntax problems in there … I see “FROM . wp_” that “.” looks suspicious to me I have no idea how it appeared there…

  • Stefano

    ok. I tried to reinstall the plugin manually instead of using admin. The plugin created 3 tables:

    wp_are_paypal_bonus
    wp_are_paypal_items
    wp_are_paypal_paypal_field_types

    On “paypal data” it shows:
    WordPress database error: [Table 'axelweb_wp.wp_are_paypal_paypal_requests' doesn't exist]
    select * from wp_are_paypal_paypal_requests

    On “post prices”, under “purchasers”, on my only test post it shows:
    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'up.expire) > CURDATE() OR up.expire is null OR up.expire = 0)' ]
    SELECT user_login FROM wp_users u INNER JOIN wp_are_paypal_users up ON up.user_id=u.id and up.post_id=1 AND (ADDDATE(up.purchase_date, up.expire) > CURDATE() OR up.expire is null OR up.expire = 0)

    On my test post, after the title, as part of the body but bfore body text it shows:

    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'expire) > CURDATE() OR expire is null OR expire = 0)' at line 1]
    SELECT users.* FROM . wp_are_paypal_users users WHERE (users.post_id=’-1′) AND users.user_id=’1′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)

    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'expire) > CURDATE() OR expire is null OR expire = 0)' at line 1]
    SELECT users.* FROM . wp_are_paypal_users users WHERE (users.post_id=’1′) AND users.user_id=’1′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)

    I tried to manually run both:
    “SELECT users.* FROM . wp_are_paypal_users users WHERE (users.post_id=’-1′) AND users.user_id=’1′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)”

    and

    “SELECT users.* FROM wp_are_paypal_users users WHERE (users.post_id=’-1′) AND users.user_id=’1′ AND (ADDDATE(purchase_date, expire) > CURDATE() OR expire is null OR expire = 0)”

    and they both return the very same message:
    “#1064 – You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘expire) > CURDATE() OR expire is null OR expire = 0)’ at line 1 ”

    Since there is not wp_are_paypal_users and wp_are_paypal_paypal_requests I guess these error message might be explained by an imperfect table creation. I tried to install it several times and it doesn’t create these tables. Maybe the problem went unnoticed because if upgraded, the script keep running on previously created tables… or I don’t know.

  • try to clean you wp. delete the tables created and also entries starting are_paypal from options table

  • Stefano

    I did (including all are_paypal option this time). Same identical result.

  • STEVEVICORY

    where do I put my paypal email address so I get paid?

  • STEVEVICORY

    would be easier to use if there were a field on the admin page to enter paypal e-mail address for those of us who are not too technical & don’t know how to edit code.

  • Check page named “Are_PayPal Configuration” field “PayPal email”

  • Fortunately you do not need to edit code to put your paypal email. Any way it is fun to write code … Code is poetry …

  • Aurimas,

    I am thinking about starting a new wordpress site and was wondering how your plugin effects the feeds. If someone has the feed address, can they see the content even if they have not paid? If not, will people who have paid be able to access the feeds using their feed/news readers? I would love for my subscribers to be able to access my feeds.

    Just curious how that worked.. Thanks

    Wayne

  • That is not tested properly. Coulde you do this for all the are-paypal users …

    I am 90% sure the plugin should do the trick …

  • Dear Sirs,

    I’m eager to use your plug in.

    Though I cannot afford the risk if it is not validated for 2.8.2.

    Please tell me asap when it is safe to install.

    Thanks

    Stef

  • You can use it but first try the routine with paypal sandbox.

  • Thanks,

    I now realize that it is extremely difficult to understand how it works without a notice. Could you provide one?

  • oops, sorry, there IS one.

    I’m reading it right now.

  • Dear Aurimas,

    I don’t get anywhere I’m just lost and I really don’t understand how it works.

    The way I see it, I’m ready to pay whatever it -reasonably- cost, but I cannot bleed time over a plugin, whatever useful and tempting it could be.

    If you can provide me with a solution or a service I’m willing to pay for it, but if I have to go through guess and test work for hours I’ll just look for something else.

    Stef

  • Trying to input the email for paypal as well as a login discription and subscribe discription… when I press update, nothing happens. I’ve uninstalled, cleared the database (even wp_options) still can not get this to work. Looks like something in the code is broken.

  • Try to use some other browser … It can be text areas which contains the html code somehow works wrong way…

  • Thank you, did the trick. Wonder why it isn’t working right with IE8…

  • prime

    Hello,

    When clicking on any menu items in the admin menu, all I see is the follwing text:
    Are you sure you want to do this?

    Is this a problem with WP 2.8?

    Thanks.

  • what browser do you use

  • prime

    Thanks for the quick reply.
    I usually use Firefox 3.5.2 and I just realized that the admin pages do display in Internet Explorer 8. However, even in IE 8 the “paypal data” doesn’t work (it’s blank). Same for Chrome.

    Thanks.

  • I found that the admin pages for are paypal don’t display right in IE 8 and need to be viewed through Firefox. I’m using 3.5.3. Try updating your FireFox. =]

  • Hello and thank you for creating this free plugin. I am trying to determine if it will fulfill my needs and I have a question.

    I need to have a paypal button on a page that has content which “is” visible to everyone. Then, when the user clicks and makes payment, they are given access to pages and articles that are hidden from others.

    Check: http://www.angermanagement-techniques.com/anger-reduction
    to see an example of what I mean.

    But that paid content has to be completely hidden, links and all. In other words, I can’t have people going to those pages and seeing a link that tells them they have to pay to see the content. Those whole pages just need to be invisible.

    Is this possible with your plugin?

  • Horacio

    After activating Are PayPal Version 1.6.1 on WordPress 2.9-rare, I get this error message at the beginning of all my posts:

    WordPress database error: [Duplicate entry '_transient_rewrite_rules' for key 1]
    INSERT INTO `fig_options` (`option_name`,`option_value`,`autoload`) VALUES (‘_transient_rewrite_rules’,”,’yes’)

    When Are paypal is deactivated, the error message does not show anymore.

  • Unfortunately this is not possible yet. I will impolement this and the other functionalities in some time.

  • I will investigate this. Try to deactivate all other plugins but are-paypal.

  • Horacio

    Thanks, Aurimas

    PayPal Version 1.6.1 on WordPress 2.9-rare with no other plugins works well.

    _____________________________________
    After activating Are PayPal Version 1.6.1 on WordPress 2.9-rare with other plugins, I get this error message at the beginning of all my posts:

    WordPress database error: [Duplicate entry '_transient_rewrite_rules' for key 1]
    INSERT INTO `fig_options` (`option_name`,`option_value`,`autoload`) VALUES (’_transient_rewrite_rules’,”,’yes’)

    When Are paypal is deactivated, the error message does not show anymore.

  • Horacio

    Are PayPal Version 1.6.1 on WordPress 2.9-rare conflict with Post Country Plug-in

    http://wordpress.org/extend/plugins/post-country/
    giving error explained above

  • Hi, I’ve set up the sand box and am testing out the plugin. I gave the entire blog a price, as opposed to an individual post. I went through the process with the sandbox and it all worked, except that I can’t see the protected content – it still asks to subscribe. I should be able to see all posts now, right?

  • I hope you forgot this … Check how to use section … This is just copy paste from my test blog …
    How to configure paypal’s Instant Payment Notification (IPN)?

    * Follow the link
    * Set IPN “On”
    * Set IPN Url to ‘http://testapp.ehibou.com/wp-content/plugins/are-paypal/are-paypal-ipn.php

  • Its all set up how you describe, but when I return to the site the content is still not available. It should work in the test environment, right?

  • yes. check if you can see any activity under PayPal data. All the pings from paypal ipn service must be logged there

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>