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 '-1' at line 1]

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ ) ORDER BY wp_posts.post_date DESC limit -1

I just installed Wordpress SEO Pager Enhanced Pagination plugin and few minutes later i got those errors at the top of every posts and also RSS feed. It causes the other plugin (YARP) experiencing technical problems.
Apparently, the developer of YARP plugin has notified about this incompatibility on FAQ.
Continue reading…

written by Ryan Isra \\ tags: plugin, SEO, SQL, wordpress

Below is an explanation, quoted from Lockerz’s about page

Lockerz is the place to go to buy the coolest stuff at the lowest prices, watch exclusive video, discover new music, play the hottest games, hang out with your friends – and get rewarded for just about EVERYTHING you do on the site.

Our mission is to be your daily habit, not a site for your parents or grandparents looking for their long-lost friends from Kindergarten.

One other thing you’ll love about Lockerz are PTZ (or “Pointz” ). PTZ are Lockerz’ proprietary loyalty “currency” that you earn whenever you buy, watch, play, share, invite friends, or even just show up on Lockerz. Redeem PTZ at the PTZ Place for incredible prizes, great products and dream experiences.

Too Good to Be True? Why are we doing this? To thank you for joining early. To build a Lockerz community of cool, stylish, cutting-edge people who love to buy great brands. To give you a taste of how PTZ will work when we go live this fall. And to test out different prizes and PTZ levels. That’s key. This version of PTZ Place is a test. PTZ levels will change when the full Lockerz site launches.
Continue reading…

written by Ryan Isra \\ tags: gift, Lockerz, shopping, style, website

If you were using a VCC (Virtual Credit Card) to verify your PayPal account, your PayPal account will remain to verified status. You will be able to send money or withdraw money into your bank account. Yes, you can use verified PayPal account with expired VCC inside. However, you won’t be able to use PayPal with expired VCC inside to make monthly subscription payment such as hosting, or any other subscription services that require automatic scheduled payment.
I’ve been becoming PayPal verified member since February 2009 using VCC, which is expired last month. However, I’m still using my PayPal account as usual, accept payments, send money, as well as withdraw to my bank account without problems, even though the VCC is already expired. Today, I was getting a problem because my VCC is expired.
PayPal requested to Update My Expired Credit or Debit Card, although I have enough balance in my PayPal account.

To complete this payment, add a debit or credit card to your PayPal account. Your card will not be charged unless the transaction amount exceeds your balance.

Continue reading…

written by Ryan Isra \\ tags: credit card, debit card, merchant, money online, online payment, paypal, shopping, website