Search found 106 matches

Search found 106 matches

jrr

Anyone working on the new IOSS VAT system integration with OC (3.0.3.6 for me)

New extension needed? Just got a note from FedEx outlining the new VAT requirements for shipments to Europe coming into effect July 1. Anyone selling items of any value to Europe will need to either register in each country they sell to or use the new IOSS (Import One Stop-Shop) system. https://op.e...

Jump to post
  • Tue Apr 13, 2021 12:07 am
  • Replies 2
  • Views 127

jrr

Re: vQmod 2.6.5-OpenCart version fix for twig issues in OpenCart 3.0.3.5/3.0.3.7

I've officially released an updated version of the OpenCart version of vQmod with fixes for the latest twig changes in 3.0.3.5 and 3.0.3.7 The vQmod class code hasn't changed... only the xml/vqmod_opencart.xml file needs to be updated on your site. ... That's it. Now your twig files should be able ...

Jump to post
  • Mon Apr 12, 2021 11:57 pm
  • Replies 4
  • Views 233

jrr

Re: max user connections exceeded - OC 3.0.3.6

I've just started looking into this error: PHP Warning: mysqli::__construct(): (HY000/1203): User xxxx already has more than 'max_user_connections' active connections in /usr/www/.../catalog/system/library/db/mysqli.php on line 7 Have read up somewhat on the problem https://stackoverflow.com/questi...

Jump to post
  • Mon Apr 12, 2021 9:14 am
  • Replies 6
  • Views 293

jrr

Re: How to tell which PayPal payment extension is best? OC 3.0.3.6

... PayPal Payments Standard is the oldest and most basic module. Which makes it the simplest to use as you just need your PayPal email address. I would us the version in the GitHub 3.0.x.x_Maintenance branch as this has recently had bug and security fixes. https://www.paypal.com/us/webapps/mpp/ref...

Jump to post
  • Thu Apr 08, 2021 2:13 am
  • Replies 5
  • Views 294

jrr

max user connections exceeded - OC 3.0.3.6

I've just started looking into this error: PHP Warning: mysqli::__construct(): (HY000/1203): User xxxx already has more than 'max_user_connections' active connections in /usr/www/.../catalog/system/library/db/mysqli.php on line 7 Have read up somewhat on the problem https://stackoverflow.com/questio...

Jump to post
  • Thu Apr 08, 2021 1:42 am
  • Replies 6
  • Views 293

jrr

Re: PayPal paying in Default Currency (USD) not the Shopping Cart Currency (eg. CAD, AUD, EUR...) OC 3.0.3.6

You could try to change: currency_code":"USD" to: currency_code":"CAD" In the PayPal Commerce Platform controllers. Ah, but won't that make all PayPal transactions then proceed in CAD? Most of my clients use USD, but I want to allow folks in Europe, the UK, and Australia (who are my biggest custome...

Jump to post
  • Sat Apr 03, 2021 3:03 am
  • Replies 3
  • Views 279

jrr

Re: How to tell which PayPal payment extension is best? OC 3.0.3.6

The one referred to in the blog is the PayPal Commerce Platform this is the most recently added module and did replace all the others in 3.0.3.3. There are also limitations such as what countries it can be used in.Which seems to be the reason that the other were added back in 3.0.3.5. They are curr...

Jump to post
  • Sat Apr 03, 2021 2:55 am
  • Replies 5
  • Views 294

jrr

How to tell which PayPal payment extension is best? OC 3.0.3.6

OK, I should have looked into this when I first started out. (rant on) The page of extensions/payments includes 8 PayPal modules. None of which have an explanation on why one should choose any one over the others. The OC documents are not much help as the version they recommend is not OFFERED in the...

Jump to post
  • Fri Apr 02, 2021 2:59 pm
  • Replies 5
  • Views 294

jrr

PayPal paying in Default Currency (USD) not the Shopping Cart Currency (eg. CAD, AUD, EUR...) OC 3.0.3.6

Just noticed this - I'm using the OC "PayPal Commerce Platform" and it is not sending the shopping cart currency code to PayPal. I'm reading the log - sample here and it is showing the currency code as USD (the default for my store). The shopping cart currency is staying in CAD - it is just being pa...

Jump to post
  • Fri Apr 02, 2021 8:57 am
  • Replies 3
  • Views 279

jrr

Re: Prevent PHP error display on front end (Customer) OC 3.0.3.6

Have a look here for an idea of how to change this. Although in the error handler you really only want to do that with fatal errors. https://github.com/opencart/opencart/blob/5d743659043bfeb851790845c16e8611d6345145/upload/system/framework.php#L60-L65 https://github.com/opencart/opencart/blob/e8930...

Jump to post
  • Fri Apr 02, 2021 7:37 am
  • Replies 4
  • Views 242

jrr

Re: Prevent PHP error display on front end (Customer) OC 3.0.3.6

To stop all errors being displayed you need to do all of the following. ... Yes, I have a pretty good idea how to disable displaying all errors, what I wanted to do was to turn display errors off just for the front end (customer) folks. If that is not possible then fine, but then you are stuck with...

Jump to post
  • Fri Apr 02, 2021 5:24 am
  • Replies 4
  • Views 242

jrr

Prevent PHP error display on front end (Customer) OC 3.0.3.6

I don't see any way to differentiate between displaying errors just to admin and errors displayed to customers. I don't like all the site details that are shown when I get a PHP fatal error as someone could use that info to attempt to hack the site. I'm assuming at this point that I need to either p...

Jump to post
  • Fri Apr 02, 2021 1:57 am
  • Replies 4
  • Views 242

jrr

Looking to integrate speadsheet date with products - OC 3.0.3.6

I have a thousands of diodes and transistors - and I am looking for a way to integrate the transistor/diode/etc name with a spreadsheet list. As an example, a transistor called 2N6122 - looking at the spreadsheet it has values of Material, Polarity, Power Dissipation, Vcb, DC Current Gain, and many ...

Jump to post
  • Thu Mar 18, 2021 1:19 pm
  • Replies 5
  • Views 192

jrr

Re: Looking to integrate speadsheet date with products - OC 3.0.3.6

I have a thousands of diodes and transistors - and I am looking for a way to integrate the transistor/diode/etc name with a spreadsheet list. ... Anyone seen anything like this that will work with OC? Or am I going to have to code it myself (not without a lot of clues!) or pay someone a bunch of be...

Jump to post
  • Thu Mar 18, 2021 1:04 pm
  • Replies 4
  • Views 194

jrr

Re: Looking to integrate speadsheet date with products - OC 3.0.3.6

kestas wrote:
Thu Mar 18, 2021 5:50 am
Have you tried to use attributes?
No, but I'm trying for this to be dynamic - where when I add a part that is on the table it automatically is updated with the relevant data when viewed by the potential customer. Can attributes do that?

Jump to post
  • Thu Mar 18, 2021 7:26 am
  • Replies 4
  • Views 194

jrr

Looking to integrate speadsheet date with products - OC 3.0.3.6

I have a thousands of diodes and transistors - and I am looking for a way to integrate the transistor/diode/etc name with a spreadsheet list. As an example, a transistor called 2N6122 - looking at the spreadsheet it has values of Material, Polarity, Power Dissipation, Vcb, DC Current Gain, and many ...

Jump to post
  • Thu Mar 18, 2021 5:47 am
  • Replies 4
  • Views 194

jrr

[SOLVED] Two Primary Keys in one Table - oc_product_description - OC 3.0.3.6

I was rummaging around the DB just looking it over as I'd had some trouble with searches when I found that oc_product_description had two primary keys! These are found in product_id and language_id when one looks at the structure under phpMyAdmin. Note I am running php 7.3.x, and my collation is utf...

Jump to post
  • Tue Mar 16, 2021 12:44 pm
  • Replies 2
  • Views 193

jrr

Re: Captcha 3 not blocking bots from registering...3.0.3.6

You can use our SpamBot Buster which uses both a honeypot trap and also checks for required mouse/touch/keyboard events to distinguish between a genjuine human user and a spambot. Ah, I already bought a different honeypot (Honeypot Spam Robot Protection) which seems to be working OK - no new junk r...

Jump to post
  • Thu Mar 11, 2021 8:30 am
  • Replies 5
  • Views 469

jrr

Re: Captcha 3 not blocking bots from registering...

sw!tch wrote:
Tue Mar 09, 2021 5:41 am
An old school HoneyPot method is still pretty effective. Lots of examples you can use.
Thanks, I found a Honeypot extension that looks like it will do the job. If it works I'll post it here with a [Solved].

Jump to post
  • Tue Mar 09, 2021 3:01 pm
  • Replies 5
  • Views 469

jrr

[Solved] Captcha 3 not blocking bots from registering...3.0.3.6

I'm getting a couple every day or two - new 'customers' with a name like TreedWise TreedWiseNM. Always with the last two letters capitalized, and the first name doubled. I'm running the default extension/extension/Captcha Goggle reCAPTCHA extension. Had this problem with my previous shopping cart (o...

Jump to post
  • Tue Mar 09, 2021 5:10 am
  • Replies 5
  • Views 469

Search found 106 matches