Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Yesterday
  3. Thomas789

    MySQL connection issue when using custom domain

    Have you tried using define('DB_SERVER', '127.0.0.1:3306'); in includes/configure.php instead of localhost ?
  4. Jack_mcs

    Automatically send data feed to Froogle

    A new version has been uploaded with these changes: Added a localfeed option. Corrected code for php warnings.
  5. On the osCommerce website https://www.oscommerce.com/ hosting company Hostiso https://hostiso.com/ is prominently featured as one of the partners of osCommerce. Does anyone have first hand experience with them? Their company setup is slightly obscure: they claim the be based in Switzerland, but their company is actually a LLC registered in the US, and they seem to be using mostly Leaseweb servers in Germany (their own website is hosted in Germany as well). I can't find many conclusive recent reviews regarding their hosting though.
  6. ruden

    Install OsCommerce 2.3.4.1 new installation

    @businesspromotion Install v2.3.5 https://github.com/ruden/vanilla-oscommerce
  7. needs_a_nap

    osCommerce v4 demo

    Sorry I missed a demo! Posting this reply solely for the purpose of getting notified if it happens again Violet
  8. Last week
  9. There are a number of mistakes in both files. I don't know if they will fix your original problem but they do need to be changed. Here are the edited files: define('HTTP_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTPS_SERVER', 'https://www.sandraspetsparadise.nl'); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', 'www.sandraspetsparadise.nl'); define('HTTPS_COOKIE_DOMAIN', 'www.sandraspetsparadise.nl'); define('HTTP_COOKIE_PATH', '/shop/'); define('HTTPS_COOKIE_PATH', '/shop/'); define('DIR_WS_HTTP_CATALOG', '/shop/'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('HTTP_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTP_CATALOG_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTPS_CATALOG_SERVER', 'https://www.sandraspetsparadise.nl'); define('ENABLE_SSL_CATALOG', 'true'); define('DIR_FS_DOCUMENT_ROOT', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); define('DIR_WS_ADMIN', '/shop/admin/'); define('DIR_FS_ADMIN', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/admin/'); define('DIR_WS_CATALOG', '/shop/'); define('DIR_FS_CATALOG', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/'); define('DIR_WS_IMAGES', '/shop/images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
  10. Which version of PHP are you using ? You can check this in Admin -> Tools -> Server Info
  11. define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); define('HTTPS_SERVER', 'https://www.sandraspetsparadise.nl'); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/shop/'); define('HTTPS_COOKIE_PATH', '/shop/'); define('DIR_WS_HTTPS_ADMIN', '/shop/admin/'); this is the last i've tried...sadly, without the wanted result 😥 @Hotclutch, thanx for the tips and trying to figure this out wiht me.💐 Maybe someone else will have another idea
  12. Your HTTPS_SERVER definition is blank, that's the last thing i can think of trying. Fill it with your website URL and incl the https:
  13. that is the way i tried it.
  14. And this: define('HTTPS_SERVER', 'https://www.xxxx.com');
  15. Try with this also: define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', '');
  16. Well...i've tried both...with and without the extra /.... no difference on my website.. Still not able to create an account OR to ad a item in the shoppingcart.
  17. I just checked my settings on a test shop i have, and it's like this: define('HTTP_SERVER', 'https://www.xxxx.com'); define('HTTPS_SERVER', 'https://www.xxxx.com'); define('ENABLE_SSL', false); define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/shop/'); define('HTTPS_COOKIE_PATH', '/shop/');
  18. I'll try....but before that... doesn't it have to have a slash behind the "shop"? like this: '/shop/'
  19. Try define('HTTP_COOKIE_PATH', '/shop'); define('HTTPS_COOKIE_PATH', '/shop');
  20. so i understand out of the responses....the problems still should be somewhere in the config files. I will, thanks! SO...here are my config files: first the include/configure.php define('HTTP_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTPS_SERVER', ''); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', 'www.sandraspetsparadise.nl'); define('HTTPS_COOKIE_DOMAIN', 'www.sandraspetsparadise.nl'); define('HTTP_COOKIE_PATH', '/shop/'); define('HTTPS_COOKIE_PATH', '/shop/'); define('DIR_WS_HTTP_CATALOG', '/shop/'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); define('DIR_WS_IMAGES', '/shop/images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . '/shop/icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/shop/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); and seccond the admin/include/configure.php: define('HTTP_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTP_CATALOG_SERVER', 'https://www.sandraspetsparadise.nl'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'true'); define('DIR_FS_DOCUMENT_ROOT', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); define('DIR_WS_ADMIN', '/shop/admin/'); define('DIR_FS_ADMIN', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/admin/'); define('DIR_WS_CATALOG', '/shop/'); define('DIR_FS_CATALOG', '/var/www/vhosts/sandraspetsparadise.nl/httpdocs/shop/'); define('DIR_WS_IMAGES', '/shop/images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . '/shop/icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . '/shop/images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); define('HTTPS_SERVER', ''); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/'); define('HTTPS_COOKIE_PATH', '/'); define('DIR_WS_HTTPS_ADMIN', '/shop/admin/'); I'm not even going to react on this. You should have read the rest of this (my) topic....and you would have known the answer 😉
  21. Headsets only offer amazing headsets, offering amazing discounts. You can buy online branded headsets of GN NETCOM headset, JABRA, AVAYA, etc.

    slide1.jpg

  22. Dear Community, I have an instance of OsCommerce on a NAS that works fine as long as I use it locally with the LAN IP address. But, when I try to access it from outside, with a custom domain, I get the following error: Warning: mysqli_connect(): (HY000/1045): Access denied for user 'xxxxx@'localhost' (using password: YES) in /volume1/web/oscommerce/catalog/includes/functions/database.php on line 20 Unable to connect to database server! the whole chain looks like: my domain -> router -> NAS -> Web station (SSL) In the browser I can see that the connection to the website is successfully made, certificate is valid, browser happy, something goes wrong after. I tried to add the osc user permissions to log in from any host, but this didn't solve the issue. Anything else I can try?
  23. Hi Jack i am wondering if you can help or give me some advice. I saw your Header Tags Controller and wondered how difficult it would be for a person who knows nothing about OSCOMMERCE other than to get into the admin area to install it. What is involved?

    The site I am working on is an OS COMMERCE site so is a data based site which needs specific SEO and which you seem to be an expert on. The site has been in existence for over 20 years with no SEO done to it and then all of a sudden for no reason it started ranking our posts on the first page of Google often in the top spot or top 5. We could almost guarantee to rank your ad on the first page.

    Approximately 12-18 months ago our host upgraded his servers and our site was no longer compatible with his server and the site was no longer visible or hosted. About 3 months ago I found hosting company in the USA and we started to set up the site in the exact same format. At this time our SA host managed to get the site live once again but we could not access the admin section and after 10 days our rankings started coming back but not as strong as before. Our SA host then switched the domain across to TMD hosting and the site went live. We are now sitting with 2 identical websites ranking different pages but nowhere near as powerfull as the site was before it was taken down

    I am looking at trying to do some SEO to get our original rankings back but because of the data base configuration you cannot do a lot of the normal SEO you would do with a wordpress site. Most people i talk to confuse oscommerce with an ecommerce site. Please find links below to the 2 sites.

     ORIGINAL SITE           http://www.xpressmedia.co.za/

    SECONDARY SITE      http://xpressme.sg08.tmd.cloud/

    1. oceanlee

      oceanlee

      Also are there any tutorials where i can learn the basics of oscommerce

    2. Jack_mcs

      Jack_mcs

      Hi,

      Regarding the installation, from your description I would say it would not be possible for you to install Header Tags. It requires changes to the files. They are too difficult as changes go but do require some experience in editing the code.

      Installing the addon, now named Header Tags SEO, can help with ranking and usually will. But it is a tool and what you get out of it depends on how much you put into setting it up. In other words, if you install it and then walk away it will probably help with ranking. But if you spend time setting things up in it, the chances of it helping increase a great deal. 

      From what you described with your ranking and in looking at your site, I think installing it would help and suggest that you do so. We charge $90 to install it but there is a 10% discount available. Ordering from us has two advantages:

      1 - You get the most recent version of the addon. The version I have here has changes to it that are not in the released version. 

      2 - I offer guidance in its usage. The addon has many options and not setting them correctly can make a big difference in the results.

      Another option is to move to our hosting. If you did that, we would install the addon for free. The advantages of hosting with us is that we specialize in oscommerce. So the problems you mention regarding both of your hosts would not happen with us. We also offer free support to our members for questions on how to use or make changes to their sites. Very few, if any, other hosts do this. 

      As for tutorials, there are none that I know of. There is this page. I'm not sure what version your shops are from looking at them but they are either 2.2 or 2.3. The basic parts of them are the same so most of the files on that page should apply. Of course, if you hosted with us, we would answer the questions about its usage for you. :)

      I hope this answers all of your questions. Please let me know if you have any others. 

  24. That's fair enough. Point taken but until you have a working alternative to offer and is available for download from the same place as the old version, then there must be a way of stopping people using such an old version of the software that has not been updated in many years and really should not even be available for download from a responsible business. Any addons currently available for that early version are also very old and many have not been updated in the same number of years, and its also known that many are insecure, so they should, also not really be used. I also don't see you offering support for the older versions, but you are still allowing people to download and use it. Very strange but up to you. Thanks for your offer to have a look at V4 by the way. Should I feel the need to change my software and once you have a version released and proven to be working I will take a look..
  25. ArtcoInc

    Install OsCommerce 2.3.4.1 new installation

    @Hotclutch You are absolutely correct. I stand corrected. I ran into this exact problem when I was moving an old osC site from a server running PHP 5.x to a different server with PHP v7.x. However, as I now look back into my notes, it was NOT a PHP issue. Instead, the SQL setup on the new server was much more strict. The resolution was ... On my local WAMP server, after locating the file my.ini file, I had to edit the line that said "sql-mode= ... <blah, blah, blah> ....", and comment out the expression NO_ZERO_DATE. (I replicated the entire "sql-mode= " line below itself, commented out the first line (with a comment explaining what I did), and edited the copied line, removing the NO_ZERO_DATE expression.) @businesspromotion Is this on your local server, or a hosted server? Do you have access to edit the appropriate .ini file? If not, you may need to contact your host to resolve this for you. I apologize for the initial wild goose chase ... M
  26. Hotclutch

    Install OsCommerce 2.3.4.1 new installation

    1525 is a SQL error, not PHP. And the official last version of osCommerce does not throw such an error.
  27. ArtcoInc

    Install OsCommerce 2.3.4.1 new installation

    @businesspromotion v2.3.4.1 was written to run under PHP v5.x, and will give you problems when running under PHP v7.x. Can your host roll back to PHP v5.x? While you can modify v2.3.4.1 to run under v7.x, you will continually chase issues as PHP evolves, resulting in your own fork of oSC. M
  28. businesspromotion

    Install OsCommerce 2.3.4.1 new installation

    7.3
  1. Load more activity
×