[RESOLVED] #1067 - Invalid default value for 'html' at phpmyadmin

[hanpedro]

I have insterted this int database at phpmyadmin, but error.

#1067 - Invalid default value for 'html'

# drop table webhard_default_config;

create table webhard_default_config
(
field varchar(64) not null default '',
value_key varchar(64) not null default '',
html tinyint(1) unsigned not null, 
value text not null default '',
unique key field (field)
);

insert into webhard_default_config values ('share_mail_subject_header', '', '', '[testers]');
insert into webhard_default_config values ('share_expire_date', '', '', '7');
insert into webhard_default_config values ('share_expire_count', '', '', '7');
insert into webhard_default_config values ('share_expire_date_max', '', '', '7');
insert into webhard_default_config values ('share_expire_count_max', '', '', '7');
insert into webhard_default_config values ('file_name_disable_chars', '', '', '');
insert into webhard_default_config values ('smtp_host', '', '', 'localhost');
insert into webhard_default_config values ('smtp_port', '', '', '25');
insert into webhard_default_config values ('quota_account', '', '', '100');


# drop table webhard_user;

create table webhard_user (
no int(10) unsigned not null default '' auto_increment,
id varchar(32) not null default '',
auth_key varchar(128) not null default '',
pass varchar(128) not null default '',
name varchar(32) not null default '',
email varchar(255) not null default '',
quota int(10) not null default '',
last_login_date date not null default '',
last_login_time int(6) zerofill not null default '',
last_login_ip_addr varchar(15) not null default '',
reg_date date not null default '',
reg_time int(6) zerofill not null default '',
ip_addr varchar(15) not null default '',
primary key (no),
unique key id (id),
key auth_key (auth_key)
);


# drop table webhard_share_data;

create table webhard_share_data (
no int(10) unsigned not null default '' auto_increment,
share_id varchar(64) not null default '',
user_id varchar(32) not null default '',
to_email varchar(255) not null default '',
to_subject varchar(255) not null default '',
to_contents text not null default '',
expire_date date not null default '',
expire_count int(3) not null default '',
reg_date date not null default '',
reg_time int(6) zerofill not null default '',
ip_addr varchar(15) not null default '',
primary key (no),
unique key share_id (share_id),
key user_id (user_id)
);


# drop table webhard_share_data_sub;

create table webhard_share_data_sub (
no int(10) unsigned not null default '' auto_increment,
share_id varchar(64) not null default '',
user_id varchar(32) not null default '',
sub_no int(3) not null default '',
dir text not null default '',
file text not null default '',
expire_date date not null default '',
expire_count int(3) not null default '',
reg_date date not null default '',
reg_time int(6) zerofill not null default '',
ip_addr varchar(15) not null default '',
primary key (no),
key share_id (share_id)
);


# drop table webhard_backoffice_default_config;

create table webhard_backoffice_default_config
(
  field varchar(64) not null default '',
  value_key varchar(64) not null default '',
  html tinyint(1) unsigned not null, 
  value text not null default '',
  unique key field (field)
);


# drop table webhard_backoffice_user;

create table webhard_backoffice_user (
no int(10) unsigned not null default '' auto_increment,
id varchar(32) not null default '',
auth_key varchar(128) not null default '',
pass varchar(128) not null default '',
name varchar(32) not null default '',
level int(3) not null default '',
last_login_date date not null default '',
last_login_time int(6) zerofill not null default '',
last_login_ip_addr varchar(15) not null default '',
primary key (no),
unique key id (id),
key auth_key (auth_key)
);

insert into webhard_backoffice_user values ('', 'admin', '', password('shade'), 'Administrator', '', '', '', '');

Please make this no-error.

[Kudose]

You are trying to insert nothing into a TINYINT ( 1 ) NOT NULL

Change the third value on your insert into an integer.