Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Smoky Barnable

♥Ambassador
  • Posts

    184
  • Joined

  • Last visited

  • Days Won

    12

Reputation Activity

  1. Like
    Smoky Barnable reacted to Ben23 in jQuery/Ajax Advanced Statistics for osCommerce 2.3   
    Hi
    I've just installed this module (on a modified 2.3.4+Bootstrap Gold) and I have to say it's a fantastic piece of work. Easy to install, looks spiffy, loads of features, and significantly higher code quality than the majority of OSC modules! Thankyou so much for all the work that's gone into it.
     
    I have a couple of minor bugs to report.
     
    The first one is with the Customer filter, which fails with the following error in the Apache log:
    PHP Fatal error:  Call to undefined method mysqli_stmt::get_result() in /var/www/hht/hhtadmin/advanced_statistics/ajax_request.php on line 93
     
    Looking at the documentation for that function at http://php.net/manual/en/mysqli-stmt.get-result.php, it says it's only available with mysqlnd. Since you claim at the top of this thread that mysqlnd should not be required, does this need rewriting to use a different method? Or is mysqlnd essential for this to work? I'm using PHP 5.4.
     
    The second concerns the menubar. At the moment, only the leftmost icon (which keeps changing - presumably this is intentional but it makes it harder to describe to users what they should be looking for) has a decent tooltip describing what it does. The rightmost one (which is showing as an "unknown character" glyph on my system) also has a tooltip but it is needlessly tall and narrow: see attached screenshot. The other three icons are not showing tooltips at all, thus they have no explanation what they do.
    And one further suggestion: It took me a while to figure out how to close the filter sidebar (by clicking outside it), so how about adding a Close button inside it just to avoid any frustration.
     
    Thanks again for your excellent work.
     

  2. Sad
    Smoky Barnable reacted to simon5968 in Competitors module configuration   
    again, maybe you should not sell an app that don't work fully and then have the nerve to sell a second app of $59 so a total of $258 what a waste of money. this is about the 4th app now 
  3. Like
    Smoky Barnable reacted to Inna Tretyak in Enabling Development Mode: Safeguard Your Test Website   
    During the website development process, protecting your test site from prying eyes and accidental interactions is paramount. It's a common practice to shield test websites from search engine indexing and unintended customer activity. Explore the simple steps to activate Development Mode
  4. Like
    Smoky Barnable reacted to Mort-lemur in Automatically send data feed to Froogle   
    @Jack_mcs I have eventually found a solution that works, thanks to a post on stackoverflow where someone else could not run a .php file via cron. The solution that works for me is as follows: (probably a very messy solution)
    1. I moved the googlefeeder.php file to the root and commented out chdir('../');
    2. Created a file called googlefeeder_test.php in the root containing the following code:
    echo file_get_contents('https://mysite.co.uk/googlefeeder.php?noftp=1/'); 3. Set a cron job with the following code:
    php /home/myusername/public_html/googlefeeder_test.php This runs the googlefeeder.php code as a URL and updates the data-feed file without uploading to google, as google merchant center is set to retrieve this file once per day.
    This still has me puzzled though as I have no problem running googlesitemap as a cron but googlefeeder just would not run.
    Thank you for the help.
  5. Like
    Smoky Barnable got a reaction from Mort-lemur in Automatically send data feed to Froogle   
    Yes, as I previously mentioned in this thread creating a daily cron job and having the file fetched daily has been working great for me. No need to upload via FTP.
  6. Like
    Smoky Barnable reacted to Webitbz in Nginx setup for osc 4.12   
    To get osCommerce 4.12 running on my Windows 11 WSL Ubuntu 22.04 NGINX 1.18.0 PHP 8.2 system I did following:
    First installed osCommerce on the server (on a demo virtual domain).
    Added nginx.conf file to the root of the osCommerce installation (see attached nginx.conf file).
    Created empty access/error log files.
    Adjusted vhost configuration for my test domain (see attached vhost.conf file).
    I might be an idea to add this nginx.conf to the core osCommerce distribution for easy setup nginx users.
    nginx.conf vhost.conf
  7. Like
    Smoky Barnable reacted to herbsandhelpers in Fatal: Adding Components in menu breaks site   
    Just reporting this, I don’t need to use it.
    If in menu you try to move Components (under top three) into the menu right. Then a strange graphic occurs under Components and the site breaks. 
     
    I quickly shifted it back. Could be a bit nerve jangling for the unprepared and unexpected …
    Lorraine
  8. Thanks
    Smoky Barnable reacted to jessicana in Nginx configuration file   
    Below is a complete Nginx configuration file that should work for you with OsCommerce x4:
    server {     listen 80;     listen [::]:80;     set $yii_bootstrap "index.php";     root /var/www/example.com/html/;     access_log /var/www/example.com/logs/access.log;     error_log /var/www/example.com/logs/error.log;     # Add index.php to the list if you are using PHP     index index.html index.htm index.nginx-debian.html index.php;          index       $yii_bootstrap;     server_name example.com www.example.com;     client_max_body_size 50m;         charset utf-8;         location /furniture {         index $yii_bootstrap;         try_files $uri $uri/ /furniture/$yii_bootstrap?$args;         }     location /printshop {         index $yii_bootstrap;         try_files $uri $uri/ /printshop/$yii_bootstrap?$args;     }     location /admin {         index $yii_bootstrap;         try_files $uri $uri/ /admin/$yii_bootstrap?$args;     }     location /b2b-supermarket {         index $yii_bootstrap;         try_files $uri $uri/ /b2b-supermarket/$yii_bootstrap?$args;     }     location /watch {         index $yii_bootstrap;         try_files $uri $uri/ /watch/$yii_bootstrap?$args;     }     location / {         index $yii_bootstrap;         try_files $uri $uri/ /$yii_bootstrap?$args;     }     location ~ \.php$ {         if (!-f $request_filename) { return 404; }         include fastcgi_params;         fastcgi_pass unix:/var/run/php/php8.0-fpm.sock;         fastcgi_index $yii_bootstrap;         fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;         fastcgi_param REDIRECT_STATUS 200;     }     #location / {         # First attempt to serve request as file, then         # as directory, then fall back to displaying a 404.     #    try_files $uri $uri/ =404;     #}     # pass PHP scripts to FastCGI server     #     #location ~ \.php$ {     #    include snippets/fastcgi-php.conf;     #     #    # With php-fpm (or other unix sockets):     #    fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;     #    # With php-cgi (or other tcp sockets):     #    fastcgi_pass 127.0.0.1:9000;     #}     # deny access to .htaccess files, if Apache's document root     # concurs with nginx's one     #     location ~ /\.ht {         deny all;     } } Please change:
    1. example to your domain name.
    2. php8.0-fpm.sock to your PHP version. For example, if you use 8.2, change this to become:
    fastcgi_pass unix:/var/run/php/php8.2-fpm.sock;  
  9. Like
    Smoky Barnable reacted to pandrei in Why doesn't PHP 8.0 work?   
    The cause of the problem:
    1. The default PHP version for the host is 5.4
    2. When you select PHP version for your domain, the following code is adding to your root .htaccess
    # php -- BEGIN cPanel-generated handler, do not edit # Set the “ea-php80” package as the default “PHP” programming language. <IfModule mime_module> AddHandler application/x-httpd-ea-php80 .php .php8 .phtml </IfModule> # php -- END cPanel-generated handler, do not edit 3. When you start osCommerce installation it unpacks the osCommerce files and overwrites root .htaccess
    4. After unpacking, it redirects to the install folder for next step, but the root .htaccess has already been overwritten and PHP version has been reset to 5.4. A 500 error occurs here because the minimum PHP version for osCommerce v4 is 7.4
    Solution for now: after you get 500 error, go to PHP version selector in your Control Panel (it's called MultiPHP Manager in your case) and select PHP 8.0 again. If it is not work, you can add the PHP selector code to the end of the root .htaccess manually.
    Also we will add additional check for such case in the next osCommerce version.
    @InfoPulse, you can continue the installation, I've already reselect PHP 8.0 for your domain.
     
  10. Haha
    Smoky Barnable reacted to jimdanforth in Why doesn't PHP 8.0 work?   
    You have a nice life.  I hopenyou are able to find what you need.
  11. Like
    Smoky Barnable reacted to InfoPulse in Why doesn't PHP 8.0 work?   
    I'm not being nasty and I'm not complaining -- just pointing out the installer didn't work for me using PHP 8.0. And if it didn't work for me, it won't work for others. Could be just the installer that doesn't support 8.0 -- but if I or someone else doesn't post that there is a problem, how will it get fixed? I did quite a bit of searching in the Forum and elsewhere to see what the problem might be and couldn't find any answer -- why would you attack me for pointing out a problem? Are you trying to discourage people from pointing out problems? 
    I do see that eventually support and custom extensions will be offered for money -- which we will gladly pay for as we've been using osCommerce for more than 40 stores since 2004 and are hoping to move them to osCommerce 4 starting within the next couple of months or so. So we are anxious for this to work -- but not at the expense of being treated like we're a pest and nasty for pointing out a problem.
  12. Like
    Smoky Barnable reacted to pandrei in How To Add Link for Customer to Agree to Terms and Conditions before Checkout?   
    If the update contains a modified file, it will ask you to force the update before which you can choose to ignore the update of that file. However, keep in mind that ignoring the update will result in an out-of-sync version, which can lead to loss of functionality.
    The correct course of action in this case is:
    1) back up changed files
    2) forced update
    3) reapplying your changes
     
  13. Thanks
    Smoky Barnable reacted to VladMal in One more important news. Now oscommerce is fully integrated with PayPal (both versions 2.x and 4.x)   
    Here you may find whole details about oscommerce and PayPal integration:
    https://www.oscommerce.com/paypal-provider
     
    This topic answering to questions, such as : why PayPal api v2. Why upgrade to it. Why it free of charge for you. Etc.
     
    Enjoy!
  14. Like
    Smoky Barnable reacted to VladMal in Introducing the New osCommerce YouTube Channel: Unleash the Power of osCommerce with Tutorials, Modules, and More!   
    Exciting Announcement! 
    We are thrilled to introduce the brand new osCommerce YouTube channel, created exclusively for osCommerce enthusiasts like you!
    🌟 Discover our channel: osCommerce YouTube Channel
    Join us as we embark on a journey to explore the world of osCommerce and unlock its full potential. Our channel is dedicated to providing you with valuable tutorials, insightful module descriptions, and helpful setup assistance. 
    🎥 Featured Video: Latest PayPal API 2.0 for osCommerce 2.2 and 2.3! 🆕
    🔗 Watch the video here: PayPal API 2.0 for osCommerce
    In our first video, we dive into the exciting realm of the latest PayPal API 2.0 for older versions of osCommerce (2.2 and 2.3). Learn how to seamlessly integrate this powerful module into your osCommerce store. Stay tuned for step-by-step guidance and expert insights to enhance your PayPal integration. 
    📅 Upcoming Videos:
    Over the next two weeks, we have a lineup of videos related to this new PayPal integration that you won't want to miss! Stay connected with us to explore additional features, troubleshooting tips, and best practices. 
    🔔 Subscribe to our channel and hit the notification bell to stay updated on our latest releases! Don't forget to like, comment, and share your thoughts with our growing osCommerce community. 
    Let's embark on this osCommerce adventure together and make your online business thrive! See you on the channel! 
  15. Haha
    Smoky Barnable reacted to appshop-claus in google fonts GDPR user acceptance check   
    A couple of months ago a german court decided that website owners whose pages load google fonts without prior acceptance by the visitor offend against GDPR and must pay compensation for immaterial damage (yes, it's mad) if brought to court. This is because for the download process your IP address is transmitted to the US and in contrary to european laws state institutions there can use this IP in reverse to get personal data from european providers and hosters. Therefore users must be able to reject the font loading or the fonts have to be loaded locally from a european server.
    I examined the given osComm templates and found that google fonts are loaded en masse. So I thought "lets comment out the loading code" and arrange the loading from my server or lets use substitute-fonts by the system. I failed by doing so because I could not find any (header-) code responsible for it. My guess now is that it must be found in the database. Before I start screwing around in the database my question: has anybody already solved this issue and can provide a plan?
    The second question: can the osComm developers either provide a GDPR fitting tool to let the visitors decide whether they want google fonts or not or just renounce the use of those fonts?
    Thanx and regards
  16. Like
    Smoky Barnable reacted to Jack_mcs in View Counter   
    A new version has been uploaded with these changes:
    Free Version:
    Added missing countries and other variations to the countries list. Added the unique IP counts to the visitor count line in Monitor. Added a line to the header of Monitor to display the counts of banned logs. Added a clean tool in the Maintenance section to remove duplicate IP's; Added code to prevent an IP from being blocked if it is in the country blocking list. Changed delete customers code to also delete from View Counters customer table. Changed code in the shops .htaccess file to prevent looping on traps. Changed the code for blocking CIDR's to catch invalid entries. Changed the four input boxes on Monitor to clear when clicked into. Changed some tep_ calls to generic ones for better compatibility. Changed the size of the countries field in the block table to hold longer country names. Changed the code so a hacker check checks both bots and non-bots in admin. Changed the spoofing checker code to improve speed and accuracy. Changed the Clean Database tool to remove blocked IP's that are being blocked by country. Converted the admin to use a class instead of function. Corrected code mistake when checking existing customers. Made many changes to the Monitor GUI for easier use. Moved the code to clear the database tables to a cron job.Moved the Warning code to the hidden area, renamed it and populated with ajax to improve speed. PRO Version:
    Added a setting to control the rating returned from abuseipdb. Added a setting to block IP's that are spoofing. Added a link to add an IP to the abuseipdb table from the popup checker. Added a cron job to clean the database of duplicates. Added many entries to the hacker definition file Added tables to store known good google and Bing Ip's and the code to ignore them. Changed the log recording code to account for the source IP if Cloudflare is used. Changed the Danger warning to a link so the hacker IP can be seen with a click. Removed ads.txt from the hacker defines since google needs it for their scripts. Rewrote some of the IP checking code. Saved 15 seconds on a site with 12,000 daily visits. Notes:
    This version has moved the code that updates the database to a cron job. For busier sites, this greatly increases the speed of the code. So be sure to remove the code previously added to both application_top files or the hook for that if your shop uses hooks. This version now uses a class for most of the work in admin. The function file is now used to provide compatibility between the various versions of oscommerce. Just upload all of the new files to apply these changes. I discovered that the names for countries that IP2location uses in its database does not always match the actual country name. I have edited the country list used by View Counter to account for this.  So of the names are longer than the field the database uses. The database script will adjust this but you will need to check the selected blocked countries to make sure the ones you want to block are checked. For the Pro version, I haven't added a limit to the abuseipdb entries yet. I am still testing how it affects a sites speed. So far, we have over 115,000 entries in that table and it has not made any noticeable difference in speed. And it has resulted in over 1,400 blocked hits. In the last six months, or so, more than one person downloaded a list of all of the old addons and created a script to check for any of them on a site. Some old addons had serious security holes so if you have one installed, it could provide a way for hackers to get in. The pro version provides a way to check for this. For the free version, be sure to double check your isntallations. I have also noticed that hackers are, more and more, using multiple IP's for checking a site. This is meant to prevent shop owners from noticing an IP that is skimming data.  Some single IP's can hit a site several thousand times in a matter of hours. By using multiple IP's, the hits are spread out making it appear that the site is just busier but in a normal way. You can change the Skimmer setting in View Counter to catch such hits. Whether you use View Counter or not, you should use the changes that are in the extra directory for the .htaccess and robots file since they will help your shop. For the .htaccess file, copy its contents into yours (don't replace yours with it). for the robots file, be sure to change the first and last lines to reference your site. Works with all oscommerce versions through Phoenix 1.0.8.21.
  17. Like
    Smoky Barnable reacted to herbsandhelpers in Footer?   
    I think I've sussed it out! Just edit the inner widget ...
  18. Like
    Smoky Barnable reacted to mendoh in Thought the widget-based OSC4 Theme structure to be very user-friendly, now I am definitely changing my mind...   
    I thought the OSC4 Themes based on widgets to be very user-friendly. In actual facts and after fiddling more than a couple of days with simple widgets modifications (i.e.: adding, removing and customizing the existing widgets), I have to change my mind. 
    After adding a few new info pages and customizing a few widgets (all modifications have been brought to the WATCH theme), this is what I am sadly getting right now: 
    the original new products, sales feature products and featured products have all DISAPPEARED from home page and there is apparently no way to have them back, despite they are still present on the admin side; the pop-up preview layout I get from admin after bringing my changes is different (better) than the actual live front end layout: widgets that previously took no more than a couple of small units now extend to half the size of the whole page and a few category pictures get piled up one atop the other, thus completely destroying the homepage design (did not happen before); all the info pages I added have DISAPPEARED and there is apparently no way to have them back, despite they are still present on the admin side. All I am left with is their page link on the hompeage footer widget but...guess what!? Clicking on it delivers absolutely nothing! the original theme page links (i.e.: New products, Sales Feature and Featured Products) behave exactly as the pages I have added, that is: ALL DISAPPEARED; the original "Contact Us" page has gone as well! clicking on any of the original "For her", "For him", "For hall" product categories, as well as on any of the original "New products", "Feature Products" and "All products" tabs/links shows ABSOLUTELY NOTHING; the BACKUP feature on admin DOES NOT HELP AT ALL. Despite having at least 4 backups, I could not restore the original theme layout and let us not even mention the for-ever spinning balls that stay onscreen even when some sort of "back-up" has already been restored 😞 the only pages and related links that still appear to work are "login" and "account". The OSC4 manuals/help wiki do not help at all. 
    Mailed a post about how to reset/reimport the original themes, so that I could at least start again from scratch: absolutely no reply so far. 
    Tried to copy the original theme folders to server and overwrite the existing ones: absolutely no difference.
    I made only very small changes to the original WATCH theme/widgets and frankly speaking I could never imagine a similar "earthquake" to be able to happen literally out of the blue, while making those changes and leaving me with absolutely no plausible cause for that. 
    At this moment, very sad to say, I am looking at a full reinstall to clear away the above and undesirable mess, but that is not even worth to be called a "solution": just imagine such a mess happening on a running site with hundreds of products and you are left with ABOSUTELY NO CLUE for the originating cause. 
    Is there ANYBODY who just KNOWS EXACTLY what is going on with that? 
    This whole new OSC4 engine appears to have great potentials to me, hovever, its remarkable inner complexity is definitely turning out to be a double-edged (or even triple-edged!) weapon so far... (OUCH!)
  19. Thanks
    Smoky Barnable reacted to Jack_mcs in Automatically send data feed to Froogle   
    It isn't a quick change. I will provide an update before that time.
  20. Like
    Smoky Barnable reacted to koopmanh in How to Install OSC V4 on Xampp   
    If you install this on XAMPP for windows, you have to manually add the symlinks for the demo shops.
    To  do this start a cmd.exe session with administrator privileges. Go tot the directory where you have oscommerce installed (in my example "c:\xampp\htdocs\catalog")
    then add the following commands
    mklink -D watch  c:\xampp\htdocs\catalog
    mklink -D  furniture c:\xampp\htdocs\catalog
    mklink -D printshop c:\xampp\htdocs\catalog
    mklink -D  b2b-supermarket  c:\xampp\htdocs\catalog
     
     
     
  21. Like
    Smoky Barnable reacted to Mort-lemur in How to Install OSC V4 on Xampp   
    Download and install Xampp from here: https://www.apachefriends.org/download.html The version I used was windows with php 8.1.12
    It will install in the directory c:\xampp
    In c:\xampp\htdocs create the directory “catalog”
    Download the latest version of OSC4 from here: https://www.oscommerce.com/
    Once downloaded unzip the files to c:\xampp\htdocs\catalog
    Start the xampp control panel and start Apache, MySql & Mercury
    In xampp control panel click on MySql admin tab – this will open xampp PhpMyAdmin where you need to create a new database and password.
    In your browser, navigate to localhost/catalog – This should start the installation process for OSC4
    Initially the installation will fail due to a couple of services needed as follows:
    First PHP GD: See this link for the solution: https://www.geeksforgeeks.org/how-to-install-php-gd-in-xampp/ Second PHP Extension intl: See this limk for the solution: https://stackoverflow.com/questions/33869521/how-can-i-enable-php-extension-intl The installation may fail again when trying to install the database due to password issues – If so you may need to hard code your database password into the catalog/admin/includes/configure.php file at around line 52
    The installation should now continue and complete (unless I forgot a step / adjustment somewhere….)
    Ok so now you can go to the browser and using localhost/catalog open your new website. BUT…..
    More changes are required to enable your access to your Admin / Backend as follows:
    Firstly from a post by @pandrei a change needed to: xampp/htdocs/catalog/admin/includes/local/configure.php and remove extra slash in these constants:

    define('DIR_WS_ADMIN', '//oscommerce/store/admin/'); define('DIR_WS_CATALOG', '//oscommerce/store'); Change to:

    define('DIR_WS_ADMIN', '/oscommerce/store/admin/'); define('DIR_WS_CATALOG', '/oscommerce/store'); You can now navigate to localhost/catalog/admin but the login will fail, as the Mercury email programme needs to be set up as follows:
    First make sure you have an email account and password set up (I created a gmail.com email account just for this purpose)
    Then you need to configure Mercury to send mails, there is lots of info out there, but this link is one of the most straightforward: https://www.geeksforgeeks.org/how-to-configure-xampp-to-send-mail-from-localhost-using-php/
    Next you need to make a change via the xampp mercury control panel, just a case of unchecking a box, which this link explains: https://stackoverflow.com/questions/6809369/warning-mail-function-mail-smtp-server-response-553-we-do-not-relay-non-l
    You should now be able to login to your Admin / Backend – Simples!
    Disclaimer: As I did the install a few days ago I may have forgotten a step or change needed, so don’t blame me if it does not work or if you waste hours of time….. If it fails post here and I (or somebody who actually knows what they are doing) will try and help.
     
     
     
  22. Like
    Smoky Barnable reacted to Mort-lemur in Can't run on local server   
    That will not be a problem - But first I need to spend a couple of days making sure its working on xampp as it should as I think there may be some minor issues.
  23. Like
    Smoky Barnable reacted to osCommerce-Official in Can't run on local server   
    Would you consider creating a new post about how to install osCommerce on Xampp? Would be ever so grateful! 
  24. Like
    Smoky Barnable reacted to Lioelx in [Addon] Ajax Product Listing for osC 2.3.4 bootstrap   
    Hi @@auzStar
    You're right in what you say, but I think the habit of users is to scroll down.
    Regards
  25. Like
    Smoky Barnable reacted to w2vy in Addon access   
    I would like to get access to the latest USPS Shipping module as well as Paypal payment module.
    The source code is covered under the GNU GPL license as stated in the source:
    /**
     * This file is part of osCommerce ecommerce platform.
     * osCommerce the ecommerce
     *
     * @link https://www.oscommerce.com
     * @copyright Copyright (c) 2000-2022 osCommerce LTD
     *
     * Released under the GNU General Public License
     * For the full copyright and license information, please view the LICENSE.TXT file that was distributed with this source code.
     */
    I am also one of the core developers and wrote a lot of the module code that was used as the basis of all the modules.
    I am attempting the simplest task, taking my store and upgrading it to 4.0
    It is surprising that there isn't a osc legacy theme...
    I am starting to wonder if osc4 is actually being used by anyone in a real application
    I may have to throw in the towel and go to one of the many osc forks, that I as a core dev felt would be going to the dark side
    Tom
×
×
  • Create New...