Coffe Joomla1.6 installation

Hi Gavick Team,
I've encountered the following error during the installation of the quickstart pack.

Some errors occurred while populating the database: Table 'ecquadro.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')


See also attached image.

Should I consider valid this installation?

Thanks in adv,

Hi,
I had the same problem today. There is a bug in Joomla installer.
Probably you set a custom db prefix, different from the default jos_.
The problem is that joomla creates the tables with the default prefix, whatever you choose.
There are two ways to solve it.

- use the default db prefix
- Rename all the tables in your db manually using phpadmin

Hope this helps

P.S.
Sei Italiano?

Hi

That's not a bug
On Quickstart installation you must keep table prefix intact or if you want to use your own, you need to previously change "jos_" table prefix on this files ..installationsqlmysqljoomla.sql

You can use (i.e.) Notepad++ and just replace all words "jos_" with "myprefix_" and save.

Cheers

thanks seichinha, i had same problem with penguin ! thumbs up...

Hi

That's not a bug
On Quickstart installation you must keep table prefix intact or if you want to use your own, you need to previously change "jos_" table prefix on this files ..installationsqlmysqljoomla.sql

You can use (i.e.) Notepad++ and just replace all words "jos_" with "myprefix_" and save.

Cheers

Hi Senchina,
Thanks for your reply. I've not changed anything in the standard installation. I'm using the default joomla prefix "jos_" so I suppose that something is wrong with the sql file in the quickstart pack. Please check the installation file again to verify that all works fine or try to install coffe from the scratch as another user have the same problem.

Thank for your attention.

@ InfoMicron SI SONO ITALIANO

Hi

Can You please give me an access to database ? I've installed it from scratch and no problem at all.

What mysql version are You running ?

Hi guys,
I have solved the problem that is inside the file joomla.sql. During the installation the table jos_usergroup is not created by the script so there is a problem when the script try to populate this table. I've compared the Gavick script with the original Joomla file and I've noticed the below difference in red:

Original Joomla file:

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 ;


Gavick file:

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` (`lft`,`rgt`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

I've changhed the code in red as in the original joomla file and now the installation works fine.

Cheers

Yes, you're right - problem occurs only on MySQL older than 5.1 - MySQL 5.1 has changes in the syntax without backward compatibility so SQL dump isn't compatible with MySQL 5.0.

Yes, you are right, my Version is 5.0.45

But seems that the problem is only with that table.

Cheers

The funniest thing is fact that syntax from MySQL 5.0 works in MySQL 5.1 - I've tested it and now I'm uploading fixed quickstarts

hi there,
which file is it exactly that needs to be changed?!
Thank you,
Martin