Joomla Templates Club 406,261 posts

[crock44 Friend crock44Join date: June 2009Posts: 1Downloads:0Uploads:0 Thanks: 2]

#166023

I’m trying to do a quickstart install of JA T3 Blank for Joomla 1.6 and am getting the following error message at Database Configuration stage:

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 ;

Any help would be much appreciated.

Thanks

[Sherlock Friend SherlockJoin date: September 2014Posts: 11453Downloads:0Uploads:88 Thanks: 221 Thanked: 2478 times in 2162 posts]

#400187

Hi Friend
Seem you posted wrong forum, but please let me know more further about your problem:
– Your version Mysql, version PHP
– Do u have same problem with JA travel quickstart or other quickstart?
– Version of T3 Blank what you tried to install

Regards

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

#400321

Hi,

Where you able to find a solution to this?
I get the same/similar error trying to install JA Business quickstart on my local PC…

Get the below error in step 4(database) for the install process.

“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]

#400406

Hi omarzahid,
The problem may be from the MySQL version and we suggest 2 ways to solve:
– To work with the lastest MySQL version, we need to change TYPE=MYISAM to ENGINE=MYISAM in the file: ..installationsqlmysqlsample_data.sql.
– We uninstall the lastest version of XAMPP 1.7.4 and go back to download and install older version (maybe 1.7.3) from http://www.apachefriends.org
And then we reinstall the quickstart package.
Hope this helps.

2 users say Thank You to Saguaros for this useful post

1. omarzahid
2. crock44

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

#400409

I have attempted the change of the sample_data.sql with no luck…I may have to try the downgrade fo XAMPP 🙁

Thanks

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

#401768

I have tried the first option by changing TYPE=MYISAM to ENGINE=MYISAM in the file: ..installationsqlmysqlsample_data.sql under where I extracted the quickstart for the tempalte i want to use, after saving I run the installation again, but get the same error, what I don’t undersatnd is that the error is still the sme, ie ….right syntax to use near ‘TYPE=MyISAM’ at line 41…., but I have just removed that line and done a search in the file there is no instances of Type=MyISAM, so where could it be getting that error??

[Author]

Posts