ArtcoInc

SELECT COUNT(p.products_id) AS total SELECT p.*, pd.*, m.*, IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) AS final_price, p.products_quantity AS in_stock, IF(s.status, 1, 0) AS is_special FROM products p LEFT JOIN specials s ON p.products_id = s.products_id INNER JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id INNER JOIN products_to_categories p2c WHERE p.products_status = 1 AND p.products_id = p2c.products_id AND pd.products_id = p2c.products_id AND pd.language_id = 1 AND p2c.categories_id = 44 I find it useful to format the statements to better understand what's going on ... 1) you have 2 select statements 2) Aren't you supposed to have commas after each WHERE/AND line (except the last line)? 3) I'm not sure if there are supposed to be commas after the JOIN/ON lines ... HTH Malcolm

Do NOT use the v2.3.4.1 package. Use the Phoenix Edition v1.0.7.9 https://www.oscommerce.com/Products (scroll down until you see the Community Edition download)

@ufty73 This is a couple of years old (the current version of osCommerce is now Phoenix, not Frozen), but the installation process is still the same ... HTH Malcolm

@dizoe How did you create the database? Unless it matches the expected structure 100%, you will have problems. Also, there are utilities such as Easy Populate that are useful for moving mass data around. https://apps.oscommerce.com/xYmiQ&easy-populate-products-attributes HTH Malcolm

@dizoe While these instructions are a bit old (referencing an older version of osC), the process is the same. HTH Malcolm

(off topic, but ...) 28 Days ... 2016 - #28

@Adam_Maynard Everybody is experiencing a decline in sales! So, what can you do about it? Ask yourself, what sets your business apart from the others? Products? Service? Pricing? Where/how are you advertising? Regarding the site itself, just a couple of quick observations ... 1) You have a paid ad in the middle of the home page that is not responsive. This means that when viewing with a small device (ie: phone), there will be a left-right scroll bar *just* to accommodate the ad. 2) When viewed on a large screen (ie: desktop computer), the left column is quite narrow, resulting in the 'Best Sellers' to be a very long list, with each displayed listing broken up into lines of only 2 or 3 words. This make for awkward reading. Either make the left column wider (preferred), or choose a smaller font. 3) Under 'Categories', you have listed 'Powermatic'. This is a manufacturer of woodworking tools, is it not? Why is it in it's own category? 4) You offer free shipping on a $10k+ bandsaw weighing over 1400 pounds (Jet 7060) ???? You need to emphasize this more! I did not catch it at first in the scrolling slide show at the top of your home page! Again, just a couple of quick observations ... Malcolm

@Pickle Are you a member of the Phoenix club? @burt released a Google reCAPTCHA module as part of his supporters code. Malcolm

@Psytanium Thank you. I just wanted to make sure your host hadn't upgraded PHP to version 7.x. Many hosts are moving to v7.x, which will break your version of osC. Malcolm

@Psytanium If I may suggest, log into the Admin side of your shop, and select Tools -> Server Info. Tell us what version of PHP your host is running. Malcolm

Just as a shot in the dark, but could there be an .htaccess file causing a redirect? M

While this is a couple of years old (ie: we use Phoenix now, not 'Frozen'), the installation process is still the same ... HTH Malcolm

@danil0 For the shits and giggles of it, try changing the captcha from numbers to images? M

@XplorMedia There are 3 areas that need to be set up correctly ... 1) Your website is XplorMedia.com. It is NOT www.XplorMedia.com. Note the www. prefix. You need to make sure that your SSL certificate and website name match. 2a) You need to make sure your .htaccess file redirects people to the correct name. In other words, if people type www.XplorMedia.com, your .htaccess file needs to redirect them to XplorMedia.com (without the www.). 2b) Your .htaccess file must then redirect people to your https:// site. 3) In osCommerce, there are two configuration files: <shop root>/includes/configure.php <shop root>/<your admin directory>/includes/configure.php BOTH of these need to be edited to reflect that you are using a SSL certificate. For example, <?php define('HTTP_SERVER', 'https://XplorMedia.com'); define('HTTPS_SERVER', 'https://XplorMedia.com'); define('ENABLE_SSL', true); Note that there is no www. in the URLs (since your site, and SSL certificate aren't using it), that the httpS is in BOTH URLs, and that ENABLE_SSL is set to true. HTH Malcolm