Actually that code has a typo. That may be why some people are getting errors. It shouldn't say "expire date" It should say "expire_date" Code: update amember_payments set expire_date = '2036-12-31' where expire_date = '2012-12-31' I know skippybosco's original code was correct. I think at some point maybe someone typed it out and got a typo in it. If you look back on page 1 of this thread you'll see his original sql.