i have native php project working on hostgator reseller account but there was problem with mysql time stamps i tried to change it but not work so i decided to move it to anther server (AWS with wHM installed) the project works fine select update delete but the insert command not working !!! why ? i haven't no idea here is the hostgator project database server
hostgator database server (works fine)
this is the new server
aws database server works fine except insert command
here is snap from the query
$sql="START TRANSACTION;";
$sql .= "INSERT INTO areas (name,add_user)
VALUES ('" . $name . "','" . $_SESSION['user_id'] . "');";
$sql .="INSERT INTO logsystem (log, add_user)
VALUES ('اضافة منطقة جديدة : ".$name."','".$_SESSION['user_id']."');";
$sql .="COMMIT;";
if ($conw->multi_query($sql) === TRUE) {
$message = '
<div class="alert alert-success">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong>تم اضافة المنطقة بنجاح </strong>
</div>
';
} else {
echo "Error: " . $sql . "<br>" . $conw->error;
}