CiviCRM Community Forums (archive)

Doesn't look surprising given that you been playing with the db - http://forum.civicrm.org/index.php/topic,12167.0.html.

Since you look ninja enough, you can figure out the problem by looking at the code for the checks that's failing and throwing that error.

Or if you have cleanup backup try loading that and check.

Also, another recommendation/opinion/suggestion question - would the clean install of 3.1.2 and reload of data from previous version be an easier task then trying to fix things that bother the update script? And also maybe better in the long run? My data is mostly contacts/mailings/addresses - would I run into primary/foreign key rewriting even if I empty sample data?

Reloading of data from 3.0.4 to the structure of 3.1.2, might not work since some columns be missing / new ..etc. Or if you mean replacing fresh install's 3.1.2 db /w 3.0.4 db, would not be of help as this 'll result in same error.
However you could try rebuilding the schema for 3.0.4 and then go for upgrade.

I'll try debugging the upgrade and getting to the bottom of it. Btw, just out of curiosity what would you recommend for interactive debugging? (I've only ever tried PHPEclipse/Xdebug).

Whichever you are comfortable with. I have Xdebug installed but never tried eclipse.
If you go this path - a simple grep of the message should point you to the file. Also all upgrade code is in CRM/Upgrade/* dir.

update:

I managed to bring my installation to 3.1.3. A big thank you to all who helped.

In short this is what worked for me:
- did a clean install of 3.0.4 (the last version of my data, but not completely right... had an extra field 'names' in civicrm_loc_block)
- rebuild the data (mostly by restoring mysqldumps created with -c --insert-ignore -t for existing tables, and dumping full data for custom tables and import tables that didn't exist in the clean 3.0.4 install)
- did an official upgrade from 3.0.4 to 3.1.3 with no error messages

I knew that I would run into some problems with existing data that comes with a clean install that blocked the import of my own data (default domains and other settings, some weirdness with custom fields). I fixed those and moved on to testing.

And just went i thought I was home free (finished testing mailings from civimail, searching, groups) I realized that I can not save any changes to contacts (only contacts).

I get no error messages. I tried truncating all the caches in the db, deleted /drupal/sites/default/files/civicrm/templates_c/*.  
It allows me to go into edit, enter and change data, and when I press save and the screen refreshes and my changes are still visible (while I am still at civicrm/contact/add?reset=1&action=update&cid=). But no changes are saved. I reviewed the drupal settings and I have drupal permission to edit all contacts.

Any suggestions on where to start looking (or what and where to debug)?

[update - solved]
Thanks for the offer on ssh, I appreciate it - I'll give it another try since I managed to finally setup xdebug.

So xdebug helped me establish that I am missing email_greeting from civicrm_option_group and civicrm_option_value.
(I think I deleted that - there was some custom data that got mixed up with civicrm data).
Will try to restore that and see if that's it [update - that was it]. Funny thing (bug?) is that the error message, which gets composed in the form's validate, is not rendered on the screen.

In the mean time, while hunting for the data to restore I saw what seems to be a little typo in sql/civicrm_data.mysql, here's a diff
4803c4803
<   (@option_group_id_emailGreeting, 'Dear {contact.household_name}',                                             5, 'Dear {contact.househols_name}',                                             NULL,    2, 1, 5, NULL, 0, 0, 1, NULL, NULL),
---
>   (@option_group_id_emailGreeting, 'Dear {contact.household_name}',                                             5, 'Dear {contact.household_name}',                                             NULL,    2, 1, 5, NULL, 0, 0, 1, NULL, NULL),
4809c4809
<   (@option_group_id_postalGreeting, 'Dear {contact.household_name}',                                             5, 'Dear {contact.househols_name}',                                             NULL,    2, 1, 5, NULL, 0, 0, 1, NULL, NULL),
---
>   (@option_group_id_postalGreeting, 'Dear {contact.household_name}',                                             5, 'Dear {contact.household_name}',                                             NULL,    2, 1, 5, NULL, 0, 0, 1, NULL, NULL),