Status field sql action doesn't work

What date you want to update? Article create date or expire date? Or value of the other field?

Hi sergey. I want to update other (custom) date field value!

FOr field value, this is not only place to alter. This place is used only for search and filter. For display fields column is used. I would try to run comething like this.

UPDATE #__js_res_record 
   SET fields = REPLACE(
        (SELECT v.field_value 
           FROM #__js_res_record_values AS v
          WHERE v.record_id = [RECORD_ID] 
            AND v.field_id = 77), 
        '2011-09-11 00:00:00', fields) 
 WHERE id = [RECORD_ID];

 UPDATE #__js_res_record_values 
    SET field_value="2011-09-11 00:00:00" 
  WHERE record_id = [RECORD_ID] 
    AND field_id = 77;

Something like this should work.Did not tested it as an idea only.

Maestro!

This gives me status of 500 (internal server error) on the console when I change status. And also delete record values when change status.

Any idea?

When you change status look into console network tab and see result of AJAX (XHR) request. Error have to be there. As I have said I have not tested it. It is only an idea. Try to run this query with AceSQL or PphMyAdmin.

Network tab says: No request captured

Did you try to run this query in aceSQL?

Do you have any errors in console?

I tried with phpMyAdmin. The query runs but reset all fields to empty. This date field is empty when change status maybe this cause the problem!?

Did you change [RECORD_ID] to ID of the record?

Yes, of course. I changed it.

I found one error in REPLACE. fields have to be first parameter. I tested also localy it is working.

REPLACE(fields, (SELECT v.field_value 
       FROM #__js_res_record_values AS v
      WHERE v.record_id = [RECORD_ID] 
        AND v.field_id = 77), 
    '2011-09-11 00:00:00')

Ok, now the value is updated in database but I get this error message (see below) on list view. The status doesn't change only after page refresh.

Can you click on console tab and than on ajax link and you can see what server answer, maybe you must turn display errors on.

Hi Konstantin!

Do you think this ajax link: http://ugyvitel.kalilab.hu/index.php?option=com_cobalt& ;task=ajax.field_call&tmpl=component

If I click on this I get this:

0 - SQL =

This site is not searchable 'for the following reasons:

Date bookmark / favorite The search engine obsolete data from this site mistyped URL You do not have permission to access this page The requested resource was not found. The error occurred while processing your request. Please try one of the following sites:

Home Page If difficulties persist, please contact your site administrator and report the following error ..

SQL =

Where to turn on display errors?

danielbidala http://ugyvitel.kalilab.hu/index.php?option=com_cobalt& ;task=ajax.field_call&tmpl=component

Yes, this is ajax url.

danielbidala 0 - SQL =

This mena that you have some errors in sql query, check it.

danielbidala Where to turn on display errors?

In global Joomla configuration. Turn on debug mode and Error reporting.