MySQL Syntax ERROR!?!?!? HELP!!!

Need help installing Joomla! 1.5? For all Joomla! 1.5 installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
andromeda23
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sat Apr 18, 2009 11:41 pm

MySQL Syntax ERROR!?!?!? HELP!!!

Postby andromeda23 » 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

User avatar
matinice
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 124
Joined: Wed Apr 01, 2009 8:42 pm
Location: kushtia,Bangladesh
Contact:

Re: MySQL Syntax ERROR!?!?!? HELP!!!

Postby matinice » Sun Apr 19, 2009 12:18 am

You need to more study about MySql, Basically How to create database,table etc
take help from
http://www.mysql.com
and
Google

andromeda23
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sat Apr 18, 2009 11:41 pm

Re: MySQL Syntax ERROR!?!?!? HELP!!!

Postby andromeda23 » Sun Apr 19, 2009 1:39 am

mhm that`s true :/ but how can i fix this problem what does it men? :/ I`m new in Linux world and MySql

User avatar
matinice
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 124
Joined: Wed Apr 01, 2009 8:42 pm
Location: kushtia,Bangladesh
Contact:

Re: MySQL Syntax ERROR!?!?!? HELP!!!

Postby matinice » Sun Apr 19, 2009 8:43 pm

That is good news for u.
if anyone wish to do any work he done 50%,try to earn rest 50%.
u may also take help tutarial..
http://www.siteground.com/tutorials/joo ... lation.htm

r272488287
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Jun 03, 2010 2:50 am

Re: MySQL Syntax ERROR!?!?!? HELP!!!

Postby r272488287 » Sat May 14, 2011 2:07 pm

If you use MySQL 5.5 you should replace in virtuemart.installation.joomla.sql and other related sql files these text - TYPE= to ENGINE= and TYPE = to ENGINE =
Let's build online joomla community - http://joomlaonlinechat.com


Return to “Installation 1.5”

Who is online

Users browsing this forum: No registered users and 5 guests