I got hit with the same upgrade bug. The SQL I used to recover is: ALTER TABLE `amember_coupon` ADD `member_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `coupon_id` ;