Developer
Supported

## Sitemap Module

ExpressionEngine 2, ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5, ExpressionEngine 6

 You must be logged in to post.

## EE 2.5.2 Installation error

### Support (Resolved)

linedup
 Posted: 08 August 2012 06:04 AM

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

PutYourLightsOn
 Posted: 08 August 2012 06:17 AM
Developer

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

linedup
 Posted: 08 August 2012 06:19 AM

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

linedup
 Posted: 08 August 2012 06:23 AM

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

PutYourLightsOn
 Posted: 08 August 2012 06:53 AM
Developer

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

linedup
 Posted: 08 August 2012 08:03 AM

PHP 5.3.8
MySQL 5.1.51

PutYourLightsOn
 Posted: 08 August 2012 08:49 AM
Developer

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

PutYourLightsOn
 Posted: 08 August 2012 08:52 AM
Developer

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

linedup
 Posted: 08 August 2012 10:50 AM

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.

PutYourLightsOn
 Posted: 08 August 2012 11:51 AM
Developer

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

linedup
 Posted: 08 August 2012 11:53 AM

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.

PutYourLightsOn
 Posted: 09 August 2012 04:48 AM
Developer

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?

linedup
 Posted: 09 August 2012 09:18 AM

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

I don’t suppose you do a refund policy?

PutYourLightsOn
 Posted: 09 August 2012 09:29 AM
Developer

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