On another thread, I reported issues with an upgrade from 1.x to 2.x and was told a procedure to de-install 1.x and reinstall 2.x. This got rid of the error messages I was seeing, but results in some other questions and it was requested that I post these in a new thread, so here they are:
On 6.x-1.x there were 8 modules and now there are 3, but there are no configuration settings that I see which would explain the difference. Missing are:
Engines
File
Helper
Term
User
Of these, I previously had all enabled except user. So, what has happened here?
Also, I am wondering how it is that one verifies that everything is now working again, unless it is by adding a new node and checking to see that it appears. I *did* try the Rebuild tab ... but after quite a while on a small site it is stuck at 4 of 7 remaining 43% and there are only three pages worth of nodes under Content, so it isn't as if this is a big site. I reported an log error message message about a reference to xmlsitemap1.xml somewhere around this time, but I don't know if it is related.
Comments
Comment #1
dave reidThe 6.x-2.x version is completely different and not yet finished. As I explained in the other thread, you cannot upgrade from one version to the next without disabling the modules, uninstalling them via admin/build/modules/uninstall, and making sure to actually remove the module files before upgrading.
The problems you are seeing is because there are remnants of the 6.x-1.x version when you are trying to use the 6.x-2.x version. It's like trying to use Drupal 6 when you didn't completely upgrade from Drupal 5. It's not going to work.
Comment #2
tamhas commentedBut, I did follow your recommended procedure. I replaced the 1.x code, disabled, uninstalled, rm -rf the 1.x code, installed the 2.x code and enabled the modules. What did I miss?
Comment #3
dave reidDid you uninstall using admin/build/modules/uninstall? Can you describe what's in the sites/all/modules/xmlsitemap folder (or wherever you installed the module) in your Drupal install?
Comment #4
tamhas commentedYes, I uninstalled using the tab on the Admin modules page.
[cintegrity][~/site/www/bin/drupal-6.10/sites/all/modules/xmlsitemap]$ ll
total 116
-rw-r--r-- 1 cintegrity vuser 120 Apr 30 14:59 CHANGELOG.txt
-rw-r--r-- 1 cintegrity vuser 14940 Apr 23 2006 LICENSE.txt
-rw-r--r-- 1 cintegrity vuser 2196 May 1 14:17 README.txt
drwxr-xr-x 2 cintegrity vuser 4096 May 2 06:58 images
-rw-r--r-- 1 cintegrity vuser 1326 May 1 18:22 xmlsitemap-xml.css
-rw-r--r-- 1 cintegrity vuser 4317 May 1 18:22 xmlsitemap-xml.js
-rw-r--r-- 1 cintegrity vuser 8238 May 1 14:17 xmlsitemap.admin.inc
-rw-r--r-- 1 cintegrity vuser 1738 May 1 14:17 xmlsitemap.api.php
-rw-r--r-- 1 cintegrity vuser 373 May 2 06:58 xmlsitemap.info
-rw-r--r-- 1 cintegrity vuser 5787 May 1 14:17 xmlsitemap.install
-rw-r--r-- 1 cintegrity vuser 22775 May 1 18:36 xmlsitemap.module
-rw-r--r-- 1 cintegrity vuser 5280 May 1 18:36 xmlsitemap.pages.inc
-rw-r--r-- 1 cintegrity vuser 4246 May 1 14:17 xmlsitemap.test
drwxr-xr-x 2 cintegrity vuser 4096 May 2 06:58 xmlsitemap_menu
drwxr-xr-x 2 cintegrity vuser 4096 May 2 06:58 xmlsitemap_node
Comment #5
dave reidHmm...that's the correct version. Can you also run this SQL on your database as well?
SELECT filename, status, schema_version FROM system WHERE name LIKE 'xmlsitemap%';Comment #6
tamhas commented+---------------------------------------------------------------------------+--------+----------------+
| filename | status | schema_version |
+---------------------------------------------------------------------------+--------+----------------+
| sites/all/modules/xmlsitemap/xmlsitemap.module | 1 | 0 |
| sites/all/modules/xmlsitemap/xmlsitemap_engines/xmlsitemap_engines.module | 0 | -1 |
| sites/all/modules/xmlsitemap/xmlsitemap_file/xmlsitemap_file.module | 0 | 6112 |
| sites/all/modules/xmlsitemap/xmlsitemap_helper/xmlsitemap_helper.module | 0 | 0 |
| sites/all/modules/xmlsitemap/xmlsitemap_menu/xmlsitemap_menu.module | 1 | 0 |
| sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module | 1 | 0 |
| sites/all/modules/xmlsitemap/xmlsitemap_term/xmlsitemap_term.module | 0 | -1 |
| sites/all/modules/xmlsitemap/xmlsitemap_user/xmlsitemap_user.module | 0 | -1 |
+---------------------------------------------------------------------------+--------+----------------+
8 rows in set (0.00 sec)
Comment #7
avpadernoHe also reported an error about a sitemap chunk being accessed, but not found; the URL of the chunk is something like http://example.com/sitemap.xml/1. The strange is that his sitemap doesn't contain any chunks.
Comment #8
dave reid@tarnhas: I guess there's part of the problem. Technically the xmlsitemap_file and xmlsitemap_helper modules were never properly uninstalled. Make sure to run this SQL:
UPDATE system SET schema_version = -1 WHERE name = 'xmlsitemap_helper' OR name = 'xmlsitemap_file';The problem with your rebuild batch is most likely an error I had in the xmlsitemap_menu rebuild code that was fixed last night. Be sure to download the lastest version and try it again.
I'm still not sure about the sitemap chunk being accessed. The actual location referred to in the other issue (#451258-6: 6.x-2.x-dev must be a clean install - *DO NOT UPGRADE*) was "http://www.reviewsbytdev.com/sitemap1.xml" which is a 6.x-1.x style chunk location, so I'm guessing that a search engine had already tried visiting that location successfully under the 6.x-1.x code. When you updated (and the search engine didn't know that you updated), that path was no longer valid, and so when it went to request it again, hence the page not found error.
Comment #9
dave reid@tarnhas: With regards to only having three modules so far, that's all that have been rewritten so far that I feel ready to have tested by more than myself. :)
It looks like your site's sitemap is working just fine now: http://www.reviewsbytdev.com/sitemap.xml. Please let me know if there are any more issues.
Comment #10
tamhas commentedOK, I deactivated the existing modules, uninstalled them, rm -rf the directory, downloaded the latest, tared that into place, and re-enabled. Now the rebuild runs to completion quite quickly. On the first page back from the rebuild I got
# user warning: Duplicate entry 'Contact' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('menu', 277, 0, 'Contact', 0, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/1' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 1, 1, 'node/1', 1233358838, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/2' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 2, 1, 'node/2', 1233796098, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/3' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 3, 1, 'node/3', 1234212775, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/7' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 7, 1, 'node/7', 1234541372, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/8' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 8, 1, 'node/8', 1234376957, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/41' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 41, 1, 'node/41', 1233933606, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/88' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 88, 1, 'node/88', 1234117754, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
But, refreshing the page those all went away. The sitemap itself seems to have more things in it and the dates are all current.
I am a little curious as to why this 2.x release would show up as an update in the status when it was not yet complete.
Comment #11
dave reid@tamhas: Update module will show all the development releases if you're currently using a development release. That's just the way update status works. That's why there are release notes for module downloads. In the case of the 6.x-2.x-dev release, it's release notes state:
Hmm...I'm not sure why you'd be getting those duplicate insert warnings. I will check on that!
Comment #12
tamhas commentedWhat is it that puts something in the "Also available" group ... being beta? If so, I would think that something that was not finished should by definition be beta. But, which said, the rebuild worked a treat and I think added a lot of nodes, so we may be better off with this than what was there before.
Now to see if I can clean up the other two sites ... since they are on a common code base, this might have some tricky aspects.
Comment #13
tamhas commentedBoth other sites updated without incident. I had previously uninstalled 1.x on them and not gone forward from that point, so I guess they were actually in a pretty clean state. Both did a rebuild with no issue and both had similar messages on the first screen after the rebuild, but so far not after a refresh or elsewhere. Here are the messages from one of those sites.
# user warning: Duplicate entry 'node/2' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 2, 1, 'node/2', 1238277692, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/3' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 3, 1, 'node/3', 1234483491, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/4' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 4, 1, 'node/4', 1234491674, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/6' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 6, 1, 'node/6', 1234483292, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/7' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 7, 1, 'node/7', 1234483320, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/8' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 8, 1, 'node/8', 1233536541, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/10' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 10, 1, 'node/10', 1234483923, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/11' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 11, 1, 'node/11', 1233447126, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/13' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 13, 1, 'node/13', 1232477921, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/14' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 14, 1, 'node/14', 1234483697, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/17' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 17, 1, 'node/17', 1233536586, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/18' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 18, 1, 'node/18', 1234550374, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/19' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 19, 1, 'node/19', 1234294231, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/20' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 20, 1, 'node/20', 1234484609, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/22' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 22, 1, 'node/22', 1238446660, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/23' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 23, 1, 'node/23', 1234310211, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/25' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 25, 1, 'node/25', 1236554210, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/28' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 28, 1, 'node/28', 1234483973, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/32' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 32, 1, 'node/32', 1234483222, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/42' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 42, 1, 'node/42', 1236549439, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/43' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 43, 1, 'node/43', 1234554194, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/44' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 44, 1, 'node/44', 1234483574, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/45' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 45, 1, 'node/45', 1234483950, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/46' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 46, 1, 'node/46', 1234485360, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/47' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 47, 1, 'node/47', 1234485335, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/48' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 48, 1, 'node/48', 1234485421, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/49' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 49, 1, 'node/49', 1234485399, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/52' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 52, 1, 'node/52', 1236554961, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/54' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 54, 1, 'node/54', 1234484131, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/60' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 60, 1, 'node/60', 1234383066, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/61' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 61, 1, 'node/61', 1238277384, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/62' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 62, 1, 'node/62', 1234481074, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/63' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 63, 1, 'node/63', 1234481300, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/64' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 64, 1, 'node/64', 1234481623, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/65' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 65, 1, 'node/65', 1234558767, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
# user warning: Duplicate entry 'node/91' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 91, 1, 'node/91', 1236537926, NULL, 0, 0) in /var/www/bin/drupal-6.10/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
Comment #14
tamhas commentedAfter rebuilding all the sitemaps for the three sites, I manually resubmitted them to Google. For the one that is now complete, I got a warning
Line? 3 Invalid XML attribute
The XML attribute of this tag was not recognized. Please fix it and resubmit. Help Help
Tag:urlset
Attribute:url
Problem detected on: May 3, 2009
Comment #15
tamhas commentedAnother datapoint. I finally got the spam tab on the Comments page in Admin Content working and deleted one of the spam comments. On return to the main Admin Comments page I got:
user warning: Duplicate entry 'node/66' for key 2 query: INSERT INTO xmlsitemap (type, id, status, loc, lastmod, priority, changefreq, changecount) VALUES ('node', 66, 1, 'node/66', 1240703612, NULL, 0, 0) in /var/www/bin/drupal-6.11/sites/all/modules/xmlsitemap/xmlsitemap.module on line 782.
Comment #16
avpadernoIs this report still valid, or the code has been changed, and the issue is not anymore present?
Comment #17
dave reidAll the presented issues have been addressed. Marking as fixed especially since we still have #451258: 6.x-2.x-dev must be a clean install - *DO NOT UPGRADE* still open to warn people about not upgrading.