JA Showcase 1.5 - SQL-failed with error 1074

[networker007]

Hello everybody,
i would like to install the JA Showcase 1.5 on a Joomla Version 1.5.3 ->I cant install ! This is the error-message. What should i do now??


JInstaller::install: SQL-Fehler DB function failed with error number 1074
Column length too big for column 'directory' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS `jos_jashowcase` ( `id` int(11) NOT NULL auto_increment, `ishot` tinyint(4) NOT NULL default '0', `name` text NOT NULL, `description` longtext, `published` tinyint(4) NOT NULL default '1', `directory` varchar(500) NULL default '', `thumbnail` varchar(500) NULL default '', `info_url` varchar(500) NULL default '', `other_info_url` varchar(500) NULL default '', `demo_url` varchar(500) NULL default '', `ordering` int(11) NOT NULL, `catid` int(11) NOT NULL, `datas` text NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=11;
SQL =

CREATE TABLE IF NOT EXISTS `jos_jashowcase` (
`id` int(11) NOT NULL auto_increment,
`ishot` tinyint(4) NOT NULL default '0',
`name` text NOT NULL,
`description` longtext,
`published` tinyint(4) NOT NULL default '1',
`directory` varchar(500) NULL default '',
`thumbnail` varchar(500) NULL default '',
`info_url` varchar(500) NULL default '',
`other_info_url` varchar(500) NULL default '',
`demo_url` varchar(500) NULL default '',
`ordering` int(11) NOT NULL,
`catid` int(11) NOT NULL,
`datas` text NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11;

[hongnt1]

hi networker007,
Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.
In your case, Mysql version is less than 5.0.3 so max value = 255. You can change like that: in Com_jashowcase package, you opens com_jashowcase.xml file and replace:

CREATE TABLE IF NOT EXISTS `jos_jashowcase` (
`id` int(11) NOT NULL auto_increment,
`ishot` tinyint(4) NOT NULL default '0',
`name` text NOT NULL,
`description` longtext,
`published` tinyint(4) NOT NULL default '1',
`directory` varchar(500) NULL default '',
`thumbnail` varchar(500) NULL default '',
`info_url` varchar(500) NULL default '',
`other_info_url` varchar(500) NULL default '',
`demo_url` varchar(500) NULL default '',
`ordering` int(11) NOT NULL,
`catid` int(11) NOT NULL,
`datas` text NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11;

to:

CREATE TABLE IF NOT EXISTS `jos_jashowcase` (
`id` int(11) NOT NULL auto_increment,
`ishot` tinyint(4) NOT NULL default '0',
`name` text NOT NULL,
`description` longtext,
`published` tinyint(4) NOT NULL default '1',
`directory` varchar(255) NULL default '',
`thumbnail` varchar(255) NULL default '',
`info_url` varchar(255) NULL default '',
`other_info_url` varchar(255) NULL default '',
`demo_url` varchar(255) NULL default '',
`ordering` int(11) NOT NULL,
`catid` int(11) NOT NULL,
`datas` text NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11;

[mayke]

Hi Hongnt1,

Thank you for good tutorial, it works!