devot:eeDevoted to ExpressionEngine

Hi

I have just tried to install the module and I get the following error:

A Database Error Occurred

Error Number: 1366

Incorrect integer value: ‘’ for column ‘extension_id’ at row 1

INSERT INTO `exp_extensions` (`extension_id`, `class`, `method`, `hook`, `settings`, `priority`, `version`, `enabled`) VALUES (’‘, ‘Sitemap_ext’, ‘ping_sitemap’, ‘entry_submission_absolute_end’, ‘’, 10, ‘2.5.1’, ‘y’)

Filename: C:\Apache2.2\htdocs\######\site\ee\codeigniter\system\database\DB_driver.php

Line Number: 330

Many thanks

Jonathan

please upgrade the Sitemap Module to version 2.5.2 and let me know if this fixes the issue

Ok I had literally just purchased the module - did not realise there was an upgrade already.

Sorry now I get

A Database Error Occurred

Error Number: 1364

Field ‘statuses’ doesn’t have a default value

INSERT INTO `exp_sitemap` (`url`, `site_id`, `change_frequency`, `priority`) VALUES (‘http://local.cornwallinnovation.co.uk/’, ‘1’, ‘’, ‘’)

Filename: C:\Apache2.2\htdocs\cornwallinnovation\site\ee\codeigniter\system\database\DB_driver.php

Line Number: 330

hmm what versions of PHP and MySQL are you on? i haven’t encountered these errors before…

PHP 5.3.8
MySQL 5.1.51

is the site running on windows? and do you have the ability to edit .ini files on it?

it sounds like your site might have strict mode enabled. can you please refer to this forum post and see if this fixes it?

Thanks - that seems to have done the trick.

I’m at a loss now as to how I add all the pages I have the website though - all I can see is an entry for each of the channels. I have multiple pages that use the same channels. Any pointers would be much appreciated.

you should see every entry for each included channel in your outputted sitemap template… do you not?

Yes I see that no problem. But I am unsure how this relates to the multiple pages that use these few channels, all with separate page_uri’s.

Forgive my ignorance.

ah i see. well the Sitemap module can only output one page per entry. does this not work for your site? what is the page structure that you are trying to achieve?

Ok then I do not think it will work for my pages nor my channels.

I don’t suppose you do a refund policy?

yes, you can request one through your devot-ee account. sorry it didn’t work out for you.