1097 replies to this topic

[enigma1]

chrisgeek, on Apr 25 2007, 02:31 AM, said:

A few more simple brief questions:

-When I installed the snippets of code into some of the files, there was an extra blank line at the end of each snippet. I deleted that blank line. Will that affect anything?

-I have the default SEO-G installed. My index.php page isn't showing up when I type in my webaddress: www.geekfitters.com

-I really don't want or need categories. Will Seo-G still work?

Chris

I see you haven't installed that properly. You used the included .htaccess directly? That meant to be an example to setup your own htaccess. Set it up properly then goto your osc Admi->SEO-G->G-Reports at the bottom hit the delete button so the SEO-G tables will be cleared.

And you should try it with v1.03. Follow the manual instructions.

[ogg2k]

installed 1.03 and same problem

index is normal but every other page is not.

http://www.airsoftsupplydrop.co.uk/store/s...-set-black.html

Thanks for the help

Rob

[ogg2k]

Sorry but i have had to remove it again as the checkout does not work

even with the page exclude it cant be found.

[grotius]

Hi there,

I was hoping someone could help me. I installed the module but i get this error in the admin page.

SEO-G Zones
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 '-60, 60' at line 1

select at.seo_types_id, at.seo_types_name, at.seo_types_class, at.seo_types_prefix, at.seo_types_handler from seo_types at order by at.sort_order limit -60, 60

[TEP STOP]

The same error is for SEO-G Reports. What did i do wrong? I hope someone could help me out.

Best regards,
Emiel

[enigma1]

ogg2k, on Apr 25 2007, 09:39 AM, said:

installed 1.03 and same problem

index is normal but every other page is not.

http://www.airsoftsupplydrop.co.uk/store/s...-set-black.html

Thanks for the help

Rob

all I get is a 404 page. Make sure you install it and check the manual instructions about the application_top.php The section in the root.php has to match the section in your application_top.php (minus the SEO-G relative parts). as the documentation states:

Quote

Also note, you need to port any custom modifications you have in that particular section of the application_top.php (now enclosed with the SEO-G tags) into the catalog\root.php. The included root.php uses part of the stock osC application_top.php file.

[enigma1]

grotius, on Apr 25 2007, 09:50 AM, said:

Hi there,

I was hoping someone could help me. I installed the module but i get this error in the admin page.

SEO-G Zones
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 '-60, 60' at line 1

select at.seo_types_id, at.seo_types_name, at.seo_types_class, at.seo_types_prefix, at.seo_types_handler from seo_types at order by at.sort_order limit -60, 60

[TEP STOP]

The same error is for SEO-G Reports. What did i do wrong? I hope someone could help me out.

Best regards,
Emiel

This error comes with the old osc code, the bug is documented here:
http://www.oscommerce.com/community/bugs,1605

Now the included catalog\admin\includes\classes\split_page_results.php includes that particular fix. If you use that file you should not see the problem. Now the other thing you should check are the fixes the latest osc version has.

http://www.oscommerce.com/solutions/downloads

[enigma1]

ogg2k, on Apr 25 2007, 09:46 AM, said:

Sorry but i have had to remove it again as the checkout does not work

even with the page exclude it cant be found.

For the shopping cart, I see, so you're using ajax buy now which modifies the generated link. This won't work because the url is translated by SEO-G inside the tep_href_link function and ajax buy now changes it again at the end and then it calls tep_href_link again. So the .html extension is already added to the link. And the ajax buy now parameters won't propagate. A link must be finalized before the SEO-G is called to translate it. And SEO-G must be called before the final session is appended for the link to be functional.

[PublicWholesaler]

enigma1, on Apr 25 2007, 08:02 AM, said:

No the code there is good. But there was a bug in the root.php of the SEO-G module. This should be fixed with v1.03. Let me know if this works for you.
I released v1.03 with the following changes:
- Added filter to process .php files only
- Improved create_safe_string to eliminate triple separators.
- Fix for loading non-php scripts

Yes, the new version solved my problems. Thank you for your hard work.

[grotius]

enigma1, on Apr 25 2007, 04:01 PM, said:

This error comes with the old osc code, the bug is documented here:
http://www.oscommerce.com/community/bugs,1605

Now the included catalog\admin\includes\classes\split_page_results.php includes that particular fix. If you use that file you should not see the problem. Now the other thing you should check are the fixes the latest osc version has.

http://www.oscommerce.com/solutions/downloads

Thanks! It works perfectly now

[bjanice44]

enigma1, on Apr 24 2007, 12:02 PM, said:

The xml maps is a valid point. I am planning to create the scripts to support at least a basic xml map. At this point I am still testing and validating various features of this module. If the initial design is not proper, everything will fall apart as other plugins rely in the seo database tables and associated structure.

I will need some feedback to see how to go on with this module. Not in terms of bug-fixes this is of course essential. But with the design aspect.

Right now the module will generate friendly urls for the entire store including every combination of parameters. Although this may look great at the beginning it includes a huge number of seo links spiders will never see. So should I integrate some extra configuration to control this behavior?

The exclusion list added with v1.02, can filter out scripts that spiders will never see like the customer various pages. Is it better to use an inclusion list instead?

I will make another release in the next couple of days where the parameters filtering is better. From the tests I did so far if you pass an invalid extension through the tep_href_link function it goes through the seo class. A filter will be included with next release to rectify this.

At this point the module's operation generating URLs is progressive. So after installation not all links from a site are generated immediately. Once you land at a page all the links in that page will be generated (if they do not exist). With xml maps I will have to write from scratch or convert one of the existing scripts to generate the important urls for the search engine. What will be the best way for it? Having a linkage between the tables so the manufacturer, category and product (or a combination of those) is added to the xml? Or a simpler method will be better.

As the search engines crawl the store now they see lots of redirections to the cookie page because simply they cannot add items to the cart or access personalized content. All these will be redirected to the cookies page. That's a default behavior with osCommerce. Now with SEO-G these links are converted showing html pages. I am still investigating this and the impact (if any) that it will have for rankings.

Also as the documentation states, with seasoned stores, it is not wise to move from one SEO module to another (or even switch the stock osc URLs). The rankings will be altered because search engines see new links. So keep that in mind.

I'll get back to the various links combinations issue as they generated and show few examples.

Hi there thanks for the reply. Looking at this mod a little closer...this thing is the real deal. This thing is in its own league compared to CRE SEOs and Ultimate SEO's. To be able to tell the system exactly the way you want to rewrite a certain product...that is marvelous. It is extremely flexible it seems. I'd love to try it out. I am currently using ultimate seo's. I took your comment about established stores not switching because of seo etc.. Let me ask you this..how much flexability is there in category rewrites? Here is an example of a product and category rewrite on my site using ultimate seo... Will I be able to set up seo-g to rewrite the same way? that way I wouldn't have to have all new links? I'd love to try it out..mainly for the fleability going forward for new products etc... I am running CRE loaded 6.2. I think I can get it to work...are there any issues with checkout etc...?It won't break my store will it?

Category (this is the subcategory page so it writes the main category plus the subcat in the rewrite)
http://www.nicebykelli.com/catalog/diaper-...es-c-64_73.html

This is a product:
http://www.nicebykelli.com/catalog/babys-f...-bank-p-77.html

This adds the product number 77 to the end. The category adds the cat # 64

Let me know if this will rewrite or can be configured to rewrite exactyl the same way.

[enigma1]

bjanice44, on Apr 25 2007, 02:15 PM, said:

Hi there thanks for the reply. Looking at this mod a little closer...this thing is the real deal. This thing is in its own league compared to CRE SEOs and Ultimate SEO's. To be able to tell the system exactly the way you want to rewrite a certain product...that is marvelous. It is extremely flexible it seems. I'd love to try it out. I am currently using ultimate seo's. I took your comment about established stores not switching because of seo etc.. Let me ask you this..how much flexability is there in category rewrites? Here is an example of a product and category rewrite on my site using ultimate seo... Will I be able to set up seo-g to rewrite the same way? that way I wouldn't have to have all new links? I'd love to try it out..mainly for the fleability going forward for new products etc... I am running CRE loaded 6.2. I think I can get it to work...are there any issues with checkout etc...?It won't break my store will it?

Category (this is the subcategory page so it writes the main category plus the subcat in the rewrite)
http://www.nicebykelli.com/catalog/diaper-...es-c-64_73.html

This is a product:
http://www.nicebykelli.com/catalog/babys-f...-bank-p-77.html

This adds the product number 77 to the end. The category adds the cat # 64

Let me know if this will rewrite or can be configured to rewrite exactyl the same way.

well ok, If I was in your place the first thing to do would be to create a copy of the store into your local pc. Then you can try it out safely into your local system and see what it does.

For the various re-writes the module includes lists of products, categories etc. names, where you can edit them quickly. Now of course you don't want to do that with many products. So you change the seo classes slightly those they insert the names to setup the defaults with the -p-"products_id" and -c-"cpath"

If you check the seo classes in catalog\admin\includes\classes folder each one of them has a function called "generate_name" This is where the name of an entity is created. It's different between classes because the database table in use is different. So for products say I could change the generate_name function so instead of this:

		$name = $names_array['products_name'];
		$name =  $this->create_safe_string($name);

I could do:

		$name = $names_array['products_name'] . '-p-' . $products_id;
		$name =  $this->create_safe_string($name);

havent tested anything here, but that's the theory anyways. And then you could change the scripts back once you finish with the existing products so the module will generate the full names with your new products

This way you don't have to spend ages updating hundreds or thousands of products to maintain name compatibility. Again you should test everything locally.

I will release v1.04 shortly (still testing), which will include a couple of fixes, as well as a safe mode of operation where the user can select if the links should be generated only for known parameters (like products_id, cpath etc) or for all parameters in the store (reviews_id, action etc). So when in safe mode it should take care of some of the problems that mentioned earlier like with the ajax buy now contribution.

Edited by enigma1, 25 April 2007, 19:49.

[bjanice44]

enigma1, on Apr 25 2007, 03:48 PM, said:

well ok, If I was in your place the first thing to do would be to create a copy of the store into your local pc. Then you can try it out safely into your local system and see what it does.

For the various re-writes the module includes lists of products, categories etc. names, where you can edit them quickly. Now of course you don't want to do that with many products. So you change the seo classes slightly those they insert the names to setup the defaults with the -p-"products_id" and -c-"cpath"

If you check the seo classes in catalog\admin\includes\classes folder each one of them has a function called "generate_name" This is where the name of an entity is created. It's different between classes because the database table in use is different. So for products say I could change the generate_name function so instead of this:

		$name = $names_array['products_name'];
		$name =  $this->create_safe_string($name);

I could do:

		$name = $names_array['products_name'] . '-p-' . $products_id;
		$name =  $this->create_safe_string($name);

havent tested anything here, but that's the theory anyways. And then you could change the scripts back once you finish with the existing products so the module will generate the full names with your new products

This way you don't have to spend ages updating hundreds or thousands of products to maintain name compatibility. Again you should test everything locally.

I will release v1.04 shortly (still testing), which will include a couple of fixes, as well as a safe mode of operation where the user can select if the links should be generated only for known parameters (like products_id, cpath etc) or for all parameters in the store (reviews_id, action etc). So when in safe mode it should take care of some of the problems that mentioned earlier like with the ajax buy now contribution.

Ok, sounds good. So the script actually stores the rewrite name in the database?

[bruyndoncx]

Hi, this looks like a versatile mod, but I'm having a problem getting my head around it.
In a shop products are added and/or removed on a daily basis. Do you need to run the admin update each time to generate the SEO urls for newly added products ?

[PublicWholesaler]

enigma1, on Apr 25 2007, 02:48 PM, said:

well ok, If I was in your place the first thing to do would be to create a copy of the store into your local pc. Then you can try it out safely into your local system and see what it does.

For the various re-writes the module includes lists of products, categories etc. names, where you can edit them quickly. Now of course you don't want to do that with many products. So you change the seo classes slightly those they insert the names to setup the defaults with the -p-"products_id" and -c-"cpath"

If you check the seo classes in catalog\admin\includes\classes folder each one of them has a function called "generate_name" This is where the name of an entity is created. It's different between classes because the database table in use is different. So for products say I could change the generate_name function so instead of this:

		$name = $names_array['products_name'];
		$name =  $this->create_safe_string($name);

I could do:

		$name = $names_array['products_name'] . '-p-' . $products_id;
		$name =  $this->create_safe_string($name);

havent tested anything here, but that's the theory anyways. And then you could change the scripts back once you finish with the existing products so the module will generate the full names with your new products

This way you don't have to spend ages updating hundreds or thousands of products to maintain name compatibility. Again you should test everything locally.

I will release v1.04 shortly (still testing), which will include a couple of fixes, as well as a safe mode of operation where the user can select if the links should be generated only for known parameters (like products_id, cpath etc) or for all parameters in the store (reviews_id, action etc). So when in safe mode it should take care of some of the problems that mentioned earlier like with the ajax buy now contribution.

In the new version, can you accommodate a means for it to ignore the /admin file? I love the contribution, but I am still having problems with .php pages from within my /Admin redirecting. my structure is:
www.mysite.com
www.mysite.com/admin
so as is, it is redirecting any .php files in my /admin folder as well. Perhaps providing the option to exclude folders in the main directory, so i can have it ignore /Admin/ altogether. I wish I knew more about this stuff, but I can say what you have accomplished with this mod is outstanding! Thanks Again

[enigma1]

bjanice44, on Apr 25 2007, 03:49 PM, said:

Ok, sounds good. So the script actually stores the rewrite name in the database?

yes it does, the product, categories, manufacturers and in general names are stored in the database. So you do not lose changes.

[enigma1]

bruyndoncx, on Apr 25 2007, 04:45 PM, said:

Hi, this looks like a versatile mod, but I'm having a problem getting my head around it.
In a shop products are added and/or removed on a daily basis. Do you need to run the admin update each time to generate the SEO urls for newly added products ?

There is no automation to that respect yet but it can be added. Perhaps I could add a global button to setup all related tables with the new names. Old, non-existend parameters where links are stored will be deleted and then the root.php will do the regular 301 redirect if a link is not present (does that part).

[chrisgeek]

Thank you for your help. I followed your advice:

I changed the htaccess file. I updated the files that were updated in version 1.3. Unfortunately, things got a little worse! Now, when I am logged in to admin, I can't access configure or any file for that matter. Instead, I get the cookie usage error page. Any thoughts?

Thank you in advance,

Chris

[enigma1]

PublicWholesaler, on Apr 25 2007, 05:52 PM, said:

In the new version, can you accommodate a means for it to ignore the /admin file? I love the contribution, but I am still having problems with .php pages from within my /Admin redirecting. my structure is:
www.mysite.com
www.mysite.com/admin
so as is, it is redirecting any .php files in my /admin folder as well. Perhaps providing the option to exclude folders in the main directory, so i can have it ignore /Admin/ altogether. I wish I knew more about this stuff, but I can say what you have accomplished with this mod is outstanding! Thanks Again

I may have to see this as an actual link. I tried it locally few times, but I cannot replicate it.

[enigma1]

Ok I did the v1.04 release. It should fix a couple of issues as mentioned previously and includes a Safe Mode function.

For the admin issue can you try to access a valid script directly? so instead of doint
www.mysite.com/admin/
to login do:

www.mysite.com/admin/index.php
php scripts aren't filtered. They should go right through.

Edited by enigma1, 26 April 2007, 02:12.

[PublicWholesaler]

enigma1, on Apr 25 2007, 09:12 PM, said:

Ok I did the v1.04 release. It should fix a couple of issues as mentioned previously and includes a Safe Mode function.

For the admin issue can you try to access a valid script directly? so instead of doint
www.mysite.com/admin/
to login do:

www.mysite.com/admin/index.php
php scripts aren't filtered. They should go right through.

I have played around with it some.
Here are my symptoms:
If I go to a direct URL:
mysite.com/admin/index.asp
everything works fine. But on my initial login, instead of a clean link, it is giving me a link like:
http://mysite.com/admin/categories.php?selected_box=catalog&osCAdminID=b0f76b4a512a847c274bfb8d08914d5

This link leads to a redirection whereas the clean link version:
http://mysite.com/admin/categories.php
takes me where i want to go.

Not sure if this is something that can be fixed, but at least I know I can work around it for the time being.

Thanks Again