jos_comprofiler_fields_values deleted

13 years 11 months ago #43466 by commander
jos_comprofiler_fields_values deleted was created by commander
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

Please Log in to join the conversation.

13 years 11 months ago #43521 by commander
Replied by commander on topic Re:jos_comprofiler_fields_values deleted
Please some help me on this

Please Log in to join the conversation.

13 years 11 months ago #43522 by nant
Replied by nant on topic Re:jos_comprofiler_fields_values deleted
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.

Please Log in to join the conversation.

13 years 11 months ago #43524 by commander
Replied by commander on topic Re:jos_comprofiler_fields_values deleted
can you tell me how to make this table
i tried to make a new table with the same name then it asked me for field value but i didnt get to a result
I entered the table name and number of field to 2 then i got this screen



Thanks alot nant for replying
i would be very gratefull if you could help me on this.

Post edited by: commander, at: 2007/08/20 17:29

Post edited by: commander, at: 2007/08/20 17:29

Post edited by: commander, at: 2007/08/20 17:30

Post edited by: commander, at: 2007/08/20 17:31

Please Log in to join the conversation.

13 years 11 months ago #43526 by nant
Replied by nant on topic Re:jos_comprofiler_fields_values deleted
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.

Please Log in to join the conversation.

13 years 11 months ago #43548 by commander
Replied by commander on topic Re:jos_comprofiler_fields_values deleted
tried it like u said but it didnt work so i just reinstalled cb and everything was ok
thanks anyways nant

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.457 seconds

Facebook Twitter LinkedIn