CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • DB error on exporting
Pages: [1]

Author Topic: DB error on exporting  (Read 734 times)

BigP

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
DB error on exporting
August 03, 2010, 05:58:49 am
Using 3.2.0

When exporting all members of the group 'Pers' we get this error. Exporting other searchresults works fine.
The group 'Pers' has subgroups. Can that be the problem.




Sorry, er is een onherstelbare fout opgetreden.

DB Error: already exists

Database foutcode: Duplicate entry '2771' for key 1, 1062

Terug naar startpagina.

Error Details:

Array
(
    [callback] => Array
        (
            
  • => CRM_Core_Error
    • [1] => handle
            )

        
Code: [Select]
=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_task_action_temp ( contact_id ) VALUES  ( 2800 ) , ( 2747 ) , ( 2596 ) , ( 2724 ) , ( 2755 ) , ( 2771 ) , ( 2771 ) , ( 2648 ) , ( 2597 ) , ( 2794 ) , ( 2650 ) , ( 2653 ) , ( 2660 ) , ( 2736 ) , ( 2582 ) , ( 2613 ) , ( 2772 ) , ( 2781 ) , ( 2780 ) , ( 2675 ) , ( 2762 ) , ( 2659 ) , ( 2820 ) , ( 2680 ) , ( 2723 ) , ( 1786 ) , ( 1786 ) , ( 1783 ) , ( 1783 ) , ( 2614 ) , ( 2654 ) , ( 2802 ) , ( 2655 ) , ( 2807 ) , ( 2657 ) , ( 2658 ) , ( 2646 ) , ( 116 ) , ( 116 ) , ( 116 ) , ( 2797 ) , ( 2647 ) , ( 2815 ) , ( 2662 ) , ( 2663 ) , ( 2664 ) , ( 2616 ) , ( 2617 ) , ( 2624 ) , ( 2640 ) , ( 2641 ) , ( 2625 ) , ( 2642 ) , ( 2626 ) , ( 2643 ) , ( 2627 ) , ( 2628 ) , ( 2645 ) , ( 2629 ) , ( 2630 ) , ( 2615 ) , ( 2631 ) , ( 2632 ) , ( 2665 ) , ( 2633 ) , ( 2618 ) , ( 2634 ) , ( 2619 ) , ( 2635 ) , ( 2620 ) , ( 2636 ) , ( 2621 ) , ( 2637 ) , ( 2622 ) , ( 2638 ) , ( 2623 ) , ( 2639 ) , ( 2588 ) , ( 2667 ) , ( 2710 ) , ( 2649 ) , ( 2839 ) , ( 2839 ) , ( 315 ) , ( 315 ) , ( 315 ) , ( 315 ) , ( 1806 ) , ( 1806 ) , ( 2824 ) , ( 1776 ) , ( 1776 ) , ( 1812 ) , ( 1812 ) , ( 1820 ) , ( 1820 ) , ( 1780 ) , ( 1780 ) , ( 2715 ) , ( 2749 ) , ( 2742 ) , ( 2770 ) , ( 1769 ) , ( 1769 ) , ( 2812 ) , ( 2689 ) , ( 2750 ) , ( 2661 ) , ( 2737 ) , ( 2840 ) , ( 2840 ) , ( 2811 ) , ( 2668 ) , ( 2819 ) , ( 2670 ) , ( 2598 ) , ( 2666 ) , ( 2837 ) , ( 2837 ) , ( 2674 ) , ( 2729 ) , ( 2718 ) , ( 2716 ) , ( 2766 ) , ( 2704 ) , ( 1727 ) , ( 1727 ) , ( 2818 ) , ( 2586 ) , ( 2838 ) , ( 2838 ) , ( 2679 ) , ( 2593 ) , ( 2719 ) , ( 2681 ) , ( 2746 ) , ( 2793 ) , ( 2583 ) , ( 2585 ) , ( 2759 ) , ( 1722 ) , ( 1722 ) , ( 1722 ) , ( 2722 ) , ( 1760 ) , ( 1760 ) , ( 2584 ) , ( 2809 ) , ( 2152 ) , ( 2152 ) , ( 2152 ) , ( 2669 ) , ( 1767 ) , ( 1767 ) , ( 2683 ) , ( 2673 ) , ( 2708 ) , ( 1821 ) , ( 1821 ) , ( 2684 ) , ( 2685 ) , ( 2686 ) , ( 2589 ) , ( 2589 ) , ( 2796 ) , ( 2799 ) , ( 2817 ) , ( 2698 ) , ( 2728 ) , ( 2761 ) , ( 2676 ) , ( 2733 ) , ( 2688 ) , ( 2801 ) , ( 2721 ) , ( 2644 ) , ( 2717 ) , ( 2753 ) , ( 2690 ) , ( 2691 ) , ( 1778 ) , ( 1778 ) , ( 1774 ) , ( 1774 ) , ( 1784 ) , ( 1784 ) , ( 1788 ) , ( 1788 ) , ( 2692 ) , ( 2805 ) , ( 2695 ) , ( 2832 ) , ( 2754 ) , ( 2760 ) , ( 2734 ) , ( 2826 ) , ( 2682 ) , ( 2827 ) , ( 2830 ) , ( 2699 )  [nativecode=1062 ** Duplicate entry '2771' for key 1]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_task_action_temp ( contact_id ) VALUES  ( 2800 ) , ( 2747 ) , ( 2596 ) , ( 2724 ) , ( 2755 ) , ( 2771 ) , ( 2771 ) , ( 2648 ) , ( 2597 ) , ( 2794 ) , ( 2650 ) , ( 2653 ) , ( 2660 ) , ( 2736 ) , ( 2582 ) , ( 2613 ) , ( 2772 ) , ( 2781 ) , ( 2780 ) , ( 2675 ) , ( 2762 ) , ( 2659 ) , ( 2820 ) , ( 2680 ) , ( 2723 ) , ( 1786 ) , ( 1786 ) , ( 1783 ) , ( 1783 ) , ( 2614 ) , ( 2654 ) , ( 2802 ) , ( 2655 ) , ( 2807 ) , ( 2657 ) , ( 2658 ) , ( 2646 ) , ( 116 ) , ( 116 ) , ( 116 ) , ( 2797 ) , ( 2647 ) , ( 2815 ) , ( 2662 ) , ( 2663 ) , ( 2664 ) , ( 2616 ) , ( 2617 ) , ( 2624 ) , ( 2640 ) , ( 2641 ) , ( 2625 ) , ( 2642 ) , ( 2626 ) , ( 2643 ) , ( 2627 ) , ( 2628 ) , ( 2645 ) , ( 2629 ) , ( 2630 ) , ( 2615 ) , ( 2631 ) , ( 2632 ) , ( 2665 ) , ( 2633 ) , ( 2618 ) , ( 2634 ) , ( 2619 ) , ( 2635 ) , ( 2620 ) , ( 2636 ) , ( 2621 ) , ( 2637 ) , ( 2622 ) , ( 2638 ) , ( 2623 ) , ( 2639 ) , ( 2588 ) , ( 2667 ) , ( 2710 ) , ( 2649 ) , ( 2839 ) , ( 2839 ) , ( 315 ) , ( 315 ) , ( 315 ) , ( 315 ) , ( 1806 ) , ( 1806 ) , ( 2824 ) , ( 1776 ) , ( 1776 ) , ( 1812 ) , ( 1812 ) , ( 1820 ) , ( 1820 ) , ( 1780 ) , ( 1780 ) , ( 2715 ) , ( 2749 ) , ( 2742 ) , ( 2770 ) , ( 1769 ) , ( 1769 ) , ( 2812 ) , ( 2689 ) , ( 2750 ) , ( 2661 ) , ( 2737 ) , ( 2840 ) , ( 2840 ) , ( 2811 ) , ( 2668 ) , ( 2819 ) , ( 2670 ) , ( 2598 ) , ( 2666 ) , ( 2837 ) , ( 2837 ) , ( 2674 ) , ( 2729 ) , ( 2718 ) , ( 2716 ) , ( 2766 ) , ( 2704 ) , ( 1727 ) , ( 1727 ) , ( 2818 ) , ( 2586 ) , ( 2838 ) , ( 2838 ) , ( 2679 ) , ( 2593 ) , ( 2719 ) , ( 2681 ) , ( 2746 ) , ( 2793 ) , ( 2583 ) , ( 2585 ) , ( 2759 ) , ( 1722 ) , ( 1722 ) , ( 1722 ) , ( 2722 ) , ( 1760 ) , ( 1760 ) , ( 2584 ) , ( 2809 ) , ( 2152 ) , ( 2152 ) , ( 2152 ) , ( 2669 ) , ( 1767 ) , ( 1767 ) , ( 2683 ) , ( 2673 ) , ( 2708 ) , ( 1821 ) , ( 1821 ) , ( 2684 ) , ( 2685 ) , ( 2686 ) , ( 2589 ) , ( 2589 ) , ( 2796 ) , ( 2799 ) , ( 2817 ) , ( 2698 ) , ( 2728 ) , ( 2761 ) , ( 2676 ) , ( 2733 ) , ( 2688 ) , ( 2801 ) , ( 2721 ) , ( 2644 ) , ( 2717 ) , ( 2753 ) , ( 2690 ) , ( 2691 ) , ( 1778 ) , ( 1778 ) , ( 1774 ) , ( 1774 ) , ( 1784 ) , ( 1784 ) , ( 1788 ) , ( 1788 ) , ( 2692 ) , ( 2805 ) , ( 2695 ) , ( 2832 ) , ( 2754 ) , ( 2760 ) , ( 2734 ) , ( 2826 ) , ( 2682 ) , ( 2827 ) , ( 2830 ) , ( 2699 )  [nativecode=1062 ** Duplicate entry '2771' for key 1]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_task_action_temp ( contact_id ) VALUES  ( 2800 ) , ( 2747 ) , ( 2596 ) , ( 2724 ) , ( 2755 ) , ( 2771 ) , ( 2771 ) , ( 2648 ) , ( 2597 ) , ( 2794 ) , ( 2650 ) , ( 2653 ) , ( 2660 ) , ( 2736 ) , ( 2582 ) , ( 2613 ) , ( 2772 ) , ( 2781 ) , ( 2780 ) , ( 2675 ) , ( 2762 ) , ( 2659 ) , ( 2820 ) , ( 2680 ) , ( 2723 ) , ( 1786 ) , ( 1786 ) , ( 1783 ) , ( 1783 ) , ( 2614 ) , ( 2654 ) , ( 2802 ) , ( 2655 ) , ( 2807 ) , ( 2657 ) , ( 2658 ) , ( 2646 ) , ( 116 ) , ( 116 ) , ( 116 ) , ( 2797 ) , ( 2647 ) , ( 2815 ) , ( 2662 ) , ( 2663 ) , ( 2664 ) , ( 2616 ) , ( 2617 ) , ( 2624 ) , ( 2640 ) , ( 2641 ) , ( 2625 ) , ( 2642 ) , ( 2626 ) , ( 2643 ) , ( 2627 ) , ( 2628 ) , ( 2645 ) , ( 2629 ) , ( 2630 ) , ( 2615 ) , ( 2631 ) , ( 2632 ) , ( 2665 ) , ( 2633 ) , ( 2618 ) , ( 2634 ) , ( 2619 ) , ( 2635 ) , ( 2620 ) , ( 2636 ) , ( 2621 ) , ( 2637 ) , ( 2622 ) , ( 2638 ) , ( 2623 ) , ( 2639 ) , ( 2588 ) , ( 2667 ) , ( 2710 ) , ( 2649 ) , ( 2839 ) , ( 2839 ) , ( 315 ) , ( 315 ) , ( 315 ) , ( 315 ) , ( 1806 ) , ( 1806 ) , ( 2824 ) , ( 1776 ) , ( 1776 ) , ( 1812 ) , ( 1812 ) , ( 1820 ) , ( 1820 ) , ( 1780 ) , ( 1780 ) , ( 2715 ) , ( 2749 ) , ( 2742 ) , ( 2770 ) , ( 1769 ) , ( 1769 ) , ( 2812 ) , ( 2689 ) , ( 2750 ) , ( 2661 ) , ( 2737 ) , ( 2840 ) , ( 2840 ) , ( 2811 ) , ( 2668 ) , ( 2819 ) , ( 2670 ) , ( 2598 ) , ( 2666 ) , ( 2837 ) , ( 2837 ) , ( 2674 ) , ( 2729 ) , ( 2718 ) , ( 2716 ) , ( 2766 ) , ( 2704 ) , ( 1727 ) , ( 1727 ) , ( 2818 ) , ( 2586 ) , ( 2838 ) , ( 2838 ) , ( 2679 ) , ( 2593 ) , ( 2719 ) , ( 2681 ) , ( 2746 ) , ( 2793 ) , ( 2583 ) , ( 2585 ) , ( 2759 ) , ( 1722 ) , ( 1722 ) , ( 1722 ) , ( 2722 ) , ( 1760 ) , ( 1760 ) , ( 2584 ) , ( 2809 ) , ( 2152 ) , ( 2152 ) , ( 2152 ) , ( 2669 ) , ( 1767 ) , ( 1767 ) , ( 2683 ) , ( 2673 ) , ( 2708 ) , ( 1821 ) , ( 1821 ) , ( 2684 ) , ( 2685 ) , ( 2686 ) , ( 2589 ) , ( 2589 ) , ( 2796 ) , ( 2799 ) , ( 2817 ) , ( 2698 ) , ( 2728 ) , ( 2761 ) , ( 2676 ) , ( 2733 ) , ( 2688 ) , ( 2801 ) , ( 2721 ) , ( 2644 ) , ( 2717 ) , ( 2753 ) , ( 2690 ) , ( 2691 ) , ( 1778 ) , ( 1778 ) , ( 1774 ) , ( 1774 ) , ( 1784 ) , ( 1784 ) , ( 1788 ) , ( 1788 ) , ( 2692 ) , ( 2805 ) , ( 2695 ) , ( 2832 ) , ( 2754 ) , ( 2760 ) , ( 2734 ) , ( 2826 ) , ( 2682 ) , ( 2827 ) , ( 2830 ) , ( 2699 )  [nativecode=1062 ** Duplicate entry '2771' for key 1]"]
)

Rahul Bile

  • I post occasionally
  • **
  • Posts: 112
  • Karma: 16
  • impossible says, I M Possible
    • I AM POSSIBLE
Re: DB error on exporting
August 03, 2010, 07:40:39 am
Quote
The group 'Pers' has subgroups. Can that be the problem.
- Yes.

Please file an issue for above bug.

Rahul.
« Last Edit: August 03, 2010, 07:42:30 am by rahulbile »
Consider donating to CiviCRM if you use it. http://civicrm.org/donate

BigP

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
Re: DB error on exporting
August 03, 2010, 08:10:01 am
Where can i post the issues?

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: DB error on exporting
August 03, 2010, 05:26:59 pm
Please go here: http://issues.civicrm.org/jira/secure/Dashboard.jspa and click "Signup" for an account.

Then click Create An Issue

And copy and paste the above information.  That would be very helpful thank you.
Try CiviTeacher: the online video tutorial CiviCRM learning library.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • DB error on exporting

This forum was archived on 2017-11-26.