My SQL tables contain deleted data

General questions Reports
1

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?

2

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

3

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.

4

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

1 Like