Thread

After I update to version 1.6 I am not allowed to edit categories. Super Admins is locked and there is not way to edit Member Group.
Include are three screen captured.

I may need to take these one at a time.  First- are you running the very latest build?  1.6 came out with a bug fix version Build 20070622- so make sure you’re on that one.

OK- next, I started with the category groups one- Superadmins don’t need to be specifically allowed to edit cats- because they can do EVERYTHING.  There are no limitations on them- so when it says no groups are allowed to edit cats?  It’s not referring to superadmins.  (And I checked- I can edit groups both in the publish/edit interface and the admin interface.)  So- I think that one is ok.

Is that going to square everything away- or do I need to keep digging on the other pdfs?  Or- am I missing something important?

As a Super Admins I can’t edit categories, and I can’t give this privilege to my self? The security lock is locked for me only. How can I unlock it? In version 1.5.2 this wasn’t happened.

There is another strange behavior: new categories created with 1.6 don’t show in the category_archive or if they show, don’t properly point to the related entry.

If you go to http://barbara-fiore.com/index.php/BFE/proyectos/ the last link in the Indice (category_archive list), it was created with 1.6, and it is the only that don’t work properly. It should point to “C123” only, instead link to “C” and show a page with all the categories in the Proyectos group.

If you go to http://barbara-fiore.com/index.php/BFE/autores/ there are two new categories created in 1.6 that don’t show, but they are in the entries (Edward van de Vendel & Christian Grenier,), the first and the last one.

Thank you for your help!

In the footer of the control panel, what build number are you running?  The category issue was a bug that I believe is fixed in the latest build.  To see if the bug is what’s jamming your categories, go to ‘admin- utilities- mysql manager’- browse the tables.  How many rows do you have for the exp_categories table?  How many do you have for the exp_category_field_data table?

86 and 83 respectively
In the screen shot you can see that the current version show is 1.6.0

Ah- you’re on the latest version, but not the latest build.  There was a bug fix- Build:  20070622 - looks like you’re running 20070621.  I’d upgrade in case it’s a pesky bug that’s been fixed.  Like I say- I’m not replicating.

That said- you’ll also need to sync up your category tables.  Those two tables should match up on the number of rows.  Let’s get that fixed and the latest build up, then see what’s what.  First- let’s backup your exp_category_field_data table- just to be on the safe side.  You can do that in ‘Admin- Utilities- SQL Manager’- just check that one table- then select to back it up via the dropdown.

Next- we need to run a bit of php to get those tables evened up.  Go to ‘Tempplates’ and let’s create a test template- name it whatever.  Go to ‘Preferences’ for that template group and set php parsing ‘on’ for that new template.  Then- paste this code in the template:

<?php
global $DB;
$count = 0;
$sql = "SELECT c.site_id, c.cat_id, c.group_id FROM exp_categories c LEFT JOIN exp_category_field_data f ON c.cat_id = f.cat_id WHERE f.cat_id IS NULL";

$query = $DB->query($sql);

 if ($query->num_rows > 0)
 {
  foreach($query->result as $row)
  {
        $fields['site_id'] = $row['site_id'];
        $fields['cat_id'] = $row['cat_id'];
        $fields['group_id'] = $row['group_id'];
        
        $DB->query($DB->insert_string('exp_category_field_data', $fields));
$count++;
  }
 }

echo $count.' rows added';

?>

Now- save it, click on ‘View Rendered Template’ - should tell you that 2 rows were added.  That will sync the two tables up.

All that make sense?

Make sense! Thank you very much! That resolve this issue.

Gratefully,
4F