CiviCRM Community Forums (archive)

I've created an event and set up a price set for it. However, the only visibility option I have is "admin". There are no other options available. Am I maybe just missing a step or option somewhere else so that public will be an option as well?

Thanks.

I've been fighting with this for days, so I went to the database. The entry in civicrm_option_value for "public" was completely missing. I just checked several other installs of CiviCRM that I have in the 3.x branch and they have the exact same problem.

I went in and inserted the item:

INSERT INTO `brain_crm`.`civicrm_option_value` (`id`, `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`) VALUES ('800', '38', 'public', '1', 'public', NULL, '0', '0', '1', NULL, '0', '0', '1', NULL, NULL, NULL);
I had to make it 800 as all the numbers around the "admin" option (which was id 213) were taken. So I looked to see what the last item in the table was and used the next id numbers. So far this seems to have fixed it since I now can see options.