Joomla pack - Joomla! Forum - community, help and support

im trying move new site localhost server joomlapack, , ok, till db restore.
when click next in joomla pack installer 4.0 message , if can me ?

code: select all

restoration progress

error @ line 0: create table `#__banner` ( `bid` int(11) not null auto_increment, `cid` int(11) not null default '0', `type` varchar(30) collate utf8_slovenian_ci not null default 'banner', `name` varchar(255) collate utf8_slovenian_ci not null default '', `alias` varchar(255) collate utf8_slovenian_ci 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) collate utf8_slovenian_ci not null default '', `clickurl` varchar(200) collate utf8_slovenian_ci 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) collate utf8_slovenian_ci default null, `custombannercode` text collate utf8_slovenian_ci, `catid` int(10) unsigned not null default '0', `description` text collate utf8_slovenian_ci 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 collate utf8_slovenian_ci not null, `params` text collate utf8_slovenian_ci not null, primary key (`bid`), key `viewbanner` (`showbanner`), key `idx_banner_catid` (`catid`) ) engine=myisam auto_increment=9 default charset=utf8 collate=utf8_slovenian_ci;

query:create table `#__banner` ( `bid` int(11) not null auto_increment, `cid` int(11) not null default '0', `type` varchar(30) collate utf8_slovenian_ci not null default 'banner', `name` varchar(255) collate utf8_slovenian_ci not null default '', `alias` varchar(255) collate utf8_slovenian_ci 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) collate utf8_slovenian_ci not null default '', `clickurl` varchar(200) collate utf8_slovenian_ci 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) collate utf8_slovenian_ci default null, `custombannercode` text collate utf8_slovenian_ci, `catid` int(10) unsigned not null default '0', `description` text collate utf8_slovenian_ci 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 collate utf8_slovenian_ci not null, `params` text collate utf8_slovenian_ci not null, primary key (`bid`), key `viewbanner` (`showbanner`), key `idx_banner_catid` (`catid`) ) engine=myisam auto_increment=9 default charset=utf8 collate=utf8_slovenian_ci

mysql: mysql query failed error 1064 (you have error in sql syntax. check manual corresponds mysql server version right syntax use near 'collate utf8_slovenian_ci not null default 'banner', `name` v). query was:create table `jos_banner` ( `bid` int(11) not null auto_increment, `cid` int(11) not null default '0', `type` varchar(30) collate utf8_slovenian_ci not null default 'banner', `name` varchar(255) collate utf8_slovenian_ci not null default '', `alias` varchar(255) collate utf8_slovenian_ci 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) collate utf8_slovenian_ci not null default '', `clickurl` varchar(200) collate utf8_slovenian_ci 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) collate utf8_slovenian_ci default null, `custombannercode` text collate utf8_slovenian_ci, `catid` int(10) unsigned not null default '0', `description` text collate utf8_slovenian_ci 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 collate utf8_slovenian_ci not null, `params` text collate utf8_slovenian_ci not null, primary key (`bid`), key `viewbanner` (`showbanner`), key `idx_banner_catid` (`catid`) ) engine=myisam auto_increment=9 default charset=utf8 collate=utf8_slovenian_ci



that appear either permissions issue database, or database exists, , or database how corrupt.

what create new blank database on server, , try importing again