MYSQL ERROR:Unknown column 'acv.commission_id'

Discussion in 'Troubleshooting' started by mmba_webmaster, May 11, 2005.

  1. mmba_webmaster

    mmba_webmaster New Member

    Joined:
    Sep 27, 2004
    Messages:
    20
    I'm receiving the below error when trying to edit a user's products (http://mmba.org/amember/admin/users.php?action=edit_payment&payment_id=2&member_id=1)
    I'm using 2.3.6PRO. It appears the field name is misspelled in the table as 'comission_id'

    # MYSQL ERROR:
    Unknown column 'acv.commission_id' in 'field list'
    in query:
    SELECT 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') WHERE ac.payment_id = 2 AND ac.record_type ='credit'

Share This Page