QuickForm error after upgrade to 2.2.8 (drupal 6.1.3)

[arrow]

on Manage Contribution Page and any attempts to edit or create those pages we get:

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    QuickForm Error: unregistered element

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -5
    [message] => QuickForm Error: unregistered element
    [mode] => 16
    [debug_info] => Element 'import contact' does not exist in HTML_QuickForm::_loadElement()
    [type] => HTML_QuickForm_Error
    [user_info] => Element 'import contact' does not exist in HTML_QuickForm::_loadElement()
    [to_string] => [html_quickform_error: message="unregistered element" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="QuickForm Error: " info="Element 'import contact' does not exist in HTML_QuickForm::_loadElement()"]
)


We did have some difficulty with the database on upgrade and had to dump our data and reimport.  the three tables we had to bring in cleanly in order not to keep lose CiviReport were civicrm_domain, civicrm_menu and civicrm_option_value.  So this problem might involve them, or data that was lost in those tables.

[Donald Lobo]

1. have u implemented any hooks?

2. can u enable debug (administer civicrm >> global settings >> debug) and cut-n-paste the backtrace for this error

thanx

lobo

[arrow]

here is the backtrace.  let me know if there's further debug info I can gather. I have server-side access.

backTrace

/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 148
, handle,
/var/www/drupal/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm.php, PEAR_Error, 2065
/var/www/drupal/sites/all/modules/civicrm/packages/PEAR.php, HTML_QuickForm_Error, 574
/var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm.php, raiseError, 596
/var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm.php, _loadElement, 638
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Form.php, addElement, 774
/var/www/drupal/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionPage/Settings.php, addWysiwyg, 81
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Form.php, buildQuickForm, 324
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 98
/var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 245
/var/www/drupal/sites/all/modules/civicrm/CRM/Contribute/Page/ContributionPage.php, run, 166
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 205
/var/www/drupal/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 343
, civicrm_invoke,
/var/www/drupal/includes/menu.inc, call_user_func_array, 348
/var/www/drupal/index.php, menu_execute_active_handler, 18

and thanks for any help!

[Donald Lobo]

seems like your option_group / option_value table is messed up. In specific the option values for the option group whose name is wysiwyg_editor has the wrong values. You might want to load a clean copy of 2.2.8 and see what the issues are. option_group and option_values are connected tables

lobo

[arrow]

thanks lobo.

in our functioning (staged) install, the option values for the option group (32) whose name is wysiwyg_editor are just two rows:

mysql> select * from civicrm_option_value where option_group_id = 32;
+-----+-----------------+-----------+-------+------+----------+--------+------------+--------+-------------+-------------+-------------+-----------+--------------+---------------+
| id  | option_group_id | label     | value | name | grouping | filter | is_default | weight | description | is_optgroup | is_reserved | is_active | component_id | visibility_id |
+-----+-----------------+-----------+-------+------+----------+--------+------------+--------+-------------+-------------+-------------+-----------+--------------+---------------+
| 163 |              32 | TinyMCE   | 1     | NULL | NULL     |      0 |       NULL |      1 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 164 |              32 | FCKEditor | 2     | NULL | NULL     |      0 |       NULL |      2 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
+-----+-----------------+-----------+-------+------+----------+--------+------------+--------+-------------+-------------+-------------+-----------+--------------+---------------+

in our non-functioning prod install there are a whole bunch of rows populated:

mysql> select * from civicrm_option_value where option_group_id = 32;
+-----+-----------------+---------------------+-------+---------------------+----------+--------+------------+--------+-------------+-------------+-------------+-----------+--------------+---------------+
| id  | option_group_id | label               | value | name                | grouping | filter | is_default | weight | description | is_optgroup | is_reserved | is_active | component_id | visibility_id |
+-----+-----------------+---------------------+-------+---------------------+----------+--------+------------+--------+-------------+-------------+-------------+-----------+--------------+---------------+
| 221 |              32 | Export Case         | 12    | Export Case         | NULL     |      0 |          0 |     12 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 216 |              32 | Export Contact      | 7     | Export Contact      | NULL     |      0 |          0 |      7 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 217 |              32 | Export Contribution | 8     | Export Contribution | NULL     |      0 |          0 |      8 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 218 |              32 | Export Membership   | 9     | Export Membership   | NULL     |      0 |          0 |      9 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 219 |              32 | Export Participant  | 10    | Export Participant  | NULL     |      0 |          0 |     10 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 220 |              32 | Export Pledge       | 11    | Export Pledge       | NULL     |      0 |          0 |     11 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 212 |              32 | Import Activity     | 3     | Import Activity     | NULL     |      0 |          0 |      3 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 211 |              32 | Import Contact      | 2     | Import Contact      | NULL     |      0 |          0 |      2 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 213 |              32 | Import Contribution | 4     | Import Contribution | NULL     |      0 |          0 |      4 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 214 |              32 | Import Membership   | 5     | Import Membership   | NULL     |      0 |          0 |      5 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 215 |              32 | Import Participant  | 6     | Import Participant  | NULL     |      0 |          0 |      6 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
| 210 |              32 | Search Builder      | 1     | Search Builder      | NULL     |      0 |          0 |      1 | NULL        |           0 |           1 |         1 |         NULL |          NULL |
+-----+-----------------+---------------------+-------+---------------------+----------+--------+------------+--------+-------------+-------------+-------------+-----------+--------------+---------------+


I have no idea what to do from here. Obviously, I'd be tempted to match the working copy, but I'm just fumbling in the dark.

[Deepak Srivastava]

Just to confirm, can you use following query (both the places) & recheck -

Code: [Select]

SELECT @option_group_id := max(id) from civicrm_option_group where name = 'wysiwyg_editor';
SELECT * from civicrm_option_value where option_group_id =@option_group_id;


[Donald Lobo]

i think this issue is the way you did the database upgrade and brought in some new tables cleanly (civicrm_option).

In general messing with the tables directly has consequences that might not be apparent. I'd go back to the original database and get the upgrade to work

lobo

[arrow]

yes, running the above queries resulted in the same in both dbs.  (option_group_id was 32 per my queries.)

I'm afraid we can't really go back and do the upgrade, mainly because the original upgrade resulted in a completely kerfunked civicrm that our webmasters didn't notice for some time (over a month).  Some modules didn't work at all even though they were "enabled."  but we'd accrued new data in that time.   

we eventually had to dump our data, do a fresh install of civicrm, then re-import our data one table at a time (checking after each table to confirm that we didn't lose CiviReport, which was the chief complaint that opened the ticket to begin with.)  We discovered there were three tables in particular that obliterated CiviReport when our old data was imported; those were the three tables in question that we left unimported.   

So now we are stuck in between.  Either not having CiviReport work, or not being able to edit or create contribution pages, it seems.   I think I'm better off trying to hand fix these three remaining tables before going back to square one again, at least for now, if you have the patience to try to poke me through it?  If not, I'm very grateful for the assistance you've given me so far.  Thank you, and hope you have a good one. 

[arrow]

Okay, I took the bold step of deleting our default (from the clean install) values for civicrm_option_value where option_group_id = 32; and inserted the values from the staged db (our successful upgrade.)
this seems to work, as the loading of the add contribution page now loads what I believe is the FCKEditor!  I'll have to let the webmasters continue with testing, since I don't mess with testing in production unless I can help it.

Thanks so much, lobo.  I couldn't possible have gotten even a tenth this far without your help.