Jump to content

Jack_mcs

Members
  • Content count

    30,723
  • Joined

  • Last visited

  • Days Won

    169

Everything posted by Jack_mcs

  1. Jack_mcs

    Incorrect datetime value

    If this just started happening then the host has probably upgraded the mysql version. But regardless, the easiest way to fix it is to run this command UPDATE customers SET customers_fob = '1970-01-02' WHERE customers_dob = '0000-00-00 00:00:00'
  2. Jack_mcs

    Help capturing data sent to Paypal

    @nemikeThere's no fix for the older paypal modules. You need to install the Paypal App. I can't guarantee that will fix it but it works in many, many shops so I think it probably will. To install it, you have to download the App from the addon site, install it and then update it in your admin. Then you have to replace the cert file with the most recent one.
  3. Jack_mcs

    Help capturing data sent to Paypal

    As I recall that was a problem with older paypal modules. If you are using the latest version of the Paypal App then you should install that first.
  4. It seems like every other question posted nowadays is about how to upgrade an older version of oscommerce and the op usually references the official version. This post is meant to provide a quick reference for how to convert an older shop to the current, recommended, one. First, the version that should be used is commonly called the Bootstrap, BS or Responsive version. It can be located here. One should not use the official version. The official version can be installed via the hosts control panel so it is easy to think that is the one to use - it is not. Since the BS version is not directly compatible with other versions, the following steps will be needed: Install the BS version into a new location Convert the database. See this thread for help with that. Install whatever addons the site needs. You need to be sure the addon will work with the BS version. This thread mentions specific ones but there are many others that will work. If in doubt, ask in the support thread for the addon in question. If you intend to use paypal, then install the Paypal App. At this point you should have a working shop. Test it thoroughly, especially the payment and shipping modules, before going live with it. When you are ready to go live, Mark your current shop as down for maintenance ( a simple index.html file is fine for this purpose ). Make a backup of the current shops database and files. Convert the database to the BS version. Replace all of the files with the new shops files. Edit the configure files so they work as the live shop. Remove the blocking page. If everything has gone correctly, the conversion should be complete.
  5. Jack_mcs

    Transfer 2.3 to 2.3.41 with fresh install

    Use a copy of the existing database as mentioned. Then empty the orders and sessions tables, and any others that might have data you don't want. Or, open the existing database in phpmyadmin, or whichever program you use, and export all tables for products and customers (remember to include the address_book table). Be sure to check the add drop table option. Then create a new database with the latest version and import the one you just created.
  6. Jack_mcs

    Transfer 2.3 to 2.3.41 with fresh install

    @aespinal2I don't reeal for sure but I think the database can be used as is. You may have to change the configuration tables, in the worst case. I would try just making a making a copy of the database and using it for the new one to see if that works. With that said, it would be a mistake to update to that version if you have a lot of addons to install and appearance changes to make. There are two versions by members here that have made improvements to that shop. I don't know how well they work and they may not be free but you might want to check them first. Here's one of them.
  7. Jack_mcs

    Add "Keep me logged in" on login page

    See if there is a tep_session_destroy call in your code, probably application_top. It might be deleting the session before seeing your code change.
  8. Jack_mcs

    Add "Keep me logged in" on login page

    @PsytaniumYoumay want to look at my Auto Logon addon. It is quite old and may not work for your shops version but it would solve your problem, I think.
  9. Jack_mcs

    Add "Keep me logged in" on login page

    It deletes all sessions that are over X days old. The number of days is in the settings. If you have the setting too low it might delete active sessions, depending on the timeout the shops code is set to. The default number of days for sessions is 14 days.
  10. Jack_mcs

    Add "Keep me logged in" on login page

    There is code to delete sessions but not for when it expires, as I recall. The session is deleted for certain actions, like when a paypal order complete or the SID changes due to the recreate setting in admin. But they are not deleted based on age which is why the table needs to have old entries removed occasionally.
  11. Jack_mcs

    PayPal App with osCommerce 2.2-MS2

    The capital letters in the left column (last entry) indicate the addon isn't installed correctly. Be sure you made the change to the admin application_top file and that you used the correct code (it's different than the code for the shop side). Also make sure you have uploaded all of the files into the includes/hooks/admin/ directory (shop side).
  12. Yes, I did. But it looks like I didn't include the changed file in the latest upload. Please try the attached file and let me know how it goes. seo.class.php
  13. @zeeshopDue to how updates are done in Phoenix, it might be that there isn't a version of this addon that will work in your version. I tested up to 1.0.7.6 and in 1.0.8.5 but not the ones in-between. But for any working version, when you click uninstall in admin, the settings won't show up again until you reload the shop side. I assume you checked for the settings after loading the shop side but thought I should mention it just in case. And, usually, you can safely replace the seo.class.php file with one from a different version for a quick test. You you may want to upload the files in one of the other Phoenix directories to see if that helps.
  14. Yes, you can use str_replace instead of preg_replace in some situations. But, as mentioned, there is usually other places in the code that need auch changes and those may not be so simple.
  15. You can ask them to but it is unlikely they will, assuming this is a shared server. The popular control panels have removed older php versions and many hosts don't have the setup to add them back in, or won't even if they do. Perhaps yours is different.
  16. I suggest that you first go into admin->Configuration->SEO URLs and turn that addon off. Then reload your shop to make sure it works. If it works, then the only problem is in the Ultimate SEO addon and you can update that to a later version by just uploading a file. If you still get the failures then spending time on the addon won't get you anywhere. You will need to fix those problems first. Normally when a shop has an ereg function in it, there will be many more scattered throughout the code and they will all need to be fixed.
  17. Jack_mcs

    Auto Update Currencies

    If that is really what is being used then you need to change "username", assuming that is not the real username.
  18. If your shop offers more than one currency, you need this contribution. With excahnge rates changing daily, at times, it is important to keep them up-to-date. Many, if not most, shop owners are not aware that this needs to be done. This contribution can be ran as a cron job or semi-automatically and will handle the updates for you. The existing Update Currencies contribution uses an external site that has changed their policy which means the updates may not always work. It also uses code that will prevent cron jobs from working on all servers. This contribution uses changed code and the same sites that oscommerce has always used so those problems should not occur. Jack
  19. Jack_mcs

    Admin Links Stop

    A shop from 2009 won't work with php 7.4. But there must have been changes made to the shop side since you said that was working. Many host's are removing php version before 7.2 and will automatically set the version to 7.4. That is probably what happened in your case. You can ask them if they will switch the account back to something lower but I doubt they will. If they will, the shop may work with php 5.6. I can only guess without seeing the files. You may need to revert to 5.3 to have it work. If your host won't switch you back, then you will either need to upgrade the shop so it works under 7.4 or switch hosts. You host may tell you that they can't switch you back but that they can move you to a dedicated server. While that would work, it would mostly like be very costly so I wouldn't recommend it.
  20. Jack_mcs

    Admin Links Stop

    @pilonIt is most likely due to your host upgrading the php version. I suggest you check with them to see if they did that. If they did, you can ask them to revert the change, though they probably won't, or you will either need to update your shop to work with the new version or move to a host that is able to run the php version you need. If it isn't the php version, see if there is a file named error_log in the admin directory. If there is, it might indicate the problem you are having. If you don't know how to find or understand that log, you can ask your host to see if they will tell you why it is failing. Some will - some won't. You can also post the last 10 or so lines of the file here so someone can check it for you. All of the above assumes there have not been any changes to the admin. It sounds that way from your post but if someone was working in the admins files, then that would be the first place to look.
  21. A new version has been uploaded with these changes. Tested through Phoenix 1.0.8.6 and php 8. Added version for Phoenix .0.8.0 and above. Changed code for php 7.4 warnings. Fixed mistake with the uninstall code. Replaced HTTP/1.x protocol checks with $_SERVER['SERVER_PROTOCOL'].
  22. You shouldn't pass the full url. You should use the tep_href_link function and only provide the filename and the parameter you want to use. There is the tep_get_all_get_params function that allows you to exclude things like the session ID if it is getting picked up from the page. The session ID should only show up on the first page although, as I recall, on very old shops it would stick around for other pages. In that case, installing the Ultimate SEO url rewriter will fix that.
  23. Jack_mcs

    [Addon] Store Times BS

    You asked what the code meant, which is what I answered. If the file is missing, that is an issue with the addon. I can't help with that. But some addons get uploaded as partial changes so if there is an earlier version you may want to check it to see if the file is there. If not, maybe someone else knows the answer. If this addon is no longer supported or you can't find the answer, you might want to look at the Store Mode addon.
  24. Jack_mcs

    PayPal App with osCommerce 2.2-MS2

    @bholiandYes, it will work fine in that version. Just be sure to follow the installation instructions closely.
  25. Hi @valquiria23Yes, that is valid code. However, it should not be needed. Please check your language file, like english.php, to make sure there is a statement to define CHARSET. If there is and if it is blank change it to have UTF-8, like this define('CHARSET', 'utf-8'); It it is already there, check your includes/application_top.php file, if this is for a pre-Phoenix shop, and make sure the code to include this addon comes after the code to load the languages. If both of the above are correct, then it would require troubleshooting to find the cause. The change you mentionrf should work but if your site uses accented characters be sure they are handled correctly by this addon.
×