Closed (fixed)
Project:
Site Notes
Version:
5.x-1.x-dev
Component:
Miscellaneous
Priority:
Normal
Category:
Support request
Assigned:
Reporter:
Created:
31 Jul 2007 at 09:51 UTC
Updated:
11 Aug 2007 at 13:37 UTC
Hi, I need a liitle tap ;-)
I've more than 30 sitenotes now, but on my www.example.net/admin/build/sitenotes only some of them are visible.
No pager, no visible reason why some are there and some aren't ...
Any idea what to check?
Thanks,
Michal
Comments
Comment #1
nancydruThis is a weird one. How about checking the node table and make sure they are all 1) type='sitenotes', 2) published (status=1).
Comment #2
mblazke commentedHi nancyw,
I have a custom View for my sitenotes, where every sitenote is shown (FYI I've added simple workflow, so the SN module acts as simple but useful ToDo list for my co-admins).
I can not see any difference (nodetype or published) between the shown and hidden on admin/build/sitenote.
Here is a fragment from my table node:
SiteNote #1 (nid=113) - as the title suggests;-), this is my first sitenote.
search insige OG content only (nid=186) - this is an example of record not shown on admin/build/sitenostes list
Comment #3
mblazke commentedHi nancyw,
I have a custom View for my sitenotes, where every sitenote is shown (FYI I've added simple workflow, so the SN module acts as simple but useful ToDo list for my co-admins).
I can not see any difference (nodetype or published) between the shown and hidden on admin/build/sitenote.
Here is a fragment from my table node:
SiteNote #1 (nid=113) - as the title suggests;-), this is my first sitenote.
search insige OG content only (nid=186) - this is an example of record not shown on admin/build/sitenostes list
Please - now what?
Michal
Comment #4
nancydruDoes it consistently display/not display the same ones?
The query is
SELECT n.nid FROM {node} n WHERE type='sitenotes' AND status=1 ORDER BY n.sticky DESC, n.created DESC. Other than an unpublished note, this shouldn't be distinguishing between notes.Why don't you document that use for others who might want to use it? Who knows, I might even get motivated to add it into the module.
Comment #5
nancydruComment #6
mblazke commentedOK, in the order:
a) I was on SN 5.x-1.x-dev downloaded Jun-1
b) I had crippled several indexes on the node table (no idea why, the primary and vid one were OK, all the others were empty. Repairing & optimizing the node table re-created all indexes. I will check that in future - still do not know the cause. Anyway, rebuilding the indexes did NOT solve my SN issue)
c) the "only visible sitenotes in the admin/build/sitenotes" actually was the first ten records ... wow, it looks like pager-query issue rather than SN ... I did not enquire into deep details - because there is new SN release announced
d) downloaded & updated Aug-5 -dev release
e) SN works as expected :)
Thanks for your help, nancyw - and for new -dev release too ;-)
As for my SN use (co-admins ToDo) - well, English is not my first language, so it'll take some day to describe the idea and HowTo - I'll post it ASAP
Comment #7
mblazke commentedSome sitenotes not displaying - Fixed in Aug-5 -dev release
Comment #8
nancydruThis was probably a duplicate of http://drupal.org/node/159952. There was a problem with the pager set up.