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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Sorry. A non-recoverable error has occurred. when viewing contact
Pages: [1]

Author Topic: Sorry. A non-recoverable error has occurred. when viewing contact  (Read 1469 times)

zuesty

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 2
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.3
Sorry. A non-recoverable error has occurred. when viewing contact
June 26, 2012, 03:09:24 pm
i just did a test migrate of my civicrm 3.4.5 from joomla 1.5.26 to a fresh install joomla 2.5.x. everything seemed to happen as planned but when i try to view a contact i get the following error (w details):


Database Error Code: Unknown column 'display_name' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  id, display_name 
 FROM civicrm_location_type
 
 WHERE (  civicrm_location_type.is_active = 1 ) 
 
 
 ORDER BY display_name 
 [nativecode=1054 ** Unknown column 'display_name' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  id, display_name 
 FROM civicrm_location_type
 
 WHERE (  civicrm_location_type.is_active = 1 ) 
 
 
 ORDER BY display_name 
 [nativecode=1054 ** Unknown column 'display_name' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  id, display_name 
 FROM civicrm_location_type
 
 WHERE (  civicrm_location_type.is_active = 1 ) 
 
 
 ORDER BY display_name 
 [nativecode=1054 ** Unknown column 'display_name' in 'field list']"]
)



please help. any advice is greatly appreciated.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Sorry. A non-recoverable error has occurred. when viewing contact
June 26, 2012, 03:27:20 pm
Did you run the DB Upgrade as described here: http://wiki.civicrm.org/confluence/display/CRMDOC41/Upgrade+Joomla+Sites+to+4.1#UpgradeJoomlaSitesto41-4RuntheDatabaseUpgradescript

I think the display_name column was added after 3.4 - so it looks like your DB schema was not upgraded for 4.1.
Protect your investment in CiviCRM by  becoming a Member!

zuesty

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 2
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.3
Re: Sorry. A non-recoverable error has occurred. when viewing contact
June 26, 2012, 03:36:55 pm
thank you for your response, dave. Yes, I did when I installed and also again right now and received the following message:

Quote
Your database has already been upgraded to CiviCRM 4.1.3

i still have the same issue.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Sorry. A non-recoverable error has occurred. when viewing contact
June 26, 2012, 03:52:09 pm
This is the code in the upgrade process that "should have" created that new column (in CRM/Upgrade/Incremental/sql/4.1.alpha1.mysql.tpl)

Code: [Select]
-- CRM-9120
{if $multilingual}
  {foreach from=$locales item=locale}
    ALTER TABLE `civicrm_location_type` ADD display_name_{$locale} VARCHAR( 64 ) DEFAULT NULL  COMMENT 'Location Type Display Name.' AFTER `name`;
    UPDATE `civicrm_location_type` SET display_name_{$locale} = `name`;
  {/foreach}
{else}
  ALTER TABLE `civicrm_location_type` ADD `display_name` VARCHAR( 64 ) DEFAULT NULL  COMMENT 'Location Type Display Name.' AFTER `name`;
  UPDATE `civicrm_location_type` SET `display_name` = `name`;
{/if}

Did you see any error messages when running civicrm/upgrade? If not, you may need to resort to doing a fresh install and then doing diff on the schema in your upgraded db  ???
Protect your investment in CiviCRM by  becoming a Member!

zuesty

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 2
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.3
Re: Sorry. A non-recoverable error has occurred. when viewing contact
June 26, 2012, 04:16:38 pm
i didn't receive any error messages. i just did another fresh install and the same thing happens. i dont fully understand what you mean by:

Quote
and then doing diff on the schema in your upgraded db

 :-(

zuesty

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 2
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.3
Re: Sorry. A non-recoverable error has occurred. when viewing contact
June 27, 2012, 10:52:13 am
I'm excited to say i found a way to make this work:

The CiviCRM version I was trying to migrate from was 3.4.8 and my new install on the new server was 4.1.x and that's when I was having the above mentioned issue. I scraped that idea and instead of going from 3.4.8 to 4.1.x, i went from 3.4.8 to a fresh install of 3.4.8 and once the migration was done and I made sure everything was working well, I upgraded my 3.4.8 to 4.1.x.

Thank you, Dave, for all your input.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Sorry. A non-recoverable error has occurred. when viewing contact

This forum was archived on 2017-11-26.