Ga naar inhoud

MySQL Error - PLease Help


Aanbevolen berichten

When trying to import a database, I rceive the following error:

Error

SQL query:

CREATE TABLE IF NOT EXISTS `admins` (

`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,

`login` varchar( 255 ) NOT NULL default '',

`password` varchar( 255 ) NOT NULL default '',

`permissions` text,

PRIMARY KEY ( `id` )

) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said: Documentation

#1064 - 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 7

Can someone help me out fixing this?

Here's the sql:

DROP TABLE IF EXISTS `admins`;

CREATE TABLE IF NOT EXISTS `admins` (

`id` int(11) unsigned NOT NULL auto_increment,

`login` varchar(255) NOT NULL default '',

`password` varchar(255) NOT NULL default '',

`permissions` text,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `admins` VALUES(1, 'admin', 'admin', NULL);

DROP TABLE IF EXISTS `categories`;

CREATE TABLE IF NOT EXISTS `categories` (

`id` int(11) NOT NULL auto_increment,

`categories` varchar(255) default NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

INSERT INTO `categories` VALUES(1, 'Admin Features');

INSERT INTO `categories` VALUES(2, 'JV Giveaway Organizer');

DROP TABLE IF EXISTS `check`;

CREATE TABLE IF NOT EXISTS `check` (

`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',

`created` datetime default NULL COMMENT 'Creation Time',

`updated` datetime default NULL COMMENT 'Modification Time',

`name` varchar(255) default NULL COMMENT 'JV Giveaway',

`loginlink` varchar(254) default NULL COMMENT 'Login URL',

`login` varchar(255) default NULL COMMENT 'Login',

`pass` varchar(255) default NULL COMMENT 'Password',

`gift` varchar(255) default NULL COMMENT 'Gift',

`landing` varchar(254) default NULL COMMENT 'Landing Page',

`info` tinyint(1) default '0' COMMENT 'Gift Info',

`ecover` tinyint(1) default '0' COMMENT 'eCover',

`subscr` tinyint(1) default '0' COMMENT 'Subscription Message',

`contact` tinyint(1) default '0' COMMENT 'Contact Adress or URL',

`optin` tinyint(1) default '0' COMMENT 'OptIn Form',

`conf` varchar(254) default NULL COMMENT 'Confirmation Page',

`thanks` tinyint(1) default '0' COMMENT 'Thanks You - Message',

`confinstr` tinyint(1) default '0' COMMENT 'Confirmation Instructions',

`whitelist` tinyint(1) default '0' COMMENT 'Whitelist Instructions',

`cont2` tinyint(1) default '0' COMMENT 'Contact Adress or URL',

`special` tinyint(1) default '0' COMMENT 'Special Offer Or Bonus',

`offer` varchar(254) default NULL COMMENT 'Special Offer Page',

`success` tinyint(1) default '0' COMMENT 'Successful Confirmation Message',

`bottom` tinyint(1) default '0' COMMENT 'Link-At-The-Bottom Message',

`special2` tinyint(1) default '0' COMMENT 'Special Offer',

`down` tinyint(1) default '0' COMMENT 'Link To Download Page',

`downlpage` varchar(254) default NULL COMMENT 'Download Page',

`thanks2` tinyint(1) default '0' COMMENT 'Thank You - Message',

`downlinstr` tinyint(1) default '0' COMMENT 'Download Instructions',

`downllink` tinyint(1) default '0' COMMENT 'Download Link',

`cont3` tinyint(1) default '0' COMMENT 'Contact Adress or URL',

`back` tinyint(1) default '0' COMMENT 'Back End Offer Or Bonus',

`ar` varchar(255) default NULL COMMENT 'Autoresponder Address',

`double` tinyint(1) default '0' COMMENT 'Double OptIn',

`follow` tinyint(1) default '0' COMMENT 'Follow-Up Messages',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `fieldsprop`;

CREATE TABLE IF NOT EXISTS `fieldsprop` (

`id` int(11) NOT NULL auto_increment,

`table_name` varchar(255) default NULL,

`field_name` varchar(255) default NULL,

`full_name` varchar(255) default NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=60 ;

INSERT INTO `fieldsprop` VALUES(1, 'check', 'id', 'ID');

INSERT INTO `fieldsprop` VALUES(2, 'check', 'created', 'Creation Time');

INSERT INTO `fieldsprop` VALUES(3, 'check', 'updated', 'Modification Time');

INSERT INTO `fieldsprop` VALUES(4, 'jv', 'id', 'ID');

INSERT INTO `fieldsprop` VALUES(5, 'jv', 'created', 'Creation Time');

INSERT INTO `fieldsprop` VALUES(6, 'jv', 'updated', 'Modification Time');

INSERT INTO `fieldsprop` VALUES(7, 'check', 'name', 'JV Giveaway');

INSERT INTO `fieldsprop` VALUES(8, 'check', 'loginlink', 'Login URL');

INSERT INTO `fieldsprop` VALUES(9, 'check', 'login', 'Login');

INSERT INTO `fieldsprop` VALUES(10, 'check', 'pass', 'Password');

INSERT INTO `fieldsprop` VALUES(11, 'check', 'gift', 'Gift');

INSERT INTO `fieldsprop` VALUES(12, 'check', 'landing', 'Landing Page');

INSERT INTO `fieldsprop` VALUES(13, 'check', 'info', 'Gift Info');

INSERT INTO `fieldsprop` VALUES(14, 'check', 'ecover', 'eCover');

INSERT INTO `fieldsprop` VALUES(15, 'check', 'subscr', 'Subscription Message');

INSERT INTO `fieldsprop` VALUES(16, 'check', 'contact', 'Contact Adress or URL');

INSERT INTO `fieldsprop` VALUES(17, 'check', 'optin', 'OptIn Form');

INSERT INTO `fieldsprop` VALUES(18, 'check', 'conf', 'Confirmation Page');

INSERT INTO `fieldsprop` VALUES(19, 'check', 'thanks', 'Thanks You - Message');

INSERT INTO `fieldsprop` VALUES(20, 'check', 'confinstr', 'Confirmation Instructions');

INSERT INTO `fieldsprop` VALUES(21, 'check', 'whitelist', 'Whitelist Instructions');

INSERT INTO `fieldsprop` VALUES(22, 'check', 'cont2', 'Contact Adress or URL');

INSERT INTO `fieldsprop` VALUES(23, 'check', 'special', 'Special Offer Or Bonus');

INSERT INTO `fieldsprop` VALUES(24, 'check', 'offer', 'Special Offer Page');

INSERT INTO `fieldsprop` VALUES(25, 'check', 'success', 'Successful Confirmation Message');

INSERT INTO `fieldsprop` VALUES(26, 'check', 'bottom', 'Link-At-The-Bottom Message');

INSERT INTO `fieldsprop` VALUES(27, 'check', 'special2', 'Special Offer');

INSERT INTO `fieldsprop` VALUES(28, 'check', 'down', 'Link To Download Page');

INSERT INTO `fieldsprop` VALUES(29, 'check', 'downlpage', 'Download Page');

INSERT INTO `fieldsprop` VALUES(30, 'check', 'thanks2', 'Thank You - Message');

INSERT INTO `fieldsprop` VALUES(31, 'check', 'downlinstr', 'Download Instructions');

INSERT INTO `fieldsprop` VALUES(32, 'check', 'downllink', 'Download Link');

INSERT INTO `fieldsprop` VALUES(33, 'check', 'cont3', 'Contact Adress or URL');

INSERT INTO `fieldsprop` VALUES(34, 'check', 'back', 'Back End Offer Or Bonus');

INSERT INTO `fieldsprop` VALUES(35, 'check', 'ar', 'Autoresponder Address');

INSERT INTO `fieldsprop` VALUES(36, 'check', 'double', 'Double OptIn');

INSERT INTO `fieldsprop` VALUES(37, 'check', 'follow', 'Follow-Up Messages');

INSERT INTO `fieldsprop` VALUES(38, 'jv', 'jv', 'JV Giveaway');

INSERT INTO `fieldsprop` VALUES(42, 'jv', 'login', 'Login');

INSERT INTO `fieldsprop` VALUES(41, 'jv', 'loginlink', 'Login URL');

INSERT INTO `fieldsprop` VALUES(43, 'jv', 'pass', 'Password');

INSERT INTO `fieldsprop` VALUES(44, 'jv', 'start', 'Start Date');

INSERT INTO `fieldsprop` VALUES(45, 'jv', 'end', 'End Date');

INSERT INTO `fieldsprop` VALUES(46, 'jv', 'refm', 'Refer Members');

INSERT INTO `fieldsprop` VALUES(47, 'jv', 'refp', 'Refer Partners');

INSERT INTO `fieldsprop` VALUES(48, 'jv', 'gift', 'Gift');

INSERT INTO `fieldsprop` VALUES(49, 'jv', 'landing', 'Landing Page');

INSERT INTO `fieldsprop` VALUES(50, 'jv', 'members', 'Number of Referred Members');

INSERT INTO `fieldsprop` VALUES(51, 'jv', 'partners', 'Number of Referred Partners');

INSERT INTO `fieldsprop` VALUES(52, 'jv', 'rank', 'Ranking');

INSERT INTO `fieldsprop` VALUES(53, 'jv', 'visits', 'Number of Visits');

INSERT INTO `fieldsprop` VALUES(54, 'jv', 'signups', 'Number of Signups');

INSERT INTO `fieldsprop` VALUES(55, 'jv', 'ratio1', 'Conversion Ratio (%)');

INSERT INTO `fieldsprop` VALUES(56, 'jv', 'oto', 'OTO');

INSERT INTO `fieldsprop` VALUES(57, 'jv', 'otovisits', 'Number of Visits');

INSERT INTO `fieldsprop` VALUES(58, 'jv', 'otosales', 'Number of Sales');

INSERT INTO `fieldsprop` VALUES(59, 'jv', 'ratio2', 'Conversion Ratio (%)');

DROP TABLE IF EXISTS `jv`;

CREATE TABLE IF NOT EXISTS `jv` (

`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',

`created` datetime default NULL COMMENT 'Creation Time',

`updated` datetime default NULL COMMENT 'Modification Time',

`jv` varchar(255) default NULL COMMENT 'JV Giveaway',

`loginlink` varchar(254) default NULL COMMENT 'Login URL',

`login` varchar(255) default NULL COMMENT 'Login',

`pass` varchar(255) default NULL COMMENT 'Password',

`start` date default NULL COMMENT 'Start Date',

`end` date default NULL COMMENT 'End Date',

`refm` varchar(254) default NULL COMMENT 'Refer Members',

`refp` varchar(254) default NULL COMMENT 'Refer Partners',

`gift` varchar(255) default NULL COMMENT 'Gift',

`landing` varchar(254) default NULL COMMENT 'Landing Page',

`members` varchar(255) default NULL COMMENT 'Number of Referred Members',

`partners` varchar(255) default NULL COMMENT 'Number of Referred Partners',

`rank` varchar(255) default NULL COMMENT 'Ranking',

`visits` varchar(255) default NULL COMMENT 'Number of Visits',

`signups` varchar(255) default NULL COMMENT 'Number of Signups',

`ratio1` varchar(255) default NULL COMMENT 'Conversion Ratio (%)',

`oto` varchar(254) default NULL COMMENT 'OTO',

`otovisits` varchar(255) default NULL COMMENT 'Number of Visits',

`otosales` varchar(255) default NULL COMMENT 'Number of Sales',

`ratio2` varchar(255) default NULL COMMENT 'Conversion Ratio (%)',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `scripts`;

CREATE TABLE IF NOT EXISTS `scripts` (

`id` int(11) NOT NULL auto_increment,

`script_name` varchar(255) default NULL,

`table_name` varchar(255) default NULL,

`name` varchar(255) default NULL,

`cat_id` int(2) default NULL,

`flag` int(1) default '1',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

INSERT INTO `scripts` VALUES(1, 'change_password.php', '', 'Change Password', 1, 2);

INSERT INTO `scripts` VALUES(2, 'edit_categories.php', '', 'Edit Categories', 1, 0);

INSERT INTO `scripts` VALUES(3, 'edit_scripts.php', '', 'Edit Features', 1, 0);

INSERT INTO `scripts` VALUES(4, 'logout.php', '', 'Logout', 1, 2);

INSERT INTO `scripts` VALUES(5, 'data_manager.php?i=5', 'check', 'Checklists', 2, 1);

INSERT INTO `scripts` VALUES(6, 'data_manager.php?i=6', 'jv', 'JV Giveaways', 2, 1);

Greetz!

;)

Link naar reactie
Delen op andere sites

×
×
  • Nieuwe aanmaken...

Belangrijke informatie

We hebben cookies geplaatst op je toestel om deze website voor jou beter te kunnen maken. Je kunt de cookie instellingen aanpassen, anders gaan we er van uit dat het goed is om verder te gaan.