Support (offered by community volunteers) > Post-installation Setup and Configuration

Sorry. A non-recoverable error has occurred. when viewing contact

(1/2) > >>

zuesty:
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
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

   
--- Code: --- => -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.
--- End code ---

Dave Greenberg:
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.

zuesty:
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
--- End quote ---

i still have the same issue.

Dave Greenberg:
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: ----- 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}

--- End code ---

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  ???

zuesty:
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
--- End quote ---

 :-(

Navigation

[0] Message Index

[#] Next page