ryszard555
18-04-2006, 11:47
Środowisko localne win XP pro + XAMPP PHP j.n.
[PHP: 4.4.1-pl1] Ustawienia zgodne z wymaganiami instalatora.
joomla 1.0.8 pl utf
Instalacja com_artbanner i komunikat jak niżej co może być przyczyną.
Ryszard
Wczytaj component - Niepowodzenie Błąd SQL: DB function failed with error number 1067
Invalid default value for 'border_value' SQL=CREATE TABLE `jos_artbanners` ( `id` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `tid` int(11) NOT NULL default '0', `type` varchar(10) NOT NULL default 'banner', `name` varchar(50) NOT NULL default '', `imp_total` int(11) NOT NULL default '0', `imp_made` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `image_url` varchar(100) NOT NULL default '', `click_url` varchar(200) NOT NULL default '', `state` tinyint(1) NOT NULL default '0', `default` tinyint(1) NOT NULL default '0', `custom_banner_code` text, `last_show` datetime NOT NULL default '0000-00-00 00:00:00', `msec` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` tinyint(1) NOT NULL default '0', `reccurweekdays` varchar(100) NOT NULL default '', `access` int(11) NOT NULL default '0', `target` varchar(15) NOT NULL default '', `border_value` int(11) NOT NULL default '', `border_style` varchar(11) NOT NULL default '', `border_color` varchar(11) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL = CREATE TABLE `jos_artbanners` ( `id` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `tid` int(11) NOT NULL default '0', `type` varchar(10) NOT NULL default 'banner', `name` varchar(50) NOT NULL default '', `imp_total` int(11) NOT NULL default '0', `imp_made` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `image_url` varchar(100) NOT NULL default '', `click_url` varchar(200) NOT NULL default '', `state` tinyint(1) NOT NULL default '0', `default` tinyint(1) NOT NULL default '0', `custom_banner_code` text, `last_show` datetime NOT NULL default '0000-00-00 00:00:00', `msec` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` tinyint(1) NOT NULL default '0', `reccurweekdays` varchar(100) NOT NULL default '', `access` int(11) NOT NULL default '0', `target` varchar(15) NOT NULL default '', `border_value` int(11) NOT NULL default '', `border_style` varchar(11) NOT NULL default '', `border_color` varchar(11) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM;
[PHP: 4.4.1-pl1] Ustawienia zgodne z wymaganiami instalatora.
joomla 1.0.8 pl utf
Instalacja com_artbanner i komunikat jak niżej co może być przyczyną.
Ryszard
Wczytaj component - Niepowodzenie Błąd SQL: DB function failed with error number 1067
Invalid default value for 'border_value' SQL=CREATE TABLE `jos_artbanners` ( `id` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `tid` int(11) NOT NULL default '0', `type` varchar(10) NOT NULL default 'banner', `name` varchar(50) NOT NULL default '', `imp_total` int(11) NOT NULL default '0', `imp_made` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `image_url` varchar(100) NOT NULL default '', `click_url` varchar(200) NOT NULL default '', `state` tinyint(1) NOT NULL default '0', `default` tinyint(1) NOT NULL default '0', `custom_banner_code` text, `last_show` datetime NOT NULL default '0000-00-00 00:00:00', `msec` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` tinyint(1) NOT NULL default '0', `reccurweekdays` varchar(100) NOT NULL default '', `access` int(11) NOT NULL default '0', `target` varchar(15) NOT NULL default '', `border_value` int(11) NOT NULL default '', `border_style` varchar(11) NOT NULL default '', `border_color` varchar(11) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL = CREATE TABLE `jos_artbanners` ( `id` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `tid` int(11) NOT NULL default '0', `type` varchar(10) NOT NULL default 'banner', `name` varchar(50) NOT NULL default '', `imp_total` int(11) NOT NULL default '0', `imp_made` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `image_url` varchar(100) NOT NULL default '', `click_url` varchar(200) NOT NULL default '', `state` tinyint(1) NOT NULL default '0', `default` tinyint(1) NOT NULL default '0', `custom_banner_code` text, `last_show` datetime NOT NULL default '0000-00-00 00:00:00', `msec` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` tinyint(1) NOT NULL default '0', `reccurweekdays` varchar(100) NOT NULL default '', `access` int(11) NOT NULL default '0', `target` varchar(15) NOT NULL default '', `border_value` int(11) NOT NULL default '', `border_style` varchar(11) NOT NULL default '', `border_color` varchar(11) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM;