|
||||||
|
|
24 comments to Are PayPal 1.7.3 version was releasedLeave a Reply |
|||||
|
Copyright © 2012 Are PayPal - All Rights Reserved |
||||||
|
||||||
|
|
24 comments to Are PayPal 1.7.3 version was releasedLeave a Reply |
|||||
|
Copyright © 2012 Are PayPal - All Rights Reserved |
||||||
Thank you very much, this is what I am highly expected ! Will help you broadcast this nice software!
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=”)
How many posts do you have in your blog?
about 2k, the piosts are generated from sql , but not regular from admin panel -> new post
In this case check sql environment parameters
SQL_BIG_SELECTS
SQL_MAX_JOIN_SIZE
I guess your answer is there
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?
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.
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…
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.
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.
paypal ipn setting are under this place after login paypal.com,
My Account -> Profile -> Selling Preferences -> Instant Payment Notification Preferences
And Aurimas, shall I set IPN to below? is it correct setting?
http://www.mydomain.com/wp-content/plugins/are-paypal/are-paypal-ipn.php
thank you!
ryan
yes
so something is wrong in those parameters check paypal buttons html source and the values in those parameters.
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.
Uncletadd> It is impossible for now to protect custom fields, but I could try to implement this on my plugin.
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
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
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
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 …
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
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.
what is your mysql version
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.
Could you try to install latest mysql version, or to try to install the plugin on another blog with latest mysql version