The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 5 posts ] 
Author Message
PostPosted: Sat Apr 18, 2009 11:53 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Apr 18, 2009 11:41 pm
Posts: 2
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', 'admin@ray-bg.com', '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


Top
 Profile  
 
PostPosted: Sun Apr 19, 2009 12:18 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Wed Apr 01, 2009 8:42 pm
Posts: 124
Location: kushtia,Bangladesh
You need to more study about MySql, Basically How to create database,table etc
take help from
http://www.mysql.com
and
Google

_________________
Web Developer
www.globalweboutsourcing.com


Top
 Profile  
 
PostPosted: Sun Apr 19, 2009 1:39 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Apr 18, 2009 11:41 pm
Posts: 2
mhm that`s true :/ but how can i fix this problem what does it men? :/ I`m new in Linux world and MySql


Top
 Profile  
 
PostPosted: Sun Apr 19, 2009 8:43 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Wed Apr 01, 2009 8:42 pm
Posts: 124
Location: kushtia,Bangladesh
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

_________________
Web Developer
www.globalweboutsourcing.com


Top
 Profile  
 
PostPosted: Sat May 14, 2011 2:07 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Jun 03, 2010 2:50 am
Posts: 1
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 



Who is online

Users browsing this forum: No registered users and 29 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group