Rank: Newbie
Joined: 9/3/2008
Posts: 3
|
Hi
We have a strange issue.
One of the nodes (items of table umbracoNode in our case, one with id=3461), is filling the table cmsDocument with rows (nodeid=3461).
Now we have, via the admin/edit, deleted the node from the tree with this specific id, but still it increases. The node was created 2008-08-19, and now (2008-09-03) there are more than 140 000 rows in the cmsDocument table, and still increasing. Another strange thing when I read the lines in the table cmsDocument, one of the rows is flagged published=true, strange, when we have deleted it?!
If it can be helpful: This node was created via code, and the code looks something like this:
==== start: c# code ======
Document docUmbracoParent = new Document(intPostingID);
//... some validating and stuff ...
Document docUmbracoComment = Document.MakeNew("NameOfDocument"), docTypeComment, usrUmbraco, intPostingID);
docUmbracoComment.ReleaseDate = System.DateTime.Now;
docUmbracoComment.Published = true;
docUmbracoComment.Publish(usrUmbraco);
docUmbracoComment.Save();
==== end: c# code ======
Some database dumps
==== start: database row: umbracoNode (sep by tabs) =======
3461 0 -20 0 1 -1,-20,3461 114 A1724290-E60B-4CDB-A57F-9AB4322AF577 comment:2008-08-19T01:26:39 C66BA18E-EAF3-4CFF-8A22-41B16D66A972 2008-08-19 13:26:42.450
==== end: database row: =======
==== start: database row, the latest: cmsDocument (sep by tabs) =======
3461 False 0 f37ee1b2-57a6-4b6f-9ab2-8d34b1b95e5b comment:2008-08-19T01:26:39 NULL NULL 2008-09-03 10:14:27 0 NULL True
==== end: database row: =======
==== start: database row, the latest: umbracoLog (sep by tabs) =======
1265489 0 3461 2008-09-03 10:15:22 Publish
==== end: database row: =======
Note that we have nothing like loops or simular that does this, it must be umbraco itself or the database that does this ?
The performance of the site is pretty weak, and we think it has something to do with the problem described above.
Any suggestions ? What can we do to fix this ?
To delete all this (all that has something to do with nodeId=3461 in our case) from the database, what is the recommended way to do that ?
Thanks in advance !
|
Rank: Fanatic
Joined: 7/19/2006
Posts: 496
Location: Göteborg, Sweden
|
What mechanism are using to trigger that code? If you have an url it might be possible than something keeps triggering it. I once had a client who's WebTrends installation kept loading a url to retrieve the page title over and over again. So it might be something else than Umbraco that launches your C# code... // ;) Kalle
" - Yeah I'd like to share your point of view, as long as it's my view too... ( http://www.d-a-d.dk/lyrics/pointofview)
|
Rank: Newbie
Joined: 9/3/2008
Posts: 3
|
Hi
No, its not our code that does this. We are logging when our code is executing ...
|
Rank: Umbracoholic
Joined: 9/8/2006
Posts: 1,831
Location: MA, USA
|
What version of umbraco are you using? Do you have any scheduled tasks in umbraco? Do you use the "publish at" or "unpublish at" dates? There was a bug when you had set the publish at date but has also manually published the node that it would publish itself every minute and fill the logs and versions table. Maybe this is related? cheers, doug.
MVP 2007-2009 - Percipient Studios
|
Rank: Newbie
Joined: 9/3/2008
Posts: 3
|
Hi
Its this version:
umbraco v 3.0.3 (Assembly version: 1.0.2825.21247)
So far as I know, I dont have any scheduled tasks, we havent coded/activated any.
We have not manually published the nodes either ( if you by manully mean, publish from the edit/admin/content mode )
The last thing we tried was to change this piece of code:
docUmbracoComment.ReleaseDate = System.DateTime.Now;
docUmbracoComment.Published = true;
docUmbracoComment.Publish(usrUmbraco);
docUmbracoComment.Save();
into:
docUmbracoComment.Published = true;
docUmbracoComment.Save();
docUmbracoComment.Publish(usrUmbraco);
The result of this os that (in edit mode) "Publication Status" : Last published: 13/09/2008 01:05:24
"Link to document" : ( nothing, the page does not apear as published?)
What is the correct way to create and publish a node/page ( as I do above, via c# code), to avoid this bug ?
BR / ricapp
|