Jump to content

Chadduck

Members
  • Content count

    108
  • Joined

  • Last visited

Everything posted by Chadduck

  1. Chadduck

    Google XML Sitemap SEO

    ecartz THANK YOU. I am ALWAYS amazed by those that can find an error induced by a module other than the one that is failing. Incorporating your change above solved the unescaped apostrophe. I, myself, would have never looked outside of the module that I had just installed. Thanks again. BJ
  2. Chadduck

    Google XML Sitemap SEO

    No problem - and again thanks for your wonderful mods. I certainly appreciate them as I am sure the entire OSC community does.
  3. Chadduck

    Google XML Sitemap SEO

    Dunno... As I pointed out originally once I removed the apostrophe the IP update went right through. I simply thought you would want to know which is why I cut and pasted the sql error.
  4. Chadduck

    Google XML Sitemap SEO

    Ubuntu 18.04.3 LTS MySQL Server version: 5.7.28-0ubuntu0.18.04.4 PHP version: 7.2.24-0ubuntu0.18.04.1
  5. Chadduck

    Google XML Sitemap SEO

    Jack, THANKS FOR THIS GREAT ADD ON. The insertion of the "Manual IP" text during the install works fine - However when an individual tries to update the IP they are greeted with this error 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's with a comma.- Manual mode only')' at line 1 insert into configuration_changes (change_date,previous_setting,new_setting,change_title,change_description) values (now(),'127.0.0.1','XXX.XXX.XXX.XX','Manual IP','Enter the IP that you want to cause the manual run to happen. Separate muliple IP's with a comma.- Manual mode only') [TEP STOP] It is caused by this portion of the configuration text " Separate muliple IP's with a comma." removing the apostrophe removes the error. As long as you are correcting it - there is also a "t" missing from the word multiple BJ
  6. Chadduck

    UPS Choice 1.8.3

    Hello everyone - Before I begin the dreaded process of troubleshooting my UPS shipping issue I wanted to ask IF I am the only one that is having issues with UPS Choice 1.8.3. Shipping has been working fine for years. I received a phone call asking IF Priority Mail was the only method of shipping that we offered on Wednesday, April 17. 2019. Of course it was not, but it was the first time anyone had told me that there was no other option. Since the module is returning this error message (see image) We are unable to obtain a rate quote for UPS shipping. Please contact the store if no other alternative is shown I do NOT believe that the module is the issue HOWEVER I am of the opinion that UPS may have finally removed the cgi server since the module has this disclaimer in step 7 ------------------------------------ Disclaimer: This revision is based on ups.php v.1.54, which employs the UPS cgi method that has been deprecated for over a year and although it appears to remain functional is no longer officially supported by UPS. The currently supported UPS API requires XML requests through a secure socket layer, for which there is not yet an osC implementation. ------------------------------------ Is anyone else having this issue? Anyone have a suggestion for a similar module for replacement? BJ
  7. Chadduck

    HoneyPot Captcha

    It seems to have worked BUT I didn't try any hacker things except for http://www.google.com as the email on the page where it asks for the email address. The code sent a password reset email - and I was able to reset the password. Thanks. I just din't know IF it was necessary to do anything besides adding the include(s). It looked like it may be necessary. Thanks again. BJ
  8. Chadduck

    HoneyPot Captcha

    Jack I finally got back to this for doing the password_reset.php. As I was preparing to do it I was looking at the install instructions for the contact_us.php and then I stopped to send these questions. I examined password_reset.php for the OSC 2.3.4 - it does not contain this line $actionRecorder = new actionRecorder('ar_contact_us', (tep_session_is_registered('customer_id') ? $customer_id : null), $name); I also noticed that the include statement to be included reads as follows /*** BEGIN HONEYPOT ***/ include('includes/honeypot/modules/honeypot_verify_contact_us.php'); /*** END HONEYPOT ***/ QUESTION 1 Since the $actionRecorder statement does NOT exist - can the include statement be inserted just after the require statement? The file would then read as follows require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PASSWORD_RESET); /*** BEGIN HONEYPOT ***/ include('includes/honeypot/modules/honeypot_verify_contact_us.php'); /*** END HONEYPOT ***/ $error = false; if ( !isset($HTTP_GET_VARS['account']) || !isset($HTTP_GET_VARS['key']) ) { $error = true; QUESTION 2 The include statement says to use the module file "honeypot_verify_contact_us.php" Does this remain "as is" or it necessary to create a "honeypot_verify_password_reset.php" file and correct it internally for the password_reset.php information? Sorry if those are dumb questions BUT Honeypot has been working so well and has made my life so much easier that I am hesitant to change anything without verifying so that I do not BREAK anything. BJ
  9. Chadduck

    Free Shipping Per Product for v2.3

    Tsimi FIRST and foremost THANK YOU for the installation instructions for OSC Bootstrap. They were RIGHT ON. Have used this particular mod for years in an OSC 2.3.4 store and really did NOT want to change. The old saying "IF it ain't broke DON'T fix it" applies. HOWEVER, there is one spot that does not exist in the BS Frozen version (All the rest matched up perfectly) That instruction set is this code *********************************************** catalog/product_info.php NOT AVAIL *********************************************** Find: <div class="page-header"> <div class="row"> <h1 class="col-sm-8"><?php echo $products_name; ?></h1> <h2 class="col-sm-4 text-right-not-xs" itemprop="offers" itemscope itemtype="http://schema.org/Offer"><?php echo $products_price; ?></h2> </div> </div> Replace with: <?php // PRODUCTS SHIP FREE START if(tep_products_ship_free_check($product_info['products_id'])) $freeship_str .= '<br /><span class="smallText">(' . TEXT_PRODUCT_SHIPS_FREE . ')</span>'; ?> <div class="page-header"> <div class="row"> <h1 class="col-sm-8"><?php echo $products_name; ?></h1> <h2 class="col-sm-4 text-right-not-xs" itemprop="offers" itemscope itemtype="http://schema.org/Offer"><?php echo $products_price . $freeship_str; ?></h2> </div> </div> <!-- PRODUCTS SHIP FREE END //--> The FROZEN version of the file reads like this <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!isset($_GET['products_id'])) { tep_redirect(tep_href_link('index.php')); } require('includes/languages/' . $language . '/product_info.php'); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); require('includes/template_top.php'); if ($product_check['total'] < 1) { ?> <div class="contentContainer"> <div class="row"> <?php echo $oscTemplate->getContent('product_info_not_found'); ?> </div> </div> <?php } else { $product_info_query = tep_db_query("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 " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$_GET['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); ?> <?php echo tep_draw_form('cart_quantity', tep_href_link('product_info.php', tep_get_all_get_params(array('action')). 'action=add_product', 'NONSSL'), 'post', 'class="form-horizontal" role="form"'); ?> <?php if ($messageStack->size('product_action') > 0) { echo $messageStack->output('product_action'); } ?> <div class="contentContainer"> <div class="row is-product"> <?php echo $oscTemplate->getContent('product_info'); ?> </div> </div> </form> <?php } require('includes/template_bottom.php'); require('includes/application_bottom.php'); ?> Not wanting to "crash" the rest of MY TEST STORE (am upgrading) I must ask Where does the required coding go? Thank you in advance BJ
  10. Chadduck

    HoneyPot Captcha

    Jack I apologize. I was thinking I had read in the beginning of this topic that YOU had discussed the AI bots. It was not you but another user. I was just trying to think outside of the box as to another verification check for those type of bots. Again, apologies. And thank you for not treating my comments /suggestions like they were unwanted or silly. BJ
  11. Chadduck

    HoneyPot Captcha

    My initial thought was elimination by country but since the account is created by data presented to the bot. So that is out. My next thought was abnormally long last name BUT in today's world with hyphenated names (e.g. Drake-Hollingsworth, Browskowski-Loveday, Rodriguez-Hernandez) This is maybe a little outside the box but perhaps a hidden dropdown with three choices empty as the default, then bot and lastly spider. Since it is an abnormal hidden field anything but the default selected would result in a denial.
  12. Chadduck

    HoneyPot Captcha

    I am sorry if that was confusing... That was a cut and paste from the administration page dashboard. The date was the date created since the dashboard only shows the First Name - Last Name and creation date. I probably should have indicated that and I do apologize. BUT it seems that the bot is simply inserting the same first and last name with an additional alpha character or two. The added characters are generally in upper case. Again - THANK YOU my life has gotten much easier thanks to this mod.
  13. Chadduck

    HoneyPot Captcha

    Jack First before I forget - THANK YOU!!! I often forget to say that as I move onto the next module. The Honeypot is stopping registrations like this one First Name What's the most convenient method to gain $79862 a month: https://make-1-btc-per-day.blogspot.co.uk?i=86 Last Name What's the most convenient method to gain $79862 a month: https://make-1-btc-per-day.blogspot.co.uk?i=86 Those type registrations were being done 10 -15 times a day. I do have a question though - Can anything be done regarding the registrations like these? Customers Date Bobbiemof BobbiemofYV 11/05/2019 Marina85waymn Marina85waymnMT 11/05/2019 CarolPhove CarolPhoveIA 11/05/2019 NovostroykiVolgogradDIx NovostroykiVolgogradDIxBN 11/05/2019 Smocnat KaocnatLC 11/05/2019 RandalJub RandalJubMD 11/05/2019 Did I miss a setting? Do I need to set something? BJ
  14. Chadduck

    HoneyPot Captcha

    Another quickie regarding enabling the LOG TRACKER file WHERE is it created and stored?
  15. Chadduck

    HoneyPot Captcha

    Jack My live store is OSC 2.3.4.1 and I just installed the HoneyPot Captcha and it appears to be working. BUT a Quick question - at present I have it enabled for these pages contact_us.php create_account.php password_reset.php tell_a_friend.php SHOULD it also be enabled for any others? There are 57 in the setup - should it be enabled for ALL of them? BTW I am updating to FROZEN and will be installing this in it also. BJ
  16. Thank you for the information.
  17. Mr Petet I feel like an ID-10-T (idiot) I overlook the possibility of the tables being created from the module installation. I located what I was asking for. BUT is it a requirement to run the update25.sql since this will be a FIRST TIME INSTALL? Again - my apologies for being an idiot. BJ
  18. Mr Petet Please forgive my constant posts - I pulled the file from the place you identified "Separate Shipping Per Product v2.5 [SSPP]" and grabbed the one identified as Bug 2.52. I also pulled the file that is identified SSPP v2.51 Full package. I extracted and examined the files... Having said that - one of the first things I do is examine any included sql file to see what changes will be done to the database. The included sql refers to altering three tables shipping_rates shipping_table_rates shipping_mode I checked my OSC Frozen db and my live store db which is OSC 2.3.4.1 Those tables DO NOT exist in either version. The included sql file is titled "update25.sql" in both files. This would indicate that the file expects those tables to already exist BUT since this is the FIRST time install for me which version contains the install table creation sql scripts. I do not mind pulling it from a previous version BUT on the "Separate Shipping Per Product v1.0" version page there are 19 different versions. On the "Separate Shipping Per Product v2.5 [SSPP]" version page there are four versions. Thank you for any insight. BJ
  19. Mr Petet Thank you... I will get the latest. BJ
  20. Mr Petet Good Morning sir. Up front I, like Mikepo above, am working with the OSC FROZEN vsn and under php 7.2. Having said that I went to your module in the contributions section - the latest that is there is SSPP v1.852 which identifies "Bugfix: 1.852 This fixes the installation of the seperate_mode table from not being installed." and was uploaded 11th August 2014. This makes me believe that I am in the WRONG area -OR- the version quoted from your post is not yet available. Could you please confirm my suspicions -AND / OR- direct me to where the newest version resides? Thank you in advance BJ Chadduck
  21. Hello All; At this point, in my migration to OSC Phoenix, I am slowly adding shipping and payment methods. I currently have these modules installed and working Master_Password_v3.1 - INSTALLED USPS Rate V4 Intl Rate V2 r1.8 - INSTALLED (thank you @Kymation) I am now needing to install an UPS Shipping method. On my LIVE store I currently use UPS CHOICE 1.8.3.1. While I understand that XML is the wave of the future and I have the needed keys etc for install I would truly prefer simple rather than complex. Also from what I have read in the forums the module UPSXML version 1.7 does not like php 7.2 or php 7.3. I am currently running under php 7.3. WHICH UPS module WORKS with Phoenix? I have reviewed the forum and there does not seem to be an identified module (old or new) that is recommended. Suggestions? and do you have it operational? BJ
  22. Chadduck

    New UPS XML Shipping Module available

    Trying to install this module on a CLEAN Frozen install Operating System I included a crop of the installation screen The OSC is CE-Phoenix-2341-Frozen The module is UPSXML version 1.7 THIS INSTALL IS RUNNING ON A LOCAL SERVER I do not understand exactly what is happening. When I place the upsxml.php in the includes/modules/shipping directory the shipping modules installation screen fails to load completely. NO there is no other UPS module there, as shown on the BEFORE placing portion of the graphic. After placing the module shows the screen after the upsxml.php is placed. Solutions? Recommendations?
  23. Chadduck

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

    @ArtcoInc THANK YOU... Although I have it installed and working your extra information about HOW the PHOENIX code works is valuable.
  24. Chadduck

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

    Appreciate this but I have one from the LIVE store I run. But others may not.
  25. Chadduck

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

    Jim I was so excited that the array issue was resolved I was NOT paying attention on the Front End. In the module includes/modules/shipping/usps.php on line 32 is this $this->icon = DIR_WS_ICONS . 'shipping_usps.gif'; First there is NO icon in the package and secondly when Phoenix installs there is not a directory created. Additionally there is no define set up in the configure.php for them. As it appears there is a broken graphic that appears. simply commenting that line out removes the broken graphic. BJ
×