Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by ArtcoInc

  1. ArtcoInc

    Emails not sending

    @zefeena Several things ... 1) You didn't say if: a) your shop used to send out emails, but now it's stopped, or b) it never has been able to send out emails. 2) Read this thread ... This explains how to create a file that tests your server to see if IT is properly set up properly to send out emails. You create and edit one file, upload it to your server, and access the file through your browser. It tries to send out two emails. If you receive them (one or both), then it's not a problem with the server. If you DON'T receive them, than the problem IS with the server. 3) People have reported that their hosts won't send emails if the From or Reply To email addresses are not from the domain the shop is in. IE, if your shop is My_Domain.com, but your email addresses say you are mailing from AOL.com, Yahoo.com, GMail.com, etc.. Apparently there are ways around this, but the best fix is to use your own domain as the sending email address. HTH Malcolm
  2. @De Dokta I have just installed this in a 234bs cart, and things work very well. Thank you! One thing I would like to see is: Since the customer is buying as a guest, once they move to checking_shipping, is there really a need to offer them the choice of changing addresses in their address book, which they don't have? If we could have a check in checkout_shipping to see if the customer is a guest, we can eliminate that, and make the guest checkout smoother ... Here's where it needs to be addressed in checkout_shipping.php <div class="page-header"> <h1><?php echo HEADING_TITLE; ?></h1> </div> <?php echo tep_draw_form('checkout_address', tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'), 'post', 'class="form-horizontal"', true) . tep_draw_hidden_field('action', 'process'); ?> <div class="contentContainer"> <h2><?php echo TABLE_HEADING_SHIPPING_ADDRESS; ?></h2> <div class="contentText row"> <div class="col-sm-8"> <!-- If this could be applied *only* if the customer is NOT a guest ... <div class="alert alert-warning"> <?php echo TEXT_CHOOSE_SHIPPING_DESTINATION; ?> <div class="clearfix"></div> <div class="pull-right"> <?php echo tep_draw_button(IMAGE_BUTTON_CHANGE_ADDRESS, 'glyphicon-home', tep_href_link(FILENAME_CHECKOUT_SHIPPING_ADDRESS, '', 'SSL')); ?> </div> <div class="clearfix"></div> </div> </div> <div class="col-sm-4"> --> <div class="panel panel-primary"> <div class="panel-heading"><?php echo TITLE_SHIPPING_ADDRESS; ?></div> <div class="panel-body"> <?php echo tep_address_label($customer_id, $sendto, true, ' ', '<br />'); ?> </div> </div> </div> </div> <div class="clearfix"></div> <?php if (tep_count_shipping_modules() > 0) { ?> Thoughts? Malcolm
  3. Table names are now hard-coded. Change : $check_query = tep_db_query ("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_FEDEX_WEB_SERVICES_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); to $check_query = tep_db_query ("select zone_id from zones_to_geo_zones where geo_zone_id = '" . MODULE_SHIPPING_FEDEX_WEB_SERVICES_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); ie: changing " . TABLE_ZONES_TO_GEO_ZONES . " to zones_to_geo_zones . M
  4. Please note that the original post was 5 years ago. What else has changed in the osC code since then? M
  5. ArtcoInc

    Phoenix Dashboard

    Admin -> Modules -> Dashboard -> Select 'Last Certified Add-Ons' -> Edit -> Set 'Enable' to False
  6. @TomB01 Typical convention uses the table name to come up the the 'arbitrary' character(s). So, the table 'products' would use the letter 'p', the table 'products_description' would use the letters 'pd', etc. Malcolm
  7. While the SQL 'select' statement is written as one long sentence, I like to format it into several lines, making it easier for me to read. So, I'll format it like this: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_gtin from products p, products_description pd where p.products_status = '1' and p.products_id = '1637' and pd.products_id = p.products_id and pd.language_id = '3' This breaks the 'select' statement into its three components: Select .... this lists the fields it wants to select. From .... this lists the tables in which to find the fields. Note that the table names are followed by a letter or two. This is the same letter preceding the fields in the Select list, letting the Select command know which table the field is in Where .... this lists the conditions for the search. Only select the records if these conditions are true. And, as @TomB01 pointed out, there error is saying that the Select function is asking for a field that does not exist in the appropriate table. HTH Malcolm
  8. ArtcoInc

    help what version

    @puggybelle All of the Community Editions were called that. As you suggested, sometimes the folder date may reflect the date you downloaded. However, all of the files within the folder should all have the same date. Regardless, with a date of May 2018, this was before the release of Frozen, which was released in August 2018. @ecartz explained it well. Malcolm
  9. ArtcoInc

    help what version

    @spacegremlin As has been said before, the Community Edition did not have an accurate version numbering system, so there is often confusion as to which version a shop may be using. When Burt started this project back in 2014, osC was at version So, the Community Edition, all through its early development, was also v2.3.3.4. Every release of the Community Edition during these early times was called v2.3.3.4. When osC upgraded to v2.3.4, Burt brought the Community Edition code base up to the v2.3.4 code base, and the Community Edition became (and stayed at) v2.3.4 while further development was happening. In January 2015, Burt released the 'Gold' fixed release. Development still continued, with every release still being called v2.3.4. When osC had the v2.3.4.1 Hot Patch applied, Burt also applied the Hot Patch, and the Community Edition was bumped up to v2.3.4.1. Once again, development continued, with every new release still being called v2.3.4.1. Burt released the 'Frozen' fixed release in August 2018. No additional development is being done on 'Frozen'. Some bugs have been identified in 'Frozen', and there is a thread on the forum identifying them (and some fixes too). At lease one member here is maintaining a patch file of these fixes needed for 'Frozen'. Development still continues (usually called 'Edge', although that is not a fixed release), and the version number is *still* v2.3.4.1. Some significant changes have been made since 'Frozen' (such as the 'upgrade' from BootStrap v3 to v4), causing some compatibility issues with prior versions, and many (most?) add-ons out there. So, there is no one 'Edge' version. Releases prior to 'Frozen' could technically be called 'Edge', and every release since 'Frozen' is also technically 'Edge'. A release of 'Edge' from a month ago may not (and probably is not) the same as 'Edge' today. Also, there is no 'Frozen' BS4. All changes to upgrade to BootStrap v4 came *after* the release of 'Frozen'. In July of 2019, the 'Phoenix' edition was released. As of this writing, Phoenix is the latest release, now with a consistent version numbering system in place. This numbering system does not relate to the 'official' osC numbering in any way. So, the only real way to know what version you are running is to look at the date of the original ZIP file that held your original osC code. HTH Malcolm
  10. @Smoky Barnable Back in 2016, @burt made a 'Fuzzy Search' module in his 28 days bundle. It might help. One other thought is to integrate the Google search function into your shop. I have seen that used before. HTH Malcolm
  11. @puggybelle @Dan Cole While I was trying to install a different TypeAhead search module, I too had the same issues that both you and Dan reported. You can start reading about them here: I was getting different results on my in-house development server and my 'live' public server. I was getting different results with different browsers. I asked different people to test the public server, and different people experienced different results. I never determined what was causing the problem. I wish I had better news ... Malcolm
  12. ArtcoInc

    Can someone explain the various editions?

    @SCM Minis Seems to be working now ....
  13. Unless I'm missing something, which is quite possible ... There is no provision to display the Category Image on a Categories page. I did a quick hack to add code to display the image in the /includes/modules/content/index_nested/templates/tpl_cm_in_title.php file, although in retrospect I should (and probably will) make a new module just to display the image. M
  14. ArtcoInc


    @rossosiya I realize you are new here, so I'll just point out that you are answering a thread that happened 14 years ago. M
  15. ArtcoInc

    Ultimate Seo Urls 5 Pro

    @DAVID3733 IIRC, any changes to httpd.conf requires a restart of Apache. Is this something you really want to do in a production environment, especially if you are on a shared server? M
  16. ArtcoInc

    Change from .htaccess to httpd.conf

    @DAVID3733 Did you stop and restart Apache?
  17. ArtcoInc

    USPS Rate V4, Intl Rate V2 (official support thread)

    @TomB01 (and the line or two following this) M
  18. ArtcoInc

    UPS XML 1.7 for Phoenix

    @TomB01 Back in the day, osC had two files: database_tables.php and filenames.php. These were in the catalog/includes/ directory. There were another set of these in the catalog/admin/includes/ directory. These files defined all of the referenced file names and database tables. In the evolution of the Community Edition of osC (which Phoenix is), these files were removed, and all of the references were hard coded. Many of the more popular add-ons have been updated to hard code these filenames and/or database tables. But, there are still a number of popular add-ons that have not be so updated. If you are trying to install one of these older add-ons, you will need to makes these changes: When there is a TABLE_xxxxx, you need to change that to the actual table name, *usually* what is in the xxxxx place. Best practices say to type it in lower case, but that shouldn't really matter. Where there is a FILE_xxxxx, you need to change that to the actual file name, *usually* using what is in the xxxxx place (so, it would become 'xxxxx.php' (yes, you need the single quotes, and add the .php to the end)). There are also other changes that will need to be made to bring the add-on up to PHP 7 compatibility. HTH Malcolm
  19. ArtcoInc

    UPS XML 1.7 for Phoenix

    @TomB01 change: select zone_code from TABLE_ZONES where zone_name = 'Tennessee' and zone_country_id = '223' and length(zone_code) > 0 to: select zone_code from zones where zone_name = 'Tennessee' and zone_country_id = '223' and length(zone_code) > 0 Basically, change TABLE_ZONES to zones . M
  20. ArtcoInc

    USPS Rate V4, Intl Rate V2 (official support thread)

    @TomB01 No. He was the one that removed them. They are not needed in 'the core'. Add-on's now need to be self-contained. M
  21. ArtcoInc

    USPS Rate V4, Intl Rate V2 (official support thread)

    To enter your ZIP code into the SQL statement, replace the 'NONE' with your ZIP code (include the single quotes). Or, like I said, just update it in Admin. M
  22. ArtcoInc

    USPS Rate V4, Intl Rate V2 (official support thread)

    1) You can use something like phpMyAdmin. Log into the correct database. Copy and paste the two lines above into the SQL box, and run. This will add the two entries into the correct table. Once the entries have been made, you should be able to use Admin -> Configuration -> Shipping/Packaging to adjust/edit these settings. 2) I have confirmed that these two entries have been dropped from Phoenix Since this USPS module uses the entries, the module now needs to be updated to include the instruction of how to do so! Unfortunately, it seems that the module has not been updated since 2012, nor has the original developer been here since. M
  23. @Kurre It was worth a shot Unfortunately, I don't see an easy way to get the Horizontal Menu to be centered. M
  24. ArtcoInc

    USPS Rate V4, Intl Rate V2 (official support thread)

    @TomB01 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '223', 'Select the country of origin to be used in shipping quotes.', '7', '1', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Postal Code', 'SHIPPING_ORIGIN_ZIP', 'NONE', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', '7', '2', now()); M