DB connection - Joomla! Forum - community, help and support


hello iam using ver 14.14 distrib 5.5.34, debian-linux-gnu (x86_64) try , install joomla getting error when try connect mysql.below error iam geting:

you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'textcharacter set `utf8`' @ 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` integer unsigned not null default 0, `description` text not null default '', `sticky` tinyint(1) unsigned not null default 0, `ordering` integer 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 default '', `params` text not null default '', primary key (`bid`), key `viewbanner` (`showbanner`), index `idx_banner_catid`(`catid`) ) textcharacter set `utf8`

what version of joomla using?
what type of install this,
clean install
export of live site database trying import

which mysql database version using?
which php version

my guess textcharacter set `utf8` should engine=myisam character set `utf8` or character set `utf8`





Comments

Popular posts from this blog

Joomla 3.3 Installation Error message - Joomla! Forum - community, help and support

Multilanguage infinite redirect loop error. - Joomla! Forum - community, help and support

trim media limit reached