Search found 38 matches

Search found 38 matches

DBI

Re: A killer error! customers paying but the order not being saved! [HELP]

Regarding the advice to run your own mail server... the problem is that emails from self hosted SMTP servers are FAR more likely to be labeled as spam by pretty much every spam filter out there. Add to that the IP you get assigned for your colocated or cloud server is likely to have been used for sp...

Jump to post
  • Tue Apr 20, 2021 7:45 pm
  • Replies 10
  • Views 678

DBI

Re: A killer error! customers paying but the order not being saved! [HELP]

There are a few things you could try: - Switch mail engine to SMTP - Ensure you're allowing less secure apps to connect in gmail settings. - Make sure your server is authenticated with gmail: https://accounts.google.com/b/0/DisplayUnlockCaptcha - Make sure your store email address is added to your g...

Jump to post
  • Tue Apr 20, 2021 5:11 pm
  • Replies 10
  • Views 678

DBI

Re: PHP Fatal Error - Is this a Bot or another form of attack? OpenCart 3.0.3.6

The part that's missing from that story is that the error was coming from MySQL, they were successfully getting OC to run queries they originated. Even if they all failed it's a huge security risk. It shouldn't be possible to execute ANY MySQL via a URL. That example URL you posted should result in ...

Jump to post
  • Tue Apr 20, 2021 4:15 pm
  • Replies 18
  • Views 12260

DBI

Re: PHP Fatal Error - Is this a Bot or another form of attack? OpenCart 3.0.3.6

An extension causing it is the most likely explanation so it sounds like you found the problem. Glad to hear it. I'd recommend finding a third party to review the code before you install that extension again, even after it's "fixed". Also, assume that your database has been compromised. Yo...

Jump to post
  • Tue Apr 20, 2021 1:33 pm
  • Replies 18
  • Views 12260

DBI

Re: PayPal Commerce Platform opencart version 3.0.2.0

Since that extension gets credentials automatically, try using the 'disconnect' button and then running the connection process again using the most recent version of the extension.

Jump to post
  • Tue Apr 20, 2021 12:37 pm
  • Replies 3
  • Views 669

DBI

Re: customer_ip data

Yes that's safe. Make a backup of the table (you can download it if you're trying to save space on the server) and then delete away. You can keep recent entries with a query similar to this: delete FROM `oc_customer_ip` WHERE `date_added` < '2021-04-19' That would delete everything from 04-18 and ol...

Jump to post
  • Tue Apr 20, 2021 12:31 pm
  • Replies 2
  • Views 427

DBI

Re: PHP Fatal Error - Is this a Bot or another form of attack? OpenCart 3.0.3.6

As you probably know, the presence of those lines in your error log means that someone is successfully getting your scripts to run arbitrary SQL. Tracking down the IP will do you no good, as long as the vulnerability is there, anyone can exploit it. And the attackers are no doubt cycling IP addresse...

Jump to post
  • Tue Apr 20, 2021 12:20 pm
  • Replies 18
  • Views 12260

DBI

Re: Problem with custom fields in multi store setup

Finally found the time to look at the code for this issue. It's is, in fact, a bug. For anyone else that runs into this, here are the causes... In these files: > catalog > controller > checkout > guest.php > catalog > controller > checkout > register.php The call to the model that loads custom field...

Jump to post
  • Tue Apr 20, 2021 5:55 am
  • Replies 8
  • Views 710

DBI

Re: Problem with custom fields in multi store setup

I appreciate the information about the potential fix in the pipeline.

In the present, though, still looking for a solution :)

Jump to post
  • Fri Apr 09, 2021 3:55 am
  • Replies 8
  • Views 710

DBI

Re: Problem with custom fields in multi store setup

I take that to mean it's a bug and there's no workaround?

Jump to post
  • Thu Apr 08, 2021 10:35 am
  • Replies 8
  • Views 710

DBI

Problem with custom fields in multi store setup

Edit: See my reply later in this thread for the solution to this problem. Hi, This problem existed in 2.x and seems to have survived into 3.x. When adding a custom field (under customers tab in admin) the field shows up during checkout (it's in the address section) for all stores despite being assi...

Jump to post
  • Thu Apr 08, 2021 6:49 am
  • Replies 8
  • Views 710

DBI

Re: Install Method and Table Creation

I think you're asking if the database is there, but the entire problem is that it isn't!

Jump to post
  • Sat Oct 31, 2020 6:32 am
  • Replies 6
  • Views 1776

DBI

Re: Install Method and Table Creation

The database user has table creation permissions.

Jump to post
  • Sat Oct 31, 2020 5:37 am
  • Replies 6
  • Views 1776

DBI

Install Method and Table Creation

I've having trouble creating a new table as part of a modification. My ocmod.zip installation works fine, OCMOD modifications are run, files are moved to the correct directories. However my query to create a new database table doesn't seem to be running. My understanding is that the way to do this i...

Jump to post
  • Fri Oct 30, 2020 8:33 am
  • Replies 6
  • Views 1776

DBI

OpenCart 3 PayPal Pro Extension Issue

This is happening with a fresh install of OC 3.0.3.2. When testing the PayPal Pro payment extension, after clicking "confirm order" the "please wait" notice shows up and nothing happens after that (the user isn't redirected to a success page). Checking PayPal confirms that the pa...

Jump to post
  • Thu Sep 12, 2019 5:52 am
  • Replies 0
  • Views 1233

DBI

What is the upgrade script status for 3.x?

Previously I used the included upgrade script to upgrade from one 2.x version to another and it made an impressively big mess. I ended up moving back to an earlier 2.x version (2.1.0.2). My mistake was assuming that the upgrade script had been fully tested. I later found on the forums that the scrip...

Jump to post
  • Sat Oct 14, 2017 2:12 am
  • Replies 1
  • Views 606

DBI

Re: Cart Update/Remove Issue

The links you pasted are straight from the default OpenCart template.

Jump to post
  • Fri Jun 30, 2017 8:22 pm
  • Replies 2
  • Views 436

DBI

Cart Update/Remove Issue

[edit] Found the problem, it's with OpenCart and the size of the encoded keys. Possibly larger ID numbers for the products associated with this store are the problem. The problem, apparently, exists with 2.1 but not 2.2. If only the upgrade script wasn't broken :(

Jump to post
  • Fri Jun 30, 2017 6:22 pm
  • Replies 2
  • Views 436

DBI

Re: Featured Products Disappearing

I downgraded to 2.1 after the 2.2.0.0 upgrade script destroyed a website. Later discovered it was a known issue that effected ALL upgrades of versions prior to 2.1... that it was a known issue and the download (with upgrade script) were still available on the OC site, and that it was the second time...

Jump to post
  • Sat Jul 09, 2016 9:13 am
  • Replies 4
  • Views 517

Search found 38 matches