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 )
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