When I adding block into the panel ,I suddenly got a message on the top :

'user warning: Duplicate entry '0' for key 'PRIMARY' query: INSERT INTO panels_pane (pid, did, panel, type, subtype, configuration, cache, shown, access, visibility, position) VALUES (0, 1, '', '', '', 'N;', 'a:0:{}', '1', '', '', 1) in /home/freelylw/public_html/yinglun.co.uk/includes/database.mysql.inc on line 174.'

What should I do now ?? I never have this problem before by using panels

I try to del the block I just added , and add it again, still got the same message !!

Please help !!

Please help !!

Comments

freelylw’s picture

anybody can help ? the message still there everyday.

reubenavery’s picture

I'm also experiencing this error. Was able to fix it by checking out the panels_pane table, there were some bogus rows in there. Also had to empty out the panels_object_cache table as well before the error went away.

merlinofchaos’s picture

Status: Active » Closed (won't fix)

With the release of Drupal 7, Drupal 5 is no longer supported.

seanr’s picture

Version: 5.x-2.x-dev » 7.x-3.0-alpha1
Status: Closed (won't fix) » Active

I just got this in D7.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '487' for key 'PRIMARY': INSERT INTO {panels_pane} (pid, did, panel, type, subtype, shown, access, configuration, cache, style, css, extras, position) 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, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12); Array ( [:db_insert_placeholder_0] => 487 [:db_insert_placeholder_1] => 11 [:db_insert_placeholder_2] => right [:db_insert_placeholder_3] => entity_field [:db_insert_placeholder_4] => node:field_image_drawing [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => a:0:{} [:db_insert_placeholder_7] => a:6:{s:5:"label";s:6:"hidden";s:9:"formatter";s:5:"image";s:18:"formatter_settings";a:2:{s:11:"image_style";s:0:"";s:10:"image_link";s:0:"";}s:7:"context";s:25:"argument_entity_id:node_1";s:14:"override_title";i:0;s:19:"override_title_text";s:0:"";} [:db_insert_placeholder_8] => a:0:{} [:db_insert_placeholder_9] => a:1:{s:8:"settings";N;} [:db_insert_placeholder_10] => a:0:{} [:db_insert_placeholder_11] => a:0:{} [:db_insert_placeholder_12] => 11 ) in drupal_write_record() (line 6868 of /var/www/vhosts/d7.aavid.d3.local/htdocs/includes/common.inc).

I'd really like to save this panel... ;-)

esmerel’s picture

Version: 7.x-3.0-alpha1 » 5.x-2.x-dev
Status: Active » Closed (won't fix)

The entire code base has pretty much been rewritten. Whatever caused this problem in 5.x is unlikely to have caused this problem two full Drupal versions and one full Panels version later. This needs to be opened as a new 7.x-3.x issue.

lukaswhite’s picture

Same problem (with Drupal 7) - have you opened a new D7 issue, seanr?

ianthomas_uk’s picture

For the benefit of anyone who stumbles across this from a web search:

I was also seeing this error in Drupal 7, but it seemed to fix itself after I re-exported the feature containing the panel, so I suspect I either had a problem with my feature (e.g. two panels with the same id) or a conflict between my feature and the database. I don't know if either of those things should be possible, but I've stopped investigating as I can no longer reproduce the problem.

islalobo’s picture

I am having this issue and stumbled upon this post by doing a websearch.

Using Drupal 7.

What do you mean when you say that you:

re-exported the feature containing the panel

ianthomas_uk’s picture

Features is a module that allows you to save a copy of parts of your Drupal site (e.g. panels) as PHP code. I "saved" my panel as a Feature, then restored the panel from the Feature.

http://drupal.org/project/features