Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dynamic sitemap problem


RCWS

Recommended Posts

Posted

1146 - Table 'db182022396.TABLE_SITEMAP_EXCLUDE' doesn't exist

 

select exclude_file from TABLE_SITEMAP_EXCLUDE where exclude_type != "0" and is_box="1"

 

[TEP STOP]

 

 

Does anyone know what would cause this ?

 

It gives this error when you click on the link "Sitemap"

 

www.rivercitywebsolutions.com/sheetmusicstore

 

Thanks in advance!

Toby Wilson

Posted

That was the problem!

 

Thanks for the help...........

I dont remember changing the file........I must have uploaded over it by mistake.\

 

Just an easy reminder to KEEP A GOOD BACKUP!!!!!!!!!

Toby Wilson

  • 1 year later...
Posted
dynamic_sitemap.php is defined in includes/filenames.php?

 

 

Gday I am getting the same error.

I have checked filenames.php & dynamic_sitemap is defined...

 

define('FILENAME_DYNAMIC_SITEMAP', 'dynamic_sitemap.php');

 

Any suggestions?

 

(when I press the Sitemap link):

1146 - Table 'bonzabuy_osc1.TABLE_SITEMAP_EXCLUDE' doesn't exist

 

select exclude_file from TABLE_SITEMAP_EXCLUDE where exclude_type != "0" and is_box="1"

 

[TEP STOP]

 

I have imported the install SQL through myadmin.

I deleted it & tried again - no change.

 

If I try to re-install without deleting I get error:

" MySQL said: Documentation

#1050 - Table 'sitemap_exclude' already exists "

 

 

In my admin Sitemap-Exclude does exist... but when trying to access it (bonzabuy_osc1.TABLE_SITEMAP_EXCLUDE) it says it doesn't exist

 

The contrib seems to be working admin side...

 

Any ideas?

Posted

I have now sorted this problem - I read another post that said there may be a problem with my database_tables.php file.

I had failed to overwrite this file when doing the install.

 

Thankyou

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...