MySQL Syntax ERROR!?!?!? HELP!!!
Posted: Sat Apr 18, 2009 11:53 pm
Hi every body I have try to install joomla on my linux machine ( I have done it before and it work`t great, and now i try to reinsta;l it again and....) so now when I try to install jooma i become this MysQL syntax error and I don`t know what to do : ( Please Help me, I don`t know what to do
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 'CREATE TABLE IF NOT EXISTS `jos_vm_vendor_category` ( `vendor_category_id` int' at line 14 SQL=-- -- Dumping data for table `jos_vm_vendor` -- INSERT INTO `jos_vm_vendor` (`vendor_id`, `vendor_name`, `contact_last_name`, `contact_first_name`, `contact_middle_name`, `contact_title`, `contact_phone_1`, `contact_phone_2`, `contact_fax`, `contact_email`, `vendor_phone`, `vendor_address_1`, `vendor_address_2`, `vendor_city`, `vendor_state`, `vendor_country`, `vendor_zip`, `vendor_store_name`, `vendor_store_desc`, `vendor_category_id`, `vendor_thumb_image`, `vendor_full_image`, `vendor_currency`, `cdate`, `mdate`, `vendor_image_path`, `vendor_terms_of_service`, `vendor_url`, `vendor_min_pov`, `vendor_freeshipping`, `vendor_currency_display_style`, `vendor_accepted_currencies`, `vendor_address_format`, `vendor_date_format`) VALUES (1, 'Washupito\\''s Tiendita', 'Owner', 'Demo', 'Store', 'Mr.', '555-555-1212', '555-555-1212', '555-555-1212', '[email protected]', '555-555-1212', '100 Washupito Avenue, N.W.', '', 'Lake Forest', 'CA', 'USA', '92630', 'Washupito\\''s Tiendita', '
We have the best tools for do-it-yourselfers. Check us out!
We were established in 1969 in a time when getting good tools was expensive, but the quality was good. Now that only a select few of those authentic tools survive, we have dedicated this store to bringing the experience alive for collectors and master mechanics everywhere.
You can easily find products selecting the category you would like to browse above.
', 0, '', 'c19970d6f2970cb0d1b13bea3af3144a.gif', 'BGL', 950302468, 1239727489, 'shop_image/', '
You haven\\''t configured any terms of service yet. Click here to change this text.
', 'http://ray-bg.com', '0.00', '0.00', '1|ЛЕВА |2|.| |2|1', 'BGL', '{storename}\r\n{address_1}\r\n{address_2}\r\n{city}, {zip}', '%A, %d %B %Y %H:%M'); -- -------------------------------------------------------- -- -- Table structure for table `jos_vm_vendor_category` -- CREATE TABLE IF NOT EXISTS `jos_vm_vendor_category` ( `vendor_category_id` int(11) NOT NULL auto_increment, `vendor_category_name` varchar(64) default NULL, `vendor_category_desc` text, PRIMARY KEY (`vendor_category_id`), KEY `idx_vendor_category_category_name` (`vendor_category_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='The categories that vendors are assigned to' AUTO_INCREMENT=7 ; -- -- Dumping data for table `jos_vm_vendor_category` -- INSERT INTO `jos_vm_vendor_category` (`vendor_category_id`, `vendor_category_name`, `vendor_category_desc`) VALUES (6, '-default-', 'Default'); -- -------------------------------------------------------- -- -- Table structure for table `jos_vm_waiting_list` -- CREATE TABLE IF NOT EXISTS `jos_vm_waiting_list` ( `waiting_list_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `notify_email` varchar(150) NOT NULL default '', `notified` enum('0','1') default '0', `notify_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`waiting_list_id`), KEY `product_id` (`product_id`), KEY `notify_email` (`notify_email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores notifications, users waiting f. products out of stock' AUTO_INCREMENT=1 ; -- -- Dumping data for table `jos_vm_waiting_list` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_vm_zone_shipping` -- CREATE TABLE IF NOT EXISTS `jos_vm_zone_shipping` ( `zone_id` int(11) NOT NULL auto_increment, `zone_name` varchar(255) default NULL, `zone_cost` decimal(10,2) default NULL, `zone_limit` decimal(10,2) default NULL, `zone_description` text NOT NULL, `zone_tax_rate` int(11) NOT NULL default '0', PRIMARY KEY (`zone_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='The Zones managed by the Zone Shipping Module' AUTO_INCREMENT=5 ; -- -- Dumping data for table `jos_vm_zone_shipping` -- INSERT INTO `jos_vm_zone_shipping` (`zone_id`, `zone_name`, `zone_cost`, `zone_limit`, `zone_description`, `zone_tax_rate`) VALUES (1, 'Default', '6.00', '35.00', 'This is the default Shipping Zone. This is the zone information that all countries will use until you assign each individual country to a Zone.', 2), (2, 'Zone 1', '1000.00', '10000.00', 'This is a zone example', 2), (3, 'Zone 2', '2.00', '22.00', 'This is the second zone. You can use this for notes about this zone', 2), (4, 'Zone 3', '11.00', '64.00', 'Another usefull thing might be details about this zone or special instructions.', 2); -- -------------------------------------------------------- -- -- Table structure for table `jos_weblinks` -- CREATE TABLE IF NOT EXISTS `jos_weblinks` ( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `url` varchar(250) NOT NULL default '', `description` text NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '1', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`,`archived`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Dumping data for table `jos_weblinks` -- INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (1, 2, 0, 'Joomla!', 'joomla', 'http://www.joomla.org', 'Home of Joomla!', '2005-02-14 15:19:02', 3, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'), (2, 2, 0, 'php.net', 'php', 'http://www.php.net', 'The language that Joomla! is developed in', '2004-07-07 11:33:24', 6, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, ''), (3, 2, 0, 'MySQL', 'mysql', 'http://www.mysql.com', 'The database that Joomla! uses', '2004-07-07 10:18:31', 1, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, ''), (4, 2, 0, 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Home of OSM', '2005-02-14 15:19:02', 11, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 'target=0'), (5, 2, 0, 'Joomla! - Forums', 'joomla-forums', 'http://forum.joomla.org', 'Joomla! Forums', '2005-02-14 15:19:02', 4, 1, 0, '0000-00-00 00:00:00', 4, 0, 1, 'target=0'), (6, 2, 0, 'Ohloh Tracking of Joomla!', 'ohloh-tracking-of-joomla', 'http://www.ohloh.net/projects/20', 'Objective reports from Ohloh about Joomla''s development activity. Joomla! has some star developers with serious kudos.', '2007-07-19 09:28:31', 1, 1, 0, '0000-00-00 00:00:00', 6, 0, 1, 'target=0\n\n');
can someone tell me how to fix it ? 10x for the time
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 'CREATE TABLE IF NOT EXISTS `jos_vm_vendor_category` ( `vendor_category_id` int' at line 14 SQL=-- -- Dumping data for table `jos_vm_vendor` -- INSERT INTO `jos_vm_vendor` (`vendor_id`, `vendor_name`, `contact_last_name`, `contact_first_name`, `contact_middle_name`, `contact_title`, `contact_phone_1`, `contact_phone_2`, `contact_fax`, `contact_email`, `vendor_phone`, `vendor_address_1`, `vendor_address_2`, `vendor_city`, `vendor_state`, `vendor_country`, `vendor_zip`, `vendor_store_name`, `vendor_store_desc`, `vendor_category_id`, `vendor_thumb_image`, `vendor_full_image`, `vendor_currency`, `cdate`, `mdate`, `vendor_image_path`, `vendor_terms_of_service`, `vendor_url`, `vendor_min_pov`, `vendor_freeshipping`, `vendor_currency_display_style`, `vendor_accepted_currencies`, `vendor_address_format`, `vendor_date_format`) VALUES (1, 'Washupito\\''s Tiendita', 'Owner', 'Demo', 'Store', 'Mr.', '555-555-1212', '555-555-1212', '555-555-1212', '[email protected]', '555-555-1212', '100 Washupito Avenue, N.W.', '', 'Lake Forest', 'CA', 'USA', '92630', 'Washupito\\''s Tiendita', '
We have the best tools for do-it-yourselfers. Check us out!
We were established in 1969 in a time when getting good tools was expensive, but the quality was good. Now that only a select few of those authentic tools survive, we have dedicated this store to bringing the experience alive for collectors and master mechanics everywhere.
You can easily find products selecting the category you would like to browse above.
', 0, '', 'c19970d6f2970cb0d1b13bea3af3144a.gif', 'BGL', 950302468, 1239727489, 'shop_image/', '
You haven\\''t configured any terms of service yet. Click here to change this text.
', 'http://ray-bg.com', '0.00', '0.00', '1|ЛЕВА |2|.| |2|1', 'BGL', '{storename}\r\n{address_1}\r\n{address_2}\r\n{city}, {zip}', '%A, %d %B %Y %H:%M'); -- -------------------------------------------------------- -- -- Table structure for table `jos_vm_vendor_category` -- CREATE TABLE IF NOT EXISTS `jos_vm_vendor_category` ( `vendor_category_id` int(11) NOT NULL auto_increment, `vendor_category_name` varchar(64) default NULL, `vendor_category_desc` text, PRIMARY KEY (`vendor_category_id`), KEY `idx_vendor_category_category_name` (`vendor_category_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='The categories that vendors are assigned to' AUTO_INCREMENT=7 ; -- -- Dumping data for table `jos_vm_vendor_category` -- INSERT INTO `jos_vm_vendor_category` (`vendor_category_id`, `vendor_category_name`, `vendor_category_desc`) VALUES (6, '-default-', 'Default'); -- -------------------------------------------------------- -- -- Table structure for table `jos_vm_waiting_list` -- CREATE TABLE IF NOT EXISTS `jos_vm_waiting_list` ( `waiting_list_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `notify_email` varchar(150) NOT NULL default '', `notified` enum('0','1') default '0', `notify_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`waiting_list_id`), KEY `product_id` (`product_id`), KEY `notify_email` (`notify_email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores notifications, users waiting f. products out of stock' AUTO_INCREMENT=1 ; -- -- Dumping data for table `jos_vm_waiting_list` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_vm_zone_shipping` -- CREATE TABLE IF NOT EXISTS `jos_vm_zone_shipping` ( `zone_id` int(11) NOT NULL auto_increment, `zone_name` varchar(255) default NULL, `zone_cost` decimal(10,2) default NULL, `zone_limit` decimal(10,2) default NULL, `zone_description` text NOT NULL, `zone_tax_rate` int(11) NOT NULL default '0', PRIMARY KEY (`zone_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='The Zones managed by the Zone Shipping Module' AUTO_INCREMENT=5 ; -- -- Dumping data for table `jos_vm_zone_shipping` -- INSERT INTO `jos_vm_zone_shipping` (`zone_id`, `zone_name`, `zone_cost`, `zone_limit`, `zone_description`, `zone_tax_rate`) VALUES (1, 'Default', '6.00', '35.00', 'This is the default Shipping Zone. This is the zone information that all countries will use until you assign each individual country to a Zone.', 2), (2, 'Zone 1', '1000.00', '10000.00', 'This is a zone example', 2), (3, 'Zone 2', '2.00', '22.00', 'This is the second zone. You can use this for notes about this zone', 2), (4, 'Zone 3', '11.00', '64.00', 'Another usefull thing might be details about this zone or special instructions.', 2); -- -------------------------------------------------------- -- -- Table structure for table `jos_weblinks` -- CREATE TABLE IF NOT EXISTS `jos_weblinks` ( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `url` varchar(250) NOT NULL default '', `description` text NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '1', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`,`archived`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Dumping data for table `jos_weblinks` -- INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (1, 2, 0, 'Joomla!', 'joomla', 'http://www.joomla.org', 'Home of Joomla!', '2005-02-14 15:19:02', 3, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'), (2, 2, 0, 'php.net', 'php', 'http://www.php.net', 'The language that Joomla! is developed in', '2004-07-07 11:33:24', 6, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, ''), (3, 2, 0, 'MySQL', 'mysql', 'http://www.mysql.com', 'The database that Joomla! uses', '2004-07-07 10:18:31', 1, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, ''), (4, 2, 0, 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Home of OSM', '2005-02-14 15:19:02', 11, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 'target=0'), (5, 2, 0, 'Joomla! - Forums', 'joomla-forums', 'http://forum.joomla.org', 'Joomla! Forums', '2005-02-14 15:19:02', 4, 1, 0, '0000-00-00 00:00:00', 4, 0, 1, 'target=0'), (6, 2, 0, 'Ohloh Tracking of Joomla!', 'ohloh-tracking-of-joomla', 'http://www.ohloh.net/projects/20', 'Objective reports from Ohloh about Joomla''s development activity. Joomla! has some star developers with serious kudos.', '2007-07-19 09:28:31', 1, 1, 0, '0000-00-00 00:00:00', 6, 0, 1, 'target=0\n\n');
can someone tell me how to fix it ? 10x for the time