help with syntax error

3 replies
  • WEB DESIGN
  • |
Trying to set up WP clickbank membership plugin. After test order, when I click complete this order I get the following error:


Invalid query -- SELECT * FROM `wp_usermeta` WHERE `user_id`= and `meta_key`='wp_capabilities' LIMIT 1 -- 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 'and `meta_key`='wp_capabilities' LIMIT 1' at line 1


The following is the associated file where I think the problem is...

<?
require_once 'txconfig.php';

$rcpt=$_REQUEST['cbreceipt'];
$time=$_REQUEST['time'];
$item=$_REQUEST['item'];
$cbpop=$_REQUEST['cbpop'];
$wpid=$_REQUEST['wpid'];
$xxpop=sha1("$key|$rcpt|$time|$item");
$xxpop=strtoupper(substr($xxpop,0,8));

if ($cbpop!=$xxpop) {exit("Security Error - Logged.");}

// Access the wordpress database and upgrade user from subscriber to paidmember.
$metachange='wp_capabilities';
$res = query("SELECT * FROM `wp_usermeta` WHERE `user_id`=$wpid and `meta_key`='wp_capabilities' LIMIT 1");
$row = mysql_fetch_assoc($res);
$subscriber=$row[meta_value];
$um=$row[umeta_id];
$paidmember=str_replace('subscriber','paidmember', $subscriber);
$res = query("UPDATE `wp_usermeta` SET `meta_value`='$paidmember' WHERE `umeta_id`='$um'");
$thankyoupage="Location: $thankyoupage";
header($thankyoupage);
?>


Thanks for any help you could provide!
#error #syntax
  • Profile picture of the author NickL
    you are missing a value between 'user_id' = and and 'meta_key'.

    SELECT * FROM `wp_usermeta` WHERE `user_id`= 'need something or null here' and `meta_key`='wp_capabilities' LIMIT 1

    Also - watch out when you copy-paste - sometimes the single quotes can actually be different character codes... use notepad to clean them up...

    Good luck!
    Signature

    Have an Excellent Day!

    ~ Nick

    {{ DiscussionBoard.errors[3999459].message }}
    • Profile picture of the author KirkMcD
      Originally Posted by NickL View Post

      you are missing a value between 'user_id' = and and 'meta_key'.
      In other words, the variable $wpid doesn't have a value.
      {{ DiscussionBoard.errors[3999824].message }}
      • Profile picture of the author smackey1
        So what should the variable be?
        {{ DiscussionBoard.errors[4082776].message }}

Trending Topics