CiviCRM Community Forums (archive)

Thanks for the explanation of my options. I guess I could replace the civicrm tables in my current database with the 1.8 tables I have in my backed up version of the database.

If I wait for the beta how does that solve my problem. I'll still need to fix the gType to gtype issue with the database, right? and there won't be a script to do that. Or will the beta version not require me to make changes to the database?

Hello nessumsara,

Use on your own risk not guaranteed/make a db copy when your content is important!!!

After updating my database from 1.8 to 1.9 and having the bug described in this forum item,
I uses phpmyadmin and browsed in the field civicrm_option_value searching in column 'label' for 'Acces Controll' and 'Mailing List'.
I deleted these lines and did additional run the coded query in phpmyadmin. 

SELECT @option_group_id_gtype := max(id) from civicrm_option_group where name = 'group_type';
INSERT INTO
      civicrm_option_value (option_group_id, label, value, name, grouping, filter, is_default, weight, description, is_optgroup, is_reserved, is_active)
VALUES
     (@option_group_id_gtype, 'Access Control'  , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 1, 1 ),
     (@option_group_id_gtype, 'Mailing List'    , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 1, 1 );
 Good luck, but take in mind the wise words of Donals Lobo and Dave Greenberg.