24 thoughts on “Are PayPal 1.7.3 version was released

  1. ryan

    Thank you very much, this is what I am highly expected ! Will help you broadcast this nice software!

  2. ryan

    after update from 1.7.1 to 1.7.3, from admin panel, checking post price page, this error was observed.

    WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay]
    SELECT posts.ID,posts.post_title, items.* FROM wp_posts posts LEFT OUTER JOIN wp_are_paypal_items items ON items.post_id=posts.id WHERE posts.post_content LIKE ‘%[Are_PayPal_LoginPlease]%’ AND (posts.post_type=’post’ OR posts.post_type=’page’ OR posts.post_type=”)

  3. ryan

    since I am using webhosting from netfirms, so it is impossible to change mysql server setting for me. Your explain is make sense, but I think using shared webhosting are popular, is there work around?

  4. Aurimas Post author

    First of all check your hostings mysql settings via phpmyadmin to be sure.

    Google for examples how to set those parameters using php mysql script.

  5. The Local Landing

    I’m getting emails from paypal saying:

    Please check your server that handles PayPal Instant Payment Notifications (IPN). IPNs sent to the following URL(s) are failing:

    http://www.thelocallanding.net/wp-content/plugins/are-paypal/are-paypal-ipn.php

    If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf. Please contact your service provider with the above information. If this problem continues, IPNs may be disabled for your account.

    Thank you for your prompt attention to this issue.

    I haven’t used this plugin on my blog in some months, and the folder has been removed along with all the files, as far as I can tell. Is there something that would make this error happen, some file that might be left somewhere that I can’t find?

    Please help…

  6. Aurimas Post author

    Go to your paypal account. somewhere in merchant tools is ipn configuration form. In that form you will probably find this url. Disable IPN and delete this URL and this will solve your issue.

  7. Martin

    new users cannot subscribe receiving message from paypal:

    Invalid Regular period. You must specify valid values for the A3, P3, and T3 parameters for a subscription.

  8. Uncletadd

    I wold like to restrict some posts and custom fields to paid members only. I have a custom field called Videos. What do i deed to edit for Arepaypal to restrict this field.

  9. Joey

    Is this able to automatically create a subscriber account upon successful payment? I’ve hooked it up and tested it, but I just get an IPN successful email. I’m just looking for something basic, use the email as the username and generate a random password which is emailed to the user. Thanks

  10. Aurimas Post author

    No this plugin is not for this but it can be used for your purpose. Just hide all your content put a blog price on and you are 90% happy :)

  11. Dan

    Hi there – just upgraded to this version and now my pages are littered with SQL errors. I looked back through a few of the other posts but haven’t found my answer. I’ve tried deactivating, completely cleaning out my database of anything to do with are_paypal and reinstalling and I’m still met with the same errors.

    The error on my public site is:
    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 ‘WEEK) > CURDATE() AND up.expiration_unit = ‘W’ ) OR ‘ at line 9]
    SELECT up.* FROM wp_are_paypal_users up WHERE (up.post_id=’-1′) AND up.user_id=’1′ AND ( ( DATE_ADD(up.purchase_date, INTERVAL up.expire DAY) > CURDATE() AND up.expiration_unit = ‘D’ ) OR ( DATE_ADD(up.purchase_date, INTERVAL up.expire WEEK) > CURDATE() AND up.expiration_unit = ‘W’ ) OR ( DATE_ADD(up.purchase_date, INTERVAL up.expire MONTH) > CURDATE() AND up.expiration_unit = ‘M’ ) OR ( DATE_ADD(up.purchase_date, INTERVAL up.expire YEAR) > CURDATE() AND up.expiration_unit = ‘Y’ ) OR up.expire is null OR up.expire = 0 )

    And an error occurs when I try to see my list of subscribed users as well and it reads:
    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 ‘WEEK) > CURDATE() AND up.expiration_unit = ‘W’ ) OR ‘ at line 17]
    SELECT DISTINCT u.id, user_login FROM wp_users u WHERE u.id not in ( SELECT user_id FROM wp_are_paypal_users up WHERE post_id = -1 AND ( ( DATE_ADD(up.purchase_date, INTERVAL up.expire DAY) > CURDATE() AND up.expiration_unit = ‘D’ ) OR ( DATE_ADD(up.purchase_date, INTERVAL up.expire WEEK) > CURDATE() AND up.expiration_unit = ‘W’ ) OR ( DATE_ADD(up.purchase_date, INTERVAL up.expire MONTH) > CURDATE() AND up.expiration_unit = ‘M’ ) OR ( DATE_ADD(up.purchase_date, INTERVAL up.expire YEAR) > CURDATE() AND up.expiration_unit = ‘Y’ ) OR up.expire is null OR up.expire = 0 ) )

    Any helps or suggestions are greatly appreciated!
    Dan

  12. Aurimas Post author

    try to run the whole sql sentence from the exception on your sql server using mysqladmin o something… It can be it will give us more information …

  13. Dan

    This was the response I got inside mysqladmin:

    #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 ‘WEEK ) > CURDATE( ) AND up.expiration_unit = ‘W’ ) OR ( DATE_ADD( up.purchase_da’ at line 1

  14. Dan

    Further to my last comment – I’ve been poking around the mySQL database and I notice that the tables are_paypal_users, are_paypal_requests, etc are all empty. What should I have in here? I’m wondering if this is what is messing up. Any light on the situation would be extremely helpful. :)

  15. Dan

    mysql version: 4.1.11

    It was running fine prior to an update though – never had an issue with it. That was the only thing that changed.

  16. Aurimas Post author

    Could you try to install latest mysql version, or to try to install the plugin on another blog with latest mysql version

Leave a Reply

Your email address will not be published. Required fields are marked *