PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062

GoogleCodeExporter commented 9 years ago

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).

Original issue reported on code.google.com by jenifer....@gmail.com on 13 Feb 2013 at 12:14

GoogleCodeExporter commented 9 years ago

Fixed (I think)

mysql > select bid,module,delta,theme from block where theme='heron' order by 
delta asc;

mysql > delete from block where bid = 1938;

Original comment by sidmouth...@gmail.com on 13 Feb 2013 at 3:10

GoogleCodeExporter commented 9 years ago

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.

Original comment by jenifer....@gmail.com on 14 Feb 2013 at 7:55

GoogleCodeExporter commented 9 years ago

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;

Original comment by jenifer....@gmail.com on 21 Feb 2013 at 1:07

GoogleCodeExporter commented 9 years ago

Original comment by jenifer....@gmail.com on 21 Feb 2013 at 4:17

Changed state: Started

GoogleCodeExporter commented 9 years ago

[deleted comment]

GoogleCodeExporter commented 9 years ago

| 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)

Original comment by jenifer....@gmail.com on 26 Feb 2013 at 6:16

JeniferTucker / martha

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 #50