Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Jack_mcs

  1. If you can find the RC2 version of oscommerce, it has the MySQL commands to add all of the indexes, as I recall.
  2. Jack_mcs

    Header Tags SEO

    See this line in the lessthan file } elseif ($action == 'new_product_preview') {
  3. That's correct. But data skimmers will spend a lot of time on product pages because that is really what they are after.
  4. @moldbodyIt's important to understand that the shop with just one visitor on it won't cause such a problem. The problem is caused when there are many visitors (customers, search engines and hackers). If they all hit the site at one time then the problem is more likely to happen. When there are more connections, the number of MySQL calls increase and that is what your host is seeing. Hosts usually mistakenly see the problem as bad code. It could be partially due to bad code, especially in an older version of oscommerce. My guess is that your database is not using indexes and that will cause a big slowdown. Many hosts will suggest upgrading to a VPS or even a Dedicated server when something like this happens. That is almost never needed but it can solve (hide) the problem because the resource limits of the server are higher. So I don't think optimizing things will fix it. Doing so will help and may be enough to hide the problem, especially adding indexes, if needed. But as soon as the site gets busy it will probably happen again. And busy doesn't mean how many customer-type visitors are on the site. There are a lot of connections that are normally hidden from you in normal operation. A bad search bot can be on a site for hours just bouncing around from page to page and you would not see it. You can look at the accounts raw access log to see that but they are difficult to read if you haven't done so. You can also install View Counter. It will let you see what is actually going on and to block IP's that causing a problem. Its country blocking option can cut down the number of connections dramatically, depending upon your situation.
  5. Jack_mcs

    Database Optimizer

    @moldbodyIt depends on when it is failing. After installing, can you go to the optimizer page or do you get the message right away. If you can get to the page, does it fail when you try to run it from there> Or is it failing when you run a cron job? Also, please see my signature for a link to a page that explains what you should include when asking a question.
  6. Jack_mcs

    Database Optimizer

    This addon provides an easy method for keeping your database fit. All osCommerce shops require a MySQL database to function but little attention is ever given to it. Just ask yourself when was the last time you optimized your database? Unfortunately, this is a big mistake since MySQL is prone to developing problems. Some are fixed as the database runs but some are not and, over time, these grow and can severely effect your shops performance. This addon will automatically tune-up the database, speeding it up and correcting problems that many shop owners are not even aware of. Here are some of its features: Defragment the tables Optimize the keys Strip the customers tables of old data Strip the sessions table of old data Strip the user tracking table (if present) of old data Remove old credit card numbers
  7. Jack_mcs

    Header Tags SEO

    @DemitryThere is a section of code for the preview section that no longer exists since the preview was removed from CE. The code is still in the pre-2.3 file so you can get it from there. I think that will fix the problem
  8. Jack_mcs

    Fake accounts

    @OzaHoney Pot will stop the majority of them.
  9. Jack_mcs

    Google XML Sitemap SEO

  10. Jack_mcs

    Article Manager v1.0

    You shouldn't have had to delete the tables. Just selecting the reset option would have brought the database up to this version. It's too late now but others may need to know this. Also, the line to change is 21. Line 13 is the class name and needs to stay as it is. Thanks for reporting this mistake.
  11. Jack_mcs

    Database Optimizer

    Yes, it should be changed.
  12. Jack_mcs

    where can i go to learn

    This is the version you should be using.
  13. Jack_mcs

    OSC Error Handler

    This addon prevents mysql errors from being displayed on the site. This is important because hackers will deliberately enter an invalid url to cause a failure, which they use to decide how best to attack it. It is compatible with all versions of oscommerce and only requires one file change to install.
  14. Jack_mcs

    Paypal Fees

    This addon will record the fees that Paypal charges and display them on the orders edit page.
  15. Jack_mcs

    Grouped Reviews

    This addon changes the reviews page to list the reviews grouped by manufacturers. This will only work with versions 2.3.4 and above. A screenshot is included.
  16. Jack_mcs

    Article Manager v1.0

    One of the things left out of the last version was the article reviews code. Mainly because I ran out of time but also because I question if it is ever used. I would be interested to hear what others think of that option. Should there be a way for customers to post reviews for articles?
  17. It looks like you mixed step 4 and 5. Please take another look at the instructions.
  18. Jack_mcs

    Article Manager v1.0

    A new version has been uploaded with these changes: Compatible with php 7.2. Compatible with BS4. (see note below) Header Tags SEO no longer required. (see note below) Added code to automatically add the title and tags for an article to Page Control in Header Tags SEO (if HTS is installed). Added the date posted on the blog comments page. Added a link to the customers account on the blog comments page, if it exists. Added multi-select option to the Cross Sell page in admin. Added a module to display articles on the home page. Added a module to display articles on the product page. Added the article ID to the article listing page in admin. Added reply to blog in admin. Added IP tracking for blog articles. Added option to require approval for blog posts. Changed the articles infobox to use ssl, if set, to fix a non-secure warning. Changed the articles infobox to only display the articles section if articles exist for those sections. Changed the format of the article listing pages on the shop side. Changed the default setting for an article to non-blog. Changed all of the article listing to use the sort order setting. Fixed code to handle the filter database definition correctly. Reported by member @vmn. Fixed code for the listing description text to prevent problems when html is used. Reported by member @vmn. Fixed Cross Sell code to the blog page. Fixed Cross Sell code to display the images. Fixed article listing page to only show blog or non-blog articles. Fixed code in the articles box to correctly show upcoming articles. Fixed the layout problem in authors section of admin. Fixed coding mistakes on the topics page that caused incorrect links. Fixed coding mistakes on the articles page that caused incorrect links. Fixed coding mistakes in the articles infobox for upcoming article that caused incorrect links. Made many changes on the blog comment page in admin fixes and improvements. Replaced date code with jquery's datepicker. Reported by member @vmn. Replaced all uses of NONSSL with $request_type. Replaced the topics code in the articles infobox with standard oscommerce code. Removed preview from articles creation page. Removed preview code in admin blog comments. Removed unnecessary database code from the articles box. Removed extra files in the new directory for the CE version. Removed redundant functions used by the articles infobox. Removed all filename and table definitions so it now works in CE shops. Rewrote the new articles page to remove html codes. Rewrote the upcoming module to remove html codes. Notes: 1 - The changes in this update are only for the CE versions. The code for the CE version will probably work in 2.3.4 shops, though I haven't tested it, but not any version before that. There were far too many changes in this version to get them to work with the older versions. It can be done but will take a bit of time. 2 - I included the code for BS4 versions. This was not thoroughly tested but I don't think there are any problems in that version. 3 - The requirement to have Header Tags SEO installed has been removed. This was not thoroughly tested but I don't think there are any problems caused by it. You have to turn the option for Header Tags SEO off in the settings. Please note that if you don't have Header Tags SEO installed, you will not be able to set the title and meta tags from admin. You will need to figure out how to do that manually. Also, the Ultimate SEO url rewriter won't change the url's as expected. My sincere thanks to @FrediHis help in troubleshooting this saved weeks on the release date. It was invaluable since he pointed out things I probably would not have seen.
  19. Add the redirect above the redirects for this addon and let the code sort it out. redirect 301 /product-p-800.html https://www.site.com/product_info.php?products_id=900
  20. Jack_mcs

    Google XML Sitemap SEO

    In answer to your questions, there's no way to remove the index.php from the url short of editing the code for that special case. But the sitemap won't override the canonical - it's the other way around. So it doesn't matter that there is a link to index.php in the sitemap file. There will also be a link to it, maybe many, in the shop. It's a non-issue.
  21. Jack_mcs

    Upgrading to the latest version

    1 - It's difficult to say how to best approach this because it varies with the database. But, usually, I think just copying the customers, orders and address book tables is enough for most sites. The only differences in those tables are usually the collation, which can be fixed afterwards, and the index key. The key is important for speed. If the conversion script mentioned keeps that then it should work. 2 - The easiest way to be sure products are handled correctly, short of properly converting the database, is to install Easy Populate into both shops. Then download the products from the old shop and upload them to the new one. 3 - Correct. There are many programs on the web that will help with this. MySQL Workbench is free. I haven't used it in a long time but it used to work very well and I think it has probably improved since then. You may want to look at these, and others: MySQL Workbench https://www.mysql.com/products/workbench/ Compare two databases: https://adamspiers.org/computing/mysqldiff/
  22. Jack_mcs

    where can i go to learn

    The domain you mentioned doesn't appear to be valid so I can't comment on what is needed for it. But, in general, you can use this thread to switch to the latest version. Hosts use a third-party service to provide packages to install. That third-party can only include packages recognized by the owner of the package. Since @Harald Ponce de Leon has not done that with the Community Edition, they can't include. The one they include is a very old and should not be used.
  23. Jack_mcs

    Hack attempt - is there a way to prevent this?

    For the code I posted, use $keywords = preg_replace('/[^ \w-\'\"]/', '', $_GET['keywords']);
  24. Jack_mcs

    Hack attempt - is there a way to prevent this?

    @ArtcoIncThe r87 dot com is a site on godaddy. You could report it as a spammer and/or block its IP's. Although the whois for it lists quite a few similar names so I suspect this guy wouldn't be easily stopped. Limiting the search string probably won't make a difference since they can type directly into the url. Many times the hackers will enter some invalid command so that an error is displayed that gives them more details about the database. You can test your site here to see if that is the case. Also be sure that anything entered in the search does not show up on the page after the search. This doesn't occur with the CE version but might with older versions. If your search doesn't require any special characters, then I suggest you change this code in the advanced_search_result.php file if (isset($_GET['keywords'])) { $keywords = tep_db_prepare_input($_GET['keywords']); } to this if (isset($_GET['keywords'])) { $keywords = preg_replace('/[^\w]/', '', $_GET['keywords']); $keywords = tep_db_prepare_input($keywords); } That will remove everything from the search string other than letters and numbers.
  25. Jack_mcs

    HoneyPot Captcha

    The error is caused by a mistake in the changes for older shops that can't use modules. I don't have a V2.3.4 shop to test but I think it can use modules so you should not be using that code. But for those that have the problem, change the following. But note, if your shop uses the module, making this change will cause problems. insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Exclude IP\'s', 'MODULE_HEADER_TAGS_HONEYPOT_EXCLUDE_IPS', '', 'A comma-separated list of IP\'s that are not blocked by the create account checks.', '1', '108', now())"); to insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Exclude IP\'s', 'MODULE_HEADER_TAGS_HONEYPOT_EXCLUDE_IPS', '', 'A comma-separated list of IP\'s that are not blocked by the create account checks.', '1', '108', now());