Comment posted Are PayPal 1.7.2 version was released by yong.
paging needed.
Recent comments by yong
- Are PayPal 1.7.3 version was released
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 - Are PayPal 1.7.3 version was released
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? - Are PayPal 1.7.3 version was released
about 2k, the piosts are generated from sql , but not regular from admin panel -> new post - Are PayPal 1.7.3 version was released
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=”) - Are PayPal 1.7.3 version was released
Thank you very much, this is what I am highly expected ! Will help you broadcast this nice software!
powered by SEO Super Comments
paging needed.
Comment by yong — February 3, 2010 @ 9:56 am
I do get this mysql error with your plugin, what to do ?
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' ]
SELECT up.* FROM wp_are_paypal_users up WHERE (up.post_id=’-1′) AND up.user_id=’0′ 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 )
Comment by Geri — February 14, 2010 @ 2:12 pm
Geri> I guess you have wrong version of mysql. What is your mysql version?
Comment by Aurimas — February 14, 2010 @ 5:51 pm
MySQL 4.1.21
Comment by Geri — February 15, 2010 @ 6:45 pm
that is not compatible unfortuantely I’ll try to update the plugin to be compatible. On the other hand try to upgrade your mysql version.
Comment by Aurimas — February 16, 2010 @ 11:35 am