Hi David
The plugin is Page Lists Plus (no longer supported) but it seems to rely on the nulls when it helps to build the menu. But I think the problem is more general than that.
I have extracted a line from the db.gz file (I removed the page content to save space):
(40, 1, '2012-05-13 13:14:05', '2012-05-13 12:14:05', 'Some page stuff', 'Development', 1, 1, 0, '', '', '', 0, '', '', 'publish', 'closed', 'closed', '', 'development', '', '', '2013-01-07 22:48:34', '2013-01-07 22:48:34', '', 0, 'http://lewishamscouts.org.uk/?page_id=40', 4, 'page', '', 0),
and when I export the same row with phpmyadmin I get:
(40, 1, '2012-05-13 13:14:05', '2012-05-13 12:14:05', '', 'Development', 1, 1, 0, NULL, NULL, NULL, 0, NULL, '', 'publish', 'closed', 'closed', '', 'development', '', '', '2013-01-07 22:48:34', '2013-01-07 22:48:34', '', 0, 'http://lewishamscouts.org.uk/?page_id=40', 4, 'page', '', 0);
Note the 4 NULL values in myphpadmin version.
The table format is:
CREATE TABLEld_posts` (
ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_author bigint(20) unsigned NOT NULL DEFAULT ‘0’,
post_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_date_gmt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content longtext NOT NULL,
post_title text NOT NULL,
show_in_menu tinyint(1) NOT NULL DEFAULT ‘1’,
link_link tinyint(1) NOT NULL DEFAULT ‘1’,
no_follow_link tinyint(1) NOT NULL DEFAULT ‘0’,
alt_link_text varchar(250) DEFAULT NULL,
custom_link_class varchar(50) DEFAULT NULL,
redirect_url varchar(100) DEFAULT NULL,
target_blank tinyint(1) NOT NULL DEFAULT ‘0’,
alt_title_attribute varchar(250) DEFAULT NULL,
post_excerpt text NOT NULL,
post_status varchar(20) NOT NULL DEFAULT ‘publish’,
comment_status varchar(20) NOT NULL DEFAULT ‘open’,
ping_status varchar(20) NOT NULL DEFAULT ‘open’,
post_password varchar(20) NOT NULL DEFAULT ”,
post_name varchar(200) NOT NULL DEFAULT ”,
to_ping text NOT NULL,
pinged text NOT NULL,
post_modified datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_modified_gmt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content_filtered longtext NOT NULL,
post_parent bigint(20) unsigned NOT NULL DEFAULT ‘0’,
guid varchar(255) NOT NULL DEFAULT ”,
menu_order int(11) NOT NULL DEFAULT ‘0’,
post_type varchar(20) NOT NULL DEFAULT ‘post’,
post_mime_type varchar(100) NOT NULL DEFAULT ”,
comment_count bigint(20) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (ID),
KEY post_name (post_name),
KEY type_status_date (post_type,post_status,post_date,ID),
KEY post_parent (post_parent),
KEY post_author (post_author)
) ENGINE=MyISAM AUTO_INCREMENT=1702 DEFAULT CHARSET=utf8 ;`
Graham
