CiviCRM Community Forums (archive)

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']"]
)[/quote]

please help. any advice is greatly appreciated.

Thank you, Hershel, for your response. I'd done that already and received the message that says your database is already upgraded.

However, I was able to fix the problem. 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 for your input.