Joomla Templates Club 406,261 posts

[rantony2001 Friend rantony2001Join date: March 2011Posts: 11Downloads:0Uploads:0 Thanks: 4]

#165467

Hi,

I tried installing the quickstart for JA Travel. But its not working. during installation at the 3rd step where its asking for db connection, its giving an SQL error and the query is breaking.

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 AUTO_INCREMENT=9’ at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) NOT NULL DEFAULT ‘0’, `type` varchar(30) NOT NULL DEFAULT ‘banner’, `name` varchar(255) NOT NULL DEFAULT ”, `alias` varchar(255) NOT NULL DEFAULT ”, `imptotal` int(11) NOT NULL DEFAULT ‘0’, `impmade` int(11) NOT NULL DEFAULT ‘0’, `clicks` int(11) NOT NULL DEFAULT ‘0’, `imageurl` varchar(100) NOT NULL DEFAULT ”, `clickurl` varchar(200) NOT NULL DEFAULT ”, `date` datetime DEFAULT NULL, `showBanner` tinyint(1) NOT NULL DEFAULT ‘0’, `checked_out` tinyint(1) NOT NULL DEFAULT ‘0’, `checked_out_time` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `editor` varchar(50) DEFAULT NULL, `custombannercode` text, `catid` int(10) unsigned NOT NULL DEFAULT ‘0’, `description` text NOT NULL, `sticky` tinyint(1) unsigned NOT NULL DEFAULT ‘0’, `ordering` int(11) NOT NULL DEFAULT ‘0’, `publish_up` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `publish_down` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `tags` text NOT NULL, `params` text NOT NULL, PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), KEY `idx_banner_catid` (`catid`) ) TYPE=MyISAM AUTO_INCREMENT=9

Please help me in installing the quick start. Require this template at the earliest.

Regards

[chavan Friend chavanJoin date: October 2014Posts: 4612Downloads:0Uploads:110 Thanked: 1440 times in 1290 posts]

#397836

Hi rantony2001

In new version, mysql doesn’t support TYPE. It uses ENGINE to alternate TYPE.

You open file installation/sql/mysql/joomla.sql and sample_data.sql, replace TYPE=MyISAM by ENGINE=MyISAM.

1 user says Thank You to chavan for this useful post

1. rantony2001

[rantony2001 Friend rantony2001Join date: March 2011Posts: 11Downloads:0Uploads:0 Thanks: 4]

#397908

<em>@dohq 248900 wrote:</em><blockquote>Hi rantony2001

In new version, mysql doesn’t support TYPE. It uses ENGINE to alternate TYPE.

You open file installation/sql/mysql/joomla.sql and sample_data.sql, replace TYPE=MyISAM by ENGINE=MyISAM.</blockquote>

Many thanks Dohq, its working now :):)

[Author]

Posts