Jump to content
Latest News: (loading..)

paul90210

Members
  • Content count

    5
  • Joined

  • Last visited

  1. View Counter

    It looks like I spoke too soon... It's still doing the same thing... I'm going to dig into it a little more and post what I find. Thanks.
  2. View Counter

    Hi Jack. Thank you for replying. I cloned my site and db on a subdomain for testing. I converted all tables to UTF per your suggestion. I see now where in application_top.php where the optimize query was being made... To test I removed the if's around each query block so that it would optimize on every admin page reload. It seems to be working fine! So, I think conversion to UTF did the trick! Thank you Jack!
  3. View Counter

    Hello Jack, Thank you very much for all your hard work and this addon. I installed it on my osCommerce BS site and it seems to be working fine. However, every once in a while my site locks up (I think it occurs when using the View Counter pages on the admin side but I'm not 100%)... I tracked it down to a query that is being made which won't complete and locks up the entire site. Below is what my hosting gave me (I assume from an error file) with the database name removed. I tried to find where the query is in the code but I don't see it. I noticed in admin/database_tables.php that the View Counter tables don't optimize. Do you have any ideas on how to fix this? | 607836 | XXX | localhost | XXX | Query | 11596 | Waiting for table metadata lock | optimize table view_counter | 0.000 | | 607837 | XXX | localhost | XXX | Query | 11596 | Waiting for table level lock | optimize table view_counter | 0.000 |
  4. Which security addon(s) do you recommend?

    It looks like this add on might be the newest version of osC_sec... https://apps.oscommerce.com/xsPfM&osc-sec-5-1-4
  5. I'm ready to go live with our updated osCommerce Bootstrap Edge store but first want to make sure we're covered with regard to security. I've already done the basics (changed admin folder name, htaccess admin, changed file/folder permissions, google recaptcha, searched all code for unsanitized GET and POST, https entire site, etc) but I don't yet have anything to monitor bots, sql injection, etc. I know there are lots of security addons but I'm not sure which are up to date in 2017. As far as I can tell osC_Sec - osCommerce Security Addon (https://apps.oscommerce.com/bXCun) looks like a good choice. Is there one or two that are up to date which you would recommend for a new install? Thank you in advance for your help!
×