ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Weblog List truncated

November 27, 2007 11:04am

Subscribe [1]
  • #1 / Nov 27, 2007 11:04am

    ASLFilms

    15 posts

    Hello,

    I’m working on yet another site with EE 1.5.2 installed.  I noticed that they have over 70 weblogs (by looking at the exp_weblog_data table), but when I either as Super Admin or Admin (or any other status) click on the Edit tab, I only get three recent weblog entries.  Anything earlier than these three are not shown.  (They are still open and showing on the website)

    I checked with the exp_weblog_member_groups table and it shows that for my member group (super admin and admin), these weblogs should be viewable. 

    Any idea why I’m unable to view these weblogs via the Edit tab?

    Thanks,
    Todd

  • #2 / Nov 27, 2007 11:08am

    Robin Sowell

    13255 posts

    I’d seriously try to work in an upgrade on that one.  But let’s see- if you go to ‘Publish’- do all of the weblogs show.  How about in ‘Admin- Weblog Admin- Weblog Management’?  Lastly- so I’m clear- when you go to the ‘Edit’ tab and click to filter by weblog- that’s where only 3 weblogs show up?  Are they running any extensions?

  • #3 / Nov 27, 2007 11:24am

    ASLFilms

    15 posts

    Robin,

    Yep, if I do a publish, all weblogs do show.  It’s the ones before the original three weblogs and any new ones I created (I didn’t mention that) that do not show up.

    Let me try and upgrade this to 1.6.1 and see if it resolves this issue. 

    Thanks,
    Todd

  • #4 / Nov 27, 2007 11:25am

    Robin Sowell

    13255 posts

    Good deal- let us know what’s going on after the upgrade.

  • #5 / Dec 02, 2007 11:32am

    ASLFilms

    15 posts

    Robin,

    I’m back.  After the upgrade to 1.6.1, the weblogs remain truncated.

    I can only see the three (plus any new ones that I add).

    Any ideas on how I can get the others back so the editor can continue the work?

    Thanks,
    Todd

  • #6 / Dec 02, 2007 11:42am

    Robin Sowell

    13255 posts

    Whee- ok, glad upgrade is squared away.  And I think I was misunderstanding on this one.  It isn’t the list of weblogs that’s getting truncated anywhere- it’s the list of entries in the edit tab- only entries in the three latest weblogs show up there.  Or- new entries to one of the old weblogs. 
    Correct?

    Let’s see if anything is goofy with your site id- go to ‘Admin- Utilities- SQL Manager- Query form’ and run these two queries:

    SELECT blog_title, weblog_id, cat_group FROM exp_weblogs WHERE site_id != '1' order by blog_title
    
    SELECT title FROM exp_weblog_titles WHERE site_id != 1

    Either one return anything?

  • #7 / Dec 02, 2007 12:10pm

    ASLFilms

    15 posts

    Site_id is 1 because this site only uses one EE.

    So the answer is no, both queries do not return anything. 

    I did an additional query:

    SELECT *
    FROM exp_weblogs

    which returned three rows with all having a site_id = 1.

    The exp_weblogs_titles had the same (all were for site_id=1).

  • #8 / Dec 02, 2007 12:39pm

    Robin Sowell

    13255 posts

    Seems to me something is off somewhere.  Do you have any extensions installed?  Also- if you turn ‘show queries’ on and go to the edit tab- what do you see for the main queries pulling in the weblog entries- I have:

    16
    SELECT exp_weblog_titles.entry_id FROM exp_weblog_titles LEFT JOIN exp_weblogs ON exp_weblog_titles.weblog_id = exp_weblogs.weblog_id LEFT JOIN exp_members ON exp_members.member_id = exp_weblog_titles.author_id WHERE exp_weblogs.site_id = '1' AND exp_weblog_titles.weblog_id IN ('2','12','8','5','1','7','4','3') AND exp_weblog_titles.author_id = exp_members.member_id
    17
    SELECT exp_weblog_titles.entry_id FROM exp_weblog_titles LEFT JOIN exp_weblogs ON exp_weblog_titles.weblog_id = exp_weblogs.weblog_id LEFT JOIN exp_members ON exp_members.member_id = exp_weblog_titles.author_id WHERE exp_weblogs.site_id = '1' AND exp_weblog_titles.weblog_id IN ('2','12','8','5','1','7','4','3') AND exp_weblog_titles.author_id = exp_members.member_id ORDER BY entry_date desc LIMIT 0, 50

    Pay particular attention to the weblog_id IN- should have all of the possible weblog ids in there.

  • #9 / Dec 02, 2007 1:19pm

    ASLFilms

    15 posts

    Bingo!

    The reason why the three entries show up and all others didn’t was because the query was looking for author_id = member_id.  That author_id no longer exists in the system (we deleted that user). 

    Doing an

    update exp_weblog_titles
    set author_id = <the true author id>
    where author_id = <the deleted author id>

    which updated x rows.  Then following up with a

    select * from exp_weblog_titles
    where author_id <> <the true author_id>

    returned an empty set. 

    Problem solved.  I’m now able to see every entry.  😊

    Thanks for pointing me in the right direction.  What I wonder is this:  shouldn’t EE have updated all entries with the new author ID after a deletion of an older author Id?  Or was that a 1.5.2 bug that has since been addressed?

    Todd

  • #10 / Dec 02, 2007 1:34pm

    Robin Sowell

    13255 posts

    It should have given you the option to re-assign all entries when you deleted the author.  I’m fairly sure this was in place for 1.5.2- but I can’t swear.  I vaguely remember at one point it wasn’t- but I thought that was way back in the day.

    Could be my faulty memory though.  Or- it could have slipped by us somewhere.  If you can remember- walk me through the pages/process to delete the member and I’ll double check the 1.6.1 code just to be sure.  If you don’t really remember- probably not a crisis.  I’m pretty sure it’s in there.

    Make sense?

  • #11 / Dec 02, 2007 2:12pm

    ASLFilms

    15 posts

    I am certain 1.6.1 is fine because I did it for another site without any problems.  I deleted this particular member prior to the upgrade to 1.6.1 from 1.5.2. 

    Well, at least this now works and I can gleefully hack their entries to smithereens.  😉 

    just kidding.

    Thanks for all your help!
    Todd

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases