Guest User

Untitled

a guest
Jun 4th, 2018
298
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.57 KB | None | 0 0
  1. $q = Doctrine_Query::create()
  2. ->update('Affiliate_Users')
  3. ->set('acct_username', '?', $acct_username)
  4. ->set('acct_pass', '?', $acct_pass)
  5. ->set('plan_group', '?', $plan_group)
  6. ->set('acct_fname', '?', $acct_fname)
  7. ->set('acct_lname', '?', $acct_lname)
  8. ->set('acct_email', '?', $acct_email)
  9. ->set('acct_street', '?', $acct_street)
  10. ->set('acct_city', '?', $acct_city)
  11. ->set('acct_state', '?', $acct_state)
  12. ->set('acct_postal', '?', $acct_postal)
  13. ->set('acct_hphone', '?', $acct_hphone)
  14. ->set('acct_cphone', '?', $acct_cphone)
  15. ->set('acct_payment_type', '?', $acct_payment_type)
  16. ->set('acct_website', '?', $acct_website)
  17. ->set('updated_at', '?', $updated_at)
  18. ->where('id > ? ',$id);
  19. $q->execute();
  20.  
  21.  
  22.  
  23. UPDATE Affiliate_Users SET acct_username = ?, acct_pass = ?, plan_group = ?, acct_fname = ?, acct_lname = ?, acct_email = ?, acct_street = ?, acct_city = ?, acct_state = ?, acct_postal = ?, acct_hphone = ?, acct_cphone = ?, acct_payment_type = ?, acct_website = ?, updated_at = ? WHERE id > ? - (hello, hello, default, hello, hellohello, hello818, hellohellohellohellohello, hello, hello, hello, hello, hello, paypal, hello, 2009-02-19 15:58:50, 3 )
  24.  
  25.  
  26.  
  27.  
  28. There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
  29.  
  30. ERROR: Unknown Punctuation String @ 44
  31. STR: ?,
  32. SQL: UPDATE Affiliate_Users SET acct_username = ?, acct_pass = ?, plan_group = ?, acct_fname = ?, acct_lname = ?, acct_email = ?, acct_street = ?, acct_city = ?, acct_state = ?, acct_postal = ?, acct_hphone = ?, acct_cphone = ?, acct_payment_type = ?, acct_website = ?, updated_at = ? WHERE id > ? - (hello123, hello, default, hello, hellohello, hello818, hellohellohellohellohello, hello, hello, hello, hello, hello, paypal, hello, 2009-02-19 15:58:50, 2 )
  33.  
  34.  
  35. SQL query:
  36.  
  37. UPDATE Affiliate_Users SET acct_username = ?, acct_pass = ?, plan_group = ?, acct_fname = ?, acct_lname = ?, acct_email = ?, acct_street = ?, acct_city = ?, acct_state = ?, acct_postal = ?, acct_hphone = ?, acct_cphone = ?, acct_payment_type = ?, acct_website = ?, updated_at = ? WHERE id > ? - (hello123, hello, default, hello, hellohello, hello818, hellohellohellohellohello, hello, hello, hello, hello, hello, paypal, hello, 2009-02-19 15:58:50, 2 )
  38.  
  39. MySQL said: Documentation
  40. #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 '?, acct_pass = ?, plan_group = ?, acct_fname = ?, acct_lname = ?, acct_email = ?' at line 1
Add Comment
Please, Sign In to add comment