search

deliciousbrains / wp-migrate-db

WordPress plugin that exports your database, does a find and replace on URLs and file paths, then allows you to save it to your computer.
https://wordpress.org/plugins/wp-migrate-db/
342 stars 515 forks source link

Migration add non exists extra field at the end #94

Closed maki10 closed 2 years ago

maki10 commented 5 years ago

Error : Column count doesn't match value count at row 1

DROP TABLE IF EXISTS `wp_supsystic_ss_project_networks`;

#
# Table structure of table `wp_supsystic_ss_project_networks`
#

CREATE TABLE `wp_supsystic_ss_project_networks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) unsigned DEFAULT NULL,
  `network_id` int(11) unsigned DEFAULT NULL,
  `position` int(11) unsigned DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `tooltip` varchar(255) DEFAULT NULL,
  `text_format` varchar(255) DEFAULT NULL,
  `profile_name` varchar(255) DEFAULT NULL,
  `icon_image` int(11) unsigned DEFAULT NULL,
  `use_short_url` bit(1) DEFAULT NULL,
  `mail_to_default` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK__wp_supsystic_ss_projects` (`project_id`),
  KEY `FK__wp_supsystic_ss_networks` (`network_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

#
# Data contents of table `wp_supsystic_ss_project_networks`
#
INSERT INTO `wp_supsystic_ss_project_networks` ( `id`, `project_id`, `network_id`, `position`, `title`, `text`, `tooltip`, `text_format`, `profile_name`, `icon_image`, `use_short_url`, `mail_to_default`) VALUES
(5, 1, 1, 2, NULL, NULL, NULL, NULL, NULL, 103, NULL, NULL, NULL),
(6, 1, 2, 1, NULL, NULL, NULL, NULL, NULL, 105, NULL, NULL, NULL),
(7, 1, 3, 0, NULL, NULL, NULL, NULL, NULL, 106, NULL, NULL, NULL),
(8, 1, 13, 3, NULL, NULL, NULL, NULL, NULL, 104, NULL, NULL, NULL) ;

INSERT(12 FIELDS) VALUES (13 FIELDS)

That fields is for plugin:

 -  Social Share Buttons by Supsystic (v2.0.7) by supsystic.com