zl0ty
16-07-2006, 15:33
Jak instaluje remository z waszej strony dzieje się tak:
Wczytaj component - Niepowodzenie
Błąd SQL: DB function failed with error number 1067
Invalid default value for 'itemid' SQL=CREATE TABLE IF NOT EXISTS `jos_downloads_reviews` (
`id` int NOT NULL auto_increment,
`sequence` int NOT NULL default '0',
`windowtitle` varchar(255) NOT NULL default '',
`component` varchar (255) NOT NULL default '',
`itemid` int NOT NULL default '',
`userid` mediumint NOT NULL default '0',
`userURL` varchar(255) NOT NULL default '',
`title` varchar (255) NOT NULL default '',
`comment` text NOT NULL default '',
`fullreview` text NOT NULL default '',
`date` datetime NOT NULL default '2000-01-01 00:00:00',
UNIQUE KEY `id` (`id`),
KEY `userid` (`component`,`itemid`,`userid`)
) TYPE=MyISAM;
SQL = CREATE TABLE IF NOT EXISTS `jos_downloads_reviews` (
`id` int NOT NULL auto_increment,
`sequence` int NOT NULL default '0',
`windowtitle` varchar(255) NOT NULL default '',
`component` varchar (255) NOT NULL default '',
`itemid` int NOT NULL default '',
`userid` mediumint NOT NULL default '0',
`userURL` varchar(255) NOT NULL default '',
`title` varchar (255) NOT NULL default '',
`comment` text NOT NULL default '',
`fullreview` text NOT NULL default '',
`date` datetime NOT NULL default '2000-01-01 00:00:00',
UNIQUE KEY `id` (`id`),
KEY `userid` (`component`,`itemid`,`userid`)
) TYPE=MyISAM;
Wczytaj component - Niepowodzenie
Błąd SQL: DB function failed with error number 1067
Invalid default value for 'itemid' SQL=CREATE TABLE IF NOT EXISTS `jos_downloads_reviews` (
`id` int NOT NULL auto_increment,
`sequence` int NOT NULL default '0',
`windowtitle` varchar(255) NOT NULL default '',
`component` varchar (255) NOT NULL default '',
`itemid` int NOT NULL default '',
`userid` mediumint NOT NULL default '0',
`userURL` varchar(255) NOT NULL default '',
`title` varchar (255) NOT NULL default '',
`comment` text NOT NULL default '',
`fullreview` text NOT NULL default '',
`date` datetime NOT NULL default '2000-01-01 00:00:00',
UNIQUE KEY `id` (`id`),
KEY `userid` (`component`,`itemid`,`userid`)
) TYPE=MyISAM;
SQL = CREATE TABLE IF NOT EXISTS `jos_downloads_reviews` (
`id` int NOT NULL auto_increment,
`sequence` int NOT NULL default '0',
`windowtitle` varchar(255) NOT NULL default '',
`component` varchar (255) NOT NULL default '',
`itemid` int NOT NULL default '',
`userid` mediumint NOT NULL default '0',
`userURL` varchar(255) NOT NULL default '',
`title` varchar (255) NOT NULL default '',
`comment` text NOT NULL default '',
`fullreview` text NOT NULL default '',
`date` datetime NOT NULL default '2000-01-01 00:00:00',
UNIQUE KEY `id` (`id`),
KEY `userid` (`component`,`itemid`,`userid`)
) TYPE=MyISAM;