Irin Posted November 8, 2015 Share Posted November 8, 2015 I'm getting the following email from /admin/database_optimizer_cron.php: X-Powered-By: PHP/5.5.29 Content-type: text/html <font color="#000000"><strong>1146 - Table 'shop.TABLE_USER_TRACKING' doesn't exist<br /><br />delete from TABLE_USER_TRACKING where time_entry > 259200<br /><br /><small><font color="#ff0000">[TEP STOP]</font></small><br /><br /></strong></font> Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted November 8, 2015 Author Share Posted November 8, 2015 It looks like you told it to clear the User Tracking tables but you don't have User Tracking enabled or, at least, not installed correctly. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Irin Posted December 27, 2015 Share Posted December 27, 2015 Yes, you're right, I don't have the User Tracking table. Is "User Tracking" module comes with osc by default or it's a separate contribution? If I don't have this contribution installed, how can I disable the module from trying to clear that table? Â Thank you! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 28, 2015 Author Share Posted December 28, 2015 Set the user tracking setting to blank. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 30, 2015 Author Share Posted December 30, 2015 A new version has been uploaded with these changes: Added option to remove orphan address book entries. Changed code to show tables command to remove error for some servers (found by member Irin). Changed code in database_cron.php to load in the general functions. Changed how database changes are made to make installation and updating easier. Removed redundant jquery statements. Simplified the installation procedure. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
mr_absinthe Posted January 6, 2016 Share Posted January 6, 2016 Hi Jack, I see this at the top of admin/database_optimizer.php TEXT_VERSION_CHECK_UPDATES_UNRELEASEDDatabase Optimizer V 1.5 is the latest version Quote Absinthe Original Liquor Store Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 6, 2016 Author Share Posted January 6, 2016 The version checker was changed to allow better checking of the versions and I forgot to include those changed files in the package. I will get that done soon. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Alex_Pavlov Posted October 25, 2016 Share Posted October 25, 2016 (edited) Hello, Can I use Database Optimizer V 1.5 if version php 5.3.3? Edited October 25, 2016 by Alex_Pavlov Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted October 25, 2016 Author Share Posted October 25, 2016 @@Alex_Pavlov Yes. Alex_Pavlov 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 15, 2017 Author Share Posted January 15, 2017 A new version has been uploaded with these changes:  Added an option to removed products that are not in the products_to_categories table. Added an option to clear the SuperTraker table. Added an option to delete orders when customers are deleted. Added a checkbox to allow checking all options with one click. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
ecommunlimited Posted January 17, 2017 Share Posted January 17, 2017 @@Jack_mcs  From the new package, when I tick the box for Remove Orphan Products, I get this error:  1054 - Unknown column 'orphan_products_last_update' in 'field list'update database_optimizer set orphan_products_last_update = now()[TEP STOP]  The "orphan_products_last_update" needs to be added to the database_optimizer table. All of the others work fine.  Take care Bill Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 17, 2017 Author Share Posted January 17, 2017 If this is an update from a previous version, did you use the reset option as mentioned in the update file? If it is a new install, did you go to admin->Tools->Database Optimizer? Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
ecommunlimited Posted January 17, 2017 Share Posted January 17, 2017 @@Jack_mcs  It's my bad, I was updating and didn't use the reset option. All is good now.  Take care Bill Quote Link to comment Share on other sites More sharing options...
vmn Posted February 7, 2017 Share Posted February 7, 2017 TEXT_VERSION_CHECK_UPDATES_UNRELEASED still missing. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 7, 2017 Author Share Posted February 7, 2017 @@vmn That is an error due to the Version Checker addon not being installed or not having the definition, if it is installed. I thought I had updated that but I see I didn't. I have done so now so if you install the latest version of Version Checker (it is just an upload to install) then the problem will be fixed. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
bigbob2 Posted February 26, 2017 Share Posted February 26, 2017 Great addon, but am I missing something? Â In the latest version, the instructions say you can go to admin->configuration->database optimizer, but that entry does not seem to be there. Â I have read over the install instructions again and I can't find where that entry was coded. Â I had very little sleep last night, so I might just be being stupid though :) Â Thanks Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 26, 2017 Author Share Posted February 26, 2017 Visit admin->Tools->Database Optimizer and the database changes will be made. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
bigbob2 Posted February 26, 2017 Share Posted February 26, 2017 Visit admin->Tools->Database Optimizer and the database changes will be made. Thanks Jack, Â I have that part, but it looked like there was supposed to be a configuration page where the items in red could be configured? Â Thanks. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 27, 2017 Author Share Posted February 27, 2017 When you visit that page, the database is checked to see if the changes have been made. If not, it adds them. So you should see the settings in admin->Configuration->Database Optimizer, or maybe some other location if you are using a template that changes the default method. If you still don't see the settings, go back to that page and change the url to include ?reset and that will force a reload. So the url would be something like ...com/admin/database_optimizer.php?reset Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Cary Posted May 10, 2017 Share Posted May 10, 2017 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 11, 2017 Author Share Posted May 11, 2017 @@Cary I can't think of a reason why the items are not being deleted. If you run it manually in the admin->Tools, do you see a message that says, "Customers (old) tables were trimmed."? Also, if the "Optimize Database Period" option isn't set to 1, try that. I don't think it will cause this problem but it can cause some updates not to be seen.  Thank you for posting the mistake. It is a silly typo that would have been difficult to see. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Cary Posted May 11, 2017 Share Posted May 11, 2017 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 12, 2017 Author Share Posted May 12, 2017 Those orders would probably be considered orphaned at this point. The code will delete orders that are attached to a customer that is being deleted. But if the customer for those orders doesn't exist, they won't get deleted. Take a look at one of the orders in admin, copy the email address or last name (something unique) and then go to the customers section and search for it. If it doesn't show a customer then that is what the problem is. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
NateNg Posted June 2, 2017 Share Posted June 2, 2017 Hi, I just updated from Database Optimizer V 1.4 to Database Optimizer V 1.6 . Now I'm getting the following email from /admin/database_optimizer_cron.php:  Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /public_html/admin/includes/functions/database.php on line 53 SHOW TABLES LIKE 'supertracker' Please help. Thank you, Nate Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 2, 2017 Author Share Posted June 2, 2017 Addresses are stored in the address_book table and the only time this addon deletes entries from it is when the customer is deleted. So I don't see how the problem you describe could cause it. As for what it does, the explanation of each option is in the Instructions popup. I don't know how to better explain what it does than what is there. But if something isn't clear, please post it here so I can address it. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.