Joomla Templates Club 406,261 posts

[omarzahid Friend omarzahidJoin date: June 2011Posts: 11Downloads:0Uploads:2 Thanks: 3]

#166073

Hi all,

Iam getting the below error at step 4 while trying to install the JA Business quickstart on my localhost(pc)
using xampp —- joomla 1.6

Some errors occurred while populating the database: 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’ at line 41 SQL=CREATE TABLE `jos_weblinks` ( `id` int(10) 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’, `state` 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’, `access` int(11) NOT NULL DEFAULT ‘1’, `params` text NOT NULL, `language` char(7) NOT NULL DEFAULT ”, `created` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `created_by` int(10) unsigned NOT NULL DEFAULT ‘0’, `created_by_alias` varchar(255) NOT NULL DEFAULT ”, `modified` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `modified_by` int(10) unsigned NOT NULL DEFAULT ‘0’, `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `featured` tinyint(3) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘Set if link is featured.’, `xreference` varchar(50) NOT NULL COMMENT ‘A reference to enable linkages to external data sets.’, `publish_up` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `publish_down` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`state`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_featured_catid` (`featured`,`catid`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) TYPE=MyISAM ;

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#400425

Answer for you here: http://www.joomlart.com/forums/topic/cant-complete-quickstart-install/

2 users say Thank You to Saguaros for this useful post

1. JA Developer
2. omarzahid

[Author]

Posts