diff -r 0f128201a031 -r 8c4ba91adf58 www/import/from_brouwhulp.php --- a/www/import/from_brouwhulp.php Wed Nov 21 21:17:18 2018 +0100 +++ b/www/import/from_brouwhulp.php Thu Nov 22 22:27:42 2018 +0100 @@ -982,10 +982,13 @@ $psql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); $rsql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); - if ($recipe->NOTES) - $rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); - else - $rsql .= "', notes='"; + if ($recipe->NOTES) { + $rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); // Duplicate the notes + $psql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); + } else { + $rsql .= "', notes='"; + $psql .= "', notes='"; + } if ($recipe->TYPE) $rsql .= "', type='" . mysqli_real_escape_string($db, $recipe->TYPE); else @@ -1149,6 +1152,7 @@ if ($recipe->EQUIPMENT) { $psql .= "', eq_name='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NAME); + $psql .= "', eq_notes='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NOTES); $psql .= "', eq_boil_size='" . floatval($recipe->EQUIPMENT->BOIL_SIZE); $psql .= "', eq_batch_size='" . floatval($recipe->EQUIPMENT->BATCH_SIZE); $psql .= "', eq_tun_volume='" . floatval($recipe->EQUIPMENT->TUN_VOLUME);