Restoring database with columns set to null did not work

Hi Graham,

Thanks for the report… please can you tell me the plugin, and (if necessary or if it’ll speed things), some steps I can take to reproduce the problem?

Also it’d really help if you could copy the lines of SQL from your database backup (the db.gz file), and also show me what phpMyAdmin outputs for the same lines. (In fact UpdraftPlus took its SQL dump code from phpMyAdmin, because of its reputation/reliability – many many moons ago (actually in the days of the original Updraft plugin)).

David

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, 'https://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, 'https://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

Hi Graham,

Thanks. Please could you try the development version? I believe it’s now fixed – https://updraftplus.com/faqs/devversion

David

Hi David

I have tested this on the test version of my site by running a backup and then a restore of the database and the problem was fixed.

Should I install the dev version on the main site or will there be a new release with the fix released soon?

Thanks

Graham

Hi Graham,

Great, glad to hear we fixed it. Yes, just install the dev version – it’s more-or-less what’ll be in the next release, all being well.

David

Hi David

Sorry, I installed the dev version (1.6.42) (deactivate, delete, upload) but now it is not recognising the Migration Plugin. Is there something else I need to do?

Regards

Graham

Hi Graham,

No, you didn’t do anything wrong – it’s not yet possible to get add-ons for development versions; I’d forgotten that you were a customer. Please let me know your order number, and I can email you a version to use instead.

David

Hi David

It is 1520

Regards

Graham

Hi Graham,

Thanks – I’ve emailed you the zip for installing now. Do let me know if you don’t receive it.

David