grafastudio
27-06-2016, 11:31
Witam. Przenoszę stronę na inny serwer i podczas importu bazy danych wyskakuje mi błąd:
#1064 - Something is wrong in your syntax obok '3607', '2015-01-10 06:17:01', '37.99.107.208', 'http://bibliotekamilicz.pl/admin' w linii 1
Tak wyglądają początkowe linie bazy:
DROP TABLE IF EXISTS `wdip_admintools_acl`;CREATE TABLE `wdip_admintools_acl` ( `user_id` bigint(20) unsigned NOT NULL, `permissions` mediumtext, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `wdip_admintools_acl` VALUES ('63', '{\"utils\":1,\"security\":0,\"maintenance\":0}');
DROP TABLE IF EXISTS `wdip_admintools_adminiplist`;
CREATE TABLE `wdip_admintools_adminiplist` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `wdip_admintools_badwords`;
CREATE TABLE `wdip_admintools_badwords` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `word` varchar(255) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `wdip_admintools_customperms`;
CREATE TABLE `wdip_admintools_customperms` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) NOT NULL, `perms` varchar(4) DEFAULT '0644', UNIQUE KEY `id` (`id`), KEY `path` (`path`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
INSERT INTO `wdip_admintools_customperms` VALUES ('40', 'plugins', '0755'), ('39', 'modules', '0755'), ('38', 'media', '0755'), ('37', 'logs', '0755'), ('36', 'libraries', '0755'), ('35', 'language', '0755'), ('34', 'includes', '0755'), ('33', 'images', '0755'), ('32', 'components', '0755'), ('31', 'cgi-bin', '0755'), ('30', 'cache', '0755'), ('29', 'administrator', '0755'), ('28', '_vti_txt', '0755'), ('27', '_vti_pvt', '0755'), ('26', '_vti_log', '0755'), ('25', '_vti_cnf', '0755'), ('24', '_vti_bin', '0755'), ('23', '_private', '0755'), ('41', 'templates', '0755'), ('42', 'tmp', '0755'), ('43', 'user', '0755'), ('44', 'xmlrpc', '0755');
DROP TABLE IF EXISTS `wdip_admintools_filescache`;
CREATE TABLE `wdip_admintools_filescache` ( `admintools_filescache_id` bigint(20) NOT NULL AUTO_INCREMENT, `path` varchar(2048) NOT NULL, `filedate` int(11) NOT NULL DEFAULT '0', `filesize` int(11) NOT NULL DEFAULT '0', `data` blob, `checksum` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`admintools_filescache_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1821 DEFAULT CHARSET=utf8;
#1064 - Something is wrong in your syntax obok '3607', '2015-01-10 06:17:01', '37.99.107.208', 'http://bibliotekamilicz.pl/admin' w linii 1
Tak wyglądają początkowe linie bazy:
DROP TABLE IF EXISTS `wdip_admintools_acl`;CREATE TABLE `wdip_admintools_acl` ( `user_id` bigint(20) unsigned NOT NULL, `permissions` mediumtext, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `wdip_admintools_acl` VALUES ('63', '{\"utils\":1,\"security\":0,\"maintenance\":0}');
DROP TABLE IF EXISTS `wdip_admintools_adminiplist`;
CREATE TABLE `wdip_admintools_adminiplist` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `wdip_admintools_badwords`;
CREATE TABLE `wdip_admintools_badwords` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `word` varchar(255) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `wdip_admintools_customperms`;
CREATE TABLE `wdip_admintools_customperms` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) NOT NULL, `perms` varchar(4) DEFAULT '0644', UNIQUE KEY `id` (`id`), KEY `path` (`path`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
INSERT INTO `wdip_admintools_customperms` VALUES ('40', 'plugins', '0755'), ('39', 'modules', '0755'), ('38', 'media', '0755'), ('37', 'logs', '0755'), ('36', 'libraries', '0755'), ('35', 'language', '0755'), ('34', 'includes', '0755'), ('33', 'images', '0755'), ('32', 'components', '0755'), ('31', 'cgi-bin', '0755'), ('30', 'cache', '0755'), ('29', 'administrator', '0755'), ('28', '_vti_txt', '0755'), ('27', '_vti_pvt', '0755'), ('26', '_vti_log', '0755'), ('25', '_vti_cnf', '0755'), ('24', '_vti_bin', '0755'), ('23', '_private', '0755'), ('41', 'templates', '0755'), ('42', 'tmp', '0755'), ('43', 'user', '0755'), ('44', 'xmlrpc', '0755');
DROP TABLE IF EXISTS `wdip_admintools_filescache`;
CREATE TABLE `wdip_admintools_filescache` ( `admintools_filescache_id` bigint(20) NOT NULL AUTO_INCREMENT, `path` varchar(2048) NOT NULL, `filedate` int(11) NOT NULL DEFAULT '0', `filesize` int(11) NOT NULL DEFAULT '0', `data` blob, `checksum` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`admintools_filescache_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1821 DEFAULT CHARSET=utf8;