Jump to content

John W

♥Ambassador
  • Content count

    962
  • Joined

  • Last visited

  • Days Won

    18

Reputation Activity

  1. Like
    John W reacted to jimlongo in MySQL 5.7 gotcha   
    The code that I needed to change only involved custom code as far as I can tell, and only inserts so it was fairly easy to find where it was happening.
    The solution in my case was to not send an empty string as a numeric value.  I suppose in the past it had been type cast as 0. So when encountering this in the code simply set the empty string to 0. In my cases NULL was not acceptable, it must be numeric.
    if ($val==""){$val=0;} Otherwise the error would be a very ugly mysql error 1366 - incorrect integer value. 
    I've been using the MariaDB replacement to MYSQL for a couple of years, and just updated from 10.1 to 10.3 on Friday. 
  2. Like
    John W reacted to jimlongo in MySQL 5.7 gotcha   
    FWIW I ran into the same issue after an upgrade from MariaDB 10.1 to 10.3 (and unfortunately cPanel dowgrades are not supported).
    Throwing a msyql error 1366 on checkout in checkout_process.php. In my case it's the insert(s) around line 241
    Has to do with not being able to insert an empty string in a numeric field type
    https://jira.mariadb.org/browse/MCOL-2059
     
  3. Like
    John W got a reaction from pete2007 in Newsletter Manager, send from a different email?   
    Yes, that is possible. You probably want to look at using something like Mailchimp or the like.  Little searching here and on Google will yeild a lot of info.  Keep in mind that the average hosting account will limit how much email you can send and you don't want to get flagged by Yahoo, Gmail, etc... for sending spam.  Send the same email to several yahoo accounts and you'll get greylisted and maybe worse.  I think Burt has a Mailchimp addon that might be easy to use. 
  4. Like
    John W reacted to MrPhil in Adding images into product description   
    No virus at all.   is the UTF-8 Byte Order Mark. You're using a dipshit editor that insists on inserting the BOM at the beginning of any file you create in UTF-8 encoding. That includes most Microsoft editors. Either find a way to turn off adding BOM, or get a better editor (e.g., Notepad++ or ViM).
  5. Thanks
    John W got a reaction from Dnj1964 in Adding images into product description   
    A litle off subject, but I would suggest you keep all your image names in lower case.  A long time ago I images with mixed case and it created some issues.  Took a while to figure out the problem. 
  6. Like
    John W got a reaction from Dan Cole in AIM Module - MD5 Hash Is Going Away. Is there an update?   
    On my test site using my AIM module on their test server/sandbox it works with all the MD5 code commented out of the aim module.  I never had anything entered for it and all the md5 code was contingent on something being entered.  I think the md5 code was carry over from when Harald did the SIM module, but I'm guessing.
    I also downloaded their SDK for the api and have played with that a little on my test site with Netbeans.  Netbeans is helpful because it parses the code and can take you right to a class or method without having to hunt for it.  Since they have about 500 files in this api, NB is really helpful.  I used their sample code to get it to work from my test site.  I think we could reuse a lot of the aim module code and convert it to use the api. 
  7. Thanks
    John W got a reaction from René H4 in Fake accounts   
    I've had a few of these in the last month with some different names, but they enter Google for company and google for company tax id each time.  I know not company tax id isn't stock code, but I added this to block spammers and I can add more to it if I need.  Most regular customers don't enter a tax id, but only spammers enter google for it.  I also have it send me an email to notify me it's happened so I can track it.
    //Added to block spammers if (strtolower($company_tax_id) == 'google') { $error = true; $messageStack->add('create_account', "You have triggered spamming prevention rules. If you info is correct and you are not a spammer please contact us or try again."); $spam_email_text = "Spammer Alert: " . $firstname . " " . $lastname . "Using company name: " . $company . " with tax id: " . $company_tax_id . " triggered spam alert."; tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Spammer Alert:', $spam_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } //END Added to block spammers  
  8. Like
    John W reacted to cannuck1964 in AIM Module - MD5 Hash Is Going Away. Is there an update?   
    For hosted forms.   For XML it is the preferred method of implementation
    The link I sent is for XML implementation classes
    Hosted forms have not been in use for a very long time now.
    cheers
    Peter
     
     
  9. Like
    John W got a reaction from Stephan Gebbers in Cezpdf pdf-php creator   
    I don't know if anyone will have interest in this, so I won't spend a lot of time on this unless it gains traction.  Anyway, I use batch print from over a decade ago and didn't realize until yesterday that the pdf class was still being maintained.  Since I only sell in the US, I haven't run into many character encoding problems, but I imagine some of you do.  So, the new version of Cezpdf seems to work with all the characters.  It's also php 7.2 compliant.  Even better, I was able to replace my old Cezpdf and Cpdf class files and associated files.  With very little changes, it prints my invoice.  The pdf manual seems pretty useful, but I haven't gone very far into it yet.  The main snag I hit was using "addTextWrap", which requires a different order than before.  But, it has more functionality, so I can right justify for totals, which I couldn't do before.  addText also has changed.  I only have a few hours into it, but check the manual out.
    So, I said wouldn't ramble too much.  If anyone is intersted you can find it at https://github.com/rospdf/pdf-php
  10. Like
    John W got a reaction from Stephan Gebbers in Cezpdf pdf-php creator   
    I don't know if anyone will have interest in this, so I won't spend a lot of time on this unless it gains traction.  Anyway, I use batch print from over a decade ago and didn't realize until yesterday that the pdf class was still being maintained.  Since I only sell in the US, I haven't run into many character encoding problems, but I imagine some of you do.  So, the new version of Cezpdf seems to work with all the characters.  It's also php 7.2 compliant.  Even better, I was able to replace my old Cezpdf and Cpdf class files and associated files.  With very little changes, it prints my invoice.  The pdf manual seems pretty useful, but I haven't gone very far into it yet.  The main snag I hit was using "addTextWrap", which requires a different order than before.  But, it has more functionality, so I can right justify for totals, which I couldn't do before.  addText also has changed.  I only have a few hours into it, but check the manual out.
    So, I said wouldn't ramble too much.  If anyone is intersted you can find it at https://github.com/rospdf/pdf-php
  11. Like
    John W reacted to cdetdi in Paypal Express Dropping Tax Calculation   
    Fixed for now - I added a function in general that looks to see if the PAYMENTREQUEST_0_TAXAMT is in the Paypal array which then turns on the tax rate I need.   The fact that this works suggests that it was the shop that calculated the rate by itself (disregarding the PayPal return) and the shop was dropping the tax rate.
  12. Like
    John W got a reaction from raiwa in AJAX Attribute Manager support   
    @raiwa
    Seems to work with 2.9.5 with a quick test.  I'll let you know if I find anything else. 
    Thanks for all your work on this.
  13. Thanks
    John W got a reaction from raiwa in AJAX Attribute Manager support   
    So, I've updated to 2.9.4 and testing it using E_ALL error reporting.  Got an undefined var warning when saving a product. 
    On attributeManagerUpdateAtomic.inc.php line 27 I added the isset and it solved it.  Like below. 
    if (isset(${AM_SESSION_VAR_NAME}) && is_array(${AM_SESSION_VAR_NAME}) && is_numeric($products_id)) { I'll keep testing and report anything and I can find and hopefully offer a fix. 
  14. Like
    John W got a reaction from zefeena in Checkout confirmation blank white page   
    Okay, a little searching and it looks like you installed this addon "Fancier Invoice & Packing Slip for OSC 2"   Line 30 is
    require(DIR_FS_ADMIN . DIR_WS_LANGUAGES . $language . "/" . FILENAME_ORDERS_INVOICE); You need to make sure you have DIR_FS_ADMIN defined correctly, just change that line to the correct path.  Probably read through the documentation or see if there's a thread for it.  One thing that stands out is that it is not compatible with Paypal IPN.
    It's a good practice to have a test site of some sort to try things first.  Otherwise, you'll continue to have your site crashing. 
  15. Like
    John W reacted to JcMagpie in help with bootstrap?   
    Something that will help with updating from V3 to V4
    http://upgrade-bootstrap.bootply.com/
    Just paste your V3 html in to the box and it will give you V4.1 alternative to use.
    Will help with some of the donky work in converting.
     
     
  16. Like
    John W got a reaction from videod in Fake accounts   
    Which code are you talking about?  If it's what I posted, you have to have SPPC installed for that field to be in create_account.  I put my block after the lines below and it's worked perfectly without any false positives.
    if (is_numeric($country) == false) { $error = true; $messageStack->add('create_account', ENTRY_COUNTRY_ERROR); }  
  17. Thanks
    John W got a reaction from René H4 in Fake accounts   
    I've had a few of these in the last month with some different names, but they enter Google for company and google for company tax id each time.  I know not company tax id isn't stock code, but I added this to block spammers and I can add more to it if I need.  Most regular customers don't enter a tax id, but only spammers enter google for it.  I also have it send me an email to notify me it's happened so I can track it.
    //Added to block spammers if (strtolower($company_tax_id) == 'google') { $error = true; $messageStack->add('create_account', "You have triggered spamming prevention rules. If you info is correct and you are not a spammer please contact us or try again."); $spam_email_text = "Spammer Alert: " . $firstname . " " . $lastname . "Using company name: " . $company . " with tax id: " . $company_tax_id . " triggered spam alert."; tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Spammer Alert:', $spam_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } //END Added to block spammers  
  18. Like
    John W reacted to clustersolutions in ULTIMATE Seo Urls 5 - by FWR Media   
    Hmm...true, clean code is important...
    I don't know if this banaid is better than the previous one,  but they both offer a similar solution.
    I would really do a var_dump($text_array) or print_r($text_array) just before the foreach statement to get a stack trace of the argument. You really need to know why PHP was complaining. In fact, the foreach statement wasn't just looking for an array, and it was expecting an associative array.
    FWR is a smart dude, I would definitely understood why before deciding on a fix. That would be my approach...some upstream setting may just fix the warning.
  19. Like
    John W reacted to JcMagpie in Google Adsense and https site   
    Short answer for an established business no! I personally only use it on my hobby sites. On these it works very well.
    However in reality it depends on what you are selling and how established your store is. If your selling hobby stuff which is not easy to get or stuff you make your self, then having others that sell similar stuff place ads that may be of interest to your customers can help.
    You may find you have competitors that target your site with ads but google allows you to block them. So it's all down to what your selling and how you use it.
  20. Like
    John W reacted to burt in <product> has been added to your Cart: I don't want this....   
    In your Admin Area there is a setting that allows the redirect to cart to be turned off.
    You can try that, it still refreshes but stays on the page the buy button is on.
    As an alternative, as @Tsimi rightly says, you could try Ajax.
    I experimented with something, you can try it http://template.me.uk/234bs3/index.php - this is just to prove it is do-able, it is not currently available as an addon.
  21. Like
    John W got a reaction from valquiria23 in Please Review my Website - comments are welcome   
    ONe other thing is some of the US prices seem off, so I'm wondering if there's a problem with the currency conversion.  Is this jig saw really USD $1,000?
    https://www.ferreteriaideal.com.uy/catalog/caladora-profesional-truper-p-2979.html
     
  22. Like
    John W got a reaction from valquiria23 in Please Review my Website - comments are welcome   
    I agree with the others that there is too much movement.  I guess you have to see where your sales come from, because while I get more mobile visits, I get most purchases from tablets and desktop/laptop.  Overall, it comes down to are you selling what someone is looking for and is the price/terms good.  I'm actually a tool guy, although not as much as I used to be.  For the most part I go looking for a certain tool like a Bosch router, or a Dewalt miter saw.  Actually, I bought my big Jet VSR lathe online and had it shipped.
    So, it depends on your martket and your customer.  Remember, they may not care for a bunch of fancey stuff.  However, the speed of your site is good and everyone is seeing that.  No matter what, speed is good.
  23. Like
    John W got a reaction from Omar_one in Time to get secure (if you haven't already)   
    Good catch!  I have a different version, so I changed it for his.  Didn't see the extra ".".
  24. Thanks
    John W got a reaction from rulegacy in PCI Compliance   
    Okay, so it kind of bugged me as to why htttpOnly and secure flag wasn't set.  I tried altering the code to make it work, but it wouldn't.  Did some more research and this is a solution that will make it set secure.  Put this at the top of application_top
    ini_set('session.cookie_httponly',1); ini_set('session.cookie_secure',1);  
  25. Like
    John W got a reaction from radhavallabh in Create Account Success not working in Firefox!   
    Works for me using Win 7 64bit FF 61.01.
    However, I find Firefox has more problems than it used to.  For instance on Fedex FF will give a redirect error on some links where Chrome works fine. 
    There's a browswer called Brave based on Chrome that is very fast.  Supposedly very secure also.
×