My SQL tables contain deleted data

Both package_patterns and products tables in the ASTPP MYSQL DB have entries that were deleted.

So it seems even if you delete a “product/package” and any or all associated “destination” rates the entires still show up in the mySQL DB.

Would deleting these manually cause issues?

Hi @NickJ ,
Yes, it causes the issue while generating the invoices if the customer was postpaid.

Sorry but Im a little confused, I didnt assign the package to a user. They were not removed when the product was removed from the web interface.

If the product was not assigned to the user then you can delete it from the MySQL database.

1 Like