joomla business directory

[hellogrish]

witam,

Joomla! 1.0.13 Stable

przy indstalacji komponentu joomla business directory
(w momencie wczytywania pliku .zip)
pojawia sie nastepujacy blad:



Błąd SQL DB function failed with error number 1067
Niewła?ciwa warto?ć domy?lna dla 'credits' SQL=CREATE TABLE `jos_10jbd` ( `id` int(11) unsigned NOT NULL auto_increment, `sid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `url` text NOT NULL default '', `description` text NOT NULL, `detail` text NOT NULL, `imageurl` varchar(250) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `rating` float(3,2) NOT NULL default '0.00', `ratingcount` int(11) NOT NULL default '0', `ratingadmin` tinyint(3) NOT NULL default '0', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `access` tinyint(3) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `created_by` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `archived` tinyint(1) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '1', `validated` varchar(5) NOT NULL default '0', `validationdate` datetime NOT NULL default '0000-00-00 00:00:00', `validationstatus` varchar(250) NOT NULL default '', `redirect` tinyint(1) NOT NULL default '0', `private` tinyint(1) NOT NULL default '0', `openwin` TINYINT( 1 ) DEFAULT '1' NOT NULL, `keywords` varchar(255) NOT NULL default '', `credits` int(11) NOT NULL default '', PRIMARY KEY (`id`), KEY `title` (`title`) ) TYPE=MyISAM;
SQL = CREATE TABLE `jos_10jbd` (
`id` int(11) unsigned NOT NULL auto_increment,
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`url` text NOT NULL default '',
`description` text NOT NULL,
`detail` text NOT NULL,
`imageurl` varchar(250) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`rating` float(3,2) NOT NULL default '0.00',
`ratingcount` int(11) NOT NULL default '0',
`ratingadmin` tinyint(3) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`created_by` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`archived` tinyint(1) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '1',
`validated` varchar(5) NOT NULL default '0',
`validationdate` datetime NOT NULL default '0000-00-00 00:00:00',
`validationstatus` varchar(250) NOT NULL default '',
`redirect` tinyint(1) NOT NULL default '0',
`private` tinyint(1) NOT NULL default '0',
`openwin` TINYINT( 1 ) DEFAULT '1' NOT NULL,
`keywords` varchar(255) NOT NULL default '',
`credits` int(11) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `title` (`title`)
) TYPE=MyISAM;



co jest nie tak? :)

pozdrawiam