- Posts: 1
×
Support for Joomla 1.5 templates is discontinued. This forum category is read-only.
Sample data does not install.
8 years 2 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: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?
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`Any fix for this?
Please Log in or Create an account to join the conversation.
8 years 2 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
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.
Time to create page: 0.227 seconds
