Module

Developer
Supported

Sitemap Module

ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5

Back to this add-on's main page
View Other Add-ons From PutYourLightsOn

     

You must be logged in to post.

Errors all around after update 1.7 to 2.1.3

General

Erwin Heiser
Erwin Heiser

The EE update went fine and I installed the EE2 version of the sitemap module according to the instructions.
I’m getting errors:
1. when I try to enter the settings in the cp in the add-ons>modules>sitemap screen, I get the following:

A Database Error Occurred

Error Number
1060

Duplicate column name 
'site_id'

ALTER TABLE exp_sitemap ADD COLUMN site_id VARCHAR(10NOT NULL AFTER url

Filename
third_party/sitemap/upd.sitemap.php

Line Number
136 

2. When I try to post an article, on submission:

A Database Error Occurred

Error Number
1054

Unknown column 
'channel_id' in 'where clause'

SELECT status FROM exp_sitemap WHERE channel_id '3'

Filenamethird_party/sitemap/ext.sitemap.php

Line Number
45 

Any suggestions?

PutYourLightsOn
# 1
Developer
PutYourLightsOn

to be honest i haven’t had a chance to test updating from 1.7 to 2.1.3. the easiest fix is to simply uninstall and then install the module, however you will have to re-enter your settings. if this is not something you want to do then let me know and i will look into this compatibility issue.

Erwin Heiser
# 2
Erwin Heiser

I uninstalled then reinstalled, no errors now but it’s taking a long time (21s) to load the modules>sitemap settings screen. The same for adding a location and updating. Any ideas what’s causing this?

PutYourLightsOn
# 3
Developer
PutYourLightsOn

no idea, is it really just this page that is loading slowly?