Redundant data in database after deleted in admin
Posted: Tue Aug 29, 2017 11:42 pm
Hi,
I'm developing a new site using Opencart which leverages on an earlier prototype - but both using 2.3.0.2. I copied the old site over to a new development installation on a new domain and deleted old orders, users etc from the system. Thinking this would also clear the relevant tables in the database I was surprised to see a number of tables still with historical data - particularly order, payment and customer related. However, this was not being reflected in admin which showed "all clear". I backed-up and cautiously truncated tables where I knew the information was redundant.
Is this "normal" behaviour of Opencart please as it seems a bit odd? I thought some of the redundant data was related to add-on modules, but some of it is certainly associated with the core installation.
Any thoughts on this (and management of it) appreciated.
Thanks
V
I'm developing a new site using Opencart which leverages on an earlier prototype - but both using 2.3.0.2. I copied the old site over to a new development installation on a new domain and deleted old orders, users etc from the system. Thinking this would also clear the relevant tables in the database I was surprised to see a number of tables still with historical data - particularly order, payment and customer related. However, this was not being reflected in admin which showed "all clear". I backed-up and cautiously truncated tables where I knew the information was redundant.
Is this "normal" behaviour of Opencart please as it seems a bit odd? I thought some of the redundant data was related to add-on modules, but some of it is certainly associated with the core installation.
Any thoughts on this (and management of it) appreciated.
Thanks
V