3 Additional LineItems have just been spotted in one of our membership sign up forms (for organisations) - though they have never been set up (I don't know how such things would be set up), and don't appear on any settings page. The amounts section is no enabled for the contribution page (because it is being used for memberships).

Does anyone have any ideas how this is happening, and how we might remove them?

Frontendenter image description here

Backendenter image description here

  • Do you have access to access to database? – Pradeep Nayak 2 days ago
  • Do you have Lineitem editor extension installed? – Pradeep Nayak 2 days ago
  • Yes, both access to database and Lineitem editor is installed – Christopher 2 days ago
  • Disabling Lineitem editor (and clearing caches etc) doesn't appear to remove the problem. However with further testing it appears to be only showing to 'Admin' level users and not Anonymous or our Member level user. – Christopher 2 days ago

You may need to run below query to disable the field so that they don't appear on screen. Deleting the field is little risky as you may end up creating screwing financial data.

UPDATE civicrm_price_field cpf 
INNER JOIN civicrm_price_set_entity cpse
  ON cpse.entity_table = 'civicrm_contribution_page'
    AND cpse.price_set_id = cpf.price_set_id
    AND cpf.html_type <> 'Radio'
    AND cpse.entity_id = 4
SET cpf.is_active = 0;

Note: Replace 4 with contribution/membership page id.

  • 1
    Thank you, that fixed it. – Christopher 23 hours ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.