Latest News: (loading..)

Cary

Members
  • Content count

    2
  • Joined

  • Last visited

About Cary

Profile Information

  • Real Name
    Cary
  1. Jack, I have the "Optimize Database Period" and "Analyze Database Period" to "1". Checked ALL option and selected "update" and below was the response. Store database has been optimized. Customers tables were trimmed. Customers (old) tables were trimmed. Products Notifications table was cleaned. ( Removed 1 record: 0product: 1 ) Credit Card data was removed from the orders table. Orphan entries were removed from the address book table. Orphan entries were removed from the products table. Sessions table was trimmed. Database was analyzed. Database was optimized. Initial size was 114835995. Final, optimized, size is 114637174. Space Recovered: 194.16 KB So, I still have +42k orders from as far back as 2010. I feel like I'm missing something but "Customers (old) tables were trimmed" is shown. Let me know what you think when time permits. Thanks! Cary
  2. Hey Jack, Thanks for all your input and contributions to OSC over the years. Maybe I'm misunderstanding one of the features to remove old customers and old orders. But, none of my customers are being removed. In Configuration -> Database Optimizer, we have Truncate Customers Old set to 365 days and Truncate Customer Orders Opt B set but old customers and orders (from 2011) still remain. The other functions seem to run and we get an email "Database has been optimized" with a "Space Recovered: 34.82 MB" the first time. I found one error in the code admin/includes/modules/database_optimizer_common.php on line 41 "case 'Oot A': break; //delete customers and leave orders" where I believe it should read "case 'Opt A': break; //delete customers and leave orders" But correcting that made no change with the old orders after running the Optimizer again. Thoughts? Do you need more details to diagnose? - Thanks! Cary