MySQL Error - PLease Help

lookielookies · February 15, 2008

When trying to import a database, the following error message appears:

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!

paul2463 · February 15, 2008

i ran it in phpmyadmin on my system and it worked perfectly

here is the mysql dump of that table from my phpmyadmin

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 15, 2008 at 11:53 AM
-- Server version: 4.1.14
-- PHP Version: 5.0.5
-- 
-- 
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `admins`
-- 

CREATE TABLE `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 ;

-- 
-- Dumping data for table `admins`
-- 

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

-- --------------------------------------------------------

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `id` int(11) NOT NULL auto_increment,
  `categories` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `categories`
-- 

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

-- --------------------------------------------------------

-- 
-- Table structure for table `check`
-- 

CREATE TABLE `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 ;

-- 
-- Dumping data for table `check`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `fieldsprop`
-- 

CREATE TABLE `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 ;

-- 
-- Dumping data for table `fieldsprop`
-- 

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 (%)');

-- --------------------------------------------------------

-- 
-- Table structure for table `jv`
-- 

CREATE TABLE `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 ;

-- 
-- Dumping data for table `jv`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `scripts`
-- 

CREATE TABLE `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 ;

-- 
-- Dumping data for table `scripts`
-- 

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);

AndyB · February 15, 2008

I have a similar problem when moving data between different host servers. It's all to do with 'collation' and such. The solution that works for me between many servers is ...

Instead of

ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

Try

TYPE = MYISAM AUTO_INCREMENT =2;

lookielookies · February 16, 2008

Thanks for the replies

i ran it in phpmyadmin on my system and it worked perfectly

here is the mysql dump of that table from my phpmyadmin

On my system (and most) it works perfectly. It's just this one person that mentioned the error...

What changes did you make (can't seem to find them :-\ )

Instead of

ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

Try

TYPE = MYISAM AUTO_INCREMENT =2;

Tried, but didn't fix the problem

AndyB · February 16, 2008

Tried, but didn't fix the problem

Did you make that (sort of) change to EACH similar line?

lookielookies · February 16, 2008

In all lines that say 'ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT', I've replaced that piece of text with TYPE = MYISAM AUTO_INCREMENT

paul2463 · February 19, 2008

Thanks for the replies

i ran it in phpmyadmin on my system and it worked perfectly

here is the mysql dump of that table from my phpmyadmin

On my system (and most) it works perfectly. It's just this one person that mentioned the error...

What changes did you make (can't seem to find them :-\ )

I didnt make any changes, it was just another mysql dump from my system, just to show it worked ok here, sorry for any misunderstanding

Sign In

MySQL Error - PLease Help

Recommended Posts

lookielookies

Link to comment

Share on other sites

paul2463

Link to comment

Share on other sites

AndyB

Link to comment

Share on other sites

lookielookies

Link to comment

Share on other sites

AndyB

Link to comment

Share on other sites

lookielookies

Link to comment

Share on other sites

paul2463

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information