| Issue 50: | PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 | |
| 1 person starred this issue and may be notified of changes. | Back to list |
After updating Insert block and views input type, I saved and no error showed.
When I navigation away from the page, I get this error message:
/admin/structure/block
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'heron-views-eventstage6-block_1' for key 'tmd': INSERT INTO {block} (module, delta, theme, status, weight, region, pages, cache) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => views [:db_insert_placeholder_1] => eventstage6-block_1 [:db_insert_placeholder_2] => heron [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => -1 [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => -1 ) in drupal_write_record() (line 7106 of /var/local/donkeys-git-local/drupal-7/includes/common.inc).
Feb 13, 2013
#1
sidmouth...@gmail.com
Feb 14, 2013
Also experienced the same duplicate error with garland, avocet and heron deleted bid 1507, 1508, 1509, 1510, 1511, 1934, 1935, 1935, 1937 bid heron 2058 (ok) This could be a side effect of upgrade from D6 to D7 so monitor.
Feb 21, 2013
Clean out old views mysql> select bid,module,delta,theme from block where delta ='EventStage6-block_1' order by theme; +------+--------+---------------------+---------------+ | bid | module | delta | theme | +------+--------+---------------------+---------------+ | 1202 | views | EventStage6-block_1 | adaptivetheme | | 1035 | views | EventStage6-block_1 | amadou | | 896 | views | EventStage6-block_1 | rebrand | | 741 | views | EventStage6-block_1 | garland | | 652 | views | EventStage6-block_1 | pippa | +------+--------+---------------------+---------------+ 5 rows in set (0.00 sec) delete from block where bid = 1202; delete from block where bid = 1035; delete from block where bid = 896; delete from block where bid = 741; delete from block where bid = 652; mysql> select bid,module,delta,theme from block where delta ='EventStage1-block_1' order by theme; +------+--------+---------------------+---------------+ | bid | module | delta | theme | +------+--------+---------------------+---------------+ | 1198 | views | EventStage1-block_1 | adaptivetheme | | 1031 | views | EventStage1-block_1 | amadou | | 892 | views | EventStage1-block_1 | rebrand | | 737 | views | EventStage1-block_1 | garland | | 648 | views | EventStage1-block_1 | pippa | +------+--------+---------------------+---------------+ delete from block where bid = 1198; delete from block where bid = 1031; delete from block where bid = 892; delete from block where bid = 737; delete from block where bid = 648;
Feb 21, 2013
(No comment was entered for this change.)
Status:
Started
Feb 26, 2013
| bid | module | delta | theme | +------+--------+----------------------------------+---------+ | 1652 | views | 5b8be485be44c98cdd44c5d158c51172 | avocet | | 792 | views | 5b8be485be44c98cdd44c5d158c51172 | garland | | 1451 | views | 5b8be485be44c98cdd44c5d158c51172 | curlew | | 1881 | views | 5b8be485be44c98cdd44c5d158c51172 | heron | | 944 | views | 716c3756e793fa9c45b2ffb703c0971f | garland | | 1588 | views | 716c3756e793fa9c45b2ffb703c0971f | avocet | | 1452 | views | 716c3756e793fa9c45b2ffb703c0971f | curlew | | 1809 | views | 716c3756e793fa9c45b2ffb703c0971f | heron | | 1653 | views | 98fb01599c2ede9638cdc1cb40e5feb0 | avocet | | 1882 | views | 98fb01599c2ede9638cdc1cb40e5feb0 | heron | | 793 | views | 98fb01599c2ede9638cdc1cb40e5feb0 | garland | | 1453 | views | 98fb01599c2ede9638cdc1cb40e5feb0 | curlew | | 1887 | views | b9962ebde271f590b87508b8b6aba674 | heron | | 1658 | views | b9962ebde271f590b87508b8b6aba674 | avocet | | 791 | views | b9962ebde271f590b87508b8b6aba674 | garland | | 1458 | views | b9962ebde271f590b87508b8b6aba674 | curlew | | 1456 | views | Appeals-block_1 | curlew | | 1656 | views | Appeals-block_1 | avocet | | 707 | views | Appeals-block_1 | garland | | 1885 | views | Appeals-block_1 | heron | | 1768 | views | blogger-block | avocet | | 1769 | views | blogger-block | curlew | | 1770 | views | blogger-block | garland | | 1988 | views | blogger-block | heron | | 1460 | views | Blogger-block_1 | curlew | | 1889 | views | Blogger-block_1 | heron | | 1660 | views | Blogger-block_1 | avocet | | 1339 | views | Blogger-block_1 | garland | | 1890 | views | Bonaire-block_1 | heron | | 1661 | views | Bonaire-block_1 | avocet | | 950 | views | Bonaire-block_1 | garland | | 1461 | views | Bonaire-block_1 | curlew | | 1663 | views | BrookfieldFarm-block_1 | avocet | | 1892 | views | BrookfieldFarm-block_1 | heron | | 773 | views | BrookfieldFarm-block_1 | garland | | 1463 | views | BrookfieldFarm-block_1 | curlew | | 1664 | views | BuxtonArrival-block_1 | avocet | | 1893 | views | BuxtonArrival-block_1 | heron | | 774 | views | BuxtonArrival-block_1 | garland | | 1464 | views | BuxtonArrival-block_1 | curlew | | 1665 | views | BuxtonBlogs-block_1 | avocet | | 1894 | views | BuxtonBlogs-block_1 | heron | | 1465 | views | BuxtonBlogs-block_1 | curlew | | 771 | views | BuxtonBlogs-block_1 | garland | | 1896 | views | BuxtonNews-block_1 | heron | | 770 | views | BuxtonNews-block_1 | garland | | 1467 | views | BuxtonNews-block_1 | curlew | | 1667 | views | BuxtonNews-block_1 | avocet | | 768 | views | BuxtonResidents-block_1 | garland | | 1897 | views | BuxtonResidents-block_1 | heron | | 1668 | views | BuxtonResidents-block_1 | avocet | | 1468 | views | BuxtonResidents-block_1 | curlew | | 1469 | views | calendar-block_1 | curlew | | 1589 | views | calendar-block_1 | avocet | | 767 | views | calendar-block_1 | garland | | 1898 | views | calendar-block_1 | heron | | 1771 | views | calendar-block_2 | avocet | | 1989 | views | calendar-block_2 | heron | | 1772 | views | calendar-block_2 | curlew | | 1773 | views | calendar-block_2 | garland | | 1810 | views | calendar-calendar_block_1 | heron | | 1590 | views | calendar-calendar_block_1 | avocet | | 766 | views | calendar-calendar_block_1 | garland | | 1470 | views | calendar-calendar_block_1 | curlew | | 1669 | views | calendar_est-block_1 | avocet | | 711 | views | calendar_est-block_1 | garland | | 1899 | views | calendar_est-block_1 | heron | | 1471 | views | calendar_est-block_1 | curlew | | 710 | views | calendar_est-calendar_block_1 | garland | | 1472 | views | calendar_est-calendar_block_1 | curlew | | 1811 | views | calendar_est-calendar_block_1 | heron | | 1591 | views | calendar_est-calendar_block_1 | avocet | | 1900 | views | calendar_training-block_1 | heron | | 943 | views | calendar_training-block_1 | garland | | 1670 | views | calendar_training-block_1 | avocet | | 1473 | views | calendar_training-block_1 | curlew | | 1474 | views | Cameroon-block_1 | curlew | | 712 | views | Cameroon-block_1 | garland | | 1901 | views | Cameroon-block_1 | heron | | 1671 | views | Cameroon-block_1 | avocet | | 713 | views | Campaigns-block_1 | garland | | 1475 | views | Campaigns-block_1 | curlew | | 1672 | views | Campaigns-block_1 | avocet | | 1902 | views | Campaigns-block_1 | heron | -------------------------------------------------------------- | 1476 | views | carousel_india-block_2 | curlew | | 1903 | views | carousel_india-block_2 | heron | | 1673 | views | carousel_india-block_2 | avocet | | 714 | views | carousel_india-block_2 | garland | | 715 | views | carousel_rug_appeal-block_2 | garland | | 1477 | views | carousel_rug_appeal-block_2 | curlew | | 1674 | views | carousel_rug_appeal-block_2 | avocet | | 1904 | views | carousel_rug_appeal-block_2 | heron | | 1478 | views | carousel_south_africa-block_2 | curlew | | 1675 | views | carousel_south_africa-block_2 | avocet | | 1905 | views | carousel_south_africa-block_2 | heron | | 716 | views | carousel_south_africa-block_2 | garland | # Delete carousel views. delete from block where bid = 1476; delete from block where bid = 1903; delete from block where bid = 1673; delete from block where bid = 714; delete from block where bid = 715; delete from block where bid = 1477; delete from block where bid = 1674; delete from block where bid = 1904; delete from block where bid = 1478; delete from block where bid = 1675; delete from block where bid = 1905; delete from block where bid = 716; -------------------------------------------------------------- | 1479 | views | CentreNews-block_1 | curlew | | 1906 | views | CentreNews-block_1 | heron | | 1676 | views | CentreNews-block_1 | avocet | | 966 | views | CentreNews-block_1 | garland | | 967 | views | CentreNews-block_2 | garland | | 1480 | views | CentreNews-block_2 | curlew | | 1677 | views | CentreNews-block_2 | avocet | | 1907 | views | CentreNews-block_2 | heron | | 1678 | views | CentreNews-block_3 | avocet | | 968 | views | CentreNews-block_3 | garland | | 1481 | views | CentreNews-block_3 | curlew | | 1908 | views | CentreNews-block_3 | heron | | 1679 | views | CentreNews-block_4 | avocet | | 1909 | views | CentreNews-block_4 | heron | | 1482 | views | CentreNews-block_4 | curlew | | 969 | views | CentreNews-block_4 | garland | | 1910 | views | CentreNews-block_5 | heron | | 970 | views | CentreNews-block_5 | garland | | 1680 | views | CentreNews-block_5 | avocet | | 1483 | views | CentreNews-block_5 | curlew | | 1484 | views | CentreNews-block_6 | curlew | | 971 | views | CentreNews-block_6 | garland | | 1681 | views | CentreNews-block_6 | avocet | | 1911 | views | CentreNews-block_6 | heron | | 1912 | views | China-block_1 | heron | | 1682 | views | China-block_1 | avocet | | 717 | views | China-block_1 | garland | | 1485 | views | China-block_1 | curlew | | 1488 | views | DonkeyTourWorkshops-block_1 | curlew | | 720 | views | DonkeyTourWorkshops-block_1 | garland | | 1685 | views | DonkeyTourWorkshops-block_1 | avocet | | 1915 | views | DonkeyTourWorkshops-block_1 | heron | | 721 | views | DonkeyWeek-block_1 | garland | | 1916 | views | DonkeyWeek-block_1 | heron | | 1686 | views | DonkeyWeek-block_1 | avocet | | 1489 | views | DonkeyWeek-block_1 | curlew | | 1490 | views | Dreams-block_1 | curlew | | 1687 | views | Dreams-block_1 | avocet | | 1917 | views | Dreams-block_1 | heron | | 722 | views | Dreams-block_1 | garland | | 723 | views | EastAxnollerFarm-block_1 | garland | | 1688 | views | EastAxnollerFarm-block_1 | avocet | | 1918 | views | EastAxnollerFarm-block_1 | heron | | 1491 | views | EastAxnollerFarm-block_1 | curlew | | 1689 | views | Egypt-block_1 | avocet | | 1492 | views | Egypt-block_1 | curlew | | 724 | views | Egypt-block_1 | garland | | 1919 | views | Egypt-block_1 | heron | | 1921 | views | ElisabethSvendsen-block_1 | heron | | 1691 | views | ElisabethSvendsen-block_1 | avocet | | 1494 | views | ElisabethSvendsen-block_1 | curlew | | 726 | views | ElisabethSvendsen-block_1 | garland | | 1692 | views | EnvironmentFriendly-block_1 | avocet | | 727 | views | EnvironmentFriendly-block_1 | garland | | 1922 | views | EnvironmentFriendly-block_1 | heron | | 1495 | views | EnvironmentFriendly-block_1 | curlew | | 1496 | views | ESTNews-block_1 | curlew | | 728 | views | ESTNews-block_1 | garland | | 1693 | views | ESTNews-block_1 | avocet | | 1923 | views | ESTNews-block_1 | heron | | 1924 | views | Ethiopia-block_1 | heron | | 729 | views | Ethiopia-block_1 | garland | | 1497 | views | Ethiopia-block_1 | curlew | | 1694 | views | Ethiopia-block_1 | avocet | | 1695 | views | Ethiopia-block_2 | avocet | | 1498 | views | Ethiopia-block_2 | curlew | | 797 | views | Ethiopia-block_2 | garland | | 1925 | views | Ethiopia-block_2 | heron | | 730 | views | EthiopiaCommunity-block_1 | garland | | 1926 | views | EthiopiaCommunity-block_1 | heron | | 1696 | views | EthiopiaCommunity-block_1 | avocet | | 1499 | views | EthiopiaCommunity-block_1 | curlew | | 1927 | views | EthiopiaDirectHelp-block_1 | heron | | 1697 | views | EthiopiaDirectHelp-block_1 | avocet | | 1500 | views | EthiopiaDirectHelp-block_1 | curlew | | 731 | views | EthiopiaDirectHelp-block_1 | garland | | 1700 | views | EventDerbyshire-block_1 | avocet | | 734 | views | EventDerbyshire-block_1 | garland | | 1503 | views | EventDerbyshire-block_1 | curlew | | 1930 | views | EventDerbyshire-block_1 | heron | | 735 | views | EventEST-block_1 | garland | | 1931 | views | EventEST-block_1 | heron | | 1504 | views | EventEST-block_1 | curlew | | 1701 | views | EventEST-block_1 | avocet | | 1932 | views | EventSidmouth-block_1 | heron | | 1702 | views | EventSidmouth-block_1 | avocet | | 1505 | views | EventSidmouth-block_1 | curlew | | 799 | views | EventSidmouth-block_1 | garland | | 1703 | views | EventSponsorDonkey-block_1 | avocet | | 736 | views | EventSponsorDonkey-block_1 | garland | | 1506 | views | EventSponsorDonkey-block_1 | curlew | | 1933 | views | EventSponsorDonkey-block_1 | heron | | 1709 | views | FosteredDonkeys-block_1 | avocet | | 1939 | views | FosteredDonkeys-block_1 | heron | | 1512 | views | FosteredDonkeys-block_1 | curlew | | 742 | views | FosteredDonkeys-block_1 | garland | | 1940 | views | frontpage-block_1 | heron | | 1513 | views | frontpage-block_1 | curlew | | 1710 | views | frontpage-block_1 | avocet | | 743 | views | frontpage-block_1 | garland | | 1774 | views | frontpage-block_2 | curlew | | 1776 | views | frontpage-block_2 | garland | | 1775 | views | frontpage-block_2 | avocet | | 1987 | views | frontpage-block_2 | heron | | 1941 | views | Fundraise-block_1 | heron | | 1349 | views | Fundraise-block_1 | garland | | 1514 | views | Fundraise-block_1 | curlew | | 1711 | views | Fundraise-block_1 | avocet | | 2104 | views | FundraisersGallery-block_1 | garland | | 2103 | views | FundraisersGallery-block_1 | curlew | | 2105 | views | FundraisersGallery-block_1 | heron | | 2102 | views | FundraisersGallery-block_1 | avocet | | 1516 | views | FundraisingEvents-block_1 | curlew | | 1713 | views | FundraisingEvents-block_1 | avocet | | 745 | views | FundraisingEvents-block_1 | garland | | 1943 | views | FundraisingEvents-block_1 | heron | | 1517 | views | India-block_1 | curlew | | 1944 | views | India-block_1 | heron | | 1714 | views | India-block_1 | avocet | | 746 | views | India-block_1 | garland | | 1782 | views | international-block | garland | | 1780 | views | international-block | curlew | | 1781 | views | international-block | avocet | | 1986 | views | international-block | heron | | 750 | views | Kenya-block_1 | garland | | 1522 | views | Kenya-block_1 | curlew | | 1949 | views | Kenya-block_1 | heron | | 1719 | views | Kenya-block_1 | avocet | | 1721 | views | Lamu-block_1 | avocet | | 752 | views | Lamu-block_1 | garland | | 1524 | views | Lamu-block_1 | curlew | | 1951 | views | Lamu-block_1 | heron | | 754 | views | LastingGift-block_1 | garland | | 1953 | views | LastingGift-block_1 | heron | | 1526 | views | LastingGift-block_1 | curlew | | 1723 | views | LastingGift-block_1 | avocet | | 1954 | views | Legacies-block_1 | heron | | 1527 | views | Legacies-block_1 | curlew | | 1724 | views | Legacies-block_1 | avocet | | 755 | views | Legacies-block_1 | garland | | 1528 | views | Links-block_1 | curlew | | 1725 | views | Links-block_1 | avocet | | 1955 | views | Links-block_1 | heron | | 756 | views | Links-block_1 | garland | | 1956 | views | LoanSchemeCaseStudies-block_1 | heron | | 757 | views | LoanSchemeCaseStudies-block_1 | garland | | 1529 | views | LoanSchemeCaseStudies-block_1 | curlew | | 1726 | views | LoanSchemeCaseStudies-block_1 | avocet | | 1958 | views | LoanSchemeTestimonials-block_1 | heron | | 1728 | views | LoanSchemeTestimonials-block_1 | avocet | | 1531 | views | LoanSchemeTestimonials-block_1 | curlew | | 759 | views | LoanSchemeTestimonials-block_1 | garland | | 1532 | views | LoanSchemeTestimonials-block_2 | curlew | | 1959 | views | LoanSchemeTestimonials-block_2 | heron | | 1347 | views | LoanSchemeTestimonials-block_2 | garland | | 1729 | views | LoanSchemeTestimonials-block_2 | avocet | | 1960 | views | Memorials-block_1 | heron | | 1533 | views | Memorials-block_1 | curlew | | 1730 | views | Memorials-block_1 | avocet | | 760 | views | Memorials-block_1 | garland | | 761 | views | Mexico-block_1 | garland | | 1731 | views | Mexico-block_1 | avocet | | 1534 | views | Mexico-block_1 | curlew | | 1961 | views | Mexico-block_1 | heron | | 1962 | views | Mexico-block_2 | heron | | 1535 | views | Mexico-block_2 | curlew | | 1303 | views | Mexico-block_2 | garland | | 1732 | views | Mexico-block_2 | avocet | | 1537 | views | Morocco-block_1 | curlew | | 1734 | views | Morocco-block_1 | avocet | | 763 | views | Morocco-block_1 | garland | | 1964 | views | Morocco-block_1 | heron | | 1538 | views | Mules-block_1 | curlew | | 1965 | views | Mules-block_1 | heron | | 1735 | views | Mules-block_1 | avocet | | 764 | views | Mules-block_1 | garland | | 1966 | views | Nepal-block_1 | heron | | 1539 | views | Nepal-block_1 | curlew | | 1736 | views | Nepal-block_1 | avocet | | 765 | views | Nepal-block_1 | garland | | 709 | views | PaccombeFarm-block_1 | garland | | 1967 | views | PaccombeFarm-block_1 | heron | | 1737 | views | PaccombeFarm-block_1 | avocet | | 1540 | views | PaccombeFarm-block_1 | curlew | | 1738 | views | Peru-block_1 | avocet | | 1968 | views | Peru-block_1 | heron | | 1541 | views | Peru-block_1 | curlew | | 775 | views | Peru-block_1 | garland | | 1740 | views | PressRoom-block_1 | avocet | | 1543 | views | PressRoom-block_1 | curlew | | 777 | views | PressRoom-block_1 | garland | | 1970 | views | PressRoom-block_1 | heron | | 1742 | views | Romania-block_1 | avocet | | 1972 | views | Romania-block_1 | heron | | 1144 | views | Romania-block_1 | garland | | 1545 | views | Romania-block_1 | curlew | | 779 | views | SladeHouseFarm-block_1 | garland | | 1546 | views | SladeHouseFarm-block_1 | curlew | | 1743 | views | SladeHouseFarm-block_1 | avocet | | 1973 | views | SladeHouseFarm-block_1 | heron | | 1547 | views | south_africa-block_1 | curlew | | 780 | views | south_africa-block_1 | garland | | 1744 | views | south_africa-block_1 | avocet | | 1974 | views | south_africa-block_1 | heron | | 782 | views | SupportUs-block_1 | garland | | 1549 | views | SupportUs-block_1 | curlew | | 1746 | views | SupportUs-block_1 | avocet | | 1976 | views | SupportUs-block_1 | heron | | 783 | views | Tanzania-block_1 | garland | | 1550 | views | Tanzania-block_1 | curlew | | 1977 | views | Tanzania-block_1 | heron | | 1747 | views | Tanzania-block_1 | avocet | | 784 | views | TownBartonFarm-block_1 | garland | | 1978 | views | TownBartonFarm-block_1 | heron | | 1551 | views | TownBartonFarm-block_1 | curlew | | 1748 | views | TownBartonFarm-block_1 | avocet | | 2083 | views | trainingcourses-block | curlew | | 2088 | views | trainingcourses-block | garland | | 2078 | views | trainingcourses-block | avocet | | 2093 | views | trainingcourses-block | heron | | 2089 | views | trainingcourses-block_1 | garland | | 2079 | views | trainingcourses-block_1 | avocet | | 2094 | views | trainingcourses-block_1 | heron | | 2084 | views | trainingcourses-block_1 | curlew | | 2090 | views | trainingcourses-block_2 | garland | | 2095 | views | trainingcourses-block_2 | heron | | 2080 | views | trainingcourses-block_2 | avocet | | 2085 | views | trainingcourses-block_2 | curlew | | 2091 | views | trainingcourses-block_3 | garland | | 2081 | views | trainingcourses-block_3 | avocet | | 2096 | views | trainingcourses-block_3 | heron | | 2086 | views | trainingcourses-block_3 | curlew | | 2097 | views | trainingcourses-block_4 | heron | | 2092 | views | trainingcourses-block_4 | garland | | 2087 | views | trainingcourses-block_4 | curlew | | 2082 | views | trainingcourses-block_4 | avocet | | 1980 | views | TrowFarm-block_1 | heron | | 1750 | views | TrowFarm-block_1 | avocet | | 785 | views | TrowFarm-block_1 | garland | | 1553 | views | TrowFarm-block_1 | curlew | | 1981 | views | VideoClips-block_1 | heron | | 1751 | views | VideoClips-block_1 | avocet | | 1554 | views | VideoClips-block_1 | curlew | | 786 | views | VideoClips-block_1 | garland | | 1982 | views | VideoClipsWelfare-block_1 | heron | | 1555 | views | VideoClipsWelfare-block_1 | curlew | | 787 | views | VideoClipsWelfare-block_1 | garland | | 1752 | views | VideoClipsWelfare-block_1 | avocet | | 1983 | views | WhatsOn-block_1 | heron | | 1753 | views | WhatsOn-block_1 | avocet | | 1556 | views | WhatsOn-block_1 | curlew | | 788 | views | WhatsOn-block_1 | garland | | 1754 | views | WoodsFarm-block_1 | avocet | | 789 | views | WoodsFarm-block_1 | garland | | 1557 | views | WoodsFarm-block_1 | curlew | | 1984 | views | WoodsFarm-block_1 | heron | | 2051 | views | working_worldwide-block | avocet | | 2053 | views | working_worldwide-block | curlew | | 2057 | views | working_worldwide-block | heron | | 2055 | views | working_worldwide-block | garland | | 1985 | views | Zambia-block_1 | heron | | 1558 | views | Zambia-block_1 | curlew | | 790 | views | Zambia-block_1 | garland | | 1755 | views | Zambia-block_1 | avocet | +------+--------+----------------------------------+---------+ 360 rows in set (0.03 sec) |