problem in search with letters like 'union' keyword in OSCommerce

[mujahid 0]

Hello, everyone. I have some problems and I need your help!

I currently use OSCommerce latest version,

I have a problem where I search union keyword but page not working and gives HTTP 500 errors.

if I search uNion keyword it's work nicely...

You can try the following URL :

👉 https://www.socomtactical.net/

 

See Attachment as well: for better understanding

[♥ecartz 724]

When I try this in the stock latest version, I get https://template.me.uk/phoenix/advanced_search_result.php?keywords=union -- this would seem to be specific to you. 

Perhaps we might offer more help if you could show your mod_rewrite rules -- probably in a .htaccess file. 

Or perhaps post some entries from your error logs. 

[mujahid 0]

# $Id$
#
# This is used with Apache WebServers
# The following blocks direct HTTP requests in this directory recursively
#
# For this to work, you must include the parameter 'Limit' to the AllowOverride configuration
#
# Example:
#
#<Directory "/usr/local/apache/htdocs">
#  AllowOverride Limit
#
# 'All' with also work. (This configuration is in your apache/conf/httpd.conf file)
#
# This does not affect PHP include/require functions
#
# Example: http://server/catalog/includes/application_top.php will not work

# FeedPlatform Tracking - Begin

#php_value  auto_prepend_file "/home/lkay/domains/socomtactical.net/public_html/malbuster/mbconnector.php"

php_value  auto_prepend_file "/home/lkay/domains/socomtactical.net/public_html/qshield/WafConnector.php"

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule ^track/redirect/(.*) http://track.feedplatform.com/redirect/$1 [R=302,L]
</IfModule>


# FeedPlatform Tracking - End

<FilesMatch "\.(ttf|otf|eot|woff)$">
    <IfModule mod_headers.c>
        Header set Access-Control-Allow-Origin "*"
    </IfModule>
</FilesMatch>

RewriteEngine On 
#RewriteCond %{SERVER_PORT} 80 
#RewriteRule ^(.*)$ https://www.socomtactical.net/$1 [R,L]

RewriteCond  %{REQUEST_FILENAME} !-f
RewriteCond  %{REQUEST_FILENAME} !-d
RewriteRule  ^airsoft\-brand/(.*)$  mrs_product_brand.php?brand=$1 [QSA,L]


# SEO Team Cleaner URLS

RewriteCond  %{REQUEST_FILENAME} !-f
RewriteCond  %{REQUEST_FILENAME} !-d
RewriteRule  ^privacy\-policy$  mrs_clean_url.php?information_id=10 [QSA,L]
RewriteRule  ^terms$  mrs_clean_url.php?information_id=9 [QSA,L]
RewriteRule  ^about\-us$  mrs_clean_url.php?information_id=7 [QSA,L]
RewriteRule  ^wholesale$  mrs_clean_url.php?information_id=12 [QSA,L]
RewriteRule  ^socom-blog-and-how-to-guides$ /airsoftblog/ [QSA,L,R=301]
RewriteRule  ^delivery-and-returns$  mrs_clean_url.php?information_id=8 [QSA,L]
RewriteRule  ^accessibility$  mrs_clean_url.php?information_id=11 [QSA,L]
RewriteRule  ^jobs$  mrs_clean_url.php?information_id=13 [QSA,L]
RewriteRule  ^airsoft-finance$  mrs_clean_url.php?information_id=18 [QSA,L]
RewriteRule  ^airsoft-information$  mrs_clean_url.php?information_id=22 [QSA,L]
RewriteRule  ^our-retail-shop$  mrs_clean_url.php?information_id=23 [QSA,L]

# Now rewrite
RewriteCond %{QUERY_STRING} (^|&)information_id\=10($|&)
RewriteRule ^information\.php$ /privacy-policy? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=9($|&)
RewriteRule ^information\.php$ /terms? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=7($|&)
RewriteRule ^information\.php$ /about-us? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=12($|&)
RewriteRule ^information\.php$ /wholesale? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=14($|&)
RewriteRule ^information\.php$ /airsoftblog/? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=8($|&)
RewriteRule ^information\.php$ /delivery-and-returns? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=11($|&)
RewriteRule ^information\.php$ /accessibility? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=13($|&)
RewriteRule ^information\.php$ /jobs? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=18($|&)
RewriteRule ^information\.php$ /airsoft-finance? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=22($|&)
RewriteRule ^information\.php$ /airsoft-information? [L,R=301]

RewriteCond %{QUERY_STRING} (^|&)information_id\=23($|&)
RewriteRule ^information\.php$ /our-retail-shop? [L,R=301]

# SEO Team Cleaner URLS

RewriteEngine On
RewriteBase /
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
RewriteCond %{SCRIPT_FILENAME} !-d
RewriteCond %{SCRIPT_FILENAME} !-f
RewriteRule (.*) m1_seourls.router.php
RewriteCond %{SCRIPT_FILENAME} -f
RewriteCond %{SCRIPT_FILENAME} .*\.php|/$
RewriteCond %{SCRIPT_FILENAME} !download\.php
RewriteCond %{SCRIPT_FILENAME} !mrs_product_brand\.php
RewriteCond %{SCRIPT_FILENAME} !mrs_clean_url\.php
RewriteRule !/ m1_seourls.router.php
ErrorDocument 401 /401.html

This is my htaccess files and error log file also empty.  

[♥ecartz 724]

The two things that leap out at me are WafConnector.php and m1_seourls.router.php

My guess is that one of them has some kind of malware detection that looks for the word union and halts when it is detected.  I would start by asking the qshield people.  You also might try commenting out the php_value line by putting a # at the beginning.  If it works without that line, then that's the problem. 

[mujahid 0]

where is located given two files? @ecartz. please let me know

[♥ecartz 724]

Well, if you look in the .htaccess, it says /home/lkay/domains/socomtactical.net/public_html/qshield/WafConnector.php

The other is probably in the public_html directory. 

Neither of those is standard.  The latter is probably an SEO App for osCommerce.  The former is probably a malware blocker of some sort, not related to osCommerce at all. 

[mujahid 0]

@ecartz very appreciated. quick support. but what changes required in public_html/qshield/WafConnector.php files. 

please only let me know ASAP.

Thank you once again!

[♥ecartz 724]

As I said, that's not an osCommerce file.  So I have no idea how it works.  You could try finding whatever is breaking things in it.  Or you could contact whomever installed it or provided it to fix its behavior.  It's called a connector, so the problematic code may be outside the file in the thing to which it connects.  Which might not be available to you. 

The only real suggestion I can make is to try commenting out the php_value line and see what happens.  If that fixes the problem, then you can work out which is more important, malware protection or searches for union.  And perhaps contact whomever provides it for support.