Some errors occurred while populating the database

GK User
Sun Feb 27, 2011 9:01 am
Hi I’m trying to install Penguinmail Theme Quick start and getting the following error.

Some errors occurred while populating the database: Table 'db_voar.jos_usergroups' doesn't exist SQL=-- -- Dumping data for table `jos_usergroups` -- INSERT INTO `jos_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES (1, 0, 1, 20, 'Public'), (2, 1, 6, 17, 'Registered'), (3, 2, 7, 14, 'Author'), (4, 3, 8, 11, 'Editor'), (5, 4, 9, 10, 'Publisher'), (6, 1, 2, 5, 'Manager'), (7, 6, 3, 4, 'Administrator'), (8, 1, 18, 19, 'Super Users')


Any suggestions?
Thanks
User avatar
Fresh Boarder

Konrad M
Mon Feb 28, 2011 6:41 am
Hi
What version Mysql and PHP you use?
User avatar

GK User
Tue Mar 01, 2011 7:06 pm
and is it for joomla 1.5 or 1.6?
User avatar
Platinum Boarder

GK User
Tue Mar 01, 2011 7:07 pm
if 1.6, i had problems installing the quickstart also on my domain, thou if installing joomla 1.6 standalone, and then template on top it worked, however no demo data...
User avatar
Platinum Boarder

GK User
Tue Mar 01, 2011 7:08 pm
moving this to penguin 1.6, please correct me if im wrong :)
User avatar
Platinum Boarder

teitbite
Wed Mar 02, 2011 1:36 am
Hi

Additionaly what prefix are You using ? Is it "jos_" as in the standard ?
User avatar
Moderator

GK User
Wed Mar 23, 2011 4:55 am
Experienced the same problem, and changed the file joomla.sql in installation/sql/mysql to read
Use at your own risk - I am not a skilled user, but it worked for me. I re-ran the installation procedure (it had paused at this error).



--
-- Table structure for table `jos_usergroups`
--

CREATE TABLE IF NOT EXISTS `jos_usergroups` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Primary Key',
`parent_id` int(10) unsigned NOT NULL default '0' COMMENT 'Adjacency List Reference Id',
`lft` int(11) NOT NULL default '0' COMMENT 'Nested set lft.',
`rgt` int(11) NOT NULL default '0' COMMENT 'Nested set rgt.',
`title` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
KEY `idx_usergroup_title_lookup` (`title`),
KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
KEY `idx_usergroup_nested_set_lookup` USING BTREE (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `jos_usergroups`
--

INSERT INTO `jos_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES
(1, 0, 1, 20, 'Public'),
(2, 1, 6, 17, 'Registered'),
(3, 2, 7, 14, 'Author'),
(4, 3, 8, 11, 'Editor'),
(5, 4, 9, 10, 'Publisher'),
(6, 1, 2, 5, 'Manager'),
(7, 6, 3, 4, 'Administrator'),
(8, 1, 18, 19, 'Super Users');
User avatar
Fresh Boarder


cron