We recently installed amember 3.1.8PRO on a new server. We have an older version (3.0.9PRO) installed on a different server that we do not have full access to, only have access to the amember control panel, no access to the actual mysql database. The person who setup the old server has been reluctant to help. I backed up the 3.0.9PRO data using the backup feature in the control panel, then I added the data into the new database using phpmyadmin as the the amount of records choked the restore fuction. and I actually had to do the phpmyadmin in big chunks as the amount of data was to big. and now when we go in and manual add a payment for a member, we get the following error after we click the add button: MYSQL ERROR: Unknown column 'nms.status' in 'field list' in query: SELECT nms.thread_id, nms.status, nt.is_active, nt.blob_available_to AS available_to FROM amember_newsletter_member_subscriptions AS nms LEFT JOIN amember_newsletter_thread AS nt ON nt.thread_id = nms.thread_id WHERE nms.member_id = '1' The payment actually shows up, just not sure what is causing the error. and then if we go in and edit a payment, we get the following when click on edit: MYSQL ERROR: Unknown column 'ac.tier' in 'on clause' in query: SELECT ac.aff_id as caff_id, ac.*, m.*, acv.date AS void_date, acv.commission_id as void_id FROM amember_aff_commission ac LEFT JOIN amember_members m ON ac.aff_id = m.member_id LEFT JOIN amember_aff_commission acv ON (ac.payment_id = acv.payment_id AND ac.receipt_id = acv.receipt_id AND acv.record_type='debit' AND ac.tier = acv.tier) WHERE ac.payment_id = 19650 AND ac.record_type ='credit' when this happens we are unable to edit the payment.