Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sitemap contribution issue.


scotch33

Recommended Posts

Hi,

 

There is a link to a sitemap on the site I am building at http://www.onlinestopshopa.webserverworld.co.uk/ - it seems to be calling to a table that it doesn't see as existing as per below - does anyone know how I can get past this? Thanks!

 

1146 - Table 'onlinestopshopa.TABLE_PAGES' doesn't exist

 

select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from TABLE_PAGES p LEFT JOIN TABLE_PAGES_DESCRIPTION s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.sort_order > 0 order by p.sort_order, s.pages_title

 

[TEP STOP]

Link to comment
Share on other sites

What sitemap contribution are you using? If it is Sitemap MS2, then someone introduced code into that one that refers to a non-standard installation. You will need to remvoe that code, use a version that doesn't have it or use the Dynamic Sitemap contribution.

 

I forgot to mention that the extra code refers to the TABLE_PAGES and TABLE_PAGES_DESCRIPTION .

 

Jack

Edited by Jack_mcs

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

Link to comment
Share on other sites

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...