Comment posted Are PayPal 1.7.3 version was released by ryan.
Thank you very much, this is what I am highly expected ! Will help you broadcast this nice software!
ryan also commented
- 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 - 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?
- about 2k, the piosts are generated from sql , but not regular from admin panel -> new post
- 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=”)
Recent comments by ryan
- Are PayPal 1.7.2 version was released
paging needed. - Are PayPal 1.7.1 version was released
haha, this id exactly what I observed and reported to you, thanks for your fix. - Are PayPal 1.4.0 released
I can not get 1.4.2 work with WP2.6 too, display is ok, just paid customer can not be exposed to hidden content.
Any suggestion? which WP version you tested?
powered by SEO Super Comments
Thank you very much, this is what I am highly expected ! Will help you broadcast this nice software!
Comment by ryan — February 4, 2010 @ 7:02 pm
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=”)
Comment by ryan — February 4, 2010 @ 7:11 pm
How many posts do you have in your blog?
Comment by Aurimas — February 4, 2010 @ 10:49 pm
about 2k, the piosts are generated from sql , but not regular from admin panel -> new post
Comment by ryan — February 5, 2010 @ 2:32 am
In this case check sql environment parameters
SQL_BIG_SELECTS
SQL_MAX_JOIN_SIZE
I guess your answer is there
Comment by Aurimas — February 5, 2010 @ 11:23 am
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?
Comment by ryan — February 5, 2010 @ 11:46 am
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.
Comment by Aurimas — February 5, 2010 @ 11:51 am
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…
Comment by The Local Landing — February 5, 2010 @ 6:01 pm
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.
Comment by Aurimas — February 5, 2010 @ 6:11 pm
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.
Comment by Martin — February 6, 2010 @ 3:16 am
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
Comment by ryan — February 6, 2010 @ 3:18 am
yes
Comment by Aurimas — February 6, 2010 @ 8:50 pm
so something is wrong in those parameters check paypal buttons html source and the values in those parameters.
Comment by Aurimas — February 6, 2010 @ 8:51 pm
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.
Comment by Uncletadd — February 14, 2010 @ 2:48 pm
Uncletadd> It is impossible for now to protect custom fields, but I could try to implement this on my plugin.
Comment by Aurimas — February 14, 2010 @ 5:50 pm
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
Comment by Joey — February 26, 2010 @ 10:11 am
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
Comment by Aurimas — February 26, 2010 @ 11:17 am
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
Comment by Dan — April 18, 2010 @ 11:05 pm
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 …
Comment by Aurimas — April 19, 2010 @ 9:16 am
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
Comment by Dan — April 22, 2010 @ 1:39 am
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.
Comment by Dan — April 22, 2010 @ 2:04 am
what is your mysql version
Comment by Aurimas — April 22, 2010 @ 11:30 am
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.
Comment by Dan — April 23, 2010 @ 2:16 am
Could you try to install latest mysql version, or to try to install the plugin on another blog with latest mysql version
Comment by Aurimas — April 23, 2010 @ 9:18 am