Обучение/Помощь новичкам | база
В чем ошибка? С меня 50р +и арбик
DROP TABLE IF EXISTS `adm_ch_file`;
CREATE TABLE `adm_ch_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`post_id` int(11) NOT NULL,
`name_file` varchar(244) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
INSERT INTO adm_ch_file VALUES("1","408","xteem.ru_4725_1427_vMk38.gif");
INSERT INTO adm_ch_file VALUES("2","410","xteem.ru_2269_3805_(R)(R)(R)(R)(R)(R)(R)Adidas.jpg");
INSERT INTO adm_ch_file VALUES("3","415","xteem.ru_3069_3876_Screenshot_1.png");
INSERT INTO adm_ch_file VALUES("4","425","xteem.ru_2968_2879_Screenshot_2.png");
INSERT INTO adm_ch_file VALUES("5","653","xteem.ru_2303_3896_Screenshot_2015-01-13-19-30-20.png");
INSERT INTO adm_ch_file VALUES("6","732","xteem.ru_4252_1546_Screenshot_2015-01-16-14-09-55.png");
INSERT INTO adm_ch_file VALUES("7","733","xteem.ru_4771_2047_Screenshot_2015-01-16-14-09-55.png");
INSERT INTO adm_ch_file VALUES("8","787","xteem.ru_2883_3069_wso2.php.png");
DROP TABLE IF EXISTS `admin_chat`;
CREATE TABLE `admin_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` varchar(255) NOT NULL,
`time` int(11) NOT NULL,
`avtor` int(11) NOT NULL,
`id_komu` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `ads`;
CREATE TABLE `ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`time_srok` varchar(255) DEFAULT NULL,
`kogda` varchar(255) DEFAULT NULL,
`color` varchar(244) CHARACTER SET utf8 NOT NULL,
`b` int(11) NOT NULL DEFAULT '0',
`i` int(11) NOT NULL DEFAULT '0',
`tip` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251;
INSERT INTO ads VALUES("1","Заказать рекламу 3 рубля","http://xteem.ru/WebMoney/","1433349400","1422808600","008000","1","1","0");
DROP TABLE IF EXISTS `anketa`;
CREATE TABLE `anketa` (
`name` varchar(20) DEFAULT NULL,
`id_us` int(11) DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`osebe` varchar(500) DEFAULT NULL,
`interes` varchar(500) DEFAULT NULL,
`data` varchar(20) NOT NULL DEFAULT '0',
`oigre` varchar(500) NOT NULL,
UNIQUE KEY `nick` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO anketa VALUES("","183849","","","","0","");
INSERT INTO anketa VALUES("","576406","","","","0","");
INSERT INTO anketa VALUES("","79531","","","","0","");
INSERT INTO anketa VALUES("Миша","552992","Рожище","","","26.10.1999","");
INSERT INTO anketa VALUES("","263223","","","","0","");
INSERT INTO anketa VALUES("","56240","","","","0","");
INSERT INTO anketa VALUES("","501490","","","","0","");
INSERT INTO anketa VALUES("","135359","","","","0","");
INSERT INTO anketa VALUES("Лика","595807","Смоленск","Добрая и честная...","Думаю вам будут не интересны мои интересы:)","6.6.6","Хорошая игра!)");
INSERT INTO anketa VALUES("","595838","","","","0","");
INSERT INTO anketa VALUES("","201062","","","","0","");
INSERT INTO anketa VALUES("","281561","","","","0","");
INSERT INTO anketa VALUES("","595833","","","","0","");
INSERT INTO anketa VALUES("Рома","595906","Донецк","Футболист","Футбол","25 мая","Нормик ");
INSERT INTO anketa VALUES("","595910","","","","0","");
INSERT INTO anketa VALUES("Андрей","595909","Киев","Есть девушка","Футбол, бокс, музыка- дабстеп и реп.","26 января 1995","Очень клас и интересов.");
INSERT INTO anketa VALUES("","595914","","","","0","");
DROP TABLE IF EXISTS `antispam`;
CREATE TABLE `antispam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news` varchar(244) NOT NULL,
`stena` varchar(244) NOT NULL,
`chat` varchar(244) NOT NULL,
`forum_tema` varchar(255) NOT NULL,
`forum_post` varchar(255) NOT NULL,
`guest` varchar(255) NOT NULL,
`blog` varchar(244) NOT NULL,
`mes` varchar(244) NOT NULL,
`down` varchar(244) NOT NULL,
`repa` varchar(255) NOT NULL,
`friends` varchar(244) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO antispam VALUES("1","60","60","60","60","1","60","60","60","60","4","60");
DROP TABLE IF EXISTS `arena_log`;
CREATE TABLE `arena_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_pro` int(11) NOT NULL,
`tip` int(11
DROP TABLE IF EXISTS `adm_ch_file`;
CREATE TABLE `adm_ch_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`post_id` int(11) NOT NULL,
`name_file` varchar(244) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
INSERT INTO adm_ch_file VALUES("1","408","xteem.ru_4725_1427_vMk38.gif");
INSERT INTO adm_ch_file VALUES("2","410","xteem.ru_2269_3805_(R)(R)(R)(R)(R)(R)(R)Adidas.jpg");
INSERT INTO adm_ch_file VALUES("3","415","xteem.ru_3069_3876_Screenshot_1.png");
INSERT INTO adm_ch_file VALUES("4","425","xteem.ru_2968_2879_Screenshot_2.png");
INSERT INTO adm_ch_file VALUES("5","653","xteem.ru_2303_3896_Screenshot_2015-01-13-19-30-20.png");
INSERT INTO adm_ch_file VALUES("6","732","xteem.ru_4252_1546_Screenshot_2015-01-16-14-09-55.png");
INSERT INTO adm_ch_file VALUES("7","733","xteem.ru_4771_2047_Screenshot_2015-01-16-14-09-55.png");
INSERT INTO adm_ch_file VALUES("8","787","xteem.ru_2883_3069_wso2.php.png");
DROP TABLE IF EXISTS `admin_chat`;
CREATE TABLE `admin_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` varchar(255) NOT NULL,
`time` int(11) NOT NULL,
`avtor` int(11) NOT NULL,
`id_komu` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `ads`;
CREATE TABLE `ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`time_srok` varchar(255) DEFAULT NULL,
`kogda` varchar(255) DEFAULT NULL,
`color` varchar(244) CHARACTER SET utf8 NOT NULL,
`b` int(11) NOT NULL DEFAULT '0',
`i` int(11) NOT NULL DEFAULT '0',
`tip` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251;
INSERT INTO ads VALUES("1","Заказать рекламу 3 рубля","http://xteem.ru/WebMoney/","1433349400","1422808600","008000","1","1","0");
DROP TABLE IF EXISTS `anketa`;
CREATE TABLE `anketa` (
`name` varchar(20) DEFAULT NULL,
`id_us` int(11) DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`osebe` varchar(500) DEFAULT NULL,
`interes` varchar(500) DEFAULT NULL,
`data` varchar(20) NOT NULL DEFAULT '0',
`oigre` varchar(500) NOT NULL,
UNIQUE KEY `nick` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO anketa VALUES("","183849","","","","0","");
INSERT INTO anketa VALUES("","576406","","","","0","");
INSERT INTO anketa VALUES("","79531","","","","0","");
INSERT INTO anketa VALUES("Миша","552992","Рожище","","","26.10.1999","");
INSERT INTO anketa VALUES("","263223","","","","0","");
INSERT INTO anketa VALUES("","56240","","","","0","");
INSERT INTO anketa VALUES("","501490","","","","0","");
INSERT INTO anketa VALUES("","135359","","","","0","");
INSERT INTO anketa VALUES("Лика","595807","Смоленск","Добрая и честная...","Думаю вам будут не интересны мои интересы:)","6.6.6","Хорошая игра!)");
INSERT INTO anketa VALUES("","595838","","","","0","");
INSERT INTO anketa VALUES("","201062","","","","0","");
INSERT INTO anketa VALUES("","281561","","","","0","");
INSERT INTO anketa VALUES("","595833","","","","0","");
INSERT INTO anketa VALUES("Рома","595906","Донецк","Футболист","Футбол","25 мая","Нормик ");
INSERT INTO anketa VALUES("","595910","","","","0","");
INSERT INTO anketa VALUES("Андрей","595909","Киев","Есть девушка","Футбол, бокс, музыка- дабстеп и реп.","26 января 1995","Очень клас и интересов.");
INSERT INTO anketa VALUES("","595914","","","","0","");
DROP TABLE IF EXISTS `antispam`;
CREATE TABLE `antispam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news` varchar(244) NOT NULL,
`stena` varchar(244) NOT NULL,
`chat` varchar(244) NOT NULL,
`forum_tema` varchar(255) NOT NULL,
`forum_post` varchar(255) NOT NULL,
`guest` varchar(255) NOT NULL,
`blog` varchar(244) NOT NULL,
`mes` varchar(244) NOT NULL,
`down` varchar(244) NOT NULL,
`repa` varchar(255) NOT NULL,
`friends` varchar(244) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO antispam VALUES("1","60","60","60","60","1","60","60","60","60","4","60");
DROP TABLE IF EXISTS `arena_log`;
CREATE TABLE `arena_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_pro` int(11) NOT NULL,
`tip` int(11
DELETED
11 апреля 2015, в 11:12
Delete
7. Запрещено вести торговую деятельность без подтвержденного WMID. Разрешено только через гаранта! (Блокировка на 5 ч.)
Kotik97 (11.04.2015 в 11:13)
Вилы Выкидные , ой
Вилы Выкидные , ой
Хотелось бы увидить саму суть ошибки.
LordSaske , заливаю и не идет 4таблы токо
Kotik97 (11.04.2015 в 11:18)
LordSaske , заливаю и не идет 4таблы токо
LordSaske , заливаю и не идет 4таблы токо
Это и есть они, или ты и сам не знаеш?
LordSaske ,INSERT INTO anketa
VALUES (
"", "576406", "", "", "", "0", ""
);
Ответ MySQL:
#1062 - Duplicate entry '' for key 'nick'
VALUES (
"", "576406", "", "", "", "0", ""
);
Ответ MySQL:
#1062 - Duplicate entry '' for key 'nick'
Kotik97 (11.04.2015 в 11:24)
LordSaske ,INSERT INTO anketa
VALUES (
"", "576406", "", "", "", "0", ""
);
Ответ MySQL:
#1062 - Duplicate entry '' for key 'nick'
LordSaske ,INSERT INTO anketa
VALUES (
"", "576406", "", "", "", "0", ""
);
Ответ MySQL:
#1062 - Duplicate entry '' for key 'nick'
Скить базу(файл) ща ее помурыжу немного
LordSaske ,http://bym.guru/downloads/view/73167
Качай
Качай
Стр.: 1, 2