× Support for Joomla 1.5 templates is discontinued. This forum category is read-only.

Sample data does not install.

Start
Prev
1
Next
End

cokolwiek
Topic Author
Offline

7 years 5 months ago #1936 by cokolwiek

cokolwiek created the topic: Sample data does not install.

When I try to install sample data package I get into problems with virtuemart. So I've decided to install joomla1.5! and then the fix for virtuemart (mod in sql.virtuemart.php) but this leaves me with very basic website layout.
So I've decided to include my fix for virtuemart in jm-deco-home package but I'm getting 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 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 googled for it and it looks like I need to modify two files (change TYPE to ENGINE)... however this does not fix virtuemart but also when I try to click 'install sample data' I get an error about XML file.
Any fix for this?

Please Log in or Create an account to join the conversation.

marcin
Offline

7 years 5 months ago #1938 by marcin

marcin replied the topic: Re: Sample data does not install.

Hello,

I guess that you haven't replaced all appearances of TYPE=MyISAM to ENGINE=MyISAM. Remember to replace it also in the virtuemart sql files.

These files can be found in "root/installation/sql/mysql/".

Regards,
Marcin

Please Log in or Create an account to join the conversation.