CiviCRM Community Forums (archive)

Hi,
I'm trying to upgrade from civicrm 4.4.5(freshly installed stable version) to civicrm 4.5 alpha
I'm following the git hub based installation http://wiki.civicrm.org/confluence/display/CRMDOC/Github+for+CiviCRM. after I've run the gitfy and fetching from the origin repository, i'm trying to run the upgrade script, but its breaking and giving the following error.
can anyone pls tell me how to get rid of this error!!

CiviCRM Upgrade Tasks
[Error: Upgrade DB to 4.5.alpha1: SQL]
Error Field   Error Value
Type   DB_Error
Code   -15
Message   DB Error: can not create
Mode   16
UserInfo   ALTER TABLE `civicrm_mail_settings` ADD CONSTRAINT `FK_civicrm_mail_settings_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE SET NULL [nativecode=1005 ** Can't create table 'civicore_civi.#sql-41a_12b' (errno: 150)]
DebugInfo   ALTER TABLE `civicrm_mail_settings` ADD CONSTRAINT `FK_civicrm_mail_settings_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE SET NULL [nativecode=1005 ** Can't create table 'civicore_civi.#sql-41a_12b' (errno: 150)]
PEAR_Exception: DB Error: can not create in unknown on line unknown
- DB_Error: DB Error: can not create in unknown on line unknown
Exception trace
#   Function   Location
0   CRM_Core_Error::exceptionHandler(Object(DB_Error))   unknown:unknown
1   call_user_func(Array, Object(DB_Error))   /var/www/html/civicore/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: can no…', -15, 16, Array, 'ALTER TABLE `civ…')   /var/www/html/civicore/sites/all/modules/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-15, 16, Array, 'ALTER TABLE `civ…')   /var/www/html/civicore/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -15, null, null, 'ALTER TABLE `civ…', 'DB_Error', true)   /var/www/html/civicore/sites/all/modules/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-15, null, null, null, '1005 ** Can't cr…')   /var/www/html/civicore/sites/all/modules/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /var/www/html/civicore/sites/all/modules/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('ALTER TABLE `civ…')   /var/www/html/civicore/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('ALTER TABLE `civ…')   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Utils/File.php:284
9   CRM_Utils_File::sourceSQLFile('mysql://root:vmw…', ' SELECT @wo…', null, true)   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Upgrade/Form.php:160
10   CRM_Upgrade_Form->source(' SELECT @wo…', true)   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Upgrade/Form.php:300
11   CRM_Upgrade_Form->processLocales('/var/www/html/ci…', '4.5.alpha1')   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Upgrade/Form.php:324
12   CRM_Upgrade_Form->processSQL('4.5.alpha1')   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourFive.php:107
13   CRM_Upgrade_Incremental_php_FourFive::task_4_5_x_runSql(Object(CRM_Queue_TaskContext), '4.5.alpha1')   unknown:unknown
14   call_user_func_array(Array, Array)   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17   CRM_Queue_Page_AJAX::{closure}()   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext()   unknown:unknown
20   call_user_func(Array)   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Core/Invoke.php:293
21   CRM_Core_Invoke::runItem(Array)   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Core/Invoke.php:72
22   CRM_Core_Invoke::_invoke(Array)   /var/www/html/civicore/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /var/www/html/civicore/sites/all/modules/civicrm/drupal/civicrm.module:456
24   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
25   call_user_func_array('civicrm_invoke', Array)   /var/www/html/civicore/includes/menu.inc:517
26   menu_execute_active_handler()   /var/www/html/civicore/index.php:21
27   {main}