Thread

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

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?

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

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

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

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?

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).

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.

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

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?

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