Problem with CobaltApi::updateRecord()

What is 52 field type?

text

This code works for me perfectly

CobaltApi::updateRecord(821, [], [54 => 'wwwwwqw']);

Check all your parameters once more.

hmmm ... just tried CobaltApi::updateRecord(147854, [], [52 => 'new']);

i only receive the Notice: Undefined index: extime in /administrator/components/com_cobalt/tables/record.php on line 201 and no update of the field/record

Joomla 3.7.2, PHP 7.0.19, Cobalt 8.741

if i try to update a record where the field does not exist yet in js_res_record_values, nothing happens.

If i try to update a record, where the field exist already in js_res_record_values, it just duplicates the record with the original value.

I used CobaltApi::updateRecord(147858, [], [52 => 'new']);

It should not create 2 records in js_res_record_values and it does not rename it to "new".

I have to add unique index for this table for fields_id and record_id.

Unfortunately I cannot tell why it does not update record, until I reproduce it or get access to that instance.

Sergey I have to add unique index for this table for fields_id and record_id.

Same fields store multiple records per record_id with different value_index. The table should be fine. There seems just some bug in the update. With the new 8.742, the Notice about the extime index is gone but duplication of records still continues and it just duplicates the old value and does not take the new value.

After i checked the manual update of a record, I realized that Cobalt deletes all field rows in #__js_res_record_values of a particular record and rewrites them again on edit.

Now it is clear, that since the CobaltApi::updateRecord() uses the same code as CobaltApi::createRecord() it does not delete the existing rows before recreating them. To solve the double creation of rows a $table->clean($record->id,''); is missing in the code.

The other problem is that $values does not hold the updated values for the fields --> it always stores the original value and does not update the field.

Sergey Unfortunately I cannot tell why it does not update record, until I reproduce it or get access to that instance.

There are 2 problems why it is not working:

1) It does not update the record because the query is an "Insert" not an "Update".

Therefore it should first delete all record values, because they will be newly created with the $table->store_value($value, $key, $record, $field);

Before calling the _touchRecord() function it should delete like:

static public function updateRecord($redord_id, $data, $fields = array(), $categories = array(), $tags = array())
    {
        $record = JTable::getInstance('Record', 'CobaltTable');
        $record->load($redord_id);
        $record->bind($data);
        $data = $record->getProperties();

        $table  = JTable::getInstance('Record_values', 'CobaltTable');
        $table->clean($record->id,'');

        self::_touchRecord($data, $fields, $categories, $tags);
    }

2) Unfortunately the value to be updated is not part of the $table->store_value(), therfore it will never create a record_values with the updated value.

Added changes

Sackgesicht 2) Unfortunately the value to be updated is not part of the $table->store_value(), therfore it will never create a record_values with the updated value.

Cannot get this? What means "is not a part"?

on update it does not use the changed/updated values from $fields. It still uses the $Form_fields, which is the old not updated value.

Just try, if it updates the old record.

Did you change something in addition to the $table = JTable::getInstance('Record_values', 'CobaltTable'); $table->clean($record->id,'');

Any news on this topic?

Yes. I've revised this API and changed it. I also added touchRecord() method with detect if record exists or not and update it or create.

I'll upload updates later today.

Great. I will check and report back after downloading ...

I want to update only one field of the record. Now it updates the field what I want but all other field values are cleared. Is it normal?

And the previous entry for that field is not deleted from res_record_values table just a new one is created.

danielbidala I want to update only one field of the record. Now it updates the field what I want but all other field values are cleared. Is it normal?

And the previous entry for that field is not deleted from res_record_values table just a new one is created.

Should be fixed in next update.

Thanks for it in advance. Can you tell us when will it be available? I'm in a project with deadline. I'dont know if I wait for update or write SQL queries in my plugin.

I'll update new Cobalt today.