Jump to content
Jack_mcs

Dynamic SiteMap

Recommended Posts

Hi, i installed this contribution and get the following error on the sitemap page on my website:

 

1054 - Unknown column 'c.categories_status' in 'where clause'

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_status = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name

 

[TEP STOP]

 

Anyone have any ideas?

Share this post


Link to post
Share on other sites

I have installed this contribution and am getting the following error message:

 

1054 - Unknown column 'c.categories_status' in 'where clause'

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_status = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name

 

[TEP STOP]

 

Any help would be greatly appreciated.

Edited by keress

Share this post


Link to post
Share on other sites
I have installed this contribution and am getting the following error message:

Any help would be greatly appreciated.

Hi, as Jack has stated above, this comes from installing v1.4, install v1.3 instead and you will have no problems. Thats how I solved my problem.

Share this post


Link to post
Share on other sites

I just installed v1.4 and I get this error when I click on the Sitemap link

 

1054 - Unknown column 'c.categories_status' in 'where clause'

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_status = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name

 

Any idea where to even start with this?

Share this post


Link to post
Share on other sites

I'm getting the "Unable to determine the page link!" and having trouble understanding this reply:

 

Some of the infoboxes should not be added to the sitemap and are automatically excluded by the code. But I built this on a standard shop so it cannot account for each setup. I have uploaded a changed version. Just copy the includes/modules/dynamic_sitemap.php file to your site. It will still fail but should give an error message at the top of the window indicating which infobox is causing the problem. You will then need to add that to the list of known boxes in that same file. That should eliminate the errors.

 

Are you saying this error message comes from it not being able to find an infobox listed somewhere? And where is this dynamic_sitemap.php you're referring to?

 

Also, I thought this contribution would also list all the product page in each category. Was I mistaken?

Share this post


Link to post
Share on other sites

No, it can find the infobox but cannot understand the format of the code used in that box. You need to add it to the excluded list in includes/modules/dynamic_sitemap.php.

 

Sitemaps don't generally list product pages. If you want a product listing, you should install All Products.

 

Jack

Share this post


Link to post
Share on other sites

just installed 1.4 and o nthe site map page i get this

 

1054 - Unknown column 'c.categories_status' in 'where clause'

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_status = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name

 

[TEP STOP]

Share this post


Link to post
Share on other sites

The code for that file is for a stock shop. Since your shop is not stock, you have to change the code for the page so that it dislays correctly on your shop.

 

Jack

Share this post


Link to post
Share on other sites

I think there is a problem with 1.4 as I have just over writen the 1.4 files with 1.3 and it now works fine apart from it wants to be made to look a bit more organised.

Share this post


Link to post
Share on other sites

Look in your includes/boxes directory. You probably have an old copy of your information box.

 

Jack

Share this post


Link to post
Share on other sites

Hi jack,

 

A few post back I saw that you where gone find a way to get the underscores shown in the site map out.

 

did you already found a solution for that?

 

I installed your sitemap today and it went really easy, thank you for that

 

Denice

Share this post


Link to post
Share on other sites

Hi jack,

 

A few post back I saw that you where gone find a way to get the underscores shown in the site map out.

 

did you already found a solution for that?

 

I installed your sitemap today and it went really easy, thank you for that

 

Denice

Share this post


Link to post
Share on other sites

I don't know what you are referring to. If you could quote what I said I would be better able to reply.

 

Jack

Share this post


Link to post
Share on other sites
I don't know what you are referring to. If you could quote what I said I would be better able to reply.

 

Jack

Hi,

 

sorry for that, its a reply you gave in post33

 

I hadn't noticed the underscores before. The names are just taken from the filename. I'll change that at some point. It doesn't affect the result with the SE's though. It is just an appearance problem.

 

If you post the box that is breaking it, I will look at it.

 

Denice

Share this post


Link to post
Share on other sites

Ah, yes I recall now. No, I haven't had time to look at that although it is planned.

 

Jack

Share this post


Link to post
Share on other sites

I haven't tried the following but I think it will work. Find this line of code in includes/classes/categories_tree.php:

    $result .= str_repeat($this->spacer_string, $this->spacer_multiplier * $level) . '<a title="'. $category['name'] . '" href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $category_link) . '">';

and change it to

    $result .= str_repeat($this->spacer_string, $this->spacer_multiplier * $level) . '<a class="someclass" title="'. $category['name'] . '" href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $category_link) . '">';

The add a someclass class to your stylesheet.css file and set the font weight to bold.

 

Jack

Share this post


Link to post
Share on other sites

Hi Jack,

I have installed a forum and a few other pages since installing this sitemap but they don't seem to be showing up on the sitemap.

Any ideas?

If not is there any way of adding them manually?

Thanks, Lee.

Edited by lee246

Share this post


Link to post
Share on other sites

Are they php files? If not, that's why since the code only looks for php files.

 

Jack

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×