I needed to create a new field for each node in my website that would have as its value a concat of two existing fields.
I firstly inserted the new rows in the newly created field table, and then updated each of the rows with he corresponding information. But when I check on the browser in the edit page of several nodes some of them have the correct value inside the field while others have that field blank. The strange part is that there is no apparent difference in the database between the nodes with a value in the field and those that have it blank.
After investigating the issue I copied all the table to its correspondent revision table, leaving revision_id as 0. This didn't solve the problem.
I know I'm not supposed to directly modify the database like this but it has half-worked and I was wondering if there's a way to execute a method or a module so all nodes will have their field filled, or if I should erase all contents of the table and use db_update() or node_save() to do the job.
thanks in advance