Ga naar inhoud

MySQL Error - PLease Help


 Delen

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


 Delen

×
×
  • Nieuwe aanmaken...