Public Forums 71,145 posts

[madelman2012 Friend madelman2012Join date: July 2012Posts: 71Downloads:0Uploads:12 Thanks: 3 Thanked: 4 times in 1 posts]

#178849

This is what I get after adding database parameters and trying to install:

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

Version fo mysql is : version: 5.5.24

How do I install this?

[MoonSailor Friend MoonSailorJoin date: November 2011Posts: 1106Downloads:0Uploads:245 Thanks: 89 Thanked: 248 times in 223 posts]

#460239

Hi madelman2012,

What template did you use? How did you install it?

When I see error, I believe the error are due to the demo database of the template. You can fix this by:

Go to folder : “installation/sql/mysql”, find all file with .sql. Find TYPE=MyISAM and replace it by ENGINE=MyISAM

Thanks

[mislily12 Friend mislily12Join date: March 2012Posts: 1Downloads:0Uploads:0]

#460669

I also install like “madelman2012”. I fully installed, completely normal.

[Author]

Posts