diff -r db8ad1c2112b -r 0d7441b39d41 src/EditProduct.cpp --- a/src/EditProduct.cpp Mon Jan 23 17:23:10 2023 +0100 +++ b/src/EditProduct.cpp Tue Jan 24 15:57:13 2023 +0100 @@ -912,6 +912,19 @@ if (rc == QMessageBox::No) return; + /* + * First delete any pictures for this product. + */ + QSqlQuery query; + query.prepare("DELETE FROM products_pics WHERE uuid=:uuid"); + query.bindValue(":uuid", product->uuid); + query.exec(); + if (query.lastError().isValid()) { + qWarning() << "on_deleteButton_clicked()" << query.lastError(); + QMessageBox::warning(this, tr("Database error"), tr("MySQL error: %1\n%2\n%3") + .arg(query.lastError().nativeErrorCode()).arg(query.lastError().driverText()).arg(query.lastError().databaseText())); + } + DB_product::dele(this, this->recno); this->close();