Database Error 1364 Field 'narrative'

[TimSchofield]

Your fix works, but to fix the sql the query at Line 213 should be:

$SQL = "INSERT INTO stockmoves (stockid,
type,
transno,
loccode,
trandate,
userid,
prd,
reference,
qty,
newqoh,
standardcost,
narrative)
VALUES ('" . $_SESSION['Adjustment' . $identifier]->StockID . "',
17,
'" . $AdjustmentNumber . "',
'" . $_SESSION['Adjustment' . $identifier]->StockLocation . "',
'" . $SQLAdjustmentDate . "',
'" . $_SESSION['UserID'] . "',
'" . $PeriodNo . "',
'" . $_SESSION['Adjustment' . $identifier]->Narrative ."',
'" . $_SESSION['Adjustment' . $identifier]->Quantity . "',
'" . ($QtyOnHandPrior + $_SESSION['Adjustment' . $identifier]->Quantity) . "',
'" . $_SESSION['Adjustment' . $identifier]->StandardCost . "',
'')";

This is caused by the sql_mode issue I mentioned in answer to your other post.

Tim