JKW
18-08-2006, 18:49
Czesc. Probowalem zainstalowac com_bookmarks na joomli 1.0.10 i niestety wyskakuje mi taki blad:
Błąd SQL: DB function failed with error number 1067
Invalid default value for 'credits' SQL=CREATE TABLE `jos_bookmarks` ( `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_bookmarks` ( `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;
Mozecie jakos na szybko pomoc. Z góry wielkie dzieki i pozdrawiamIrek.
Błąd SQL: DB function failed with error number 1067
Invalid default value for 'credits' SQL=CREATE TABLE `jos_bookmarks` ( `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_bookmarks` ( `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;
Mozecie jakos na szybko pomoc. Z góry wielkie dzieki i pozdrawiamIrek.