Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2015
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. [Error: Upgrade DB to 4.6.alpha7]
  2. Fout Veld fout waarde
  3. Type DB_Error
  4. Code -1
  5. Message DB Error: unknown error
  6. Mode 16
  7. UserInfo ALTER TABLE civicrm_mailing_abtest ADD COLUMN `created_id` int unsigned COMMENT 'FK to Contact ID', ADD COLUMN `created_date` datetime COMMENT 'When was this item created', ADD COLUMN `testing_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD COLUMN `winner_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD CONSTRAINT FK_civicrm_mailing_abtest_created_id FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL [nativecode=1215 ** Cannot add foreign key constraint]
  8. DebugInfo ALTER TABLE civicrm_mailing_abtest ADD COLUMN `created_id` int unsigned COMMENT 'FK to Contact ID', ADD COLUMN `created_date` datetime COMMENT 'When was this item created', ADD COLUMN `testing_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD COLUMN `winner_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD CONSTRAINT FK_civicrm_mailing_abtest_created_id FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL [nativecode=1215 ** Cannot add foreign key constraint]
  9. PEAR_Exception: DB Error: unknown error in unknown on line unknown
  10. - DB_Error: DB Error: unknown error in unknown on line unknown
  11. Exception trace
  12.  
  13. mysql -u root -p
  14.  
  15. use civicrm; // replace civicrm with the name of your database
  16.  
  17. show tables; // it will give you a list with the civicrm database tables
  18.  
  19. drop table civicrm_mailing_abtest; // this will remove the table
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement