Hi
I am working on Drupal6.
1-I have installed civicrm3.0.3 on Drupal6 -> that was working fine.
2- I have my old civicrm data base which was wrking on Drupal5 previously.
3- I replaced database information of Drupal5 in my current civicrm.settings.php on Drupal 6.
Then i got a following database error:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT *
FROM civicrm_preferences
WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
[nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
[type] => DB_Error
[user_info] => SELECT *
FROM civicrm_preferences
WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
[nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
FROM civicrm_preferences
WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
[nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']"]
)
Please help me i know this is due to data base but what step i should follow.
Its urgent..
Comments
CiviCRM upgrade: Drupal 5 to Drupal 6
Reena,
you need to follow the upgrade instructions found on the CiviCRM.org website.
Basically, you will need to restore your working Drupal 5 / CiviCRM 2.x site and then work through the upgrade procedures. You might also want to consider hiring an experienced Drupal/CiviCRM professional.
Hope this helps.