Developer
Supported
Sitemap Module
ExpressionEngine 2, ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5, ExpressionEngine 6
Back to this add-on's main page
View Other Add-ons From PutYourLightsOn
EE 2.5.2 Installation error
Support (Resolved)
linedup
|
Posted: 08 August 2012 05: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 05:17 AM |
# 1
|
|
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 05:19 AM |
# 2
|
|
|
Ok I had literally just purchased the module - did not realise there was an upgrade already.
|
|
|
linedup
|
Posted: 08 August 2012 05:23 AM |
# 3
|
|
|
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 05:53 AM |
# 4
|
|
Developer
|
hmm what versions of PHP and MySQL are you on? i haven’t encountered these errors before…
|
|
|
linedup
|
Posted: 08 August 2012 07:03 AM |
# 5
|
|
|
PHP 5.3.8
MySQL 5.1.51
|
|
|
PutYourLightsOn
|
Posted: 08 August 2012 07:49 AM |
# 6
|
|
Developer
|
is the site running on windows? and do you have the ability to edit .ini files on it?
|
|
|
PutYourLightsOn
|
Posted: 08 August 2012 07:52 AM |
# 7
|
|
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 09:50 AM |
# 8
|
|
|
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 10:51 AM |
# 9
|
|
Developer
|
you should see every entry for each included channel in your outputted sitemap template… do you not?
|
|
|
linedup
|
Posted: 08 August 2012 10:53 AM |
# 10
|
|
|
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 03:48 AM |
# 11
|
|
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 08:18 AM |
# 12
|
|
|
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 08:29 AM |
# 13
|
|
Developer
|
yes, you can request one through your devot-ee account. sorry it didn’t work out for you.
|
|
|