Jump to content

MySQL Error - PLease Help

lookielookies

By lookielookies
in MySQL Help

Recommended Posts

lookielookies Newbie

lookielookies

Posted
Posted

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!

;)

Link to comment
https://forums.phpfreaks.com/topic/91228-mysql-error-please-help/
Share on other sites
paul2463 Member

paul2463

Posted
Posted

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 Regular Member

AndyB

Posted
Posted

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 Newbie

lookielookies

Posted
  • Author
Posted

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

paul2463 Member

paul2463

Posted
Posted

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

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.