PDA

Zobacz pełną wersję : com_booklibrary_v07b_pl



ireks
06-12-2006, 14:06
Nie mogę zainstalować com_booklibrary_v07b_pl.

Pojawia się błąd :
Błąd SQL: DB function failed with error number 1067
Invalid default value for 'fk_bookid' SQL=CREATE TABLE IF NOT EXISTS `jos_booklibrary_lend` ( `id` int(11) unsigned NOT NULL auto_increment, `fk_bookid` int(11) NOT NULL default '', `fk_userid` int(11), `lend_from` datetime NOT NULL default '0000-00-00 00:00:00', `lend_until` datetime, `lend_return` datetime, `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `user_name` varchar(250) default '', `user_email` varchar(250) default '', `user_mailing` TEXT default '', PRIMARY KEY (`id`), FOREIGN KEY (`fk_userid`) REFERENCES jos_users(`id`), FOREIGN KEY (`fk_bookid`) REFERENCES jos_booklibrary(`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ;
SQL = CREATE TABLE IF NOT EXISTS `jos_booklibrary_lend` (
`id` int(11) unsigned NOT NULL auto_increment,
`fk_bookid` int(11) NOT NULL default '',
`fk_userid` int(11),
`lend_from` datetime NOT NULL default '0000-00-00 00:00:00',
`lend_until` datetime,
`lend_return` datetime,
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`user_name` varchar(250) default '',
`user_email` varchar(250) default '',
`user_mailing` TEXT default '',
PRIMARY KEY (`id`),
FOREIGN KEY (`fk_userid`) REFERENCES jos_users(`id`),
FOREIGN KEY (`fk_bookid`) REFERENCES jos_booklibrary(`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;