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

Sample data does not install.

More
7 years 9 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.

More
7 years 9 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.

Time to create page: 0.222 seconds

INDICO S.C.

ul. Wałowa 10/3, 84-200 Wejherowo, registered in Centralna Ewidencja i Informacja o Działalnosci Gospodarczej
NIP/VATID: PL5882424318

Copyright © 2009-2019 Joomla-Monster.com All rights reserved.

Joomla-Monster.com and this site is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.