Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Mysql import help

  • 23-04-2011 11:03am
    #1
    CSU
    Registered Users, Registered Users 2 Posts: 459 ✭✭


    Can anyone see any obvious problems with this sql file?

    It's throwing out
    #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 'TYPE=MyISAM AUTO_INCREMENT=5' at line 33

    I can't see anything wrong on line 33 ( TYPE=MyISAM AUTO_INCREMENT=5 ; )

    -- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 27, 2005 at 11:14 PM
-- Server version: 4.0.18
-- PHP Version: 4.3.6
-- 
-- Database: `servicemanagement`
-- 

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

-- 
-- Table structure for table `site_calls`
-- 

CREATE TABLE `site_calls` (
  `service_id` int(11) NOT NULL auto_increment,
  `service_name` varchar(200) NOT NULL default '',
  `service_date` int(11) NOT NULL default '0',
  `service_post_date` int(11) NOT NULL default '0',
  `service_contact_data` text NOT NULL,
  `service_type` int(11) NOT NULL default '0',
  `service_description` text NOT NULL,
  `service_work` text NOT NULL,
  `service_visit` int(11) NOT NULL default '0',
  `post_user` int(11) NOT NULL default '0',
  `post_date` int(11) NOT NULL default '0',
  `post_ip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`service_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `site_calls`
-- 

INSERT INTO `site_calls` VALUES (1, 'Dryer taking long time', 1107893040, 1107893098, '1', 2, 'Dryer is not drying clothes in a cycle.', 'Vent was badly plugged. Cleaned up dryer vent. Working fine now.', 1107893040, 1, 1107893098, '172.20.100.3');
INSERT INTO `site_calls` VALUES (2, 'Dryer door stuck', 1107896580, 1107896608, '1', 1, '', 'Door hinge was bent, replaced hinge.', 1107896580, 1, 1107896608, '172.20.100.3');
INSERT INTO `site_calls` VALUES (3, 'Setup', 1107906780, 1107906810, '3', 1, '', 'All set, was interested in buying an extended warranty.', 1107906780, 1003, 1107906810, '172.20.100.3');
INSERT INTO `site_calls` VALUES (4, 'Washer Repair', 1108835100, 1108747931, '2', 1, '', 'Re-balanced washer for customer.', 1108838700, 1, 1108747931, '207.74.51.248');

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

-- 
-- Table structure for table `site_calls_prods`
-- 

CREATE TABLE `site_calls_prods` (
  `scall_id` int(11) NOT NULL auto_increment,
  `scall_product` int(11) NOT NULL default '0',
  `scall_service` int(11) NOT NULL default '0',
  PRIMARY KEY  (`scall_id`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `site_calls_prods`
-- 

INSERT INTO `site_calls_prods` VALUES (2, 1, 2);
INSERT INTO `site_calls_prods` VALUES (3, 1, 2);
INSERT INTO `site_calls_prods` VALUES (9, 2, 2);
INSERT INTO `site_calls_prods` VALUES (6, 2, 2);
INSERT INTO `site_calls_prods` VALUES (10, 2, 2);
INSERT INTO `site_calls_prods` VALUES (11, 2, 2);
INSERT INTO `site_calls_prods` VALUES (12, 2, 2);
INSERT INTO `site_calls_prods` VALUES (13, 2, 4);
INSERT INTO `site_calls_prods` VALUES (14, 4, 3);

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

-- 
-- Table structure for table `site_clients`
-- 

CREATE TABLE `site_clients` (
  `client_id` int(11) NOT NULL auto_increment,
  `client_name` varchar(200) NOT NULL default '',
  `client_address` text NOT NULL,
  `client_contact_name` varchar(200) NOT NULL default '',
  `client_phone` varchar(50) NOT NULL default '',
  `client_phone2` varchar(50) NOT NULL default '',
  `client_phone3` varchar(50) NOT NULL default '',
  `client_email` varchar(200) NOT NULL default '',
  `client_web` varchar(200) NOT NULL default '',
  `client_other` text NOT NULL,
  PRIMARY KEY  (`client_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `site_clients`
-- 

INSERT INTO `site_clients` VALUES (1, 'Sally Smothers', '1209 Sad Lane', 'Sally', '555-5555', '555-5556', '555-5557', 'ss@example.com', '', 'Sally is nice, but can get caught up for an hour if she starts talking to you, stay on task :)');
INSERT INTO `site_clients` VALUES (2, 'Marshall Blue', '1212 Water Ave\r\nBlue Wave, MN', 'Blue', '456-1234', '', '', '', '', 'Prefers to be called "old blue"');
INSERT INTO `site_clients` VALUES (3, 'MaryAnn Johnson', '555 Main Street', 'Mary', '555-1212', '555-3057', '555-1234', '', '', 'Use the side door for service calls. Beware of dogs.');
INSERT INTO `site_clients` VALUES (4, 'Jon Doe', '1200 Doe Ave\r\nDover, DE', 'Jon Doe', '555-7777', '555-8888', '555-9999', 'joedoe@example.com', '', 'Jon leaves the key under the mat.');

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

-- 
-- Table structure for table `site_notes`
-- 

CREATE TABLE `site_notes` (
  `note_id` int(11) NOT NULL auto_increment,
  `note_title` varchar(200) NOT NULL default '',
  `note_body` text NOT NULL,
  `note_relation` int(11) NOT NULL default '0',
  `note_type` int(1) NOT NULL default '0',
  `note_post_date` int(11) NOT NULL default '0',
  `note_post_ip` varchar(20) NOT NULL default '',
  `note_post_user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`note_id`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `site_notes`
-- 

INSERT INTO `site_notes` VALUES (11, 'test', 'test', 1, 1, 1107885324, '172.20.100.3', 1);
INSERT INTO `site_notes` VALUES (9, 'Another Note', 'dsah fajlfalsjfalsdj fasd\r\n', 1, 1, 1106769957, '172.20.100.3', 1);
INSERT INTO `site_notes` VALUES (10, 'Product Note', 'This is the first note for this product.', 1, 2, 1106773231, '172.20.100.3', 1);
INSERT INTO `site_notes` VALUES (12, 'Cat Warning', 'Watch out for the cats, found one sleeping in the dryer when I went to test it. Yikes.', 2, 2, 1107897317, '172.20.100.3', 1);
INSERT INTO `site_notes` VALUES (13, 'safdasfdas', 'dfsdfsaf', 3, 1, 1107906950, '172.20.100.3', 1);
INSERT INTO `site_notes` VALUES (14, 'Vent Pipe', 'Vent pipe was slightly loose, remind customer to check monthly.', 4, 2, 1108750465, '207.74.51.248', 1);

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

-- 
-- Table structure for table `site_products`
-- 

CREATE TABLE `site_products` (
  `product_id` int(11) NOT NULL auto_increment,
  `product_name` varchar(200) NOT NULL default '',
  `product_number` varchar(200) NOT NULL default '',
  `product_other` text NOT NULL,
  PRIMARY KEY  (`product_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `site_products`
-- 

INSERT INTO `site_products` VALUES (1, 'GE 5.8 cu. ft. Extra Large Capacity Electric Dryer', 'DVLR223EEWW', 'Spacious dryer uses the Auto Dry system of thermostats to monitor air temperature and reduce fabric wear. DuraDrum interior for long-lasting dependability. 2 heat selections, 2 auto dry cycles.');
INSERT INTO `site_products` VALUES (2, 'HE4t King Size Capacity Plus Front Load Washer', '45087', 'Comes in many colors.');
INSERT INTO `site_products` VALUES (3, 'HE4 Super Capacity Gas Dryer', '95087', 'SmartHeat combined with EvenHeat technology');
INSERT INTO `site_products` VALUES (4, 'Neptune 7.0 cu. ft. Electric Drying Center', 'MCE8000AYW', 'Combines a 7.0 cu. ft. dryer with a unique 17.3 cu. ft. drying cabinet on top that gently dries, prevents shrinkage, reduces wrinkles, eliminates clutter, and saves time');
INSERT INTO `site_products` VALUES (5, 'Whirlpool 7.4 cu. ft. Ultra Capacity Electric Dryer', 'LEQ8611PW', 'The AccuDry sensor monitors remaining moisture and automatically stops the cycle when the load is dry. The on/off Winkle Shield option tumbles the load intermittently without heat after the cycle ends.');

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

-- 
-- Table structure for table `site_types`
-- 

CREATE TABLE `site_types` (
  `type_id` int(11) NOT NULL auto_increment,
  `type_name` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`type_id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `site_types`
-- 

INSERT INTO `site_types` VALUES (1, 'Warranty Repair');
INSERT INTO `site_types` VALUES (2, 'Out of Warranty Repair');
INSERT INTO `site_types` VALUES (3, 'Delivery and Setup');
INSERT INTO `site_types` VALUES (4, 'Emergency Service Plus');
INSERT INTO `site_types` VALUES (5, 'Extended Warranty Plan');
INSERT INTO `site_types` VALUES (6, 'Preventative Maintenance');
INSERT INTO `site_types` VALUES (7, 'Trade In Pickup');

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

-- 
-- Table structure for table `site_users`
-- 

CREATE TABLE `site_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_login` varchar(30) NOT NULL default '',
  `user_password` varchar(30) NOT NULL default '',
  `user_name` varchar(200) NOT NULL default '',
  `user_address` varchar(200) NOT NULL default '',
  `user_city` varchar(100) NOT NULL default '',
  `user_state` char(3) NOT NULL default '',
  `user_zip` varchar(20) NOT NULL default '',
  `user_country` char(3) NOT NULL default '',
  `user_phone` varchar(39) NOT NULL default '',
  `user_email` varchar(200) NOT NULL default '',
  `user_email2` varchar(200) NOT NULL default '',
  `user_im_aol` varchar(100) NOT NULL default '',
  `user_im_icq` varchar(100) NOT NULL default '',
  `user_im_msn` varchar(100) NOT NULL default '',
  `user_im_yahoo` varchar(100) NOT NULL default '',
  `user_im_other` varchar(200) NOT NULL default '',
  `user_status` int(1) NOT NULL default '0',
  `user_level` int(1) NOT NULL default '0',
  `user_pending` int(11) NOT NULL default '0',
  `user_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1004 ;

-- 
-- Dumping data for table `site_users`
-- 

INSERT INTO `site_users` VALUES (1, 'admin', 'test', 'Site Admin', '', '', '', '', '', '', 'admin@example.com', '', '', '', '', '', '', 0, 0, 0, 0);
INSERT INTO `site_users` VALUES (1003, 'Joe', 'test', 'Joe Service', '', '', '', '', '', '123-5555', 'joe@example.com', '', '', '', '', '', '', 0, 1, 0, 1106772292);

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

-- 
-- Table structure for table `site_vars`
-- 

CREATE TABLE `site_vars` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=36 ;

-- 
-- Dumping data for table `site_vars`
--


Comments

  • #2
    ressem
    Registered Users, Registered Users 2 Posts: 2,426 ✭✭✭ressem


    That came from an old server (4.0.18)

    I guess that you want to upload onto a server running a newer version of mysql?

    Can you try... 
    ) ENGINE=MyISAM AUTO_INCREMENT=5 ;

    as TYPE has been deprecated.

    With that changed for each table, script runs correctly on mysql 5.6.


  • #3
    CSU
    Registered Users, Registered Users 2 Posts: 459 ✭✭CSU


    100%

    Thanks ressem


Advertisement