Not updating other records after server move
Posted: Wed Apr 02, 2025 11:09 am
I have a form pickhead with a subform pickitems. On as save I run the following:
this used to work and update pickhead, pickitems and stkbody, however now I have moved server it comes up with a gateway error and doesn't update stkbody. Php settings and verisons are the same, the only thing different is MariaDB has changed from 10.6.16 to 10.6.21 I have tried changing PHP-FPM settings as my host suggested. Anyone see this behaviour before?
Code: Select all
$sql = "UPDATE pickhead SET pickhead.status = 'INPROGRESS' WHERE pickhead_id = '#RECORD_ID#'";
nuRunQuery($sql);
$sql2 = "UPDATE pickitems INNER JOIN pickhead ON pickitems.pickhead_id = pickhead.pickhead_id SET pickitems.pick_date = pickhead.pick_date WHERE pickitems.pickhead_id = '#RECORD_ID#'";
nuRunQuery($sql2);
$sql3 = "UPDATE pickitems INNER JOIN pickhead ON pickitems.pickhead_id = pickhead.pickhead_id SET pickitems.pick_no = pickhead.pick_no WHERE pickitems.pickhead_id = '#RECORD_ID#'";
nuRunQuery($sql3);
$sql4 = "UPDATE pickitems INNER JOIN pickhead ON pickitems.pickhead_id = pickhead.pickhead_id SET pickitems.complete = pickhead.complete WHERE pickitems.pickhead_id = '#RECORD_ID#'";
nuRunQuery($sql4);
$sql5 = "UPDATE stkbody INNER JOIN pickitems ON stkbody.stkbody_id = pickitems.pstkbody_id SET stkbody.status = 'PICKED', stkbody.pick_date = pickitems.pick_date, stkbody.pick_no = pickitems.pick_no WHERE pickitems.pickhead_id = '#RECORD_ID#'";
nuRunQuery($sql5);
$sql7 = "UPDATE pickhead SET pickhead.status = 'OUT' WHERE pickhead_id = '#RECORD_ID#' AND pickhead.complete = 'COMPLETE'";
nuRunQuery($sql7);