CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Option Lists - how to edit/delete/add
Pages: [1]

Author Topic: Option Lists - how to edit/delete/add  (Read 1274 times)

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
Option Lists - how to edit/delete/add
February 10, 2010, 03:54:28 pm
I have a new installation of 3.1.1.
I have another installation on a different website of 3.1.0 on the same server, so the server is good for civicrm.
This is a fresh installation, which looks like it went well, however i run into an issue with Option Lists.

Question:
I cannot add/delete/edit any of the Option Groups..
When i go to enter a new option, screen goes wide, can't enter anything in the field.

I found the table for the option groups: civicrm_option_value
Is it okay to edit this table and what would be the recommended approach?

Is this a bug in 3.1.1?

Appreciate the help. Best, Karen-Ann

Sean Madsen

  • I post occasionally
  • **
  • Posts: 98
  • Karma: 5
  • CiviCRM implementer/developer
    • Bikes Not Bombs
  • CiviCRM version: 4.6
  • CMS version: Drupal 7
Re: Option Lists - how to edit/delete/add
February 12, 2010, 07:24:40 am
I can't imagine a situation where you'd want to manually add a new option group, but I believe it's possible with this page: http://<your-ste>/civicrm/admin/options?action=add&reset=1

That page should also allow you to edit any of the option values for the existing groups (which would expect to be a much more likely need) if you click on "Multiple Choice Options" for the specific group in question listed in the option groups table.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Option Lists - how to edit/delete/add
February 12, 2010, 09:22:45 am
Hi KarenAnn,
You can even add/edit option values in the database if you know where to look (the files are civicrm_option_group and civicrm_option_group_values of the top of my head), but I am worried about all these screens that go blank in your installation :-) I believe something is wrong that you should fix or it will bite you more times?
Good luck.....
Erik
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
Re: Option Lists - how to edit/delete/add
February 13, 2010, 05:52:02 am
Hi Erik:
I am willing to do a reinstallation if I know what to fix.

What about reinstalling, while using a .htaccess file, adding criteria  to the bottom:
(I did not do this before - wondering if it would help???)
php_value memory_limit 64M
php_value register_globals off
php_value max_execution_time 600

If I uninstall, the civicrm tables are not removed.  Is there a trick to removing them?
Or maybe I should install on top?
Or maybe i should start with a new database?

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Option Lists - how to edit/delete/add
February 14, 2010, 03:12:02 am
Hi KarenAnn,
I would try a compete new install (including the DB) and my guess is that 64M is certainly a good option. I do not think that the max execution time is a problem, I am not sure about the register globals but I am sure there is lots to be found on the Internet on that.
Good luck......
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
Re: Option Lists - how to edit/delete/add
March 04, 2010, 12:27:14 pm
Problem solved - browser issue. Using IE7. Went to Firefox and no issues there. I am up and running, yippee!

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Option Lists - how to edit/delete/add
March 04, 2010, 11:54:20 pm
Congratulations and enjoy!
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Option Lists - how to edit/delete/add

This forum was archived on 2017-11-26.