Comment posted on Are PayPal 1.7.3 version was released by Aurimas
In this case check sql environment parameters
SQL_BIG_SELECTS
SQL_MAX_JOIN_SIZE
I guess your answer is there
Aurimas also commented
- Could you try to install latest mysql version, or to try to install the plugin on another blog with latest mysql version
- what is your mysql version
- 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 …
- 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
- Uncletadd> It is impossible for now to protect custom fields, but I could try to implement this on my plugin.
Recent comments by Aurimas
- FAQ
paypal sends ipn posts to the blog and everything what comes from paypal gets registered in there.
Yes csv or txt export of the data could be a good thing. - FAQ
Content will be hidden if you will have no price for it – no 0, but compleately empty – try to clear it using clear button next to post price. this is my bug I should check if its 0 or empty before sending it to paypal. I will put this to be fixed for next version. - Features
If plugin is activated it ads metatag into header and tells the google to index the content but prevents it from caching. You can check sites header and metatags to understand how it works.
Plugin is also able to detect googlebot and if googlebot comes to the site content is exposed to it as if it was user who purchased the content. As google is not allowed to cache the sites contetn it will never show the content under cached version So you blog can still be indexed by google your users can find it by keywords residing in a hidden area and they still has to pay for it … - Are PayPal 1.7.7 version was released
try to click the button “restore defaults” or similar (I do not recall the label of the button) under templates. It should be ok. - Are PayPal 1.7.7 version was released
Check generated html for buttons maybe you will notice something unusual. Try to reset button templates if so. Try to identify if this is not due to your paypal account configuration.
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