commander wrote:

Hi
I was trying to copy something from a table in my mysql database to jos_comprofiler_fields_values but it overwrited to data already in that table and then by mistake i deleted the whole table. So i tried to make a new field and see if it builds the table but it doesn't also tried to load sample data and did database check but nothing worked.
SO please help me out and tell me what to do.
Thanks in advance

restore?

the table fields_values basically contains values used in select fields - so you need to manually recreate.

tedious task.

always take backup before playing with production database.

sounds like you should have never tampered with this to begin with ...

i assume you have cb 1.1 installed ...

if so you can look in the comprofiler.xml file for the create statements:

CREATE TABLE IF NOT EXISTS `#__comprofiler_field_values` (
`fieldvalueid` int(11) NOT NULL auto_increment,
`fieldid` int(11) NOT NULL default '0',
`fieldtitle` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`sys` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`fieldvalueid`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;

hope this will get you going - if not get professional help.