CBSubs Mailer Issue

did you follow the instructions on the Joomla docs page to fix assets table or did you just do it through phpmyadmin?

You need to directly fix the _assets table in your database. The second URL I've provided says specifically what I've done.

so:

update _assets
set parent_id = 1
where parent_id = 0

(then change the root back to 0?

?

ThePiston,

I just wanted to add an FYI here. I use ACL Manager to assist with these issues. The support is awesome. They will come into your site and fix it for you, as well. Their product was recognizing CBSubs as an orphan, but came in and resolved everything for me.

Just wanted to provide some other insight.

Thanks,
Joe

ThePiston wrote: so:

update _assets
set parent_id = 1
where parent_id = 0

(then change the root back to 0?

?

Yes, only Root should have a parent of 0. All others with a parent of 0 should be at least 1. Create a database backup before doing this. I've no idea why Joomla just doesn't fix this automatically in an update script when updating to a new version of Joomla.

nphic wrote: ThePiston,

I just wanted to add an FYI here. I use ACL Manager to assist with these issues. The support is awesome. They will come into your site and fix it for you, as well. Their product was recognizing CBSubs as an orphan, but came in and resolved everything for me.

Just wanted to provide some other insight.

Thanks,
Joe

ACL Manager is commercial. I agree it's good an useful, but you don't need to spend a penny to fix a simple Joomla bug. In regards to CBSubs being orphaned it's because ACL Manager doesn't know how to recognize a CB plugin. It thinks CBSubs is a component, which it is not. So it's safe to just ignore this.

last thing - somew of my articles have parent_id of 27, 44, etc. Do those matter? They are obviously > 0 but should some of the parent_ids be some other number besides 1?

ThePiston wrote: last thing - somew of my articles have parent_id of 27, 44, etc. Do those matter? They are obviously > 0 but should some of the parent_ids be some other number besides 1?

You only need to fix those with a parent id of 0. The below ran through phpmyadmin should fix it all including ensuring root is 0. Please change the table prefix (jos_) if it doesn't match yours.