Problem with Sitemap contrib?

[pafranklin]

Hi, I installed the excellent Sitemap contrib (Site Map MS2 - 2.3), but now have a slight problem with it.

 

The resulting page has an error that I think is caused somehow by the information box. Here is the sitemap page http://www.pianocoversonline.co.uk/catalog/sitemap.php.

 

Can anyone offer a suggestion as I am still fairly new to PHP (but learning fast!).

 

Very many thanks.

 

Paul.

[equilla]

Hi,

 

it's the stuff in capitals (i.e. TABLE_PAGES) that indicate your problem.

 

If you recheck the installation instructions, hopefully you should find a line that should have been added to /catalog/includes/database_tables.php which probably looks something like this:

 

define ('TABLE_PAGES', 'thenameoftheactualtable');

 

Then, the script will replace TABLE_PAGES with the name of the mysql table it should be looking for and that error should go away (assuming you have created this database table of course!).

 

Sorry I can't be more specific - I haven't actually used this contrib before.

 

HTH,

 

 

 

 

Oops! Forgot to mention that you also need to add a similar line to cover the TABLE_PAGES_DESCRIPTION table as well.

 

Mark

[pafranklin]

Hi, Many thanks for this.

 

I have checked the installation instructions but there is no reference at all to making any changes in the database_tables.php file.

 

I have checked that I carried out the install correctly and so am now stumped. Is tere anything you cn suggest as this seems to work really well except for the recal of the items in the information box. Is there something I can do around this to configure properly?

 

Many thanks.

[equilla]

Hi, Many thanks for this.

 

I have checked the installation instructions but there is no reference at all to making any changes in the database_tables.php file.

 

I have checked that I carried out the install correctly and so am now stumped. Is tere anything you cn suggest as this seems to work really well except for the recal of the items in the information box. Is there something I can do around this to configure properly?

 

Many thanks.

Hi Again,

 

do you have the information pages contribution installed because I'm guessing that this is what that section of the code for the sitemap contribution is trying to cover. If you don't have it installed, you could either:

 

1. Install in the information pages contribution

2. Remove/comment out the code from the sitemap contribution that trys to present it.

 

Regards,

 

 

 

 

Mark

[luckyhuckster]

Hi, Many thanks for this.

 

I have checked the installation instructions but there is no reference at all to making any changes in the database_tables.php file.

 

I have checked that I carried out the install correctly and so am now stumped. Is tere anything you cn suggest as this seems to work really well except for the recal of the items in the information box. Is there something I can do around this to configure properly?

 

Many thanks.

 

This sounds very similar to the problem I had when I first installed sitemap. There is a thread here where I explain to another sufferer what I did to solve the problem. It may work for you. Be sure to heed my warning! I am not a php wiz.

 

Hope it helps though.

 

Simon