Simple SEO URL (OLD version) [support thread]

[cobra7]

Hello all,

I've just installed Simple SEO and it has benn working great.

After playing with some links i came acros some minor mistake.

If i type domain.com/category-one-c-1 it works, but if i misspell url like domain.com/category-one-c-1x i get MySql mistake

1054 Unknown column '1x' in 'where clause'
in:
[SELECT categories_name FROM categories_description WHERE categories_id =1x LIMIT 1]

aslo get the mistake with product (if i type x behind product number)

1054 Unknown column '3x' in 'where clause'
in:
[SELECT d.products_name, p.products_type FROM products p, products_description d WHERE p.products_id =3x AND d.products_id= p.products_id LIMIT 1]

I guess there should be some kind of checking if $_GET[c,p... and other variables are numbers or not.

How can that be done?

Regards

[yellow1912]

Guys, I'm in Houston and if you read the news, you know we have power outage here. And it's possible that, even when we got our power back, it may take a while for the internet to come back. So I apology for not being able to get back to you as soon as you may expect. I will, spend some time everyday when I get internet access (and power) at a friend's house to reply as many questions as possible.

[yellow1912]

Cobra, thanks for reporting that.
I believe that the alpha version I posted a few posts earlier should address that problem. If not, I will have it in place in the next version.

Regards.

Hello all,

I've just installed Simple SEO and it has benn working great.

After playing with some links i came acros some minor mistake.

If i type domain.com/category-one-c-1 it works, but if i misspell url like domain.com/category-one-c-1x i get MySql mistake

1054 Unknown column '1x' in 'where clause'
in:
[SELECT categories_name FROM categories_description WHERE categories_id =1x LIMIT 1]

aslo get the mistake with product (if i type x behind product number)

1054 Unknown column '3x' in 'where clause'
in:
[SELECT d.products_name, p.products_type FROM products p, products_description d WHERE p.products_id =3x AND d.products_id= p.products_id LIMIT 1]

I guess there should be some kind of checking if $_GET[c,p... and other variables are numbers or not.

How can that be done?

Regards

[yellow1912]

You may want to "view source" your site, and the check the google analytics code at the very end of your page. It is very possible that the module uses zen's href link, if so we just need to add an exception in admin.

First post, but long time follower...

I installed Simple SEO about a week ago and it's been working perfectly - great mod! I also use Paypal IPN and have not had any trouble.

However, I did notice that my Adwords tracking has suddenly gone to 0. My Google analytics are still working fine, but the tracking of Adwords inside Google Analytics is now missing.

I'm wondering if this may have something to do with the gclid= ID tag from Adwords that may be getting messed up somehow...

I also have the Google Analytics mod installed.

Here's our website: www.craftaroo.com

If anyone else has had any problems or found a resolution I'd really appreciate your help.

Note: this is not a major problem. Adwords clicks are still getting through to the correct pages and everything else is working perfectly. Just wondering why Google Analytics has lost the tracking of Adwords impressions and clicks...

Thanks!
Chris

[yellow1912]

YOu may want to clear cache again and see if that fixes. I dont use that module, so it's hard for me to actually figure out why the error happens until I really see it (and checking the error code etc....)

If that still does not fix the problem, I suggest you set up at test site online and send me over the info, I will check it for you.

Regards

Me again, sorry for repetitive posting.
I am testing further the contrib, and did find an error.
If you go to my site you will see that all products have lots of color attributes.
It would be impossible for me to publish all colors full size, so I use a contrib called "Attribute pop-up (large images)".
Now, this doesn't work with SSU, I am positive because I get the images in the popup back when turning SSU off in Admin.
Sorry, but cannot load this contrib yet on the live site until I make sure that it won't cause any disruption.
If you would I can post a snapshot of error.
One more thing: in module manager, the contrib still shows as beta 2.5, even after updating database.
Thanks.

[ckosloff]

YOu may want to clear cache again and see if that fixes. I dont use that module, so it's hard for me to actually figure out why the error happens until I really see it (and checking the error code etc....)

If that still does not fix the problem, I suggest you set up at test site online and send me over the info, I will check it for you.

Regards

Yellow,
Sorry to hear about your hurricane-related problems.
I live in South Florida, so I know what you are talking about.
Regarding this issue, I tried everything: clearing cache, upgrading database, restarting comp, etc., no joy.
The module is available in the downloads area:
http://www.zen-cart.com/index.php?ma...roducts_id=616
I will set up an online test site but you have to give me some guidelines on what you want: a top-level domain, a sub-domain, etc.
Thanks for continuing support.

[yellow1912]

You can set it up any way you want. For example, if you have a store at site.com, you may want to set it up at test.site.com or at site.com/test

Regards

[christo]

You may want to "view source" your site, and the check the google analytics code at the very end of your page. It is very possible that the module uses zen's href link, if so we just need to add an exception in admin.

First of all, I've been watching the news here from Hong Kong and my thoughts go out to you and everyone there in Houston. I hope you're ok - it certainly looks devastating from here...

I appreciate your help with this, thanks yellow1912...

OK... Here's the 'view source' from the footer of the site.

<script type="text/javascript">
<!--
if(!gaJsHost) {
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
}
//-->
</script>
<script type="text/javascript">
<!--
if(!pageTracker) {
var pageTracker = _gat._getTracker('UA-removed-1');pageTracker._initData();pageTracker._trackPageview();
}
//-->
</script>

I'm not sure what the exception to add might be... maybe something with ga.js?

I do know that the gclid passed from the web ad gets translated in the URL from:

www.craftaroo.com/catalog/index.php?main_page=product_info&cPath=14_15&products_id=115?gclid=CPyGo9ef3pUCFblahblahblahblah

to:

http://www.craftaroo.com/catalog/stickers-3d-c-14_15/party-masks-3d-sticker-p-115/gclid/CPyGo9ef3pUCFblahblahblahblah

Is there a way to disable the gclid URL attribute 'SEO-ization' the same way you handle the zenid attribute?

Take care,
Chris

[FairyAlchemy]

How many ways to have a mental breakdown......
Yellow I sooo need your help please..
After having a weekend away (much needed) after spending weeks building and installing my 3 shops ... (multisite, hover etc etc) I totally demolished them in the space of about 30secs and deleted the backup at the same time. Lesson learned never let your cat walk across your keyboard when you make tea.....

I've tried redoing the whole lot today and sod it I'll be happy with the one site as it needs to open this weekend, the rest i'll do on another server as I just have had a total melt down....

My brain is on shut down as i cannot sort this out
this is what is in the url

http://www.fairyalchemy.co.uk/shop/c..._ID_DELIMITER1
I use expression to work in and it has access problems due to the .htaccess but i can work round that if need be.. I know its prob not to difficult but with my last two brain cells threatening divorce i'm stumped.......

xxx

[yellow1912]

Go to admin-extras-ssu manager-clear cache.

How many ways to have a mental breakdown......
Yellow I sooo need your help please..
After having a weekend away (much needed) after spending weeks building and installing my 3 shops ... (multisite, hover etc etc) I totally demolished them in the space of about 30secs and deleted the backup at the same time. Lesson learned never let your cat walk across your keyboard when you make tea.....

I've tried redoing the whole lot today and sod it I'll be happy with the one site as it needs to open this weekend, the rest i'll do on another server as I just have had a total melt down....

My brain is on shut down as i cannot sort this out
this is what is in the url

http://www.fairyalchemy.co.uk/shop/c..._ID_DELIMITER1
I use expression to work in and it has access problems due to the .htaccess but i can work round that if need be.. I know its prob not to difficult but with my last two brain cells threatening divorce i'm stumped.......

xxx