Joomla Templates Club 406,261 posts

[hrasno Friend hrasnoJoin date: April 2008Posts: 38Downloads:7Uploads:6 Thanks: 11 Thanked: 2 times in 2 posts]

#167122

I can’t install any cuick start for JA Teline on a localhost. When I enter username, database name… and click next I got this error:

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=12' 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=12

Regular Joomla is working fine.

Thanks in advance

[himangi Friend himangiJoin date: April 2011Posts: 1406Downloads:1Uploads:86 Thanks: 21 Thanked: 345 times in 332 posts]

#404731

Hi,

I have installed JA teline IV quickstart for Joomla 1.5 and 1.6 and it works fine. Can you please check if you are using latest version and try installing quickstart again? Let me know the verion of the template quickstart and Joomla version being used for it (J1.5 / J1.6), if you still get the error and I will check the quickstart package again.

[Author]

Posts