Skip to content

Instantly share code, notes, and snippets.

[Error: Upgrade DB to 4.3.alpha1: SQL]
Error Field Error Value
Type DB_Error
Code -1
Message DB Error: unknown error
Mode 16
UserInfo ALTER TABLE `civicrm_line_item` DROP FOREIGN KEY `FK_civicrm_line_item_price_field_id`, CHANGE `price_field_id` `price_field_id` INT( 10 ) UNSIGNED DEFAULT NULL [nativecode=1025 ** Error on rename of './aarweb/civicrm_line_item' to './aarweb/#sql2-33c-11c' (errno: 152)]
DebugInfo ALTER TABLE `civicrm_line_item` DROP FOREIGN KEY `FK_civicrm_line_item_price_field_id`, CHANGE `price_field_id` `price_field_id` INT( 10 ) UNSIGNED DEFAULT NULL [nativecode=1025 ** Error on rename of './aarweb/civicrm_line_item' to './aarweb/#sql2-33c-11c' (errno: 152)]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Error Field Error Value
Type DB_Error
Code -3
Message DB Error: constraint violation
Mode 16
UserInfo ALTER TABLE `civicrm_line_item` ADD CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field`(id) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`aarweb`.`#sql-33c_e1`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE SET NULL)]
DebugInfo ALTER TABLE `civicrm_line_item` ADD CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field`(id) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`aarweb`.`#sql-33c_e1`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE SET NULL)]
PEAR_Exception: DB Error: constraint violation in unknown on line
$content = array(
'member_id_row' => array(
'#type' => 'container',
'label' => array(
'#markup' => '<label>' . t('Member ID') . '</label>',
),
'value' => array(
'#markup' => '<span>' . $GLOBALS['user']->name . '</span>',
)
)
$email_params = array(
'subject' => 'PAPERS User has been merged',
'body' => 'PAPERS user "' . $other->display_name . '" has updated their username from "' . $other->external_identifier . '" to "' . $main->external_identifier . '". Please update your records.',
'from' => '[email protected]',
);
drupal_mail('oasis_cas_service_tracking', 'merge_notification', variable_get('oasis_cas_papers_admin_email'), language_default(), $email_params);
Jan 29 10:33:01 ip-10-140-2-106 drupal: http://papersqa.aarweb.org|1422545581|php|54.235.200.241|http://papersqa.aarweb.org/bgp-start/uc%253Auser_notifications_cron/6dcc4cd073368b7f99d112e77c60b810||0||Table &#039;papers.drupal6_user_notifications_message&#039; doesn&#039;t exist#012query: DELETE FROM drupal6_user_notifications_message WHERE mid = 163 in /srv/www/papers.aarweb.org/htdocs/sites/all/modules/contrib/user_notifications/user_notifications.module on line 193.
Jan 29 10:33:01 ip-10-140-2-106 drupal: http://papersqa.aarweb.org|1422545581|php|54.235.200.241|http://papersqa.aarweb.org/bgp-start/uc%253Auser_notifications_cron/6dcc4cd073368b7f99d112e77c60b810||0||Unknown column &#039;mid&#039; in &#039;where clause&#039;#012query: DELETE FROM drupal6_user_notifications_index WHERE mid = 164 in /srv/www/papers.aarweb.org/htdocs/sites/all/modules/contrib/user_notifications/user_notifications.module on line 192.
@roberttdev
roberttdev / gist:51f05e1f02c4b8eb3c58
Created January 13, 2015 17:52
oasis.aliases.drushrc.php
<?php
$aliases['prod'] = array(
'root' => '/srv/www/www.aarweb.org/htdocs',
'uri' => 'www.aarweb.org',
'remote-user' => '[SSH User]',
'remote-host' => '[Remote IP]',
'os' => 'Linux',
'ssh-options' => '-i [PEM file location]'
);
htdocs/sites/all/modules/civicrm/civicrm.config.php:define('CIVICRM_SETTINGS_PATH', $settingsFile);
htdocs/sites/all/modules/civicrm/drupal/drush/civicrm.drush.inc: define('CIVICRM_SETTINGS_PATH', $civicrmSettingsFile);
htdocs/sites/all/modules/civicrm/drupal/civicrm.config.php.drupal:define('CIVICRM_SETTINGS_PATH', $settingsFile);
htdocs/sites/all/modules/civicrm/drupal/civicrm.module: define('CIVICRM_SETTINGS_PATH', $settingsFile);
htdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php: if (!defined('CIVICRM_SETTINGS_PATH')) {
htdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php: } elseif (preg_match(self::SETTINGS_SNIPPET_PATTERN, file_get_contents(CIVICRM_SETTINGS_PATH))) {
htdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php: } elseif (!is_writable(CIVICRM_SETTINGS_PATH)) {
htdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php: 1 => CIVICRM_SETTINGS_PATH,
htdocs/sites/all/modules/civicrm/CRM/Upgrade/I
[29-Oct-2014 22:26:14] [pool www] pid 7978
script_filename = /srv/www/www.aarweb.org/htdocs/index.php
[0x0000000001b6c178] execute() /srv/www/www.aarweb.org/htdocs/includes/database/
database.inc:2171
[0x0000000001b6ba60] execute() /srv/www/www.aarweb.org/htdocs/includes/database/
database.inc:683
[0x0000000001b6b470] query() /srv/www/www.aarweb.org/htdocs/includes/database/my
sql/query.inc:36
[0x0000000001b6a858] execute() /srv/www/www.aarweb.org/htdocs/includes/database/
query.inc:1621
[0x00000000024a34f8] mysql_query() /srv/www/www.aarweb.org/htdocs/sites/all/modu
les/civicrm/packages/DB/mysql.php:324
[0x00000000024a3020] simpleQuery() /srv/www/www.aarweb.org/htdocs/sites/all/modu
les/civicrm/packages/DB/common.php:1216
[0x00000000024a0d80] query() /srv/www/www.aarweb.org/htdocs/sites/all/modules/ci
vicrm/packages/DB/DataObject.php:2421
[0x000000000249f6c8] _query() /srv/www/www.aarweb.org/htdocs/sites/all/modules/c
ivicrm/packages/DB/DataObject.php:441
[0x000000000249f3e8] find() /srv/www/www.aarweb.org/htdocs/sites/all/modules/civ
icrm/CRM/Member/BAO/MembershipType.php:262
Bootstrap to phase 0. [0 sec, 2.38 MB] [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drush() [0 sec, 2.51 MB] [bootstrap]
Cache HIT cid: 6.2.0-commandfiles-0-f19506a43831c12de4a0bc8288bf3199 [debug]
[0.01 sec, 2.53 MB]
Bootstrap to phase 0. [0.05 sec, 6.29 MB] [bootstrap]
Bootstrap to phase 0. [0.08 sec, 6.29 MB] [bootstrap]
Found command: sql-sync (commandfile=sql) [0.08 sec, 6.29 MB] [bootstrap]
Including /usr/share/php/drush/commands/sql/sync.sql.inc [0.14 sec, [bootstrap]
6.31 MB]
Calling drush command init function: drush_sql_sync_init [0.14 sec, [bootstrap]