Web Hosting Talk






PDA

View Full Version : MySQL Import Problem

Andrej
01-22-2006, 03:26 PM
We currently get the following error

#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=3' at line 27


when trying to import:


-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 20, 2006 at 08:52 AM
-- Server version: 5.0.16
-- PHP Version: 5.1.1
--
-- Database: `ekicks`
--

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

--
-- Table structure for table `ekicks_admin`
--

CREATE TABLE `ekicks_admin` (
`adminId` int(15) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`status` varchar(100) NOT NULL default '',
PRIMARY KEY (`adminId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ekicks_admin`
--

INSERT INTO `ekicks_admin` VALUES (1, 'admin', 'admin', '', '0000-00-00', 'u');
INSERT INTO `ekicks_admin` VALUES (2, 'admin', 'admin', '', '0000-00-00', '');

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

--
-- Table structure for table `ekicks_category`
--

CREATE TABLE `ekicks_category` (
`cId` int(5) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`det` text NOT NULL,
`date` date NOT NULL default '0000-00-00',
`status` char(1) NOT NULL default 'u',
PRIMARY KEY (`cId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_category`
--


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

--
-- Table structure for table `ekicks_contactus`
--

CREATE TABLE `ekicks_contactus` (
`contactId` int(10) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL default '',
`Email` varchar(100) NOT NULL default '',
`State` varchar(100) NOT NULL default '',
`Phone` varchar(100) NOT NULL default '',
`Comments` text NOT NULL,
PRIMARY KEY (`contactId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_contactus`
--


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

--
-- Table structure for table `ekicks_discount`
--

CREATE TABLE `ekicks_discount` (
`disId` int(10) NOT NULL auto_increment,
`pId` int(10) NOT NULL default '0',
`item` int(10) NOT NULL default '0',
`discount` float NOT NULL default '0',
PRIMARY KEY (`disId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_discount`
--


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

--
-- Table structure for table `ekicks_faqs`
--

CREATE TABLE `ekicks_faqs` (
`faqId` int(10) NOT NULL auto_increment,
`head` varchar(100) NOT NULL default '',
`body` text NOT NULL,
PRIMARY KEY (`faqId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `ekicks_faqs`
--

INSERT INTO `ekicks_faqs` VALUES (1, 'How long will it take for me to receive my order?', 'Your order will be processed immediately. Processing on average takes 1 - 3 business days, and then it will be shipped. Shipping on average takes 8 - 12 business days.\r\n');
INSERT INTO `ekicks_faqs` VALUES (2, 'What is a business day?', 'A business day is a regular working day (Monday to Friday). This excludes weekends and holidays.\r\n');
INSERT INTO `ekicks_faqs` VALUES (3, 'What is the difference between your regular Air Jordans and your Rare Air Jordans?', 'The primary difference between these two is that our Rare Air Jordans include the original manufacturing box as well as the Michael Jordan Retro Card.\r\n');
INSERT INTO `ekicks_faqs` VALUES (4, 'Can I exchange or return my product after receiving it?', 'All sales are final. There are no returns or exchanges unless you have received the wrong shoe or size (based on tags & order invoice).\r\n\r\nIf you received a wrong pair of shoes (based on tags & order invoice) please contact us AS SOON as you receive the order. You must submit a digital picture of the order you received as proof - we will not accept any shoes unless you receive an authorization from us.\r\n\r\n');
INSERT INTO `ekicks_faqs` VALUES (5, 'Do you accept credit card payments?', 'Yes, we accept all forms of credit cards through our merchant PayPal. Simply add an item to your cart and pay with your credit card at check out.\r\n\r\n');
INSERT INTO `ekicks_faqs` VALUES (6, 'Do you ship to international locations?', 'Yes, we ship our products world wide');
INSERT INTO `ekicks_faqs` VALUES (7, 'What does USD stand for?', 'USD is an abbreviation for United States Dollars. All prices on our web site are in USD.');

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

--
-- Table structure for table `ekicks_mycart`
--

CREATE TABLE `ekicks_mycart` (
`cartId` int(10) NOT NULL auto_increment,
`userId` int(10) NOT NULL default '0',
`pId` int(10) NOT NULL default '0',
`orderId` varchar(100) NOT NULL default '0',
`quantity` varchar(100) NOT NULL default '',
`size` varchar(100) NOT NULL default '',
`item` int(10) NOT NULL default '0',
`date` varchar(100) NOT NULL default '',
`comment` varchar(250) NOT NULL default '',
`status` char(1) NOT NULL default 'n',
PRIMARY KEY (`cartId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_mycart`
--


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

--
-- Table structure for table `ekicks_product`
--

CREATE TABLE `ekicks_product` (
`pId` int(10) NOT NULL auto_increment,
`cId` int(10) NOT NULL default '0',
`subCatId` int(100) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`details` text NOT NULL,
`thumImg` varchar(100) NOT NULL default '',
`bigImg` varchar(100) NOT NULL default '',
`RetailPrice` float NOT NULL default '0',
`LowPrice` float NOT NULL default '0',
`Make` varchar(200) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`status` char(1) NOT NULL default '',
`specialofweek` varchar(10) NOT NULL default 'n',
`bestseller` varchar(10) NOT NULL default 'n',
`hotproduct` varchar(10) NOT NULL default 'n',
`size` varchar(100) NOT NULL default '0',
PRIMARY KEY (`pId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_product`
--


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

--
-- Table structure for table `ekicks_settings`
--

CREATE TABLE `ekicks_settings` (
`site_name` varchar(100) NOT NULL default '',
`site_url` varchar(100) NOT NULL default '',
`admin_email` varchar(100) NOT NULL default '',
`paypal_email` varchar(100) NOT NULL default '',
`keywords` text NOT NULL,
`description` text NOT NULL,
`results` int(10) NOT NULL default '0',
`contact_email` varchar(200) NOT NULL default '',
`currency` varchar(100) NOT NULL default '',
`address` varchar(200) NOT NULL,
`city` varchar(200) NOT NULL,
`state` varchar(200) NOT NULL,
`country` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ekicks_settings`
--

INSERT INTO `ekicks_settings` VALUES ('Ekicks', 'http://www.ekicks.net', 'admin@ekicks.net', 'paypal@ekicks.net', 'XYZ', 'This is basket', 0, 'sales@ekicks.net', 'USD', '11, Clive Row. 5th Floor', 'kolkata', 'west bengal', 'india');

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

--
-- Table structure for table `ekicks_shipping`
--

CREATE TABLE `ekicks_shipping` (
`domestic_country` varchar(200) NOT NULL default '',
`national_shipping` float NOT NULL default '0',
`international_shipping` float NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ekicks_shipping`
--

INSERT INTO `ekicks_shipping` VALUES ('India', 46, 95);

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

--
-- Table structure for table `ekicks_subcat`
--

CREATE TABLE `ekicks_subcat` (
`subId` int(10) NOT NULL auto_increment,
`cId` int(10) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`details` text NOT NULL,
`date` date NOT NULL default '0000-00-00',
`status` char(1) NOT NULL default '',
PRIMARY KEY (`subId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_subcat`
--


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

--
-- Table structure for table `ekicks_tracking`
--

CREATE TABLE `ekicks_tracking` (
`orderId` int(10) NOT NULL default '0',
`comments` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ekicks_tracking`
--


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

--
-- Table structure for table `ekicks_transport`
--

CREATE TABLE `ekicks_transport` (
`transId` int(20) NOT NULL auto_increment,
`orderId` varchar(100) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`address` varchar(250) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`state` varchar(50) NOT NULL default '',
`zip` varchar(10) NOT NULL default '',
`country` varchar(20) NOT NULL default '',
`phone_no` varchar(20) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`purchase_date` date NOT NULL default '0000-00-00',
`status` char(1) NOT NULL default '',
`pay_link` varchar(100) NOT NULL default '',
`amount` varchar(200) NOT NULL default '',
PRIMARY KEY (`transId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_transport`
--


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

--
-- Table structure for table `ekicks_user`
--

CREATE TABLE `ekicks_user` (
`userId` int(20) NOT NULL auto_increment,
`password` varchar(25) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`email` varchar(30) NOT NULL default '',
`company` varchar(100) NOT NULL default '',
`address1` varchar(250) NOT NULL default '',
`address2` varchar(100) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`state` varchar(50) NOT NULL default '',
`zip` varchar(10) NOT NULL default '',
`country` varchar(20) NOT NULL default '',
`phone_no` varchar(20) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`addStatus` char(1) NOT NULL default '',
`status` char(1) NOT NULL default 'u',
`reg_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ekicks_user`
--


Could anybody help us with this problem? Thank you!
orbitz
01-22-2006, 03:38 PM
remove all the " DEFAULT CHARSET=latin1" ( I counted a total of 11 of them) and see if it works.
I once had to do something similar like this in order to make the import work.

Goodluck.
mitchlrm
01-22-2006, 03:39 PM
You could take out "default charset=latin1". Too obvious I guess
Andrej
01-22-2006, 03:44 PM
Thank you both for the help, that has fixed the issue.