Forum issue

Views: 94

Results 1 to 5 of 5
28 Dec 2020, 6:43 PM
#1
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,305
Plugin Contributions:
39

Forum issue

When accessing urls through both FireFox and Chrome for example like this

PHP Fatal error: 1054:Unknown column 'is_guest_order' in 'field list' :: SELECT is_guest_order

The results are this link

https://www.zen-cart.com/showthread.php?220781-One-Page-Checkout-Support-Thread&highlight=PHP+Fatal+error%3A+1054%3AUnknown+column+%27is_guest_order%27+%27field+list%27+%3A%3A+SELECT+is_guest_order

the result is this

(403) Access Denied

You do not have permission to access the requested resource on this server.

You are being redirected to our main page...
Click here if you do not wish to wait.

IP: 134.215.175.155
URL Requested: /showthread.php?220781-One-Page-Checkout-Support-Thread&highlight=PHP+Fatal+error%3A+1054%3AUnknown+column+%27is_guest_order%27+%27field+list%27+%3A%3A+SELECT+is_guest_order

I had this earlier searching for another error as well.

28 Dec 2020, 6:59 PM
#2
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,973
Plugin Contributions:
8

Re: Forum issue

mprough:

When accessing urls through both FireFox and Chrome for example like this

PHP Fatal error: 1054:Unknown column 'is_guest_order' in 'field list' :: SELECT is_guest_order

The results are this link

https://www.zen-cart.com/showthread.php?220781-One-Page-Checkout-Support-Thread&highlight=PHP+Fatal+error%3A+1054%3AUnknown+column+%27is_guest_order%27+%27field+list%27+%3A%3A+SELECT+is_guest_order

> 
> the result is this
> 
> ```
(403) Access Denied

You do not have permission to access the requested resource on this server.

You are being redirected to our main page...
Click here if you do not wish to wait.

IP: 134.215.175.155
URL Requested: /showthread.php?220781-One-Page-Checkout-Support-Thread&highlight=PHP+Fatal+error%3A+1054%3AUnknown+column+%27is_guest_order%27+%27field+list%27+%3A%3A+SELECT+is_guest_order

I had this earlier searching for another error as well.

i am a little confused.

were you searching for the initial PHP fatal error? what search engine were you using?

i agree that the link you posted results in the error that you also posted; i'm running chrome on a linux box.

however, when i use google to search for the error, i do not see the URL that you posted.

so, i'm not sure if the problem is with the forum software or with the search engine that presented you a bad url to go to.

does that make sense?

author of square Webpay, now with Apple Pay and Google Pay.
mXworks
donations: venmo or paypal accepted.
premium consistent excellent support. available for hire.

28 Dec 2020, 7:20 PM
#3
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,305
Plugin Contributions:
39

Re: Forum issue

i am a little confused.
were you searching for the initial PHP fatal error? what search engine were you using?
On this forum
i agree that the link you posted results in the error that you also posted; i'm running chrome on a linux box.
however, when i use google to search for the error, i do not see the URL that you posted.
so, i'm not sure if the problem is with the forum software or with the search engine that presented you a bad url to go to.
does that make sense?
I searched in this forum's search and clicked the resulting link. I also, copied the link target and pasted it directly in to both Chrome and FF with the same resulting error.

28 Dec 2020, 7:29 PM
#4
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,973
Plugin Contributions:
8

Re: Forum issue

mprough:

i am a little confused.
were you searching for the initial PHP fatal error? what search engine were you using?
On this forum
i agree that the link you posted results in the error that you also posted; i'm running chrome on a linux box.
however, when i use google to search for the error, i do not see the URL that you posted.
so, i'm not sure if the problem is with the forum software or with the search engine that presented you a bad url to go to.
does that make sense?
I searched in this forum's search and clicked the resulting link. I also, copied the link target and pasted it directly in to both Chrome and FF with the same resulting error.

i see said the blind man!

this bb code software is a bit of a bear to configure.

i agree that is a definite bug in the forum software.

author of square Webpay, now with Apple Pay and Google Pay.
mXworks
donations: venmo or paypal accepted.
premium consistent excellent support. available for hire.

28 Dec 2020, 7:51 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Forum issue

This is a result of some WAF rules we've configured to trap for malicious visitor traffic.

The downside to employing such tools on a site related to web development and db queries is that it's hard to catch the edge-cases where the traffic is legitimate vs a malware or vulnerability probing attempt.

It's likely the &highlight= parameters from your search query, which get tagged onto each search result in order to highlight the found text in the posts you visit.

I've fixed the false-positive and tweaked the rules around it.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.