1054 - Unknown column 'value' in 'field list'

[adidaxx]

Hi to all,

 

thats is my error:

1054 - Unknown column 'value' in 'field list'

update address_book set customers_id = '2', fields_id = '1', value = '1781125290091' where customers_id = '2' and address_book_id = '2'

[TEP STOP]

 

and this is the sql code what start this error:

 

CREATE TABLE customers_to_extra_fields (
 customers_id int(11) NOT NULL default '0',
 fields_id int(11) NOT NULL default '0',
 `value` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE extra_fields (
 fields_id int(11) NOT NULL auto_increment,
 fields_input_type int(11) NOT NULL default '0',
 fields_input_value text NOT NULL,
 fields_status tinyint(2) NOT NULL default '0',
 fields_required_status tinyint(2) NOT NULL default '0',
 fields_size int(5) NOT NULL default '0',
 fields_required_email tinyint(2) NOT NULL default '0',
 PRIMARY KEY  (fields_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


CREATE TABLE extra_fields_info (
 fields_id int(11) NOT NULL default '0',
 languages_id int(11) NOT NULL default '0',
 fields_name varchar(32) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

- its about extra fields to customers details, and i put frist field and firest error

- thx for all how lock to this and give a solution;

[adidaxx]

i just add the field "value" in address_book in database, and the error not come, but i don't noe if that the answer...