Jump to content
Our Partners

All Activity

This stream auto-updates     

  1. Today
  2. Bullylette Bullylette joined the community
  3. Yesterday
  4. grylliolus grylliolus joined the community
  5. michel_herrera michel_herrera joined the community
  6. PrairieWoodSprite PrairieWoodSprite joined the community
  7. Thomas789 started following Any experiences with Hostiso hosting company? and MySQL connection issue when using custom domain
  8. Thomas789

    MySQL connection issue when using custom domain

    Thomas789 replied to vilmarci's topic in General Support

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

    Automatically send data feed to Froogle

    Jack_mcs replied to gottaloveit's topic in General Support

    A new version has been uploaded with these changes: Added a localfeed option. Corrected code for php warnings.
  10. 0912587x 0912587x joined the community
  11. Thomas789
    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.
  12. olafhackbarth olafhackbarth joined the community
  13. Dradityapradhan Dradityapradhan joined the community
  14. bajrasinghasari bajrasinghasari joined the community
  15. ruden

    Install OsCommerce 2.3.4.1 new installation

    ruden replied to businesspromotion's topic in General Support

    @businesspromotion Install v2.3.5 https://github.com/ruden/vanilla-oscommerce
  16. Drvimaldassi Drvimaldassi joined the community
  17. walkaroo walkaroo joined the community
  18. needs_a_nap started following osCommerce v4 demo
  19. needs_a_nap

    osCommerce v4 demo

    needs_a_nap replied to osCommerce-Official's topic in General Support

    Sorry I missed a demo! Posting this reply solely for the purpose of getting notified if it happens again Violet
  20. Last week
  21.    Smoky Barnable reacted to a post in a topic: placing site from local host to real host problems
  22. everafterentertainment everafterentertainment changed their profile photo
  23. whodah started following Google reCAPTCHA v3
  24. Jack_mcs
    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/');
  25. Hotclutch

    placing site from local host to real host problems

    Hotclutch replied to sandrasp's topic in General Support

    Which version of PHP are you using ? You can check this in Admin -> Tools -> Server Info
  26. sandrasp
    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
  27. Hotclutch

    placing site from local host to real host problems

    Hotclutch replied to sandrasp's topic in General Support

    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:
  28. sandrasp
    that is the way i tried it.
  29. Hotclutch

    placing site from local host to real host problems

    Hotclutch replied to sandrasp's topic in General Support

    And this: define('HTTPS_SERVER', 'https://www.xxxx.com');
  30. Hotclutch

    placing site from local host to real host problems

    Hotclutch replied to sandrasp's topic in General Support

    Try with this also: define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', '');
  31. sandrasp
    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.
  32. Hotclutch

    placing site from local host to real host problems

    Hotclutch replied to sandrasp's topic in General Support

    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/');
  33. sandrasp
    I'll try....but before that... doesn't it have to have a slash behind the "shop"? like this: '/shop/'
  34. Hotclutch

    placing site from local host to real host problems

    Hotclutch replied to sandrasp's topic in General Support

    Try define('HTTP_COOKIE_PATH', '/shop'); define('HTTPS_COOKIE_PATH', '/shop');
  35.    sandrasp reacted to a post in a topic: placing site from local host to real host problems
  36. sandrasp
    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 😉
  37. HeadsetsOnly

    Headsets only offer amazing headsets, offering amazing discounts. You can buy online branded headsets of GN NETCOM headset, JABRA, AVAYA, etc.

    slide1.jpg

  38. HeadsetsOnly HeadsetsOnly changed their profile photo
  39. vilmarci started following MySQL connection issue when using custom domain
  40. vilmarci
    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?
  41. oceanlee

    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. 

  42.    puddlec reacted to a post in a topic: placing site from local host to real host problems
  43.    puddlec reacted to a post in a topic: placing site from local host to real host problems
  44.    Mikepo reacted to a post in a topic: placing site from local host to real host problems
  45. 14steve14

    placing site from local host to real host problems

    14steve14 replied to sandrasp's topic in General Support

    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..
  46. ArtcoInc

    Install OsCommerce 2.3.4.1 new installation

    ArtcoInc replied to businesspromotion's topic in General Support

    @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
  47.    Smoky Barnable reacted to a post in a topic: placing site from local host to real host problems
  48. Hotclutch

    Install OsCommerce 2.3.4.1 new installation

    Hotclutch replied to businesspromotion's topic in General Support

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

    Install OsCommerce 2.3.4.1 new installation

    ArtcoInc replied to businesspromotion's topic in General Support

    @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
  50. businesspromotion

    Install OsCommerce 2.3.4.1 new installation

    businesspromotion replied to businesspromotion's topic in General Support

    7.3
  1. Load more activity
×