Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
- The issue occurs for both PostreSQL and MySQL
- The issue occurs by failure of retrieving a record from node_revisions where nr.nid = %nid and failure to retrieve a record from comments where c.nid = %nid and c.status = COMMENT_PUBLISHED.
- The proposed fix in comment 66 ensures that if no rows were returned from the DB the changecount is 0 instead of -1.
- The question becomes why no rows are being returned for
$query = db_query("SELECT nr.timestamp FROM {node_revisions} nr WHERE nr.nid = %d", $node->nid);
?
Original Issue Post
Hi!
I gave the following errors after node creation, however the created node appear in the sitemap.xml. I'm using postgresql-8.3.7, php-5.2.10, xmlsitemap-6.x-2.x-dev (11-july-2009) and drupal-6.13.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: value for domain int_unsigned violates check constraint "int_unsigned_check" in /adat/3w/postgres/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO xmlsitemap (id, type, loc, access, status, lastmod, priority, priority_override, changefreq, changecount, node_type) VALUES (2, 'node', 'node/2', 1, 1, 1247408591, NULL, NULL, 0, -1, 'page') in /adat/3w/postgres/sites/all/modules/xmlsitemap/xmlsitemap.module on line 805.
Comment | File | Size | Author |
---|
Comments
Comment #1
Dave ReidI tested the module with pgsql and confirmed this error happens with new nodes because the -1 value is inserted into the node/add form. I committed a fix to CVS and left an error check just in case this pops up again.
http://drupal.org/cvs?commit=236870
Comment #2
mrfelton CreditAttribution: mrfelton commentedI just got the following message when going to the page /node/add/blog-post:
EDIT: That was with xmlsitemap-6.x-2.x-dev.tar.gz downloaded this afternoon
Comment #3
Dave Reid@mrfelton: I know that the error on node creation should be fixed with the latest commit (http://drupal.org/cvs?commit=237046) which should be included the next time the development build is regenerated. It didn't quite make it with the commit in #1.
Comment #4
gregarios CreditAttribution: gregarios commentedI'm getting this PHP error, and it tells me to go here to report it:
Changecount for node was negative (timestamps: . Please report this to <a href="http://drupal.org/node/516928">http://drupal.org/node/516928</a>. in /usr/local/apache2/vhosts/<mywebsite.com>/htdocs/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 296.
I'm not even using PostgreSQL at all. I'm using MySQL.
I'm running FreeBSD 6.3, Drupal 6.13, MySQL 5.0.75, PHP 5.2.9, Apache 2.2.11
Comment #5
Dave Reid@gregarios: Same response as #3. Been fixed already, will be included in next dev build.
Comment #6
gregarios CreditAttribution: gregarios commentedOops... ok I didn't see that. Thanks. :-)
Comment #7
Dave Reid@gregarios: No problem! I'm kicking myself for not getting the followup fix in before the module was repackaged. I think the next one should be ready in less than an hour.
Comment #8
xmarket CreditAttribution: xmarket commentedHi!
The originally reported error message disappeared, but I'm gave the message which reported in #2. I will test again tomorrow with the new nightly build.
Comment #9
eyecon-1 CreditAttribution: eyecon-1 commentedI am not using PostgreSQL but note the following message printed to the syslog:
Jul 15 16:03:02 gaynewsservice drupal: http://www.tips-q.com|1247688182|php|68.236.166.73|http://www.tips-q.com/node/add/blog|http://www.tips-q.com/node/add/blog|1||Changecount for node was negative (timestamps: . Please report this to http://drupal.org/node/516928.
Reported as requested -;)
OS=CentOS 5.3
Webserver=Lighty
PHP=5.2x (custom RPM)
DB=MySql 5.0.45
I don't know if this is pertinent, but every cron run prunes stale aggregated content.
Comment #10
Dave ReidWell I'm glad that everyone actually read the debugging message I put in. :) Everyone please make sure you are using the absolute latest 6.x-2.x development build and report back here if you do or do not see any more warnings.
@eyecon XML sitemap has nothing to do with cron removing stale aggregator content.
Comment #11
eyecon-1 CreditAttribution: eyecon-1 commentedVersion=6.x-2.x-dev (2009-Jul-13)
Comment #12
Dave ReidHmm.... my latest commit for this issue seems to have not triggered the development build script. I'll make a dummy commit to get it to repackage.
Comment #13
Dave ReidOk everyone. The 6.x-2.x-dev was finally repackaged with the desired changes. Please re-download and test it out. Be sure to test the node/add pages since that's where the problem is coming from.
Comment #14
xmarket CreditAttribution: xmarket commentedVersion 6.x-2.x (2009-jul-16) works like a charm! Yeah XD.... Thanks for the great and FAST work!
Comment #15
Dave Reid@xmarket Woot! Thanks for reporting back!
Comment #16
atan CreditAttribution: atan commentedhttp://drupal.org/node/518090
" * user warning: Unknown column 'access' in 'where clause' query: SELECT COUNT (id) FROM WHERE xmlsitemap access = 1 AND status = 1 in / home / content /**/***/**/*********/ html / modules / xmlsitemap / xmlsitemap.module on line 326 ".
Comment #17
Dave Reid@atan: That's not related to this issue, but make sure to run update.php. That will create the column.
Comment #19
Oleksa-1 CreditAttribution: Oleksa-1 commentedI use last dev version (not upgrade, this is new installation). When I clicked " Rebuild " - I got :
Comment #20
Dave ReidLooking back into this.
Comment #21
Oleksa-1 CreditAttribution: Oleksa-1 commentedAnd a bit more info. It is about another site, when I tried to upgarade it (update.php) I goo on screen:
Update #4
* Failed: The {xmlsitemap}.language field does not yet exist. Please re-run the update script.
Then I re-run script and got:
user warning: Column 'language' cannot be null query: UPDATE xmlsitemap SET language = (SELECT node.language FROM node WHERE node.nid = xmlsitemap.id AND node.language <> '') WHERE xmlsitemap.type = 'node' in /home/mysite/public_html/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.install on line 74.
The following queries were executed
xmlsitemap_node module
Update #4
* Failed: UPDATE {xmlsitemap} SET language = (SELECT {node}.language FROM {node} WHERE {node}.nid = {xmlsitemap}.id AND {node}.language <> '') WHERE {xmlsitemap}.type = 'node'
And when post comments, error message appears:
* user warning: Unknown column 'language' in 'field list' query: SELECT loc, access, status, lastmod, priority, changefreq, changecount, language FROM xmlsitemap WHERE type = 'node' AND id = 2299 LIMIT 0, 1 in /home/my site/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 492.
* user warning: Duplicate entry '2299-node' for key 'PRIMARY' query: INSERT INTO xmlsitemap (id, type, loc, access, status, lastmod, priority, priority_override, changefreq, changecount, menu_name, node_type, term_vid) VALUES (2299, 'node', 'node/2299', 1, 1, 1251322230, NULL, 0, 151613, 2, NULL, 'blog', NULL) in /home/mysite/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 836.
Comment #22
skyredwangI update XML Sitemap Dev to Sept.1st, click rebuild, got this
Comment #23
Dave ReidWent and double checked with the latest code using PostgreSQL and I couldn't duplicate. Fixed the "Column 'language' cannot be null query" in #4 though.
Comment #24
Oleksa-1 CreditAttribution: Oleksa-1 commentedThx, Dave, seems it really fixed. at least i do not see any error messages.
Comment #25
atan CreditAttribution: atan commentedtnx DR,
Once I did update with the new Drupal version 6.14, I tried to activate cron manually.I post new issue http://drupal.org/node/589092 Any help is appreciated.
standby for answer!
atan,
Comment #26
Oleksa-1 CreditAttribution: Oleksa-1 commented@atan
I am not sure, but in realise notes it is mentioned:
May be try to remove old version xmlsitemap completly and make new installation. Regarding me i do not have any problem with cron.
Comment #27
Dave Reid@atan: The xmlsitemap_user is not part of the 6.x-2.x version, so you have a mix of old and new files in there. Please clear out the entire sites/all/modules/xmlsitemap directory and re-download the 6.x-2.x version.
Comment #28
atan CreditAttribution: atan commentedThanks for the quick reply oleksa and DR.
Whether module xmlsitemap_user, I can remove the deletion from the server,because I can not uninstall.I have hosting on godaddy, where Drupal is problematic again re-download the 6.x-2.x version.Ili might not know how.
Comment #29
Dave Reid@atan: Did using a fresh xmlsitemap module folder and files fix this problem for you?
Comment #31
drupalfan2 CreditAttribution: drupalfan2 commentedI get this error on every manuel cron run (perhaps normal cron run too):
user error: Negative changecount value. Please report this to http://drupal.org/node/516928.
Fresh installation. 6.x-2.0-beta1
What can I do?
Comment #32
Dave ReidThere should have been more to the error message that you didn't copy & paste here. Can you do that please?
Comment #33
drupalfan2 CreditAttribution: drupalfan2 commentedYes, I will write more.
I have never used XML sitemap before. I installed XML sitemap on a multi site installtion of Drupal with about 3 domains. This is running now for about 2 days.
On 2 domains (same multi site installation) there are no errors.
On 1 domain I get this error (see above) when cron is run or every time I run cron manuall in drupal report center.
Version 6.x-2.0-beta1.
I had to reindex search on this domain, but I don't know if this matters.
On this domain the generated xml sitemap is greater then on the other domains of the same installation: 2 xml sitemap urls, ~5000 urls, ~1200 urls (2 parts of same sitemap).
What other information can I provide here?
Is it possible to "hack out" this error message? Is this a critical error or not? Thank you very much.
Comment #34
gregarios CreditAttribution: gregarios commented@DrupalFan2: I believe what Dave Reid needs is a copy of the exact error message as written to your server's error logs, not the error as displayed in your browser.
Comment #35
drupalfan2 CreditAttribution: drupalfan2 commentedHere the exact error message:
What is this changecount for and why is it not allowed to be negative?
Comment #36
kerberos CreditAttribution: kerberos commentedNot sure if this helps, but this is under MySQL 5:
*****************
Negative changecount value. Please report this to http://drupal.org/node/516928.array (
'type' => 'node',
'id' => '81626',
'subtype' => 'logo',
'loc' => 'node/81626',
'status' => 0,
'status_default' => 0,
'status_override' => 0,
'priority' => 0.5,
'priority_default' => 0.5,
'priority_override' => 0,
'changefreq' => 0,
'changecount' => -1,
'lastmod' => 1274878925,
'access' => true,
'language' => '',
) in sites/all/modules/contributed/xmlsitemap/xmlsitemap.module on line 616.
-Daniel
Urbo
Comment #37
Dave ReidI'll test the latest code with PostgreSQL, but I'm guessing if you're hitting this condition, your node is missing data in the {node_revision} table, which indicates a much bigger problem.
Comment #38
Dave ReidShould be able to test this yourself if you do this SQL query and you get any results, then you have messed up data:
SELECT n.nid, n.type, n.title FROM node n LEFT JOIN node_revisions nr USING (nid) WHERE nr.vid IS NULL
Comment #39
drupalfan2 CreditAttribution: drupalfan2 commentedhello,
I did this test
SELECT n.nid, n.type, n.title FROM node n LEFT JOIN node_revisions nr USING (nid) WHERE nr.vid IS NULL
and I got an empty result.
Further on I get error messages like this with every cron cycle in drupal reporting:
Negative changecount value. Please report this to http://drupal.org/node/516928.
array ( 'id' => '24', 'type' => 'node', 'subtype' => 'forum', 'loc' => 'node/24', 'language' => 'de', 'access' => true, 'status' => '1', 'status_override' => '0', 'lastmod' => '1265240743', 'priority' => '0.5', 'priority_override' => '0', 'changefreq' => 0, 'changecount' => -1, 'status_default' => '1', 'priority_default' => '0.5', ) in /home/drupal/www/sites/all/modules/xmlsitemap/xmlsitemap.module in Zeile 616.
I do NOT use PostgreSQL, I am using mysql 5.0.51.
Is there a way to get rid of this error message?
Does xml sitemap work correct despite this error?
Comment #40
drupalfan2 CreditAttribution: drupalfan2 commentedComment #41
lionstone CreditAttribution: lionstone commentedI'm also suffering from this issue:
Thanks for your hard work on the module!
Comment #42
Dave ReidI still can't reproduce this so moving this to a support request until we can narrow down what's wrong.
Comment #43
aacraig CreditAttribution: aacraig commentedI was getting the same error when programatically creating a node.
When I correctly inserted it, the error went away.
I was mistakenly passing an array as the 'body' property to the node, which caused a number of errors. When I fixed this issue, the xmlsitemap error went away. I'm not sure if this is because the body was empty or an array at the time xmlsitemap got to it.
To summarize:
This code provokes the error.
This code does not.
Comment #44
Dave ReidAwesome detective work aacraig! Can anyone else confirm this is the same problem for them?
Comment #45
Anonymous (not verified) CreditAttribution: Anonymous commentedToo bad we don't have a is_valid_node_object() API to call. But core expects the node object to remain sane without needing to worry about the data types in it.
Comment #46
Dave ReidMarking as fixed as no one else has responded and we have figured out the issue in #43.
Comment #47
beumont CreditAttribution: beumont commentedI am getting:
user warning: unknown column 'max_filesize' w field list query: INSERT INTO xmlsitemap_sitemap (smid, context, updated, links, chunks, max_filesize) VALUES ('NXhscRe0440PFpI5dSznEVgmauL25KojD7u4e9aZwOM', 'a:0:{}', 0, 0, 0, 0) in /home/users/thomasit/public_html/includes/common.inc on line 3477.
its not working, i can not generate a XML sitemap, can anybody help me with that ?
Their is also a message in the report:
user warning: unknown column 'max_filesize' w field list query: SELECT MAX(max_filesize) FROM xmlsitemap_sitemap in /home/users/thomasit/public_html/sites/default/modules/xmlsitemap/xmlsitemap.install on line 81.
Comment #48
Dave Reid@beumont: Make sure to run update.php.
Comment #50
heyyo CreditAttribution: heyyo commentedwith this error too
I'm not using the comments module anymore
Comment #51
heyyo CreditAttribution: heyyo commentedComment #52
sense-design@heyyo: This is fixed in DEV version, just updated to latest DEV
Comment #53
heyyo CreditAttribution: heyyo commentedthanks will try it soon
Comment #54
heyyo CreditAttribution: heyyo commentedthanks works great.
Comment #55
tonytosta CreditAttribution: tonytosta commentedMy error is slightly different than the one above....
a few of these...
WD php: User error: Negative changecount value. Please report this to [error]
http://drupal.org/node/516928.array (
'type' => 'node',
'id' => '4629',
'subtype' => 'article',
'status' => '1',
'status_default' => '1',
'status_override' => 0,
'priority' => '0.5',
'priority_default' => '0.5',
'priority_override' => 0,
'changefreq' => 0,
'changecount' => -1,
'loc' => 'node/4629',
'lastmod' => 0,
'access' => false,
'language' => '',
) in xmlsitemap_link_save() (line 584 of
[path-to-modules]/modules/contrib/xmlsitemap/xmlsitemap.module).
followed by a
Drush command could not be completed.
Has anyone seen this?
Comment #56
dlumberg CreditAttribution: dlumberg commented7.x.2.0-beta3
Looks like it's fixed in dev but I always do what error messages tell me :P
I got a ton of these trying to debug importing nodes with the Feeds module. I haven't had a problem adding nodes normally.
EDIT: Not fixed in 7.x.2.x-dev
Comment #57
djbobbydrake CreditAttribution: djbobbydrake commentedI'm running 6.x-2.0-beta3. Ran xmlsitemap-rebuild drush command and received a similar error:
WD php: User error: Negative changecount value. Please report this to http://drupal.org/node/516928.array ( [error]
'type' => 'node',
'id' => '12305',
'subtype' => 'article',
'status' => '1',
'status_default' => '1',
'status_override' => 0,
'priority' => '0.5',
'priority_default' => '0.5',
'priority_override' => 0,
'changefreq' => 0,
'changecount' => -1,
'loc' => 'node/12305',
'lastmod' => 0,
'access' => false,
'language' => 'en',
) in xmlsitemap_link_save() (line 584 of /sites/all/modules/contrib/xmlsitemap/xmlsitemap.module).
Comment #58
djbobbydrake CreditAttribution: djbobbydrake commentedThe negative changecount value occurs if the timestamp column in the node revision table is set to ZERO. Changecount is set here in the xmlsitemap_node_create_link function:
I'm going to fix this by updating the timestamp for any node revision that has a timestamp of ZERO. I believe this timestamp might have been set during a bad import process (we are importing image nodes). What do we think about not causing this negative changecount to trigger an error that causes the sitemap generation process to stop? Rather, what if we just ignore those particular nodes?
Comment #59
lyricnz CreditAttribution: lyricnz commentedI'm also getting this error. This is happening even though type 'activitystream' is excluded from the sitemaps.
Comment #60
raghu_gh CreditAttribution: raghu_gh commentedWhen Ever I update xml Site map I am getting this error.
What is the solutions for this.
user error: Negative changecount value. Please report this to http://drupal.org/node/516928.array ( 'type' => 'node', 'id' => '1383', 'subtype' => 'articles', 'status' => '1', 'status_default' => '1', 'status_override' => 0, 'priority' => '1.0', 'priority_default' => '1.0', 'priority_override' => 0, 'changefreq' => 0, 'changecount' => -1, 'loc' => 'node/1383', 'lastmod' => 0, 'access' => true, 'language' => '', ) in /home/../public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 584.
Comment #61
Dave ReidComment #62
Alex Andrascu CreditAttribution: Alex Andrascu commentedGetting this in 7.x-2.0-rc1
Comment #63
Vacilando CreditAttribution: Vacilando commentedConfirming -- getting the error still in 7.x-2.0-rc1 (and using MySQL, not PostgreSQL).
In our case it happens when several people create nodes of the same type. In one case, 3 people from a group of 5 got this error message.
Comment #64
rp7 CreditAttribution: rp7 commentedConfirming as well.
Comment #65
Vacilando CreditAttribution: Vacilando commentedAdjusting the title to
Comment #66
Anonymous (not verified) CreditAttribution: Anonymous commentedSince this is obviously still occuring, here is a patch that will take care of it.
Comment #66.0
Anonymous (not verified) CreditAttribution: Anonymous commentedIssue summary
Comment #67
Anonymous (not verified) CreditAttribution: Anonymous commentedThose of you receiving this error, when the error occurs please determine why the DB returned no rows for
db_query("SELECT nr.timestamp FROM {node_revisions} nr WHERE nr.nid = %d", $node->nid);
. The patch in 66 only works around that issue.Comment #68
Vacilando CreditAttribution: Vacilando commentedWhat would be the equivalent of #66 for D7 dev? It seems rather different. (I see there is xmlsitemap_recalculate_changefreq() but it is not used anywhere?)
Comment #69
logi CreditAttribution: logi commentedHello! Here is a problem
user error: Negative changecount value. Please report this to http://drupal.org/node/516928.array ( 'id' => '66', 'type' => 'node', 'subtype' => 'mezhgorod', 'loc' => 'node/66', 'language' => '', 'access' => true, 'status' => '1', 'status_override' => '0', 'lastmod' => 0, 'priority' => '1', 'priority_override' => '0', 'changefreq' => 0, 'changecount' => -1, 'status_default' => '1', 'priority_default' => '1.0', ) in /var/www/vhosts/logitaxi.ru/httpdocs/modules/xmlsitemap/xmlsitemap.module on line 584.
Comment #70
jelo CreditAttribution: jelo commentedMy issue (6.x-2.0-rc2):
array ( 'type' => 'node', 'id' => '10421', 'subtype' => 'program', 'status' => 1, 'status_default' => 1, 'status_override' => 0, 'priority' => '0.9', 'priority_default' => '0.9', 'priority_override' => 0, 'changefreq' => 0, 'changecount' => -1, 'loc' => 'node/10421', 'lastmod' => 0, 'access' => false, 'language' => '', ) in sites/all/modules/xmlsitemap/xmlsitemap.module on line 584
Here is what caused it for me. I was experimenting with a XML import through feeds module into a content type called "program". That content type is setup to be included in the XML sitemap. My XML file included 4 entries for Drupal node IDs that did not exist in the development site (I had accidentally created them in the production site, but not in development). The feed import was configured to use NID as unique identifier and to update existing nodes. However, the XML does not cover a lot of the required fields, just a small subsets of fields in the content type. When I ran the import, feeds stated on screen that 4 new nodes had been created. However, the nodes had in fact not been created, I assume because of missing required field entries. My guess is that feeds fired a hook to notify other modules about the successful creation of a node (when in fact it should not have) which XML sitemap then tried to include. It failed to find entries in the node_revisions because they simply do not exist. When I checked the watchdog, I found 4 error messages like the above for exactly those 4 node IDs in the list.
Comment #71
cha0s CreditAttribution: cha0s commentedGot this when running an install profile that installs some content. The weird thing is, I've run it many times and this didn't happen. Only happened the last time, and only on 2 of the 40 or so created noes. Weird. Regardless, here's the full text of the errors:
I'm running 7.x-2.0-rc2
Comment #71.0
cha0s CreditAttribution: cha0s commentedIssue Summary
Comment #72
super_romeo CreditAttribution: super_romeo commentedUser error: Negative changecount value. Please report this to http://drupal.org/node/516928.
array ( 'type' => 'node', 'id' => '11566', 'subtype' => 'scrap_price', 'status' => 0, 'status_default' => 0, 'status_override' => 0, 'priority' => 0.5, 'priority_default' => 0.5, 'priority_override' => 0, 'changefreq' => 0, 'changecount' => -1, 'loc' => 'node/11566', 'lastmod' => 0, 'access' => true, 'language' => '', ) в функции xmlsitemap_link_save() (строка 588 в файле /DATA/home-sites/sday_lom_rf/htdocs/sites/all/modules/xmlsitemap/xmlsitemap.module).
Comment #73
gaurav.goyal CreditAttribution: gaurav.goyal commentedWhile migrating nodes from drupal 6 to drupal 7, getting this error
MigrateException: Negative changecount value. Please report this to http://drupal.org/node/516928.
array ( 'type' => 'node', 'id' => '7058', 'subtype' => 'news', 'status' => '0', 'status_default' => '0', 'status_override' => 0, 'priority' => '0.5', 'priority_default' => '0.5', 'priority_override' => 0, 'changefreq' => 0, 'changecount' => -1, 'loc' => 'node/7058', 'lastmod' => 0, 'access' => false, 'language' => 'en', ) File /var/www/hcl/docroot/sites/all/modules/contrib/xmlsitemap/xmlsitemap.module, line 588 in MigrationBase->errorHandler() (line 530 of /var/www/hcl/docroot/sites/all/modules/contrib/migrate/includes/base.inc).
Negative changecount value. Please report this to http://drupal.org/node/516928.
array ( 'type' => 'node', 'id' => '7058', 'subtype' => 'news', 'status' => '0', 'status_default' => '0', 'status_override' => 0, 'priority' => '0.5', 'priority_default' => '0.5', 'priority_override' => 0, 'changefreq' => 0, 'changecount' => -1, 'loc' => 'node/7058', 'lastmod' => 0, 'access' => false, 'language' => 'en', ) File /var/www/hcl/docroot/sites/all/modules/contrib/xmlsitemap/xmlsitemap.module, line 588
Comment #74
moehac CreditAttribution: moehac commentedPer the error message, I'm posting the error in this thread. We are running MariaDb 10.0.
array_flip(): Can only flip STRING and INTEGER values! [warning] entity.inc:182 Negative changecount value.
array (
‘type’ => ‘node’,
‘id’ => ‘[nid]’,
‘subtype’ => ‘[node type]’,
‘status’ => 0,
‘status_default’ => 0,
‘status_override’ => 0,
‘priority’ => 0.5,
‘priority_default’ => 0.5,
‘priority_override’ => 0,
‘changefreq’ => 0,
‘changecount’ => -1,
‘loc’ => ‘node/[nid]’,
‘lastmod’ => 0,
‘access’ => false,
‘language’ => ‘und’,
)
xmlsitemap.module:602
Comment #75
Rade CreditAttribution: Rade at Druid for Yle - Finnish Broadcasting Company commentedReporting per the error message. I was doing a D7 -> D7 migration when this happened:
WD node: MigrateException: Negative changecount value. Please report this to http://drupal.org/node/516928.array ( [error]
'type' => 'node',
'id' => '147402',
'subtype' => 'article',
'status' => '1',
'status_default' => '1',
'status_override' => 0,
'priority' => '0.7',
'priority_default' => '0.7',
'priority_override' => 0,
'changefreq' => 0,
'changecount' => -1,
'loc' => 'node/147402',
'lastmod' => 0,
'access' => true,
'language' => 'und',
)
File /.../modules/contrib/xmlsitemap/xmlsitemap.module, line 602 in MigrationBase->errorHandler() (line 707 of /.../modules/contrib/migrate/includes/base.inc).
Comment #76
gobinathmAs D6 is in EOL, I believe there won't be any support / fix for a problem identified in 6x going forward. Hence i guess this issue can be closed.
Changing the status, if incorrect pls revert the status.
Comment #77
bmunslow CreditAttribution: bmunslow at SOCIETAT PORTAL DE LLEIDA S.L commentedI just got the following message in a Drupal 7 site:
Comment #78
GoZ CreditAttribution: GoZ at Centarro commentedRe-roll patch for Drupal 7.x-2.x.
This fix this issue for me.
Comment #79
donaldinou CreditAttribution: donaldinou as a volunteer commentedThis still occurs in xmlsitemap 7.x-2.5
I've just got this message for all my nodes in a certain type.
Comment #80
Chris Matthews CreditAttribution: Chris Matthews commentedComment #81
sokru CreditAttribution: sokru as a volunteer commentedHappened today with xmlsitemap 7.x-2.6, could not reproduce it after it first happened. Applied the patch #78.
Comment #82
marco-sIt happened with xmlsitemap 7.x-2.x-dev too (Drupal 7.65). I have applied the patch #78 today. Keep watching the problem.
Comment #83
loze CreditAttribution: loze commentedI just got this for the first time today. Error said to post here.
Drupal 7.69
xmlsitemap 7.x-2.6
php:User error: Negative changecount value. Please report this to https://www.drupal.org/node/516928.
array ( 'type' => 'node', 'id' => '90913', 'subtype' => 'photo', 'status' => '0', 'status_default' => '0', 'status_override' => 0, 'priority' => '0.5', 'priority_default' => '0.5', 'priority_override' => 0, 'changefreq' => 0, 'changecount' => -1, 'loc' => 'node/90913', 'lastmod' => 0, 'access' => false, 'language' => 'und', ) in xmlsitemap_link_save() (line 658 of /var/www/html/sites/all/modules/contrib/xmlsitemap/xmlsitemap.module);
This is the first time I've ever seen this error on a site that's been running smoothly for 6+ years
It may be related to memcache as I had been tweaking some settings recently.
Happened on a cron run.
Strange thing is the node referenced in the error node/90913 does not exist in the node table. Unsure of when it was deleted, and if it was intentionally or by error.
Could very well have been deleted by a user as the type 'photo' can be created/deleted by any registered user and happens frequently. But as I said, I've never seen this one before.