I have recently updated from Drupal 5 to Drupal 6, and believe that something might be wrong with my panels_page database scheme.

My current schema is as follows...

CREATE TABLE `panels_pane` (
`pid` int(10) NOT NULL default '0',
`did` int(10) NOT NULL default '0',
`panel` varchar(32) default NULL,
`type` varchar(32) default NULL,
`subtype` varchar(64) default NULL,
`shown` int(1) default '1',
`access` varchar(128) default NULL,
`visibility` text,
`configuration` longtext,
`cache` longtext,
`position` int(5) default NULL,
PRIMARY KEY (`pid`),
KEY `did` (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I'm beginning work on fixing up issues with the migration, and also with building more views. When attempting to build a new panel, there is an error since drupal is attempting to add a row to pid 0, which already exists.
Therefore, duplicate row causes an error.

Start of the error looks as such

Duplicate entry '0' for key 1 query: INSERT INTO panels_pane (did, panel, type, subtype, configuration, cache, shown, access, visibility, position) VALUES

I see that the panels_page.install file describes pid as serial, which I do not see reflected in the database, and the count has started over to 0.

Any advice to help me with my issue?

Comments

xrampage16’s picture

Title: Panels_page Schema » Panels_pane Schema
merlinofchaos’s picture

Status: Active » Closed (won't fix)

Panels 2 is no longer available and is unsupported. Marking all Panels 2 issues won't fix.