Добро пожаловать, Гость!
где? - Страница 1
Помощь мастерам | где?
Sasha1V :
Помогите где ошыбки ?
-- phpMyAdmin SQL Dump
-- version 2.6.1-rc1
-- Ссылка
--
-- Host: localhost
-- Generation Time: Feb 17, 2005 at 04:41 PM
-- Server version: 4.0.23
-- PHP Version: 4.3.10
--
-- Database: `camgirlz_camgirlz`
--
-- --------------------------------------------------------
--
-- Table structure for table `chatmodels`
--
CREATE TABLE `chatmodels` (
`id` varchar(32) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`language1` varchar(12) NOT NULL default '',
`language2` varchar(12) default NULL,
`language3` varchar(12) default NULL,
`language4` varchar(12) default NULL,
`birthDate` int(11) NOT NULL default '0',
`braSize` varchar(12) default NULL,
`birthSign` varchar(12) default NULL,
`weight` varchar(12) default '0',
`weightMeasure` varchar(12) default NULL,
`height` varchar(12) default '0',
`heightMeasure` varchar(12) default NULL,
`eyeColor` varchar(12) default NULL,
`ethnicity` varchar(32) default NULL,
`message` varchar(32) default NULL,
`position` varchar(255) default NULL,
`fantasies` varchar(255) default NULL,
`hobby` varchar(255) default NULL,
`hairColor` varchar(32) default NULL,
`hairLength` varchar(32) default NULL,
`pubicHair` varchar(32) default NULL,
`tImage` varchar(32) NOT NULL default '',
`cpm` smallint(6) NOT NULL default '0',
`epercentage` tinyint(4) NOT NULL default '0',
`minimum` int(11) NOT NULL default '500',
`category` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`city` varchar(32) NOT NULL default '',
`zip` varchar(12) NOT NULL default '',
`adress` varchar(32) NOT NULL default '',
`actImage` varchar(32) NOT NULL default '',
`pMethod` varchar(12) default NULL,
`pInfo` varchar(255) default NULL,
`dateRegistered` int(11) NOT NULL default '0',
`owner` varchar(32) default NULL,
`lastLogIn` int(11) NOT NULL default '0',
`phone` varchar(16) NOT NULL default '',
`fax` varchar(16) default NULL,
`idtype` varchar(32) NOT NULL default '',
`idmonth` varchar(32) NOT NULL default '',
`idyear` varchar(4) NOT NULL default '',
`idnumber` varchar(32) NOT NULL default '',
`birthplace` varchar(32) NOT NULL default '',
`ssnumber` varchar(32) default NULL,
`msn` varchar(32) default NULL,
`yahoo` varchar(32) default NULL,
`icq` varchar(32) default NULL,
`broadcastplace` varchar(32) default NULL,
`emailtype` enum('text','html') NOT NULL default 'text',
`status` varchar(8) NOT NULL default '',
`lastupdate` int(11) default NULL,
`onlinemembers` tinyint(4) NOT NULL default '0',
`monday` varchar(4) NOT NULL default '0000',
`tuesday` varchar(4) NOT NULL default '0000',
`wednesday` varchar(4) NOT NULL default '0000',
`thursday` varchar(4) NOT NULL default '0000',
`friday` varchar(4) NOT NULL default '0000',
`sunday` varchar(4) NOT NULL default '0000',
`saturday` varchar(4) NOT NULL default '0000',
`gmt` varchar(5) NOT NULL default '+0',
PRIMARY KEY (`id`),
KEY `id` (`id`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `chatoperators`
--
CREATE TABLE `chatoperators` (
`id` varchar(32) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`city` varchar(32) NOT NULL default '',
`zip` varchar(12) NOT NULL default '',
`phone` varchar(12) NOT NULL default '',
`adress` varchar(32) NOT NULL default '',
`pMethod` varchar(12) default NULL,
`pInfo` varchar(255) default NULL,
`dateRegistered` int(11) NOT NULL default '0',
`lastLogIn` int(11) NOT NULL default '0',
`moneyEarned` varchar(24) NOT NULL default '',
`moneySent` varchar(24) NOT NULL default '',
`minimum` mediumint(9) NOT NULL default '0',
`status` varchar(12) NOT NULL default '',
`epercentage` tinyint(4) NOT NULL default '0',
`emailtype` enum('text','html') NOT NULL default 'text',
`company` varchar(32) default NULL,
`idtax` varchar(32) default NULL,
PRIMARY KEY (`id`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `chatusers`
--
CREATE TABLE `chatusers` (
`id` varchar(32) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`city` varchar(32) NOT NULL default '',
`phone` varchar(16) NOT NULL default '',
`zip` varchar(12) NOT NULL default '',
`adress` varchar(255) NOT NULL default '',
`dateRegistered` int(11) NOT NULL default '0',
`lastLogIn` int(11) NOT NULL default '0',
`money` bigint(12) NOT NULL default '1',
`emailnotify` char(1) NOT NULL default '0',
`smsnotify` char(1) NOT NULL default '0',
`status` varchar(12) NOT NULL default '',
`emailtype` enum('html','text') default 'text',
`freetime` smallint(6) NOT NULL default '120',
`freetimeexpired` int(11) NOT NULL default '0',
PRIMARY KEY (`id`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `favorites`
--
CREATE TABLE `favorites` (
`member` varchar(32) NOT NULL default '',
`model` varchar(32) NOT NULL default '',
`dateadded` int(11) NOT NULL default '0',
PRIMARY KEY (`member`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `modelpictures`
--
CREATE TABLE `modelpictures` (
`user` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`dateuploaded` bigint(20) NOT NULL default '0',
PRIMARY KEY (`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `modelshows`
--
CREATE TABLE `modelshows` (
`user` varchar(32) NOT NULL default '',
`name` varchar(24) NOT NULL default '',
`string` varchar(32) NOT NULL default '',
`previewtime` bigint(20) NOT NULL default '0',
`movietime` bigint(20) NOT NULL default '0',
`price` mediumint(9) NOT NULL default '300',
PRIMARY KEY (`user`,`string`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `payments`
--
CREATE TABLE `payments` (
`id` varchar(32) NOT NULL default '',
`date` bigint(24) NOT NULL default '0',
`ammount` varchar(24) NOT NULL default '',
`taxes` varchar(24) NOT NULL default '',
`method` varchar(12) NOT NULL default '',
`details` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`,`date`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `videosessions`
--
CREATE TABLE `videosessions` (
`sessionid` varchar(32) NOT NULL default '',
`member` varchar(32) NOT NULL default '',
`model` varchar(32) NOT NULL default '',
`sop` varchar(32) NOT NULL default '',
`cpm` mediumint(9) NOT NULL default '0',
`epercentage` smallint(6) NOT NULL default '0',
`date` int(11) NOT NULL default '0',
`duration` mediumint(9) NOT NULL default '0',
`paid` char(1) NOT NULL default '',
`soppaid` char(1) NOT NULL default '0',
`type` varchar(12) NOT NULL default '',
KEY `sessionid` (`sessionid`,`member`,`model`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(24) default NULL,
`code` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=113 ;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` VALUES (1, 'Romania', 40);
INSERT INTO `countries` VALUES (2, 'Italy', 39);
INSERT INTO `countries` VALUES (8, 'United Kingdom', 44);
INSERT INTO `countries` VALUES (14, 'Azerbaijan', 994);
INSERT INTO `countries` VALUES (15, 'Bahrain', 973);
INSERT INTO `countries` VALUES (17, 'Belgium', 32);
INSERT INTO `countries` VALUES (19, 'Brasil', 55);
INSERT INTO `countries` VALUES (21, 'British Virgin Islands', 284);
INSERT INTO `countries` VALUES (22, 'Brunei', 673);
INSERT INTO `countries` VALUES (23, 'Bulgaria', 359);
INSERT INTO `countries` VALUES (27, 'Chile', 56);
INSERT INTO `countries` VALUES (28, 'China', 86);
INSERT INTO `countries` VALUES (30, 'Cote d Ivoire', 225);
INSERT INTO `countries` VALUES (31, 'Croatia', 385);
INSERT INTO `countries` VALUES (32, 'Cyprus', 357);
INSERT INTO `countries` VALUES (34, 'Czech Republic', 420);
INSERT INTO `countries` VALUES (35, 'Denmark', 45);
INSERT INTO `countries` VALUES (36, 'Egypt', 20);
INSERT INTO `countries` VALUES (37, 'Estonia', 372);
INSERT INTO `countries` VALUES (38, 'Ethiopia', 251);
INSERT INTO `countries` VALUES (39, 'Faroe Islands', 298);
INSERT INTO `countries` VALUES (40, 'Fiji', 679);
INSERT INTO `countries` VALUES (41, 'Finland', 358);
INSERT INTO `countries` VALUES (42, 'France', 33);
INSERT INTO `countries` VALUES (43, 'Georgia', 995);
INSERT INTO `countries` VALUES
где?
9 Авг 2014Помогите где ошыбки ?
-- phpMyAdmin SQL Dump
-- version 2.6.1-rc1
-- Ссылка
--
-- Host: localhost
-- Generation Time: Feb 17, 2005 at 04:41 PM
-- Server version: 4.0.23
-- PHP Version: 4.3.10
--
-- Database: `camgirlz_camgirlz`
--
-- --------------------------------------------------------
--
-- Table structure for table `chatmodels`
--
CREATE TABLE `chatmodels` (
`id` varchar(32) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`language1` varchar(12) NOT NULL default '',
`language2` varchar(12) default NULL,
`language3` varchar(12) default NULL,
`language4` varchar(12) default NULL,
`birthDate` int(11) NOT NULL default '0',
`braSize` varchar(12) default NULL,
`birthSign` varchar(12) default NULL,
`weight` varchar(12) default '0',
`weightMeasure` varchar(12) default NULL,
`height` varchar(12) default '0',
`heightMeasure` varchar(12) default NULL,
`eyeColor` varchar(12) default NULL,
`ethnicity` varchar(32) default NULL,
`message` varchar(32) default NULL,
`position` varchar(255) default NULL,
`fantasies` varchar(255) default NULL,
`hobby` varchar(255) default NULL,
`hairColor` varchar(32) default NULL,
`hairLength` varchar(32) default NULL,
`pubicHair` varchar(32) default NULL,
`tImage` varchar(32) NOT NULL default '',
`cpm` smallint(6) NOT NULL default '0',
`epercentage` tinyint(4) NOT NULL default '0',
`minimum` int(11) NOT NULL default '500',
`category` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`city` varchar(32) NOT NULL default '',
`zip` varchar(12) NOT NULL default '',
`adress` varchar(32) NOT NULL default '',
`actImage` varchar(32) NOT NULL default '',
`pMethod` varchar(12) default NULL,
`pInfo` varchar(255) default NULL,
`dateRegistered` int(11) NOT NULL default '0',
`owner` varchar(32) default NULL,
`lastLogIn` int(11) NOT NULL default '0',
`phone` varchar(16) NOT NULL default '',
`fax` varchar(16) default NULL,
`idtype` varchar(32) NOT NULL default '',
`idmonth` varchar(32) NOT NULL default '',
`idyear` varchar(4) NOT NULL default '',
`idnumber` varchar(32) NOT NULL default '',
`birthplace` varchar(32) NOT NULL default '',
`ssnumber` varchar(32) default NULL,
`msn` varchar(32) default NULL,
`yahoo` varchar(32) default NULL,
`icq` varchar(32) default NULL,
`broadcastplace` varchar(32) default NULL,
`emailtype` enum('text','html') NOT NULL default 'text',
`status` varchar(8) NOT NULL default '',
`lastupdate` int(11) default NULL,
`onlinemembers` tinyint(4) NOT NULL default '0',
`monday` varchar(4) NOT NULL default '0000',
`tuesday` varchar(4) NOT NULL default '0000',
`wednesday` varchar(4) NOT NULL default '0000',
`thursday` varchar(4) NOT NULL default '0000',
`friday` varchar(4) NOT NULL default '0000',
`sunday` varchar(4) NOT NULL default '0000',
`saturday` varchar(4) NOT NULL default '0000',
`gmt` varchar(5) NOT NULL default '+0',
PRIMARY KEY (`id`),
KEY `id` (`id`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `chatoperators`
--
CREATE TABLE `chatoperators` (
`id` varchar(32) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`city` varchar(32) NOT NULL default '',
`zip` varchar(12) NOT NULL default '',
`phone` varchar(12) NOT NULL default '',
`adress` varchar(32) NOT NULL default '',
`pMethod` varchar(12) default NULL,
`pInfo` varchar(255) default NULL,
`dateRegistered` int(11) NOT NULL default '0',
`lastLogIn` int(11) NOT NULL default '0',
`moneyEarned` varchar(24) NOT NULL default '',
`moneySent` varchar(24) NOT NULL default '',
`minimum` mediumint(9) NOT NULL default '0',
`status` varchar(12) NOT NULL default '',
`epercentage` tinyint(4) NOT NULL default '0',
`emailtype` enum('text','html') NOT NULL default 'text',
`company` varchar(32) default NULL,
`idtax` varchar(32) default NULL,
PRIMARY KEY (`id`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `chatusers`
--
CREATE TABLE `chatusers` (
`id` varchar(32) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`city` varchar(32) NOT NULL default '',
`phone` varchar(16) NOT NULL default '',
`zip` varchar(12) NOT NULL default '',
`adress` varchar(255) NOT NULL default '',
`dateRegistered` int(11) NOT NULL default '0',
`lastLogIn` int(11) NOT NULL default '0',
`money` bigint(12) NOT NULL default '1',
`emailnotify` char(1) NOT NULL default '0',
`smsnotify` char(1) NOT NULL default '0',
`status` varchar(12) NOT NULL default '',
`emailtype` enum('html','text') default 'text',
`freetime` smallint(6) NOT NULL default '120',
`freetimeexpired` int(11) NOT NULL default '0',
PRIMARY KEY (`id`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `favorites`
--
CREATE TABLE `favorites` (
`member` varchar(32) NOT NULL default '',
`model` varchar(32) NOT NULL default '',
`dateadded` int(11) NOT NULL default '0',
PRIMARY KEY (`member`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `modelpictures`
--
CREATE TABLE `modelpictures` (
`user` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`dateuploaded` bigint(20) NOT NULL default '0',
PRIMARY KEY (`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `modelshows`
--
CREATE TABLE `modelshows` (
`user` varchar(32) NOT NULL default '',
`name` varchar(24) NOT NULL default '',
`string` varchar(32) NOT NULL default '',
`previewtime` bigint(20) NOT NULL default '0',
`movietime` bigint(20) NOT NULL default '0',
`price` mediumint(9) NOT NULL default '300',
PRIMARY KEY (`user`,`string`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `payments`
--
CREATE TABLE `payments` (
`id` varchar(32) NOT NULL default '',
`date` bigint(24) NOT NULL default '0',
`ammount` varchar(24) NOT NULL default '',
`taxes` varchar(24) NOT NULL default '',
`method` varchar(12) NOT NULL default '',
`details` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`,`date`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `videosessions`
--
CREATE TABLE `videosessions` (
`sessionid` varchar(32) NOT NULL default '',
`member` varchar(32) NOT NULL default '',
`model` varchar(32) NOT NULL default '',
`sop` varchar(32) NOT NULL default '',
`cpm` mediumint(9) NOT NULL default '0',
`epercentage` smallint(6) NOT NULL default '0',
`date` int(11) NOT NULL default '0',
`duration` mediumint(9) NOT NULL default '0',
`paid` char(1) NOT NULL default '',
`soppaid` char(1) NOT NULL default '0',
`type` varchar(12) NOT NULL default '',
KEY `sessionid` (`sessionid`,`member`,`model`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(24) default NULL,
`code` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=113 ;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` VALUES (1, 'Romania', 40);
INSERT INTO `countries` VALUES (2, 'Italy', 39);
INSERT INTO `countries` VALUES (8, 'United Kingdom', 44);
INSERT INTO `countries` VALUES (14, 'Azerbaijan', 994);
INSERT INTO `countries` VALUES (15, 'Bahrain', 973);
INSERT INTO `countries` VALUES (17, 'Belgium', 32);
INSERT INTO `countries` VALUES (19, 'Brasil', 55);
INSERT INTO `countries` VALUES (21, 'British Virgin Islands', 284);
INSERT INTO `countries` VALUES (22, 'Brunei', 673);
INSERT INTO `countries` VALUES (23, 'Bulgaria', 359);
INSERT INTO `countries` VALUES (27, 'Chile', 56);
INSERT INTO `countries` VALUES (28, 'China', 86);
INSERT INTO `countries` VALUES (30, 'Cote d Ivoire', 225);
INSERT INTO `countries` VALUES (31, 'Croatia', 385);
INSERT INTO `countries` VALUES (32, 'Cyprus', 357);
INSERT INTO `countries` VALUES (34, 'Czech Republic', 420);
INSERT INTO `countries` VALUES (35, 'Denmark', 45);
INSERT INTO `countries` VALUES (36, 'Egypt', 20);
INSERT INTO `countries` VALUES (37, 'Estonia', 372);
INSERT INTO `countries` VALUES (38, 'Ethiopia', 251);
INSERT INTO `countries` VALUES (39, 'Faroe Islands', 298);
INSERT INTO `countries` VALUES (40, 'Fiji', 679);
INSERT INTO `countries` VALUES (41, 'Finland', 358);
INSERT INTO `countries` VALUES (42, 'France', 33);
INSERT INTO `countries` VALUES (43, 'Georgia', 995);
INSERT INTO `countries` VALUES
Комментарии:
mikro 10 Авг 2014
Sasha1V (9 Авг 2014):
INSERT INTO `countries` VALUES (64, 'Si... Ошибка: Table 'facetk_face.countries' doesn't exist как исправить?
Sasha1V, в этом запросе ты добавляешь в таблицу строку, но выдает ошибку так как данная таблица не существуетINSERT INTO `countries` VALUES (64, 'Si... Ошибка: Table 'facetk_face.countries' doesn't exist как исправить?
Sasha1V 10 Авг 2014
Автор темы
iseeT, Table structure for table `chatmodels` -... Ошибка: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Table structure for table `chatmodels` -- CREATE TABLE `chatmodels` ( `id` varch' at line 1 -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- -- Dumping data for table `countries... Сделано! ! INSERT INTO `countries` VALUES (2, 'Ita... Ошибка: Table 'facetk_face.countries' doesn't exist INSERT INTO `countries` VALUES (8, 'Uni... Ошибка: Table 'facetk_face.countries' doesn't exist и ничего не заливает
Автор темы
iseeT, Table structure for table `chatmodels` -... Ошибка: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Table structure for table `chatmodels` -- CREATE TABLE `chatmodels` ( `id` varch' at line 1 -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- ------------------------------------... Сделано! ! -- -- Dumping data for table `countries... Сделано! ! INSERT INTO `countries` VALUES (2, 'Ita... Ошибка: Table 'facetk_face.countries' doesn't exist INSERT INTO `countries` VALUES (8, 'Uni... Ошибка: Table 'facetk_face.countries' doesn't exist и ничего не заливает