|
Well I don't know there are many pro out in the world and they can't provide a solution....anyway no matter what you do - upgrade from old version, your website just show blank, your admin page show blank after login; then just do this
Access your MySQL or PhPMYAdmin....find the databse structure Make a Back UP, do not blame me.
1. Drop the Table "jos_core_acl_aro", "jos_core_acl_aro_groups", "jos_core_acl_aro_sections"
Run this SQL:
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro` ( `id` int(11) NOT NULL AUTO_INCREMENT, `section_value` varchar(240) NOT NULL DEFAULT '0', `value` varchar(240) NOT NULL DEFAULT '', `order_value` int(11) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `hidden` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `__section_value_value_aro` (`section_value`(100),`value`(100)), KEY `jos_gacl_hidden_aro` (`hidden`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;
-- -- Dumping data for table `jos_core_acl_aro` --
INSERT INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES (10, 'users', '62', 0, 'Administrator', 0);
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `lft` int(11) NOT NULL DEFAULT '0', `rgt` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `jos_gacl_parent_id_aro_groups` (`parent_id`), KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
-- -- Dumping data for table `jos_core_acl_aro_groups` --
INSERT INTO `jos_core_acl_aro_groups` (`id`, `parent_id`, `name`, `lft`, `rgt`, `value`) VALUES (17, 0, 'ROOT', 1, 22, 'ROOT'), (28, 17, 'USERS', 2, 21, 'USERS'), (29, 28, 'Public Frontend', 3, 12, 'Public Frontend'), (18, 29, 'Registered', 4, 11, 'Registered'), (19, 18, 'Author', 5, 10, 'Author'), (20, 19, 'Editor', 6, 9, 'Editor'), (21, 20, 'Publisher', 7, 8, 'Publisher'), (30, 28, 'Public Backend', 13, 20, 'Public Backend'), (23, 30, 'Manager', 14, 19, 'Manager'), (24, 23, 'Administrator', 15, 18, 'Administrator'), (25, 24, 'Super Administrator', 16, 17, 'Super Administrator');
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_sections` ( `section_id` int(11) NOT NULL AUTO_INCREMENT, `value` varchar(230) NOT NULL DEFAULT '', `order_value` int(11) NOT NULL DEFAULT '0', `name` varchar(230) NOT NULL DEFAULT '', `hidden` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`section_id`), UNIQUE KEY `jos_gacl_value_aro_sections` (`value`), KEY `jos_gacl_hidden_aro_sections` (`hidden`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-- -- Dumping data for table `jos_core_acl_aro_sections` --
INSERT INTO `jos_core_acl_aro_sections` (`section_id`, `value`, `order_value`, `name`, `hidden`) VALUES (10, 'users', 1, 'Users', 0);
|