Installation problems

[EricD]

I am trying to install VirtueMart 1.1.9.j15 but am having great difficulties. I downloaded both the complete package and the VirtueMart eCommerce Bundle (Joomla! bundled with VirtueMart) but having problems with both.

When trying to install the complete package, I get a white blank screen and nothing happens after that, ie: I don't get the "welcome" screen. The files in the admin/components/virtuemart seem to be all there but in the components/virtue mart there is only a the "frontend_files.tar" and nothing else. I tried it a few times but the same happens every time. I have been waiting for 30 minutes now but I still have the white blank page.

I also tried the VirtueMart eCommerce Bundle but I get the following 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 CHARACTER SET `utf8`' 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` 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`) ) TYPE=MyISAM CHARACTER SET `utf8`

I am having the same problems both using Windows and Ubuntu and installing on my own pc's.

Can anyone help please.

Thanks

[jenkinhill]

Looks like you are using MySQL5.5 - use an earlier version and the bundle will install. I have had no problems at all installing 1.1.9 -I assume this was with Joomla 1.5?    See http://forum.virtuemart.net/index.php?topic=87637  and  http://forum.virtuemart.net/index.php?topic=84238.msg286589#msg286589

I'd use the bundle in case you have other component install issues.