#__flexiaccess_groups has an id=0

alatak
Topic Author
Offline
New Member

14 years 6 months ago #6849 by alatak

#__flexiaccess_groups has an id=0 was created by alatak

Hello,
I am having trouble while trying to restore a web site with flexi acces.

1) The table #__flexiaccess_groups` is declared:

Code:

CREATE TABLE IF NOT EXISTS `#__flexiaccess_groups` (
  `id` int(11) unsigned NOT NULL auto_increment,
  ....
) ENGINE=MyISAM  CHARACTER SET utf8;

the first item id is NOT NULL.

2) In the file newinstall.sql, there is the line

Code:

UPDATE `#__flexiaccess_groups` SET `id` = 0 WHERE `id` = 1;

which sets the id to 0.
So the id of the first group is 0.

3) the problem when trying to restore the site with joomlapack (for example), you get the error

Code:

Query:INSERT INTO `#__flexiaccess_groups` VALUES ('1', 'FLEXIACCESS_GR_REGISTERED', 'FLEXIACCESS_GR_REGISTERED_DESC', '1', '1', '2');

MySQL: Duplicate entry '1' for key 'PRIMARY'

the reason is:
- the id for the first entry is set to 1, even if the sql request says 0,
- it does not accept the second entry with id=1

Please Log in or Create an account to join the conversation.

vistamedia
Offline
Administrator

14 years 4 months ago #8115 by vistamedia

Replied by vistamedia on topic #__flexiaccess_groups has an id=0

It's now solved in 1.0.5a
Cheers,
Emmanuel.

FLEXIcontent lead developer.
www.vistamedia.fr web agency and custom development.
www.joomla.fr co-administrator.
Please no PM for support request, use the forum for that!!!

Please Log in or Create an account to join the conversation.