Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

I just installed this contrib and would really like it to work. The page looks great and the infobox link work great but I have this error on the page. What can I do to fix it?

 

Site Map

 

 

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]

 

Thank you

delite163

 

<_< <_<

Posted
Try using the last version I uploaded. The one you have is not meant for most shops.

 

Jack

Hi Jack,

Are talking about Dynamic SiteMap V 1.3?

Thank you

Delite163

Posted
Yes.

 

Jack

 

Hi Jack,

I installed sitemapv1.3 and when I was finished and looked at the site the sitemap link didn't show up so I went to admin store config and turned un use search engine safe urls from false to true and then checked the index.php page and I got the error. If I return the use search engine safe urls back to false the error goes away but the sitemap link still isn't there. What else can I do?

Thank you

delite163

Posted

You shouldn't have the SEF option enabled, unless you are using the SEF contribution that requires it. But as far as the sitemap is concerned, that wouldn't make a difference either way. First, see if it is installed correctly by go to http://your_site.com/dynamic_sitemap.php. If the sitemap doesn't display, then it is not installed correctly. If it does display, then you have a problem with the link you added for the sitemap. Post it here if you can't find a problem with it.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted
You shouldn't have the SEF option enabled, unless you are using the SEF contribution that requires it. But as far as the sitemap is concerned, that wouldn't make a difference either way. First, see if it is installed correctly by go to http://your_site.com/dynamic_sitemap.php. If the sitemap doesn't display, then it is not installed correctly. If it does display, then you have a problem with the link you added for the sitemap. Post it here if you can't find a problem with it.

 

Jack

 

Hi Jack,

I went through the pages that I had to edit and found that in boxes/information.php I had two ); changed that and that worked like a charm. The sitemap is wonderful and very robust.

Thanks so much for the help.

delite163

Posted
Hi Jack,

I went through the pages that I had to edit and found that in boxes/information.php I had two ); changed that and that worked like a charm. The sitemap is wonderful and very robust. Oh one other thing could you recommend a good seo contrib?

Thanks so much for the help.

delite163

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...