Go to advanced search

Search found 252 matches

Search found 252 matches

jrr

Re: Upgrade OpenCart 3.0.4.0 to 3.0.4.1 question

It is usually not a good idea to be on the bleeding edge of updates...but Mona explains it far better than I can here:
viewtopic.php?t=235190
John :-#)#

Jump to post
  • Sun May 18, 2025 6:38 am
  • Replies 6
  • Views 1926

jrr

Has Isenselabs abandoned OpenCart?

I was just looking at extensions and spotted this on an IsenseLabs extension: Thank you for using iSenseLabs extensions. Starting January 13, 2025, our OpenCart modules will continue to be available “as-is,” and we will no longer be providing maintenance or support. I can't find any announcement on ...

Jump to post
  • Thu May 08, 2025 3:03 pm
  • Replies 2
  • Views 2198

jrr

Re: How to disable cookie window

by mona wrote: ↑
Sat Mar 08, 2025 8:00 pm
 The topic was for OC4.1.0.0.
https://www.opencart.com/index.php?rout ... ch=cookies
Opps! Sorry about that...

John :-#(#

Jump to post
  • Tue Mar 11, 2025 8:35 am
  • Replies 4
  • Views 1734

jrr

Re: How to disable cookie window

ADD Creative wrote: ↑
Thu Feb 27, 2025 8:06 am
 Set Cookie Policy to none in the settings.
I hate to seem like a simpleton, but exactly WHERE is the Cookie Policy on OC 3.0.4.0? Certainly isn't under admin/System/Settings/?? I've hunted for a while now...

John :-#(#

Jump to post
  • Sat Mar 08, 2025 8:55 am
  • Replies 4
  • Views 1734

jrr

Re: Reduce the Product Title to One Line On Home Page

paulfeakins wrote: ↑
Mon Jan 20, 2025 7:04 pm
Gobbo wrote: ↑
Mon Jan 20, 2025 9:45 am
 How can we reduce the displayed product title to one line on the home page?
You can see how it appears on our themes: https://www.antropy.co.uk/opencart-serv ... me-builds/
"Oops!
Looks like we've moved the page you were after!"

John :-#(#

Jump to post
  • Fri Mar 07, 2025 8:43 am
  • Replies 11
  • Views 1695

jrr

Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...

Dang - just got hit with around 240 attempts: PHP Warning: mysqli::query(): (42000/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 '?', search_term = '' where tracking_id='1018'' at line 1 in /.../catalog_oc...

Jump to post
  • Wed Jan 22, 2025 2:13 am
  • Replies 22
  • Views 2230

jrr

Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...

because this part "'?', search_term = '' where tracking_id='258#'" on the error message might have been provided as a parameter in a request as opposed to being part of your source code. This could also mean a possible SQL injection attack or test. Can you confirm if the tracking_id='258#...

Jump to post
  • Sat Jan 18, 2025 3:38 am
  • Replies 22
  • Views 2230

jrr

Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...

The tracking_id in admin/model/extension/payment/pp_express.php is not used in an SQL query, so it is not that. Also disabling a payment extension won't necessarily stop it being used in an attack. Remember to also search the modifications directory and and vQmod cache. As suggested by nonnedelecta...

Jump to post
  • Fri Jan 17, 2025 1:20 am
  • Replies 22
  • Views 2230

jrr

Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...

Well, inclinations are fine but you have an sql construct which contains "where tracking_id = ...." somewhere and I don't see that in pp_express. Indeed, and it's disabled. I'm putting this down to an attempted attack on PayPal Express and move on - (not [solved] - and I was wrong on that...

Jump to post
  • Fri Jan 17, 2025 12:14 am
  • Replies 22
  • Views 2230

jrr

Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...

Error Message PHP Warning: mysqli::query(): (42000/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 My guess would be an extension you have installed is vulnerable to SQL injection and someone is trying to run SQ...

Jump to post
  • Thu Jan 16, 2025 3:38 pm
  • Replies 22
  • Views 2230

jrr

Re: PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...

Right...

How do I find which extension might be creating this problem - if it is actually a problem and not the system trying to protect my site from an attach of some sort?

It was a one-off situation, hasn't happened before or since.

Thanks!

John :-#)#

Jump to post
  • Wed Jan 15, 2025 3:04 am
  • Replies 22
  • Views 2230

jrr

PHP Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual...

OC 3.0.4.0, PHP 8.x. Got about 150 of these tonight (7:53-7:54PM) from a number of multiple IP addresses. Was this an attack or possibly an extension error. Have not added any new extensions in the past couple of days, nor reinstalling any though - and I've not seen this error message before. Error ...

Jump to post
  • Tue Jan 14, 2025 2:50 pm
  • Replies 22
  • Views 2230

jrr

Re: [SOLVED] Receive an email anytime admin logs in

I do all my coding and compression on a M1 MacBook Air and never had issues with a compressed ocmod "install.xml" Double click the install.xml file, and click: "Compress install.xml", then rename the compressed file so that it ends with: XXX.ocmod.zip . It was all my fault - as ...

Jump to post
  • Sun Jan 05, 2025 12:12 am
  • Replies 39
  • Views 3482

jrr

Re: Receive an email anytime admin logs in [SOLVED]

I just compared his code to your new OCmod code and there is nothing in there that I can see that would make his code not work lol. No clue why his code didn't work lol . There is something wrong with my compress function in osx Sonoma. I tried expanding Mona's extension and then recompressed it us...

Jump to post
  • Sat Jan 04, 2025 4:30 pm
  • Replies 39
  • Views 3482

jrr

Re: Receive an email anytime admin logs in [SOLVED]

Try this and check your error logs if it does not work Tested and Send Email on Admin Login (seoal for short) is working on 3.0.4.0 IMPORTANT : this download has site specific addresses Hi Mona, That worked as it should - I'm getting the emails from admin logins - and the extension now shows up in ...

Jump to post
  • Sat Jan 04, 2025 10:09 am
  • Replies 39
  • Views 3482

jrr

Re: Receive an email anytime admin logs in [SOLVED]

Yup -

Code: Select all

$this->session->data['user_token'] = token(32);
- is on line 15.

Weird.

Probably all my fault...

Thanks!

John :-#)#

Jump to post
  • Sat Jan 04, 2025 9:52 am
  • Replies 39
  • Views 3482

jrr

Re: Receive an email anytime admin logs in [SOLVED]

Post a copy of your full XML ocmod file PS did you refresh your modification after installation?? . This is not my first extension installation...so yes, I refreshed extension/modification (and clear all caches) - it simply doesn't show up! I'm assuming it got stuck and followed the <operation erro...

Jump to post
  • Fri Jan 03, 2025 2:55 pm
  • Replies 39
  • Views 3482

jrr

Re: Receive an email anytime admin logs in

You use the code below if you are making an ocmod for installation through admin->extensions->installer page... If you are hardcoding the code into the login.php file directly (hardcoding is never really recommended), you don't need the code below, and you don't need a bunch of other code from my o...

Jump to post
  • Fri Jan 03, 2025 8:52 am
  • Replies 39
  • Views 3482

jrr

Re: Receive an email anytime admin logs in

Not sure why it's not working on your 3.0.4.0. Login.php file is pretty much the same as my 3.0.3.2. Maybe someone else can tell us how to pull username another way. PS put your code after line 15 $this->session->data['user_token'] = token(32); Right you are! Putting the script after line 15 has it...

Jump to post
  • Thu Jan 02, 2025 2:28 pm
  • Replies 39
  • Views 3482

jrr

Re: Receive an email anytime admin logs in

Interesting, but I'm not getting the username defined on my 3.0.4.0 system. Is there another way to retrieve the login name than: Admin: {$this->request->post['username']} I'm simply stuffing this after line 23 in ../admin/controller/common/login.php $ip_address = ''; if (!empty($_SERVER['HTTP_CLIEN...

Jump to post
  • Thu Jan 02, 2025 10:36 am
  • Replies 39
  • Views 3482

Search found 252 matches

Go to advanced search