Categories not showing at all in 9.6

[humaneasy]

Categories do not show at all in my 9.6 installation grabbed from SF.net.

MySQL 5.0.24 (cannot change this)
PHP 4.4.7 (can use also last 5)

Data in MySQL follows:

 CREATE TABLE `pligg_categories` (
  `category__auto_id` int(11) NOT NULL auto_increment,
  `category_lang` varchar(2) NOT NULL default 'en',
  `category_id` int(11) NOT NULL default '0',
  `category_parent` int(11) NOT NULL default '0',
  `category_name` varchar(64) NOT NULL default '',
  `category_safe_name` varchar(64) NOT NULL default '',
  `rgt` int(11) NOT NULL default '0',
  `lft` int(11) NOT NULL default '0',
  `category_enabled` int(11) NOT NULL default '1',
  `category_order` int(11) NOT NULL default '0',
  `category_color` varchar(6) default '000000',
  PRIMARY KEY  (`category__auto_id`),
  UNIQUE KEY `key` (`category_name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5;

-- 
-- Data in table `pligg_categories`
-- 

INSERT INTO `pligg_categories` (`category__auto_id`, `category_lang`, `category_id`, `category_parent`, `category_name`, `category_safe_name`, `rgt`, `lft`, `category_enabled`, `category_order`, `category_color`)
VALUES (2, 'pt', 2, 0, 'todas', 'todas', 2, 1, 1, 0, '000000'),
(1, 'pt', 1, 0, 'Ambiente', 'ambiente', 4, 3, 1, 0, '000000'),
(3, 'pt', 3, 0, 'Ecologia', 'ecologia', 6, 5, 1, 0, '000000'),
(4, 'en', 4, 0, 'new category', 'newcategory', 8, 7, 1, 0, '000000'); 
  

The site is in PT but I already tested both `category_lang` equal to 'pt' and equal to 'en' with the same empty result.

Data never appeared. Each time I click on "Add a New Category..." it creates a new record, ALWAYS in 'en' as you can see above, and when I find out just changed the text in phpMyAdmin by hand. No result achieved, whatsoever.

What could be wrong? Site must be on on Monday.

Thanks in advance for your help.

Lopo

[humaneasy]

Solved!

Reading another post from AshDigg I tested the following and it worked:

 UPDATE `pligg_categories` 
         SET `category__auto_id` = '0', 
                `category_safe_name` = 'all', 
                `category_enabled` = '2' 
         WHERE `category__auto_id` = 2 LIMIT 1 ; 
  

This is done. More to come... but only tomorrow