Sitemap issue - please help...!!

[epstudent]

Hi,

 

I feel like a doofus coz i can't work out what i've done wrong but 've just tried using this contribution

(http://www.oscommerce.com/community/contributions,2208) to add a sitemap to my site... this is the new sitemap page

and now on this new sitemap page I get this error:

 

1146 - Table 'db105646753.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]

 

it didn't say anything about creating a new table but i really don't know how to fix it - any help would be really appreciated

 

hopefully once it's fixed, my right hand column and footer content will re-appear!!

 

many many thanks in advance!

[Jack_mcs]

Read this.

 

Jack