Simple SEO URL (OLD version) [support thread]

[srigari]

In my site 404 is not working. If I give random text after the domain name it is redirecting me to my home page.

I am using SSU 3.6.6, zencart 1.3.8a

more over if the text has a ' (single quote), then it is giving a database error (1064)

Here are the examples:
(1) http ://www.salevalley.com/asdfgh - suppose to give 404 but takes you to homepage.

(2) http ://www.salevalley.com/xyz'
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 '/%' ) ORDER BY length(link_alias) DESC' at line 1
in:
[SELECT DISTINCT link_url, link_alias FROM links_aliases WHERE (link_alias LIKE '%/xyz'/%' ) ORDER BY length(link_alias) DESC]


These are causing PCI non compliance problems.

[countrycharm]

In my site 404 is not working. If I give random text after the domain name it is redirecting me to my home page.

I am using SSU 3.6.6, zencart 1.3.8a

more over if the text has a ' (single quote), then it is giving a database error (1064)

Here are the examples:
(1) http ://www.salevalley.com/asdfgh - suppose to give 404 but takes you to homepage.

(2) http ://www.salevalley.com/xyz'
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 '/%' ) ORDER BY length(link_alias) DESC' at line 1
in:
[SELECT DISTINCT link_url, link_alias FROM links_aliases WHERE (link_alias LIKE '%/xyz'/%' ) ORDER BY length(link_alias) DESC]


These are causing PCI non compliance problems.

How about getting 3.6.7 and reupload the files first, then clearing your cache, in your store admin/Extras/simple seo URL manager. If it still doesnt solve the problem, we can go from there.

[srigari]

thank you. I will try that.

[srigari]

How about getting 3.6.7 and reupload the files first, then clearing your cache, in your store admin/Extras/simple seo URL manager. If it still doesnt solve the problem, we can go from there.

I upgraded to 3.6.7, now I do not see 1064 error for

http: //www.salevalley.com/xyz'

but still it is redirecting to homepage. not getting the 404

[countrycharm]

I upgraded to 3.6.7, now I do not see 1064 error for

http: //www.salevalley.com/xyz'

but still it is redirecting to homepage. not getting the 404

Did you clear your simple seo cache?

[batteryman]

Yellow do you think you can shed a little light on this for me.

http://www.zen-cart.com/forum/showpo...postcount=3199

its on page 320 of this thread

Thank you

[countrycharm]

Yellow do you think you can shed a little light on this for me.

http://www.zen-cart.com/forum/showpo...postcount=3199

its on page 320 of this thread

Thank you

Turn off gzip for now, seems like the page content is messed up.

What module have you installed recently that can interfere with content? I know SSU cant do that for sure.

I don't have it on in my store. I have this in my .ini file
zlib.output_compression_level = -6
but I took that out to see what it would do but i'm getting the same thing.

No I was talking to countrycharm, sorry for the confustion. Can you post your problem or link to it again?

@Countrycharm: Seem like it appears like that only on a 2nd load of a page, so for example if i load http://www.thegoodshepherdstore.com/...gifts-under-20 once it works okie, and then when i refresh i see only code. And it only happens on category pages. I have turned off ssu for checking and it's still the same, so the problem is not there

PS: seem like because there are 2 level of gzip (by server and by simple-cache), I turned off simple cache gzip and it works for you now. I cannot replicate the other problem tho.

Just to make sure you know what the problem was I had simple cache with gzip cut on and I had zlib.output_compression_level = -6 on, on my server so that was what was messing things up for me. Yellow went to my site admin and cut off simple cache and things was back to normal. I hope this will help.

[batteryman]

Just to make sure you know what the problem was I had simple cache with gzip cut on and I had zlib.output_compression_level = -6 on, on my server so that was what was messing things up for me. Yellow went to my site admin and cut off simple cache and things was back to normal. I hope this will help.

I checked my GZip Compression level is set to off but I dont know what the zlib.output_compression_level = -6 means or where it is to change it or what to even change it to.

??

[srigari]

Did you clear your simple seo cache?

I did clear the cache. when I stop the SSU and remove htaccess file, everything is working as expected. The moment I put the .htaccess file back, I see the problem.

The problem seems to be in my .htaccess file. I am playing around with it now. But no luck.

here is my .htaccess

Options +FollowSymLinks -MultiViews
RewriteEngine on
RewriteCond %{HTTP_HOST} ^salevalley.com$ [OR]
RewriteCond %{HTTP_HOST} ^www.salevalley.com$
RewriteRule ^shop/?$ "http\:\/\/www.salevalley\.com" [R=301,L]

RewriteCond %{HTTP_HOST} ^salevalley.com
RewriteRule (.*) http://www.salevalley.com/$1 [R=301,L]

#### BOF SSU

# Change "/zencart/ to the correct setting
# if your site is located at root folder, then you should have RewriteBase /
# Go to your include/configure.php, this value should be the same with the value of DIR_WS_CATALOG
RewriteBase /

# Deny access from .htaccess
RewriteRule ^\.htaccess$ - [F]

RewriteCond %{SCRIPT_FILENAME} -f [OR]
RewriteCond %{SCRIPT_FILENAME} -d
RewriteRule .* - [L]

RewriteRule ^(.*) index.php/$1 [E=VAR1:$1,QSA,L]
#### EOF SSU



Please let me know any changes needed.

Thanks

[srigari]

I tried with just putting the .htaccess supplied with SSU 3.6.7 bas below and deleted everything else, still same problem


#### BOF SSU
Options +FollowSymLinks -MultiViews
RewriteEngine On
# Make sure to change "zencart" to the subfolder you install ZC. If you use root folder, change to: RewriteBase /
RewriteBase /

# Deny access from .htaccess
RewriteRule ^\.htaccess$ - [F]

RewriteCond %{SCRIPT_FILENAME} !-f
RewriteCond %{SCRIPT_FILENAME} !-d
RewriteRule ^(.*) index.php?/$1 [E=VAR1:$1,QSA,L]
#### EOF SSU

Please let me know how to go about it.

Thanks